not able to logging in sql prompt

[former_member72943]

Hello,

When i try to loogin through sql prompt , i am getting the following error. Has anyone got this error before.

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

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\gpsadm>sqlplus /nolog

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Mar 21 04:11:10 2009

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

SQL> connect /as sysdba

ERROR:

ORA-12560: TNS:protocol adapter error

[sarbajitm]

Go to Control Panel->Administrative Tool->Services. Then right Click on Tns Listener and Start it. Then try to looging in again into Oracle.

Regards.

Sarbajit

[Former Member]

Check all Oracle Services are running or not,If not then restart them...

[former_member204746]

you probably forgot to start Windows Service "OracleServiceGPS"

try to start it first:

net start OracleServiceGPS

[fidel_vales]

How are you connected to the Windows server?

Are you directly in the console?

Are you connected using VNC?

Are you connected using WTS?

Are you conneced using ...?

[former_member220071]

Hi ,

> ORA-12560: TNS:protocol adapter error

Possible fixes for the TNS-12560 include:

1 Check your $ORACLE_HOME and $PATH Variables.

2 Check file permission on the PC Client.

3 Ensure that TNS_ADMIN is set properly.

4 check for network firewall issues.

5 In windows , verify that database service is started , verify

that the ORACLE_SID parameters is correctly set.

You can also do this

>TRACE_LEVEL_LISTENER = ON

execute the function and then make it OFF

and check the logs.

Abhijeet

Edited by: Abhijeet Siras on Mar 21, 2009 2:56 PM

[former_member603052]

Hi Swamy,

Check listener is up and running from command prompt using command lsnrctl stat

If the listener is down then start using command lsnrctl start

Also run the command R3trans -d and check the connectivity to the database.

Regards,

Kalyan

[Former Member]

Hi,

In listener.ora port configured is 1527

(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = prdserver)
(PORT = 1527)
)

I saw your previos thread where as in tnsnames.ora file has port configure 1521 for GPS SID.

channge the 1521 to 1527.

Also Host in listerner.ora is prdserver where as in tnsnames.ora has 167.147.0.200

check both are same. I suggest change ip to hostname.

Regards,

Sachin Rane.

[Former Member]

Hi,

Check listener service is running. Also check listener.ora file is properly configured.

Regards,

Sachin Rane.

[former_member72943]

hello

listener.log

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

TNSLSNR for 32-bit Windows: Version 10.2.0.2.0 - Production on 21-MAR-2009 03:57:07

Copyright (c) 1991, 2005, Oracle. All rights reserved.

System parameter file is D:\usr\sap\GPS\SYS\profile\oracle\listener.ora

Log messages written to D:\oracle\GPS\102\network\log\listener.log

Trace information written to D:\oracle\GPS\102\network\trace\listener.trc

Trace level is currently 0

Started with pid=2620

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\GPS.WORLDipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=
.\pipe\GPSipc)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prdserver)(PORT=1527)))

Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA * PROTOCOL INFO * EVENT * SID * RETURN CODE

WARNING: Subscription for node down event still pending

21-MAR-2009 03:57:08 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=gpsadm))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869824)) * status * 0

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

listner.ora

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

################

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = GPS.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = GPS)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = prdserver)

(PORT = 1527)

)

1. (ADDRESS =

2. (PROTOCOL = IPC)

3. (KEY = EPD.WORLD)

4. )

5. (ADDRESS =

6. (PROTOCOL = IPC)

7. (KEY = EPD)

8. )

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = GPS)

(ORACLE_HOME = D:\oracle\GPS\102)

)

1. (SID_DESC =

2. (SID_NAME = GPS)

3. (ORACLE_HOME = D:\oracle\GPS\102)

4. )

5. (SID_DESC =

6. (SID_NAME = EPD)

7. (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)

8. )

)