TNS error

When I trying to start sap getting following problem ..

TNS-12535: TNS:operation timed out

V2 connect is not available. Terminating

/usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 14

Listner is taking time to start but starting successfully.

Thanks and Regards,

Kalyan

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hello Kalyan,

which database version?

Normally you receive a TNS-12535, if your network is too slow or you have a firewall between your database and application servers. Please post the output of the following files and commands:


shell> tnsping PRD
shell> cat $ORACLE_HOME/network/admin/listener.ora
shell> cat $ORACLE_HOME/network/admin/sqlnet.ora

How many application servers (with the amount of WPs) are starting in parallel and trying to connect to the database?

Regards

Stefan

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hello Stefan,

below is ther output...

SAP:oraprd 26> tnsping PRD

TNS Ping Utility for HPUX: Version 9.2.0.6.0 - Production on 21-MAY-2009 15:59:31

Used parameter files:

/oracle/PRD/920_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = SAP) (PORT = 1527))) (CONNECT_DATA = (SID = PRD) (GLOBAL_NAME = PRD.WORLD)))

TNS-12535: TNS:operation timed out

SAP:oraprd 25> cat sqlnet.ora

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

Filename......: sqlnet.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:

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

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

NAME.DEFAULT_ZONE = WORLD

SQLNET.EXPIRE_TIME = 0

TCP.NODELAY=YES

SAP:oraprd 29> cat listener.ora

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

Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:

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

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = PRD.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = PRD)

)

(ADDRESS =

(PROTOCOL = TCP)

(HOST = SAP)

(PORT = 1527)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = PRD)

(ORACLE_HOME = /oracle/PRD/920_64)

)

Thank you,

Kanlyan

Hello Kanlyan,

your listener was up and running while you have performed the tnsping right?

If yes - you can see that the problem also persist if no parallel startup of application servers is running, so you can exclude an overload situation as the cause.

As i can see you have set the parameter "CONNECT_TIMEOUT_LISTENER" to 10, but this parameter is obsolete with Oracle 9i, this parameter was valid until Oracle 8i.

So please set the following values, restart the listener and try it again.


sqlnet.ora
SQLNET.INBOUND_CONNECT_TIMEOUT=20

listener.ora
INBOUND_CONNECT_TIMEOUT_LISTENER=20

http://download.oracle.com/docs/cd/B10501_01/network.920/a96581/listener.htm#503113

You can restart the listener while the sap is running, the connected SAP work processes will remain.

Btw. you should also identify why your connection is so slow.

Regards

Stefan

Hello Stefan,

I have chaged the parameter in both the file and restart linstner file .Here is the results.

SAP:prdadm 24> startsap

Checking PRD Database

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

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

This is Saposcol Version COLL 20.95 640 - V2.6.1 2007-06-14 HP-UX IA64
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 17507) is already running .....

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

saposcol already running

Running /usr/sap/PRD/SYS/exe/run/startdb

Trying to start PRD database ...

Log file: /home/prdadm/startdb.log

No SQL*Net V2 connect to PRD available.

Check that the listener is running: "lsnrctl status".

Start the listener as user oraprd: "lsnrctl start".

/usr/sap/PRD/SYS/exe/run/startdb: Terminating with error code 14

DB startup failed

SAP:prdadm 25>

Start PRD database separtely and it running file and try again below command.

SAP:prdadm 25> startsap r3

Checking PRD Database

ABAP Database is not available via R3trans

Starting SAP-Collector Daemon

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

This is Saposcol Version COLL 20.95 640 - V2.6.1 2007-06-14 HP-UX IA64
Usage: saposcol -l: Start OS Collector
saposcol -k: Stop OS Collector
saposcol -d: OS Collector Dialog Mode
saposcol -s: OS Collector Status
The OS Collector (PID 17507) is already running .....

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

saposcol already running

ABAP Database PRD must be started first

SAP:prdadm 26>

Regards,

Kalyan

Hello Kalyan,

ok, the startsap script output says nothing about the problem. So just let's try to get it running without startsap.

So please do the following and post the output


shell> lsnrctl start
shell> lsnrctl status
shell> sqlplus "/ as sysdba"
SQL> startup;
SQL> exit
shell> lsnrctl status
shell> tnsping PRD
shell> sqlplus <SAP_SCHEMA>/PASS@PRD

Regards

Stefan

here you go...

shell> lsnrctl start

shell> lsnrctl status

