ORA-12560 when using the Database Upgrade Assistant

http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci978802,00.html

I already saw that comment. Orcale_Home has been removed from the user's environment, as stated in my upgrade manual (SAP).
That Upgrade Assistant recognizes the "old" database, since it's listed in the list of available databases (it's actually the only entry in this list).

hi

check the link below.

https://www.experts-exchange.com/questions/20866347/ORA-12560-while-upgrading-from-8-1-7-to-9-2.html

regards
annamalai

I found that thread also. The last comment has actually been logged by me.

There is no resultion posted in that message. I tried all the other suggestions in that thread.

@repeat:

can you post the following results from your DOS window?

C:\>tnsping -v


C:\>lsnrctl -v


C:\>set | findstr  ora

@seazodiak:

I executed "tnsping <SID>" and "lsnrctl status". Both "-v" flags are unknown (it's a Windows system, not UNIX).

***************************************
tnsping TST:

D:\Oracle\TST\920\bin>tnsping TST

TNS Ping Utility for 32-bit Windows: Version 9.2.0.5.0 - Production on 19-AUG-2004 15:26:48

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files: D:\Oracle\TST\920\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = s31000039)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = TST)))
OK (30 msec)

***************************************
lsnrctl status:

D:\Oracle\TST\920\bin>lsnrctl status

LSNRCTL for 32-bit Windows: Version 9.2.0.5.0 - Production on 19-AUG-2004 15:27:30

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=s31000039)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 9.2.0.5.0 - Production
Start Date                19-AUG-2004 13:31:12
Uptime                    0 days 1 hr. 56 min. 18 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   D:\Oracle\TST\920\network\admin\listener.ora
Listener Log File         D:\Oracle\TST\920\network\log\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=s31000039.ct.group.local)(PORT=1521)
))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "TST" has 1 instance(s).
  Instance "tst", status READY, has 1 handler(s) for this service...
The command completed successfully

***************************************

Environment:

DBMS_TYPE=ORA
DBS_ORA__SCHEMA=SAPR3
dbs_ora_tnsname=TST
ORACLE_SID=TST

ok, sounds good.

Can you also take a look at TNSNAMES.ORA file under D:\Oracle\TST\920\network\admin\ ?

Make sure it contains TST entry there, otherwise, you have to manually add it there.


then you should be able to run DBUA

My TNSNAMES.ORA looks like this:

# TNSNAMES.ORA Network Configuration File: D:\Oracle\TST\920\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TST.CT.GROUP.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = s31000039)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = TST)
    )
  )

EXTPROC_CONNECTION_DATA.CT.GROUP.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

sorry, can you also post up your SQLNET.ORA file in the same folder?



also show the result of the command below:

D:\Oracle\TST\920\bin>tnsping TST.CT.GROUP.LOCAL

Just one more thing, Make sure oracle8i database is up and running.

you can do this by using sqlplus log in .

SQLNET.ORA:

# SQLNET.ORA Network Configuration File: D:\Oracle\TST\817\NETWORK\ADMIN\sqlnet.ora
# Generated by Oracle configuration tools.

#NAMES.DEFAULT_DOMAIN = WORLD
NAMES.DEFAULT_DOMAIN = ct.group.local

SQLNET.AUTHENTICATION_SERVICES = (NTS)

AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
NAME.DEFAULT_ZONE = WORLD

#### Attributes from protocol.ora ####

tcp.nodelay = true

*************************************

Results of the TNSPING:

D:\Oracle\TST\920\bin>tnsping TST.ct.group.local

TNS Ping Utility for 32-bit Windows: Version 9.2.0.5.0 - Production on 19-AUG-2004 15:53:49

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
D:\Oracle\TST\920\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = s31000039)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = TST)))
OK (30 msec)

ok, this should solve you problem.


YOu need to get rid of ".CT.GROUP.LOCAL " on TST entry in TNSNAMES.ORA

so change from :


TST.CT.GROUP.LOCAL =
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = s31000039)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = TST)
   )
 )



to

TST=
 (DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = s31000039)(PORT = 1521))
   )
   (CONNECT_DATA =
     (SERVICE_NAME = TST)
   )
 )

