Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

TNS ping error:

user497634Sep 26 2007 — edited Sep 27 2007
I have installed fresh 10G R3 Grid on Windows 2003 server.

step1> Installed Grid 10g R2 in following homes
d:/oracle/product/oms10g
d:/oracle/product/agent10g
d:/oracle/product/db10g

step2> Upgrade to 10g R3
Installed a new database home 10.2.0.3
d:/oracle/product/10.2.0/db_1

Every thing is fine up and running but I have problems logging in from command prompt:

I have set following environment variables

ORACLE_SID=emprep
ORACLE_HOME=d:/oracle/product/10.2.0/db_1
TNS_ADMIN=d:/oracle/product/10.2.0/db_1/NETWORK/ADMIN

C:\Documents and Settings\admgb>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\admgb\Application Data
CLIENTNAME=HO6691
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=HOAPPS08
ComSpec=C:\WINDOWS\system32\cmd.exe
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\admgb
invPtr=D:\oracle\product\agent10g\oraInst.loc
LOGONSERVER=\\HOWIN10
NUMBER_OF_PROCESSORS=4
ORACLE_HOME=D:\oracle\product\10.2.0\db_1
ORACLE_SID=emprep
OS=Windows_NT
Path=D:\oracle\product\agent10g\jlib;D:\oracle\product\agent10g\bin;D:\oracle\pr
oduct\oms10g\bin;D:\oracle\product\oms10g\jlib;D:\oracle\product\10.2.0\db_1\bin
;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
PERL5LIB=D:\oracle\product\10.2.0\db_1\perl\lib\5.8.3\MSWin32-x86;D:\oracle\prod
uct\10.2.0\db_1\perl\lib\5.8.3;D:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWi
n32-x86-multi-thread;D:\oracle\product\10.2.0\db_1\perl\site\5.8.3;D:\oracle\pro
duct\10.2.0\db_1\perl\site\5.8.3\lib;D:\oracle\product\10.2.0\db_1\sysman\admin\
scripts
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 33 Stepping 2, AuthenticAMD
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=2102
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=RDP-Tcp#43
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\admgb\LOCALS~1\Temp\1
TMP=C:\DOCUME~1\admgb\LOCALS~1\Temp\1
TNS_ADMIN=D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
USERDNSDOMAIN=NEWSTAR.AD
USERDOMAIN=NEWSTAR
USERNAME=admgb
USERPROFILE=C:\Documents and Settings\admgb
windir=C:\WINDOWS

C:\Documents and Settings\admgb>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 26-SEP-2007 16:41
:23

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.3.0 - Produ
ction
Start Date 26-SEP-2007 16:27:16
Uptime 0 days 0 hr. 14 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hoapps08.NEWSTAR.AD)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "emrep.NEWSTAR.AD" has 2 instance(s).
Instance "emrep", status UNKNOWN, has 1 handler(s) for this service...
Instance "emrep", status READY, has 1 handler(s) for this service...
Service "emrep_XPT.NEWSTAR.AD" has 1 instance(s).
Instance "emrep", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Documents and Settings\admgb>tnsping emprep

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 26-SEP-2
007 16:41:34

Copyright (c) 1997, 2006, Oracle. All rights reserved.

Used parameter files:
D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\sqlnet.ora

TNS-03505: Failed to resolve name

C:\Documents and Settings\admgb>

C:\Documents and Settings\admgb>tnsping test

TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 26-SEP-2
007 16:44:45

Copyright (c) 1997, 2006, Oracle. All rights reserved.

Used parameter files:
D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\sqlnet.ora

TNS-03505: Failed to resolve name

C:\Documents and Settings\admgb>
********************************************************************************

listener.ora:


# listener.ora Network Configuration File: D:\oracle\product\db10g\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = emrep.NEWSTAR.AD)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = emrep)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hoapps08.NEWSTAR.AD)(PORT = 1521))
)
)
)
*************************************************************************************
tnsnames.ora

# tnsnames.ora Network Configuration File: D:\oracle\product\db10g\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EMREP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hoapps08.NEWSTAR.AD)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = emrep.NEWSTAR.AD)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hoapps08.NEWSTAR.AD)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = emrep)
)
)
*************************************************************************************
sqlnet.ora

# sqlnet.ora Network Configuration File: D:\oracle\product\db10g\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

NAMES.DEFAULT_DOMAIN= NEWSTAR.AD
******************************************************************************



Grid server is saying to update listener.ora location

LISTENER_hoapps08.NEWSTAR.AD Listener 26-Sep-2007 16:18:34 The listener is down: Although a Listener with name "LISTENER", is running on this host at port: "1521", it was not started using this target's "LISTENER.ORA" file. CORRECTIVE ACTION: To monitor this "EM Listener Target" with its present configuration, you must stop the currently running listener process, and start it again using the Listener Parameter file: D:\oracle\product\db10g\network\admin/listener.ora . Alternatively, you can update this target's "LISTENER.ORA Location" parameter with the location of the currently running Listener, which was started using: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora.

How do I change "LISTENER.ORA Location" parameter... Is it talking about registry?

Can some one help me to resoleve this problem... tns_admin is already set... does things needs to be changed in registry.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2007
Added on Sep 26 2007
8 comments
914 views