TNS ping error:
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.