I'm trying to understand why a simple TNS setup done by NETCA doesn't work (accessing the database using the TNS string).
Is the listener setup wrong ? TNS setup ?
C:\Oracle\product\11.2.0\NETWORK\ADMIN>netca
Oracle Net Services Configuration:
Configuring Listener:LISTENER
Default local naming configuration complete.
Listener configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
C:\Oracle\product\11.2.0\bin\lsnrctl start LISTENER
Listener Control complete.
Setting Listener service to start automatically.
Listener started successfully.
Oracle Net Services configuration successful. The exit code is 0
C:\Oracle\product\11.2.0\NETWORK\ADMIN>dir
Volume in drive C is xxxxx
Volume Serial Number is yyyy-zzzz
Directory of C:\Oracle\product\11.2.0\NETWORK\ADMIN
26/05/2014 11:19 <DIR> .
26/05/2014 11:19 <DIR> ..
26/05/2014 11:19 632 listener.ora
26/05/2014 11:19 357 tnsnames.ora
2 File(s) 989 bytes
2 Dir(s) 86.838.067.200 bytes free
C:\Oracle\product\11.2.0\NETWORK\ADMIN>type listener.ora
# listener.ora Network Configuration File: C:\Oracle\product\11.2.0\network\admi
n\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\Oracle\product\11.2.0)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\Oracle\product\11.2.0\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = computername.domain)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = C:\Oracle
C:\Oracle\product\11.2.0\NETWORK\ADMIN>type tnsnames.ora
# tnsnames.ora Network Configuration File: C:\Oracle\product\11.2.0\network\admi
n\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
C:\Oracle\product\11.2.0\NETWORK\ADMIN>tnsping ORACLR_CONNECTION_DATA
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 26-MEI-2
014 11:19:46
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Gebruikte parameterbestanden:
TNSNAMES adapter gebruikt voor herleiden van de alias.
Poging om contact te maken met (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOC
OL = IPC)(KEY = EXTPROC1521))) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION
= RO)))
OK (0 msec.)
C:\Oracle\product\11.2.0\NETWORK\ADMIN>sqlplus system/manager@ORACLR_CONNECTION_
DATA
SQL*Plus: Release 11.2.0.1.0 Production on Ma Mei 26 11:19:58 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-28547: Er is geen verbinding met de server gemaakt, waarschijnlijk vanwege
een admin-fout in Oracle Net.
Voer gebruikersnaam in: