Re: ORA-01034: ORACLE not available via SQLplus and JDBC

looks like the listener thinks the database is in another oracle home

stevie wrote:

> 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 Sat Jul 27 2002 - 02:21:31 CDT