Home » RDBMS Server » Server Administration » RC-50004 in adcfgclone.pl in db tier (ORACLE-9.2.0.6, OS - WIndows server 2003. )
RC-50004 in adcfgclone.pl in db tier [message #389356] Sun, 01 March 2009 08:13 Go to next message
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 1266 times)
Re: RC-50004 in adcfgclone.pl in db tier [message #389363 is a reply to message #389356] Sun, 01 March 2009 10:17 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>ORA-12638: Credential retrieval failed
When was last time it worked?
What changed?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you & please be consistent & correct in your postings.
Re: RC-50004 in adcfgclone.pl in db tier [message #389376 is a reply to message #389363] Sun, 01 March 2009 12:15 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #389819 is a reply to message #389356] Tue, 03 March 2009 12:20 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Please guide me solving yhis issue.
Has Oracle RDBMS been actually started?
Re: RC-50004 in adcfgclone.pl in db tier [message #389821 is a reply to message #389819] Tue, 03 March 2009 12:27 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


>>ORA-12638: Credential retrieval failed

Replacing the line: NTS -----------> NONE (nts to none)

SQLNET.AUTHENTICATION_SERVICES= (NTS)

with

SQLNET.AUTHENTICATION_SERVICES= (NONE)

Once clone goes fail; Then database should be goes down; That's why you got below error.

Quote:
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.
Re: RC-50004 in adcfgclone.pl in db tier [message #389823 is a reply to message #389819] Tue, 03 March 2009 12:30 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Yes it is started.
Checked from services and found 'RDBMSSNMPpeer and master agent' and 'RDBMSTNS listener' are running. Oracle services also running.

Regards
Ridhi Sundar
Re: RC-50004 in adcfgclone.pl in db tier [message #389825 is a reply to message #389356] Tue, 03 March 2009 12:34 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Please follow Posting Guidelines!

>Yes it is started.
using sqlplus along with CUT & PASTE to prove your assertion is correct.

Simply put if you can not use sqlplus to get logged into DB,
then the database is NOT running. QED!
Re: RC-50004 in adcfgclone.pl in db tier [message #389828 is a reply to message #389825] Tue, 03 March 2009 12:41 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


As per your log file database goes down because your cloning fail.

1/ Requesting to you; Please post if it's database up (check your services and alert log files)

2/ Please read the OraFAQ Forum Guide before posting.
http://www.orafaq.com/forum/t/88153/0/
Re: RC-50004 in adcfgclone.pl in db tier [message #389830 is a reply to message #389356] Tue, 03 March 2009 12:47 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>(ORACLE-9.2.0.6, OS - WIndows server 2003. )
NOT a certified combination, besides the fact that V9.2 is obsoleted now.

What Operating system name & version for source DB system?
What Oracle version to 4 decimal places for source DB?
Re: RC-50004 in adcfgclone.pl in db tier [message #389893 is a reply to message #389830] Wed, 04 March 2009 00:12 Go to previous messageGo to next message
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 #389965 is a reply to message #389893] Wed, 04 March 2009 06:26 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


>ORA-12560 (TNS: Protocol adaptor error)

Looks like manually you need to start your Oracle service. (Check from services.msc)

>>I am completely clueless what to do now.

Hope we already answer your query;
Re: RC-50004 in adcfgclone.pl in db tier [message #389975 is a reply to message #389965] Wed, 04 March 2009 06:56 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #390018 is a reply to message #390002] Wed, 04 March 2009 11:02 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
So how can I know whether my datafile is missed?
Do you mean to say I have to start from preclone again?

Regards
RIdhi Sundasr
Re: RC-50004 in adcfgclone.pl in db tier [message #390043 is a reply to message #389356] Wed, 04 March 2009 12:50 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Compare & contrast the environment of the source system & the target system.
Re: RC-50004 in adcfgclone.pl in db tier [message #390559 is a reply to message #389356] Sat, 07 March 2009 08:28 Go to previous messageGo to next message
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 #390568 is a reply to message #389356] Sat, 07 March 2009 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
post contents of SQLNET.ORA file
Re: RC-50004 in adcfgclone.pl in db tier [message #390586 is a reply to message #390568] Sat, 07 March 2009 22:48 Go to previous messageGo to next message
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 #390589 is a reply to message #389356] Sat, 07 March 2009 23:36 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Since you are unwilling or incapable of following Posting Guidelines, I will stop wasting my time trying to guess what is or is not happening.
Re: RC-50004 in adcfgclone.pl in db tier [message #390591 is a reply to message #390589] Sun, 08 March 2009 00:32 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Hi
I am extremely sorry if I am doing any mistake but I couldn't know where I am violating the posting guidelines.

Please help me.

Thanks
Ridhi Sundar
Re: RC-50004 in adcfgclone.pl in db tier [message #390592 is a reply to message #389356] Sun, 08 March 2009 00:36 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Please post 2 lists.

List #1

Provide the Posting Guidelines you have followed with examples.

List #2

Provide the Posting Guidelines you have NOT followed.

For those you have not provided, then do so.

Re: RC-50004 in adcfgclone.pl in db tier [message #390595 is a reply to message #390592] Sun, 08 March 2009 01:19 Go to previous messageGo to next message
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 #390596 is a reply to message #389356] Sun, 08 March 2009 01:33 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Please post 2 lists.

List #1

Provide the Posting Guidelines you have followed with examples.

List #2

Provide the Posting Guidelines you have NOT followed.

For those you have not provided, then do so.


Why do you need SQL*Net to start Oracle?
Re: RC-50004 in adcfgclone.pl in db tier [message #390599 is a reply to message #390596] Sun, 08 March 2009 03:57 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Why do you need SQL*Net to start Oracle?


I didn't use SQL*Net to start Oracle.
Re: RC-50004 in adcfgclone.pl in db tier [message #390605 is a reply to message #390599] Sun, 08 March 2009 08:54 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

@ridhi_sundar,

As per your last statement; There are two many database configured in your Operating System (May be some of databases down)

That's the reason you need set ORACLE_SID.

>>How can I set the ORACLE_SID permanently?

You must aware of Operating System level PATH; Try to configure User level variable for your OS (windwos -> properties > Advanced > Environment for Variables > (In user variable) > New > ORALCE_SID and SID Name

Open New command prompt verify using echo %ORACLE_SID%

PS: Requesting to you; before posting you need to check post guide also you may need to fix your root cause of error. ( I hope your root error

ORA-12638: Credential retrieval failed


Try to fix the above error.

Babu
Re: RC-50004 in adcfgclone.pl in db tier [message #390608 is a reply to message #390605] Sun, 08 March 2009 10:24 Go to previous messageGo to next message
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


Re: RC-50004 in adcfgclone.pl in db tier [message #390613 is a reply to message #390608] Sun, 08 March 2009 12:30 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Thanks for your feedback.

I think you may need to start new topic for your autoconfig issue.
Re: RC-50004 in adcfgclone.pl in db tier [message #390614 is a reply to message #390613] Sun, 08 March 2009 12:35 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Thanks Babu

I am going to start a new topic for my autoconfig issue.

Regards
Ridhi Sundar

[Updated on: Sun, 08 March 2009 12:36]

Report message to a moderator

Re: RC-50004 in adcfgclone.pl in db tier [message #445995 is a reply to message #389356] Fri, 05 March 2010 01:31 Go to previous message
seraulu1
Messages: 1
Registered: March 2010
Location: shgdrgyer
Junior Member
Hi


Razz Razz Razz Thanks for that!
Previous Topic: Oudated alert log
Next Topic: Drop table issue
Goto Forum:
  


Current Time: Fri Dec 09 13:50:54 CST 2016

Total time taken to generate the page: 0.10055 seconds