topic tnsping failed .. in Operating System - HP-UX

tnsping failed ..

Manuales — Thu, 02 Nov 2006 23:32:36 GMT

Hi ..
i'm trying to start sap into HP-9000 server.

the log indicates:

UNIX1: SERVER1adm 4> more /home/SERVER1adm/startdb.log
------------------------------ Thu Nov 2 22:21:44 CST 2006
LOGFILE FOR STARTING ORACLE

------------------------------ Thu Nov 2 22:21:44 CST 2006
checking required environment variables

ORACLE_HOME is >/oracle/SERVER1<
ORACLE_SID is >SERVER1<

------------------------------ Thu Nov 2 22:21:44 CST 2006
check initora

------------------------------ Thu Nov 2 22:21:44 CST 2006
check initora

------------------------------ Thu Nov 2 22:21:44 CST 2006
checking V2 connect

TNS Ping Utility for HPUX: Version 2.3.4.0.0 - Production on 02-NOV-06 22:21:44

Copyright (c) Oracle Corporation 1995. All rights reserved.

TNS-03505: Failed to resolve name
V2 connect is not available. Terminating

------------------------------ Thu Nov 2 22:21:45 CST 2006
/usr/sap/SERVER1/SYS/exe/run/startdb: Terminating with error code 4

why ?

Re: tnsping failed ..

Hein van den Heuvel — Fri, 03 Nov 2006 00:23:27 GMT

Did it ever work?
If yes, what changed recently?

Did someone muck with tnsnames.ora?
nodename / ip-addresses changed improperly?

Is the listener running (ps -ef | grep ora)

Is the DB running (does not yet have to)

Can you start listener + oracle manually?
- su - oraXXX
- lsnrctl start
- lsnrctl status
- sqlplus "/ as sysdba"
> startup
:

Good luck,
Hein.

Re: tnsping failed ..

javedk — Fri, 03 Nov 2006 00:27:56 GMT

try starting the listener manually as explained by Hein and then run the sap startup script it should be fine.

Re: tnsping failed ..

Manuales — Fri, 03 Nov 2006 01:07:58 GMT

Problem continues ..
when i run:

UNIX1:SERVER1adm 6> startsap

Starting SAP-Collector Daemon
------------------------------
Collector already running ... don't launch
saposcol already running

Checking SAP R/3 SERVER1CP Database
------------------------------
Database is not available via /usr/sap/SERVER1CP/SYS/exe/run/R3trans -d -w

Starting SAP R/3 SERVER1CP1 Database
------------------------------
Startup-Log is written to /home/SERVER1cpadm/startdb.log

No SQL*Net V2 connect to SERVER1CP available.
Check that the listener is running: "lsnrctl status".
Start the listener as user oraXXX: "lsnrctl start".

Database startup failed!
See /home/SERVER1cpadm/startdb.log for details

if i run lsnrctl status is showed the process running !!!!

why indicate that it isnot running !!!!

help please

Thanks.

Re: tnsping failed ..

Dinesh S Devan — Fri, 03 Nov 2006 01:29:31 GMT

could you please provide the output for
ps -ef|grep ora |more

Re: tnsping failed ..

Manuales — Fri, 03 Nov 2006 10:34:10 GMT

this is the output:

/oracle/SERVER1CP/bin/tnslsnr LISTENER -inherit

Thanks.

Re: tnsping failed ..

Hein van den Heuvel — Fri, 03 Nov 2006 11:28:45 GMT

So you do have a defautl listener going.
Now what is it listening to?

'lsnrctl status' will help with that.
It will point to a listener.ora file.
Type that out. Does it look ok?
Specifically look for the instance and node names.

The status report will also point to the listener log file. Tail that! Any surprises?

- Did it ever work ?

- When did it stop working ?

- What changed ?

Regards,
Hein.

Re: tnsping failed ..

Manuales — Fri, 03 Nov 2006 12:34:28 GMT

when i start the listener process that works o.k ... if i stop that works well

configuration file have not changed some years ago

ther is a message into syslog.log i do not know if that has something to see with the problem that i have with the listener
syslog.log reports:

WARNING: Cluster lock on disk /dev/dsk/c0t2d1 is missing!
Until it is fixed, a single failure could
cause all nodes in the cluster to crash

Please, help ..

Re: tnsping failed ..

Manuales — Sat, 04 Nov 2006 17:26:23 GMT

The solution was update tnsmnames.ora file .. putting correct name

thanks all