REDHAT ES3
EBS 10.5.10
Creating the control file for dev_gmerp database ...
SQL*Plus: Release 9.2.0.6.0 - Production on Fri Jan 19 16:32:45 2007
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
Connected.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area581506668 bytes
Fixed Size
452204 bytes
Variable Size
402653184 bytes
Database Buffers
167772160 bytes
Redo Buffers
10629120 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/ebsdev/devdata/system01.dbf'
alter tablespace TEMP add tempfile '/u02/ebsdev/devdata/temp01.dbf' REUSE
*
ERROR at line 1:
ERROR at line 1:
ORA-01109: database not open
ALTER DATABASE RENAME GLOBAL_NAME TO "dev.nlic.com.cn"
*
ERROR at line 1:
ORA-01109: database not open
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area581506668 bytes
Fixed Size
452204 bytes
Variable Size
402653184 bytes
Database Buffers
167772160 bytes
Redo Buffers
10629120 bytes
Database mounted.
Database mounted.
PL/SQL procedure successfully completed.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area581506668 bytes
Fixed Size
452204 bytes
Variable Size
402653184 bytes
Database Buffers
167772160 bytes
Redo Buffers
10629120 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/ebsdev/devdata/system01.dbf'
ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost: gmerp
sDbDomain: nlic.com.cn
sDbPort: 1524
sDbSid : dev
sDbUser: APPS
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc
racle:thin:@gmerp.nlic.com.cn:1524:dev
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter
could not establish the connection
Trying to connect using SID as ServiceName
Trying to connect using SID as ServiceName
getConnectionUsingServiceName() -->
JDBC URL: jdbc
racle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gmerp.
nlic.com.cn)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=dev)))
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter
could not establish the connection
Trying to connect using SID as ServiceName.DomainName
getConnectionUsingServiceName() -->
JDBC URL: jdbc
racle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gmerp.
nlic.com.cn)(PORT=1524))(CONNECT_DATA=(SERVICE_NAME=dev.nlic.com.cn)))
Exception occurred: java.sql.SQLException: Io exception: The Network Adapter
could not establish the connection
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.(ApplyDatabase.java:474)
at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:319)
-------------------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.(ApplyDatabase.java:474)
at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:319)
at oracle.apps.ad.clone.ApplyDatabase.(ApplyDatabase.java:295)
at oracle.apps.ad.clone.ApplyDBTier.(ApplyDBTier.java:154)
at java.lang.reflect.Constructor.newInstance(Native Method)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:68)
at java.lang.Thread.run(Thread.java:479)