| RC-50004 in adcfgclone.pl in db tier [message #389356] |
Sun, 01 March 2009 08:13  |
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
|
Senior Member |
|
|
Hi
While running adcfgclone.pl in my target server I found the below error.
Beginning database tier Apply - Sun Mar 1 03:24:54 2009
Log file located at D:\TEST\testdb\9.2.0\appsutil\log\TEST_fintest\ApplyDBTier_
3010324.log
RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed
ERROR while running Apply...
ERROR: Failed to execute D:\TEST\testdb\9.2.0\appsutil\clone\bin\adclone.pl
Please check logfile.
I am attaching the log file here.
Can anyone give some clue to troubleshoot this error?
Thanks & Regards
Ridhi Sundar
-
Attachment: clone_log.txt
(Size: 267.37KB, Downloaded 2908 times)
|
|
|
|
|
|
| Re: RC-50004 in adcfgclone.pl in db tier [message #389376 is a reply to message #389363] |
Sun, 01 March 2009 12:15  |
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
|
Senior Member |
|
|
Hi Black swan
Thanks for the responce.
| Quote: | ORA-12638: Credential retrieval failed
|
Yes I have this error in my alertlog.
| Quote: | When was last time it worked?
|
This is first time I am doing a clone on this DB.
can you give some hint to troubleshoot?
Regards
Ridhi Sundar
|
|
|
|
| Re: RC-50004 in adcfgclone.pl in db tier [message #389809 is a reply to message #389376] |
Tue, 03 March 2009 11:56 |
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
|
Senior Member |
|
|
Can any one help me out please? I have also
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
errors in my log file.
I checked my ORACLE_HOME, and SID are set properly from regedit.
Please guide me solving yhis issue.
Regards
Ridhi Sundar
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: RC-50004 in adcfgclone.pl in db tier [message #389893 is a reply to message #389830] |
Wed, 04 March 2009 00:12 |
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
|
Senior Member |
|
|
Hi All
Sorry for a wrong information. That is not 9.2.0.6 that is 9.2.0.7.
OS is same for both (windows 2003).
About DB version the version of source DB is 9.2.0.7.
What has been done till now:
-----------------------------
1. My client did the preclone in source and put the files in destination.
2. I jst used adcfgclone.pl and I faced this error.
3. Then I ran autoconfig after that the db services started but when i am trying to connect to DB it is giving error ORA-12560 (TNS: Protocol adaptor error)
I am completely clueless what to do now.
Another information in regedit I found the ORACLE_BASE is pointing to e:\oracle. There is no directory 'oracle' in e:\.
Please help....
Regards
Ridhi Sundar
|
|
|
|
|
|
| Re: RC-50004 in adcfgclone.pl in db tier [message #389975 is a reply to message #389965] |
Wed, 04 March 2009 06:56 |
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
|
Senior Member |
|
|
Hi all
I have already told oracle service is running in services.msc. Listener is up. ORACLE_HOME and ORACLE_SID are set properly.
D:\TEST\testdb\9.2.0\bin>tnsping TEST
TNS Ping Utility for 32-bit Windows: Version 9.2.0.7.0 - Production on 04-MAR-20
09 07:50:07
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
D:\TEST\testdb\9.2.0\network\admin\TEST_fintest\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=fintest)(PORT=1
521)) (CONNECT_DATA=(SID=TEST)))
OK (20 msec)
D:\TEST\testdb\9.2.0\bin>set ORACLE_SID
ORACLE_SID = TEST
D:\TEST\testdb\9.2.0\bin>set ORACLE_HOME
ORACLE_HOME = D:\TEST\testdb\9.2.0
D:\TEST\testdb\9.2.0\bin>sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production on Wed Mar 4 07:51:49 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: /as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
What should be my next step to solve this?
Regards
Ridhi
|
|
|
|
| Re: RC-50004 in adcfgclone.pl in db tier [message #390002 is a reply to message #389975] |
Wed, 04 March 2009 09:05 |
IBNHUSSAIN
Messages: 39
Registered: December 2007
Location: INDIA
|
Member |
|
|
The first major step when run adcfgclone.pl is to create database. It never created database in your case so look into the log file for database creation errors. it may be that some of the datafiles missing or corrupted.
hope it helps.
|
|
|
|
|
|
|
|
| Re: RC-50004 in adcfgclone.pl in db tier [message #390559 is a reply to message #389356] |
Sat, 07 March 2009 08:28 |
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
|
Senior Member |
|
|
Hi All
I didn't see there were 2 more datatops. I was missing these datatops so i was getting this error.After this also i got an error as below in log file:
| Quote: |
Exception occurred: java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
|
When i was trying to login to DB from sqlplus I got the same error.
D:\TEST\testdb\9.2.0\bin>sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production on Sat Mar 7 06:18:33 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: /as sysdba
ERROR:
ORA-12638: Credential retrieval failed
Then I tried the below steps:
D:\TEST\testdb\9.2.0\bin>sqlplus /nolog
SQL*Plus: Release 9.2.0.7.0 - Production on Sat Mar 7 06:36:50 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysdba
ERROR:
ORA-01031: insufficient privileges
SQL> connect sys/manager as sysdba
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 573121060 bytes
Fixed Size 455204 bytes
Variable Size 394264576 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
Database mounted.
Database opened.
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
test OPEN
SQL>
Now my DB is up and running.
My question is do i need to do any thing else? or my process for the dbtier is over ? Shall I go ahead with APPS tier now?
Regards
Ridhi Sundar
|
|
|
|
|
|
| Re: RC-50004 in adcfgclone.pl in db tier [message #390586 is a reply to message #390568] |
Sat, 07 March 2009 22:48 |
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
|
Senior Member |
|
|
Contents of sqlnet.ORA:
| Quote: |
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
sqlnet.authentication_services= (NONE)
SQLNET.EXPIRE_TIME= 10
|
Every time when i try to connect to DB I am geting ORA-12560 error, and I need to set the SID. How can i omit this error permanently?
Regards
Ridhi Sundar
|
|
|
|
|
|
|
|
|
|
| Re: RC-50004 in adcfgclone.pl in db tier [message #390595 is a reply to message #390592] |
Sun, 08 March 2009 01:19 |
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
|
Senior Member |
|
|
Hi
Sorry for the mistakes I have done so far.
When ever I am opening a new session and trying to login to DB it gives error ORA-12560.
D:\TEST\testdb\9.2.0\bin>sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production on Sun Mar 8 02:11:05 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys/manager as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
When I set the ORACLE_SID again this gets resolved
D:\TEST\testdb\9.2.0\bin>set ORACLE_SID=TEST
D:\TEST\testdb\9.2.0\bin>sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production on Sun Mar 8 02:12:01 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys/manager as sysdba
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
SQL>
How can I set the ORACLE_SID permanently?
Regards
Ridhi Sundar
|
|
|
|
|
|
|
|
|
|
| Re: RC-50004 in adcfgclone.pl in db tier [message #390608 is a reply to message #390605] |
Sun, 08 March 2009 10:24 |
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
|
Senior Member |
|
|
Thanks Babu.
I configured user level variable as you told. Now my SID is set properly.
C:\Documents and Settings\fintest>echo %ORACLE_SID%
TEST
C:\Documents and Settings\fintest>sqlplus
SQL*Plus: Release 9.2.0.7.0 - Production on Sun Mar 8 10:10:24 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter user-name: sys/manager as sysdba
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
SQL>
Now I have another problem.
I have run the adcfgclone.pl in appstier. It completed but with some errors in autoconfig.
the content of log file:
| Quote: | [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: E:\TEST\testcomn\admin\install\TEST_fintest
adgenjky.cmd INSTE8_SETUP 128
[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: E:\TEST\testcomn\admin\install\TEST_fintest
adsvalsn.cmd INSTE8_APPLY -1
AutoConfig is exiting with status 2
|
I modified the environmental variable DISCO_JRE to point to the jre in my COMMON_TOP.
After this wen i ran autoconfig it stopped abruptly. In log i found the below:
| Quote: | Starting AutoConfig at Sun Mar 8 09:33:47 2009
Using adconfig.pl version 115.74
Classpath :
Version Conflicts among development maintained and customized templates encountered; aborting AutoConfig run.
The logfile for this session is located at: D:\TEST\testappl\admin\TEST_fintest\log\03080933\adconfig.log
|
Then i rolled back my environmental variable DISCO_JRE to the old value but no result.
Please can any one help me get rid of this problem?
Regards
Ridhi Sundar
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