I changed the entry in tnsnames.ora and restarted the listener.
After that, the ODUA still gives the ORA-12560 error.

In your sqlnet.ora I noticed that it says
D:\Oracle\TST\817\NETWORK\ADMIN\sqlnet.ora

whereas I would expect it to be
D:\Oracle\TST\920\network\admin\sqlnet.ora

Can you check and post sqlnet.ora from D:\Oracle\TST\920\network\admin\sqlnet.ora

Also, when you log on to sqlplus, what is the banner displayed to you ?

The reference to my old oracle home in the SQLNET.ORA is because this file was copied from the old location to the new.
It's a commented line, so it shouldn't matter.

When I start SQLPlus, The banner reads:

"SQL*Plus: Release 9.2.0.5.0 - Production on Thu Aug 19 16:09:54 2004"

The command "connect / as sysdba" now results in "ORA-12514: TNS: Listener could not resolve SERVICE_NAME given in connect descriptor", where this connection was possible earlier today.

this is one of solutions appearing in metalink:



i deleted the oracle_home environment variable and rebooted my windows server.
i could then connect. however, if i connected to the database using sqlplus 8.1.7 just prior to starting the dbua, i would get a 12560! connecting via the 9.2 sqlplus and then quitting solves the problem!?!

In your SQLNET.ora you have NAMES.DEFAULT_DOMAIN = ct.group.local
so, you should not remove ".CT.GROUP.LOCAL" from tnsnames.ora.

from the command prompt, can you post the path ?

and the classpath (from environment variables)

@ seazodiak:

After I commented out the line you sugested, I get a "ORA-12154: TNS: Could not resolve service name" when connecting.

When I activate the line again, I'm able to connect to the database.

@@Repeat64 ::

from the command prompt, can you post the PATH ? and the classpath (from environment variables) ??

ok, anyway, once you can use sqlplus to connect TST,

you should be able to run DBUA to upgrade

@ pratikroy:

PATH=C:\Program Files\Perl\bin\;D:\Oracle\TST\920\jre\1.4.2\bin\client;D:\Oracle\TST\920\jre\1.4.2\bin;D:\Oracle\TST\920\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;D:\Oracle\TST\817\bin;C:\Program Files\Oracle\jre\1.1.7bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Progra
m Files\Support Tools\;D:\Program Files\nsr\bin;d:\oracle\tst\920\opatch;;H:\usr\sap\TST\sys\exe\run;D:\Oracle\TST\817\bin

I can't seem to find any reference to classpath

@seazodiak:

While I'm connected to the database using sqlplus 9205 but the ODUA still reports the ORA-12560.

try to reboot machine.

and start DBUA that way.

If you check the System Properties (You may find the 'system' icon on control panel - you'll have to double click this icon or open it to see the system properties), you would find 'Environment Variables' Button on the 'Advanced' Tab. In the environment variables, you would find classpath as one of the system variables. If you double click on it, you would be able top copy and paste the value from the edit box there.

Anyways, have you tried rebooting your machine ?

1) I shutdown the database using sqlplus 9205
2) I rebooted the server
3) I started svrmgrl and started up the database
4) I connected to the database using sqlplus 9205
5) I started the ODUA and selected the old Oracle home
6) ORA-12560 occurred

@pratikroy:
There is no environment variable called classpath either in the user's environment or in the system's environment.

3) I started svrmgrl and started up the database

this could cause the problem.


In the service control , you should make the OracleServiceTST automatically start..


YOu should not use any 817 tool after restart.

Huh? The OracleServiceTST is set to automatic, but this does not start my database automatically.

I'm unable to start the database using the 9205 tools provided.

try this:

C:\>Set ORACLE_HOME=<to oracle8i HOME>
C:\>set ORACLE_SID=TST

C:\>D:\Oracle\TST\920\BIN\dbua

This, you are not going to believe: The problem was solved by installing VNC on the server and by using that tool to connect to the server instead of using a Remote Desktop connection. I didn't even mention the fact thta we were using RDC since I thought it to be obvious or not important.

Thanks for the input you all have given me over the past hours.