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

Do you have MTS set up? If yes, then probably you need to revise its setup correctly.
Posting your listener.ora along with any MTS setting that you have, will help.
And yes, the regular .. Oracle version, O/S .. just in case

Anurag

"stevie" <steviehaston_at_hotmail.com> wrote in message news:4092f6be.0207221406.56495be5_at_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 - 19:05:00 CDT