Southern California Data Loss Prevention User Group

 View Only
Expand all | Collapse all

cant continue upgrade of DLP

  • 1.  cant continue upgrade of DLP

    Posted May 28, 2013 09:30 PM

    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

     

     



  • 2.  RE: cant continue upgrade of DLP

    Broadcom Employee
    Posted May 30, 2013 09:54 AM

    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>



  • 3.  RE: cant continue upgrade of DLP

    Posted May 30, 2013 08:26 PM

    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.



  • 4.  RE: cant continue upgrade of DLP

    Broadcom Employee
    Posted May 31, 2013 02:12 AM

    The variable name:ORACLE_SID

    The variable value:Protect



  • 5.  RE: cant continue upgrade of DLP

    Posted May 31, 2013 03:01 AM

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

    please advice.

     

    marj



  • 6.  RE: cant continue upgrade of DLP

    Posted May 31, 2013 03:11 AM

    hi,

     

    how could i start the services OracleMTS recovery service

     

    thanks a lot.

    marj



  • 7.  RE: cant continue upgrade of DLP

    Posted May 31, 2013 08:11 AM

    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?  

     



  • 8.  RE: cant continue upgrade of DLP

    Posted Jun 02, 2013 09:06 AM

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



  • 9.  RE: cant continue upgrade of DLP

    Posted Jun 02, 2013 09:01 PM

    hi fivelakes,

    there is one services that cant start. the ORACLEMTSRecoverryServices.

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

     

     



  • 10.  RE: cant continue upgrade of DLP

    Posted Jun 02, 2013 09:03 PM

    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



  • 11.  RE: cant continue upgrade of DLP

    Posted Jun 04, 2013 10:23 AM

    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>

     



  • 12.  RE: cant continue upgrade of DLP
    Best Answer

    Posted Jun 05, 2013 10:16 PM

    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.