cant continue upgrade of DLP

[m@ntec]

hi all,

 

please help me regards of this issue, cant continue this upgrade due to this error.

 

in a command prompt:

c:\Users\Administrator>sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Tue May 28

Copyright <c> 1982, 2011, Oracle. All rights reserved.

 

SQL>conn sys/<password> as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error

 

please advise. 

thank you,

marj

 

 

[yang_zhang]

I think you need to set a environment variable named ORACLE_SID for your Windows System.

Set the ORACLE_SID via My Computer > Properties > Advanced > Environment Variables. Add a new variable by clicking New and supplying a variable name of ORACLE_SID and a value of whatever the database name is as it appears in the tnsnames.ora file. Click OK when you are done.

When you log in from the command line again, the new variable will be picked up and you will get something similar to the following:

C:\Documents and Settings\Administrator>sqlplus protect

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Feb 10 13:49:24 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter password:

Connected to:
Oracle Database 10g Release 10.2.0.4.0 - Production

SQL>

[m@ntec]

hi thanks for reply, what should i input in Variable name: and variable value?

apologized for asking this, i'm just new here. please help.

[yang_zhang]

The variable name:ORACLE_SID

The variable value:Protect

[m@ntec]

hi, thanks for this. but stilll can't move forward on conn sys/password as sysdba

please advice.

 

marj

[m@ntec]

hi,

 

how could i start the services OracleMTS recovery service

 

thanks a lot.

marj

[Migration User]

Are you oracle services even started? If you can't connect sys/password as sysdba then you have to check to see if the services are running.  Is this a single tier or three tier installation?  

 

[DLP kishorilal]

Please chcek the installation logs and verify the prerequisite for DLP.

[m@ntec]

hi fivelakes,

there is one services that cant start. the ORACLEMTSRecoverryServices.

it might be the cause of the TNS:protocol adapter error.

 

 

[m@ntec]

hi K S Sharma,

where could i found this installation logs? and does it need all the services of oracle  are started before installing the new oracle?

 

 

thanks,

marj

[DLP kishorilal]

Dear mbuenaobra

As Also refer below for logs

https://www-secure.symantec.com/connect/forums/dlp-logs

As mentioned above yang, Please chcek the same, I am writing again with above log thead

Set the ORACLE_SID via My Computer > Properties > Advanced > Environment Variables. Add a new variable by clicking New and supplying a variable name ofORACLE_SID and a value of whatever the database name is as it appears in the tnsnames.ora file. Click OK when you are done.

When you log in from the command line again, the new variable will be picked up and you will get something similar to the following:

C:\Documents and Settings\Administrator>sqlplus protectSQL*Plus: Release 10.2.0.4.0 - Production on Tue Feb 10 13:49:24 2009Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Enter password:Connected to:Oracle Database 10g Release 10.2.0.4.0 - ProductionSQL>

To connect to another database, provide the net service name as it appears in the tnsnames.ora file. Use the following example:

C:\Documents and Settings\Administrator>sqlplus protect@vontudbsSQL*Plus: Release 10.2.0.4.0 - Production on Tue Feb 10 13:49:24 2009Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Enter password:Connected to:Oracle Database 10g Release 10.2.0.4.0 - ProductionSQL>

 

[m@ntec]

hi,

ORAMTSRecovery Services  is now working. by changing the prod!

and added new variable through MY computer>properties>advanced>environment variable.

then run SET ORACLE_HOME= location of the software directory

edit and add input to sqlnet.ora and to listener.ora.

 

this works all. and checking all services of oracle if they are all running.

 

but i'm still completing the upgrade (POST UPGRADE)

 

thank you again.