Oracle- 12560: TNS: protocol adapter error

[former_member182034]

Hi All,

I installed ORACLE 10.2.0.1 software and its patch 10.2.0.2 on window server 2003 64Bit R2. First i created listener service which is not created and after then i want to upgrade the oracle. When i run

sqlplus "/as sysdba"

then i received below error:

Oracle- 12560: TNS: protocol adapter error

while i have add the ORACLE_SID = DSD

cheers,

[former_member204746]

Windows services OracleService<SID> and OracleTNSListener<SID> must both be started.

[former_member182034]

Hi Eric,

plz read my first message in which i mentioned

First i created listener service which is not created

after that still facing that problem.

regards,

[Former Member]

Hi Majamil,

Please create oracle service with the follwoing command:-

Step 1:- Go to CMD promont

Step2 :- Oradim -NEW -SID (SID is the name of your database)

This command will create oracle service. Start the oracle service from services.

Once this service is running then try to connect to database with sqlplus.

Best Luck,

Atil

[former_member182034]

i created it and when i try to start it then i got error like (service could not start on local computer) .

regards.

[Former Member]

Hi,

Is there any other instance of Oracle is running? If it is then check for the port no listener.ora file and also check the serverices.

Thank You,

Mahesh C

[former_member204746]

WAIT!

when you install Oracle, you should not need to create listener or Oracle Service. SAPINST will do that for you.

ins this a new installation? a system copy? a standby DB?

[former_member182034]

Hi Erick,

this is new installation and i created new listener service with default 1521 port while during the SAP installation oracle want to create listener service with 1527 port. now installation is stop and i m getting listener port error. may i delete the oracle software and listener service from window registry and reinstall the oracle software and its patch.

what should i do for further proceeding mean restart is best solution?

waiting ur response

regards,

majamil

[Former Member]

Hi,

Change the port no to 1527 in the listener.ora and tnsnames.ora this will resolve your problem.

Thank You,

Mahesh C

[former_member204746]

just stop the listener, then rename files tnsnames.ora and listener.ora and try again.

[former_member182034]

Hi Mahesh and Erick,

the tnsname.ora file is following:

DSD.WORLD=
  (DESCRIPTION =
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = SAP.WORLD)
          (PROTOCOL = TCP)
          (HOST = sapdsd)
          (PORT = 1527)
        )
    )
    (CONNECT_DATA =
       (SID = DSD)
       (GLOBAL_NAME = DSD.WORLD)
    )
  )

Mahesh said me that you simply change the port number So i changed.

while Erick when i try to stop the Listener service then i got message like (service is not stop on Local machine).

regards,

majamil

[Former Member]

Hi,

You need to change in listener.ora file also. Before doing this stop the listener services. Or you can do one more thing. While doing the Installation change the name of the listener to LISTENER1 and run the sapinst. This can surely run the installation.

Mahesh C

[Former Member]

Majamil

Paste the listener.ora contents also....

Thanks & Regards

Babu

[former_member182034]

thanks All,

I deleted the Oracle folders from all window Drives and also delete the oracle from Regedit. Now

i have successfully installed the ECC 6.0 SR3.

regards,

majamil

[Former Member]

Hi,

If running on the server (or workstation) that is running the database (i.e. if the database is local to the machine) then try explicitly setting u2018ORACLE_SIDu2019. e.g.

set ORACLE_SID=<sid>

and then try again. If this works then consider whether to make the change permanent by specifying it as a system variable.

(Possibly 8.1.5 and later:) If running on the server (or workstation) that is running the database then check that the service name u2018OracleService<SID>u2019 ties up with the actual database SID. If the database SID is changed without recreating the service then this can lead to this error. To recreate the service:

oradimxx -delete -sid <old-sid>

oradimxx -new -sid <SID> -intpwd <internal-password> AUTO -pfile <full-init-ora-filename>

*One more possible work around* is to set the LOCAL environment variable in a dos box and try to connect again.

The difference between using LOCAL instead of ORACLE_SID is that LOCAL will try to connect through the listener, so it should run as well.

eg:

C:>set LOCAL=ORA920

C:>sqlplus

SQL*Plus: Release 9.2.0.7.0 - Production

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

Enter user-name: / as sysdba

ERROR:

ORA-12541: TNS:no listener

C:>set LOCAL=

C:>set ORACLE_SID=ORA920

C:>sqlplus

SQL*Plus: Release 9.2.0.7.0 - Production

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

Enter user-name: / as sysdba

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production

With the OLAP and Oracle Data Mining options

JServer Release 9.2.0.7.0 - Production

Hope it resolves your issue.

Thanks

Kishore