plumbum

Members
  • Content count

    13
  • Joined

  • Last visited

Community Reputation

0 Neutral

About plumbum

  • Rank
    Newbie

Profile Information

  • Gender
    Male
  • Location
    Poland
  1. A few weeks ago I have done similar migration; source: Oracle database 9.2.0.1 worked on SunSolaris 8 destination: oracle database 11.2.0.2.3 worked on Intel x86_64 I you have small database f.e less than 200GB consider to use EXP/IMP Oracle programs (included on each Oracle Database server: see exp help=y as database owner with ORACLE_HOME environment) In this option remeber that you need an appropriate undo tablespace and undo retention ( if it is used) or rollabck segmets configured on source database If you database is larger than 200-300GB consider to upgrade database. f.e. first step: 9.2.0.1 upgrade to 9.2.0.8 second step: 9.2.0.8 upgrade to 11.2.0.3 In both situation application/users could not to connect to database during migration process
  2. Too small informations. 12170 can be for many reasons, f.e. listener not running, instance not running, firewall on network card, listener doesn't know about instance or isn't registered with instance bacause listener working on nondefault port, wrong ip address on listener configuration, wrong tnsnames and/or sqlnet configuration. Using commandline you can test resolve connection to listener using tnsping. This programm can check that tnsnames resolve good ip address, port and the name of service your database. Good luck.
  3. Hi Plumbum It is very sad to answer his own post. Such an operation itself is feasible and is not a problem. Thank you all for your attention
  4. Hi everyone I have a little problem. My production database is Oracle 9.2.0.1 works on Sun Solaris (big-endian). I have to make a migration from release 9.2.0.1 up to 11.2.0.1 on another platform - little endian (RedHat Linux 64bit). Database uses several tables with BLOB columns. If anyone could tell me the possible ways to implement such a migration? Please, not theoretical, only practical ways ;-)
  5. Just comment this line.
  6. It is very difficult to help you if you do not write a little more information; f.e. how you making connection to database using RMAN, your tnsname.ora file, lintener.ora file you ORACLE_SID e.t.c. Without this informations I suppose that you try to connect to wrong database. Please, write some more information to help you. (PS. sorry for my english)
  7. Answer on Your first question: YES. Answer on Your second question: I have a book "OCP Oracle Database 11g New Features for Administrators Exam Guide" published by Osborne and I suppose this position is enought.
  8. Can you paste your sqlnet.ora file, please? I suppose you do not have a line line: NAMES.DIRECTORY_PATH=(TNSNAMES,EZCONNECT)
  9. The best way is to use RMAN. I suppose you network configuration in Oracle on Windows and Linux is properly. Your Oracle on Linux is your target database and Oracle on Windows is your auxiliary database; f.e TEST. 1. note the name of tablespaces and id files on your target database using query: SQL> SELECT FILE_ID,TABLESPACE_NAME,FILE_NAME FROM DBA_DATA_FILES; 2. note the group of thet logfiles and members of this group usinf the query: SQL>SELECT GROUP#,MEMBER FROM V$LOGFILE; login to your target database using RMAN RMAN TARGET / AUXILIARY SYS/PASSWORD_OF_SYS@TEST RMAN> run{ set newname for datafile 1 to 'c:\path\to\your\oradata\system01.dbf'; set newname for datafile 2 to 'c:\path\to\your\oradata\undo01.dbf'; . . . set newname for tempfile 1 to 'c:\path\to\your\oradata\temp01.dbf'; duplicate target database to "TEST" logfile group 1 ('c:\path\to\your\logfile\redo01a.log','c:\path\to\your\logfile\redo01b.log') size 100M reuse, group 2 ('c:\path\to\your\logfile\redo02a.log','c:\path\to\your\logfile\redo02b.log') size 100M reuse, group 3 ('c:\path\to\your\logfile\redo03a.log','c:\path\to\your\logfile\redo03b.log') size 100M reuse; } After that remember to create default temporary tablespace: SQL> CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE 'C:\PATH\TO\YOUR\ORADATA\temp01.dbf' SIZE 100m; sql> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP01; Good Luck.
  10. Once again, you HAVE TO check that everything is ok about your configuration: file listener.ora: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME=ORCL) (ORACLE_HOME = C:\u01\product\11.1) (SID_NAME=ORCL) ) (SID_DESC = (GLOBAL_DBNAME=TEST) (ORACLE_HOME = C:\u01\product\11.1) (SID_NAME=TEST) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.10)(PORT = 1521)) ) ) ### END OF FILE file: tnsnames.ora ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.10)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) ) TEST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.10)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = PROD) ) ) ### remember to change HOST= to your ip address or your localname f.e. oracle.svrk.com. If you want to use localname you have to edit ### the file "localhost" in windows vista. ### END OF FILE file: sqlnet.ora NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) ### END OF FILE OEM do not like DHCP on your network card. REgardless of DHCP, sometimes you can have problems when you have two network cards. Sometimes you cannot create a new instance of OEM because you did not create a default temporary tablespace, f.e. : SQL> CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE '/PATH/TO/YOUR/ORADATA/TEMP01.DBF' SIZE 100M; SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP01; Good Luck.
  11. 1. check your listener, if your listener listen for the second DB 2. try to start listener first, then OEM of second DB and using OEM start second DB 3. check this files: sqlnet.ora, tnsnames.ora. In sqlnet.ora you have to appropriate NAMES.DIRECTORY_PATH and into tnsnames.ora aliases to your both instances. 4. I have DB on linux so in my OS version, to create OEM manually I am using this scripts: emca -repos create emca -config dbcontrol db to recreate OEM : emca -config dbcontrol db -repos recreate do delete OEM: emca -deconfig dbcontrol db I have no idea how it works on Vista. Good Luck.
  12. My intention is not to pass 1z0-311 exam, I would like to know a basic information about Oracle Application Server. Thank You for answer Regards.
  13. Hi everyone. I am reading this book "OCA Oracle Application Server 10g Stydy Guide" published by SYBEX. Few weeks ago I have found another similar book published by McGraww Hill Osborne "OCA Oracle Application Server 10g Administrator Exam Guide". I could not find some best part of this second book and I do not want to buy it to recognize both of them are the same. I have a question; have everyone read both of this books and can tell me about differences ? Maybe someone is the owner of this second book and could send me some part or all of this book in readable format f.e. PDF ? Thanks for any answers. PS. I am sorry for my English.