Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01034: ORACLE not available via SQLplus and JDBC

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

From: Karen Abgarian <abvk_at_ureach.com>
Date: Sat, 27 Jul 2002 07:21:31 GMT
Message-ID: <3D4249CE.D130B42E@ureach.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US