OraFAQ Forum: Server Administration » Rapid clone on Database error

Home » RDBMS Server » Server Administration » Rapid clone on Database error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rapid clone on Database error [message #282395]

Wed, 21 November 2007 21:14

alson
Messages: 41
Registered: October 2007
Location: -

Member

Dear Experts

Need your expertise on this problem Urgently, I have cloning problem for 2 weeks already. I am using Note:230672.1 to do the cloning for my databse.

Please refer to attached file for my error.

thank you

regards
ng

Attachment: 11191135.log
(Size: 140.70KB, Downloaded 1264 times)

Report message to a moderator

Rapid clone on Database error [message #282396 is a reply to message #282395]

Wed, 21 November 2007 21:16

alson
Messages: 41
Registered: October 2007
Location: -

Member

Dear Experts

Need your expertise on this problem Urgently, I have cloning problem for 2 weeks already. I am using Note:230672.1 to do the cloning for my databse.

I have try to rerun the whole process of 230672.1 and make sure the database has properly shutdown before I copy datafile and oracle home to target.

Please refer to attached file for my error.

thank you

regards
ng

Attachment: 11191135.log
(Size: 140.70KB, Downloaded 1383 times)

[Updated on: Wed, 21 November 2007 21:17]

Report message to a moderator

Re: Rapid clone on Database error [message #282397 is a reply to message #282395]

Wed, 21 November 2007 21:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Yes, you have errors.

---------------------------------------------------------------
                   ADX Database Utility                        
---------------------------------------------------------------

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : testdb1
    sDbDomain  : test.com.my
    sDbPort    : 1531
    sDbSid     : HLD
    sDbUser    : apps
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@testdb1.test.com.my:1531:HLD
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory

    Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testdb1.test.com.my)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=HLD)))
    Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HP-UX Error: 2: No such file or directory

    Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testdb1.test.com.my)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=HLD.test.com.my)))
    Exception occurred: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=135295744)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

IMO, you need to make the above failure no longer occurs, before attempting another invocation of this utility.

I have have NO idea about your environment & you presented no details, You're On Your Own (YOYO)!

Report message to a moderator

Re: Rapid clone on Database error [message #282399 is a reply to message #282395]

Wed, 21 November 2007 21:42

alson
Messages: 41
Registered: October 2007
Location: -

Member

I have this error even in my previous successful clone. But I don't know why my database still can mount and open successfully. But for the below error, only happen recently,
do you have any idea how to solved this. I can start and stop my clone databse successfuly, does it mean that the below error not so critical. thanks

ERROR at line 1:
ORA-01119: error in creating database file
'/hld/orahld/hlddb/8.1.7/dbs/MISSING00373'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 2619
ORA-06512: at line 1

Report message to a moderator

Re: Rapid clone on Database error [message #282401 is a reply to message #282395]

Wed, 21 November 2007 22:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORA-01119: error in creating database file '/hld/orahld/hlddb/8.1.7/dbs/MISSING00373'
>ORA-27037: unable to obtain file status

The above means that Oracle knows a datafile is missing.
Depending upon which datafile/tablespace is involved, you may or may not be able to open the database.

The main question that first comes to mind is, "Does the source database have all its files intact?".

Report message to a moderator

Re: Rapid clone on Database error [message #282402 is a reply to message #282395]

Wed, 21 November 2007 22:17

alson
Messages: 41
Registered: October 2007
Location: -

Member

hi, any idea how to check what is the missing file ?

thanks

regards
ng

Report message to a moderator

Re: Rapid clone on Database error [message #282404 is a reply to message #282395]

Wed, 21 November 2007 22:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Subject: Datafiles named 'MISSING' Doc ID: Note:77338.1

Report message to a moderator

Re: Rapid clone on Database error [message #282412 is a reply to message #282395]

Wed, 21 November 2007 23:12

alson
Messages: 41
Registered: October 2007
Location: -

Member

hi, thanks for your quick response, referring to the note, i found that the /hld/orahld/hlddb/8.1.7/dbs/MISSING00373 is actually referring to /hld/orahld/hlddata/mrp04.dbf, the file is being copy during cloning, but some how, it could not find the file.

I will try to redo all the cloning process(from adpreclone on source system) tonight and see whether the problem can be solved.

I don't have metalink access, the note I am actually getting from my friend, appreciate if you could download for me any notes in future.

thanks for your help.

Report message to a moderator

Re: Rapid clone on Database error [message #282419 is a reply to message #282395]

Wed, 21 November 2007 23:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I don't have metalink access, the note I am actually getting from my friend, appreciate if you could download for me any notes in future.
Your friend could be in BIG TROUBLE for violating his contract with Oracle by sharing copyrighted material with YOU!
If you need access to MetaLink, I suggest you contract for it legally as opposed to conspiring with others to do illegal acts.

Report message to a moderator