I was cloning PROD to DEV instance … when I am configuring DEV instance , got following errors.
==================================================================================
ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2235208 bytes Variable Size 427820216 bytes Database Buffers 624951296 bytes Redo Buffers 13930496 bytes Control file created. alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/u02/oracle/DEV/oradata/DEV/system01.dbf' alter tablespace TEMP1 add tempfile '/u02/oracle/DEV/oradata/DEV/temp01.dbf' REUSE * ERROR at line 1: ORA-01109: database not open alter tablespace TEMP2 add tempfile '/u02/oracle/DEV/oradata/DEV/temp02.dbf' REUSE * ERROR at line 1: ORA-01109: database not open ALTER DATABASE RENAME GLOBAL_NAME TO "DEV.localhost" * ERROR at line 1: ORA-01109: database not open ORA-01109: database not open Error Running create/replace library with adupdlib.sql ORA-01109: database not open PL/SQL procedure successfully completed. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options exit_code=0 Checking for errors ... The database has not been successfully created. Shutting down the instance ... SQL*Plus: Release 11.2.0.3.0 Production on Sat Nov 1 01:26:22 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected. ORACLE instance shut down. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options .end std out. .end err out. --------------------------------------------------------------- ADX Database Utility --------------------------------------------------------------- getConnectionUsingAppsJDBCConnector() --> APPS_JDBC_URL='null' Trying to get connection using SID based connect descriptor getConnection() --> sDbHost : localhost sDbDomain : localhost.domain.com sDbPort : 1530 sDbSid : DEV sDbUser : apps Trying to connect using SID... getConnectionUsingSID() --> JDBC URL: jdbc:oracle:thin:@localhost:1530:DEV Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 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=localhost)(PORT=1530))(CONNECT_DATA=(SERVICE_NAME=DEV))) Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux-x86_64 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=localhost)(PORT=1530))(CONNECT_DATA=(SERVICE_NAME=DEV.localhost))) Exception occurred: java.sql.SQLException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor Connection could not be obtained; returning null -------------------ADX Database Utility Finished--------------- RC-00118: Error occurred during creation of database Raised by oracle.apps.ad.clone.ApplyDatabase StackTrace: java.lang.Exception: Control file creation failed at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:635) at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:473) at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:366) at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:110) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:501) at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67) at java.lang.Thread.run(Thread.java:637)
==================================================================================
In my case, control file were created successfully, but above error indicates that database was not created successfully.
I found root of this issue that when i had copied PROD binaries and data files at same time some services were running using ORACLE user.
Note: You would get this error if oracle database was not properly shutdown when you copied the files.
All my stuff were wasted.
So, I have copied only datafiles again from PROD to DEV.
And ran adcfgclone.pl dbTier again and cloning has been completed successfully without any error !!
Comments
Tags: Creation Of Database, data file 1, database, database not open, file 1 needs more recovery to be consistent, Occurred During Creation Of Database, ORA-01109, ORA-01109: database not open, ORA-01110, ORA-01110: data file 1, ORA-01194, ORA-01194: file 1 needs more recovery to be consistent, ORA-12514, Oracle, Oracle APPs DBA, Oracle Clone, Oracle Cloning, Oracle Database, Oracle DBA, oracle error, RC-00118, RC-00118 Error, RC-00118 Error Occurred During Creation Of Database, TNS:listener does not currently know of service requested in connect descriptor