ORA-01034: ORACLE not available via SQLplus and JDBC

From: stevie <steviehaston_at_hotmail.com>
Date: 22 Jul 2002 15:06:11 -0700
Message-ID: <4092f6be.0207221406.56495be5@posting.google.com>

We're experiencing an issue with connecting to oracle via jdbc and sqlplus. This began after we restored the file system from tape. Both now report 'ORA-01034: ORACLE not available'.

If you put a full connect string to access sqlplus... sqlplus system/blah@'(description=(address=(protocol=tcp)(host=127.0.0.1)(port=1521))(connect_data=(sid=ls)))' ... the error occurs. Using ...
sqlplus system/blah
... doesnt have a problem and you can execute SQL commands.

listener status is OK ....

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=127.0.0.1)(Port=1521)) STATUS of the LISTENER

---

<snip>
Services Summary...
ls has 1 service handler(s)
The command completed successfully"

.... listener.log doesnt tell us much ....

21-JUL-02 20:23:40 *
(connect_data=(sid=ls)(CID=(PROGRAM=)(HOST=colt)(USER=oracle))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=32897)) * establish * ls
* 0

.... I set the listener trc level to admin, but the trace file doesnt seem to have error entries in it.

Any idea gratefully received.
TIA
Steve Received on Mon Jul 22 2002 - 17:06:11 CDT