Home » RDBMS Server » Server Administration » Rapid clone on Database error
Rapid clone on Database error [message #282395] Wed, 21 November 2007 21:14 Go to next message
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 295 times)
Rapid clone on Database error [message #282396 is a reply to message #282395] Wed, 21 November 2007 21:16 Go to previous messageGo to next message
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 461 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 Go to previous messageGo to next message
BlackSwan
Messages: 25041
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)!
Re: Rapid clone on Database error [message #282399 is a reply to message #282395] Wed, 21 November 2007 21:42 Go to previous messageGo to next message
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
Re: Rapid clone on Database error [message #282401 is a reply to message #282395] Wed, 21 November 2007 22:04 Go to previous messageGo to next message
BlackSwan
Messages: 25041
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?".


Re: Rapid clone on Database error [message #282402 is a reply to message #282395] Wed, 21 November 2007 22:17 Go to previous messageGo to next message
alson
Messages: 41
Registered: October 2007
Location: -
Member

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

thanks

regards
ng
Re: Rapid clone on Database error [message #282404 is a reply to message #282395] Wed, 21 November 2007 22:31 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
Subject: Datafiles named 'MISSING' Doc ID: Note:77338.1
Re: Rapid clone on Database error [message #282412 is a reply to message #282395] Wed, 21 November 2007 23:12 Go to previous messageGo to next message
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.
Re: Rapid clone on Database error [message #282419 is a reply to message #282395] Wed, 21 November 2007 23:41 Go to previous messageGo to next message
BlackSwan
Messages: 25041
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.
Re: Rapid clone on Database error [message #282420 is a reply to message #282395] Wed, 21 November 2007 23:50 Go to previous messageGo to next message
alson
Messages: 41
Registered: October 2007
Location: -
Member

strongly agreed with you. I will try to sign up the Metalink as soon as possible. thanks for your advise.
Re: Rapid clone on Database error [message #282421 is a reply to message #282395] Wed, 21 November 2007 23:52 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
11/21/07 21:51:48 dns 219.93.187.106
nslookup 219.93.187.106
Canonical name: mail.tamco.com.my
Addresses:
219.93.187.106
Previous Topic: Making Oracle password automatically windows password
Next Topic: Exporting Data from a partitioned table
Goto Forum:
  


Current Time: Tue Dec 06 14:27:36 CST 2016

Total time taken to generate the page: 0.10072 seconds