shell> sqlplus "/ as sysdba"

SQL> startup;

SQL> exit

shell> lsnrctl status

shell> tnsping PRD

shell> sqlplus <SAP_SCHEMA>/PASS@PRD

LSNRCTL> start

Starting /oracle/PRD/920_64/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 9.2.0.6.0 - Production

System parameter file is /oracle/PRD/920_64/network/admin/listener.ora

Log messages written to /oracle/PRD/920_64/network/log/listener.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD.WORLD)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD)))

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

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PRD.WORLD))

STATUS of the LISTENER

Alias LISTENER

Version TNSLSNR for HPUX: Version 9.2.0.6.0 - Production

Start Date 21-MAY-2009 16:54:43

Uptime 0 days 0 hr. 1 min. 16 sec

Trace Level off

Security OFF

SNMP OFF

Listener Parameter File /oracle/PRD/920_64/network/admin/listener.ora

Listener Log File /oracle/PRD/920_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SAP)(PORT=1527)))

-*- at this line, the listner waits for a minute and then proceeds with the next line-*-

Services Summary...

Service "PRD" has 1 instance(s).

Instance "PRD", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL> status

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PRD.WORLD))

STATUS of the LISTENER

Alias LISTENER

Version TNSLSNR for HPUX: Version 9.2.0.6.0 - Production

Start Date 21-MAY-2009 16:54:43

Uptime 0 days 0 hr. 1 min. 39 sec

Trace Level off

Security OFF

SNMP OFF

Listener Parameter File /oracle/PRD/920_64/network/admin/listener.ora

Listener Log File /oracle/PRD/920_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SAP)(PORT=1527)))

Services Summary...

Service "PRD" has 1 instance(s).

Instance "PRD", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL>

SQL> startup

ORACLE instance started.

Total System Global Area 5253325968 bytes

Fixed Size 734352 bytes

Variable Size 2667577344 bytes

Database Buffers 2583691264 bytes

Redo Buffers 1323008 bytes

Database mounted.

Database opened.

SAP:oraprd 22> lsnrctl status

LSNRCTL for HPUX: Version 9.2.0.6.0 - Production on 21-MAY-2009 16:58:48

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PRD.WORLD))

STATUS of the LISTENER

Alias LISTENER

Version TNSLSNR for HPUX: Version 9.2.0.6.0 - Production

Start Date 21-MAY-2009 16:54:43

Uptime 0 days 0 hr. 4 min. 5 sec

Trace Level off

Security OFF

SNMP OFF

Listener Parameter File /oracle/PRD/920_64/network/admin/listener.ora

Listener Log File /oracle/PRD/920_64/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD.WORLD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PRD)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SAP)(PORT=1527)))

Services Summary...

Service "PRD" has 1 instance(s).

Instance "PRD", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

SAP:oraprd 23> tnsping PRD

TNS Ping Utility for HPUX: Version 9.2.0.6.0 - Production on 21-MAY-2009 16:59:1

Used parameter files:

/oracle/PRD/920_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION= (SDU=32768) (ADDRESS_LIST= (ADDRESS= (PROTOC

OL=TCP) (HOST=SAP) (PORT=1527))) (CONNECT_DATA= (SID=PRD) (GLOBAL_NAME=PRD.WORLD

)))

-*- at this line, tnsping waits for some time again and we get the below result -*-

TNS-12535: TNS:operation timed out

SAP:oraprd 24>

we do not know the password for the "sap_schema" user

Thank you,

Kalyan

Sorry that is absolutely unreadable.. please format it with the tag.

Regards

Stefan

i am not able to format my output with the tag you mentioned.

is there any option to upload a file...?

Thank you,

Kalyan

Hi ,

I think problem with the ip which is not set properly.I have changed host entry with ip in tnsnames.ora and listner.ora and it started working fine.I am getting R3trans -d return code 0000. and tnsping hostname or (ip) also giving no error..I will update yu soon.

Thanks

Kalyan

Hi Kalyan,

give Log file: /home/prdadm/startdb.log

Check your database in mount stat or Open stat u can check through sql prompt

select open_mode from v$database;

is it READ WRITE or Mount ???

Surendra Jain

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

TNS error

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Re: in Auto Change Request Creation cl_usmd_model_...

Re: How to set the same SAP GUI settings for multi...

From R/3 4.7 to ECC 6.0 EH7/8

How to set the same SAP GUI settings for multiple ...

Re: reading external (OData) API from cap