ORA 12560 TNS: Protocol Adapter Error

[Former Member]

Dear Folks,

System Environment: HP UX, Oracle 11g, Windows 2003, and Solution Manager 7.1 SP11

I have done a System Restore on Development Server of Solution Manager from an old backup, but system is failing to start as I am not able to start DB

When I try to log in to Oracle using sqlplus "/as sysdba" it is asking me for username and password, when I enter username and password it does not work and gives me error after 3 attempts

ORA 12560 TNS: Protocol Adapter Error

Help is appreciated

APS

[former_member182657]

Hi,

Could you check with Oracle services under services.msc,these all should be in running state or if possible share the snap-shot for services.msc.

One more thing which i would like to check here for complete disability of any type of firewall as well as for Antivirus if any.Try to disable windows firewall & Antivirus to re-check again.

Please confirm.

Thanks,

[former_member182657]

Could you share alert_<SID>.log as well as result for command lsnrctl status.

Thanks,

[former_member182657]

Hi Aps,

Hope your issue has already been resolved by above suggestions,if not please follow SAP KBA 1734700 - ORA-12560: TNS:protocol adapter error

& SAP Note  441518 - ORA-12560 composite SAP Note, which are suggeststing issue with ORACLE_SID.Try to set the variable & restart the complete system.

Hope this will help you.

Good luck !!

[Former Member]

Dear all,

I have followed notes:

441518_ORA_12560_composite_SAP_Note

1921560_sidadm_environment_variable_is_not_read_when_SAP_starting

and I have set all parameters correctly in environmental variables and also checked registry entries in HLOCAL_KEY

and still nowhere bloody thing won't start

Help is appreciated

Regards,

APS

[Brindavan_M]

Hello ,

Login with oraSID at OS Level and execute the comment  " relink all".

Let me know if you still facing the issue.

Thanks,

BM

[Former Member]

Dear All,

I am attaching screen shots for listener and services.msc file

\

Help is appreciated

Regards

APS

[Brindavan_M]

Hello ,

The screen shot clearly that you have login SIDadm user. Can you login with Administrator or oraSID and try to start the database. if not then do the command "relink all".

Let us know if you still facing the issue.

Thanks,

BM

[Former Member]

Hi Brindavan,

Even when I try to login as administraor I am not able to enter DB using sqlplus

I have checked environmental variable and they are all pointing to correct values.

secondly I checked relink all I think that works only in UNIX and not in Windows environment as I tried and binary is not there in /oracle/SMS/11203/bin

Regards,

APS

[Brindavan_M]

Hi,

Have you try with ORASID login as well, check the host file and the IP address maintained as when install oracle .

Thanks,

Brindavan

[Former Member]

How old was your backup? Did you restore the same SID?

[Brindavan_M]

Hi Mark,

Try the below comments

C:\set ORACLE_SID=<SID>

SQL> conn /@<SID> as sysdba

Also, Check the below user  operating system users and groups

ORA_DBA -> <sid>adm, SAPService<SID>

ORA_<SID>_DBA -> <sid>adm, SAPService<SID>

ORA_<SID>_OPER -> <sid>adm, SAPService<SID>

SAP_LocalAdmin -> <sid>adm, SAPService<SID>

SAP_<SID>_GlobalAdmin -> <sid>adm, SAPService<SID>

SAP_<SID>_LocalAdmin -> <sid>adm, SAPService<SID>

Check the ORACLE_HOME path set correctly

Let us know if you still facing the issue.

Thanks,

BM

[former_member184628]

Hi,

Check if all Oracle services are running.

Start -> run -> services.msc -> OracleserviceSID and other services are running.

Login as SIDadm and check if ORACLE_SID is properly set.

Thanks,

Sharib