tnsping failed ..

[Manuales]

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 ?

[Hein van den Heuvel · Accepted solution]

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.

[javedk]

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

[Manuales]

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.

[Dinesh S Devan]

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

[Manuales]

this is the output:

/oracle/SERVER1CP/bin/tnslsnr LISTENER -inherit

Thanks.

[Hein van den Heuvel]

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.

[Manuales]

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 ..

[Manuales]

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

thanks all