[lug] sqlplus dead

[Gordon Golding]

 I know this is not a question for this forum, but some people here are amazingly knowledgeable.

What would be the best resource for a Windows SQLNet problem ??

If anybody is interested in a "evil empire question" - massive output below:

SQLPLUS worked, then not, worked, then not....  currently not, not, not, not.....
I think that it was working one day, then not the next, without a reboot (??)

Enterprise Manager and SQL Developer both work, so I know DB is up and passwords correct.

tnsnames info in output below.

LISTENER.ORA
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)      !!!!!   tHIS LISTERNER SHOWS STATUS UNKNOWN BELOW
      (ORACLE_HOME = C:...)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:C:...\bin\oraclr11.dll")
    )
  )
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ...)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
ADR_BASE_LISTENER = C:\...

SQLNET.ORA
SQLNET.AUTHENTICATION_SERVICES = (NTS)

This machine has had Oracle rolled on and off a few times.
Two Thoughts from below:

????????????????
STATUS shows 2 listeners for the same instance and one STATUS UNKNOWN
START only shows the STATUS UNKNOWN
????

anonymized OUTPUT

SQL Developer 3.2.10
Oracle Enterprise Manager Database Console    11.2.0.1.0

>sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Sat Oct 13 12:08:25 2012
...
Enter user-name: username
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

>tnsping db
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-OCT-2 012 12:21:08
...
Used parameter files:
C:....\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = db)))
OK (0 msec)

LSNRCTL> start
Starting tnslsnr: please wait...
TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is C:...\network\admin\listener.ora
Log messages written to c:...\listener\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date                13-OCT-2012 12:33:59
Uptime                    0 days 0 hr. 0 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:...\network\admin\listener.ora
Listener Log File         c:...\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=...)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=CR002FO-BOU7.pbi.global.
pvt)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date                13-OCT-2012 11:41:13
Uptime                    0 days 0 hr. 49 min. 29 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\.....\network\admin\listener.ora
Listener Log File         c:\.....\diag\tnslsnr\CR002FO-BOU7\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "mydbXDB" has 1 instance(s).
  Instance "db", status READY, has 1 handler(s) for this service...
Service "db" has 1 instance(s).
  Instance "db", status READY, has 1 handler(s) for this service...
The command completed successfully


Gordon

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lug.boulder.co.us/pipermail/lug/attachments/20121013/ee9a5657/attachment.html>