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: sqlplus error using @

Re: sqlplus error using @

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/09/21
Message-ID: <969573975.6606.0.pluto.d4ee154e@news.demon.nl>#1/1

Usually, this is a protection problem, or the database hasn't been started under the user oracle. Refer to the Installation and Users Guide, chapter 4, post-installation tasks.
As I posted it already to the newsgroup, I am not going to repeat this action.

Hth,

Sybrand Bakker, Oracle DBA

"Bunyips" <bunyips_at_my-deja.com> wrote in message news:8qdns6$hlv$1_at_nnrp1.deja.com...
> This worked yesterday, but it's not working since the
> database was restarted today.
>
> I can log into my database using "sqlplus foouser" from
> a terminal widow on the server, but when I try to use
> "sqlplus foouser_at_mydb" from that system, or any other client,
> I get a "ORA-01034: ORACLE not available" error after I
> enter the password.
>
> When I look at listener.log it sees the connection
> and everything appears normal. I doubt it's a bad
> tnsnames.ora because I've tried to connect from
> two different clients that used to work. Also, I
> checked $ORACLE_HOME and $ORACLE_SID - they are correct.
> There is also nothing in the alert log.
>
> I'm sure I'm forgetting something, but nothing I have
> R'ed in TFM's seems to explain this.
>
> Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Sep 21 2000 - 00:00:00 CDT

Original text of this message

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