Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connect problems with SQL*Net
Hi Uwe,
ORA-1034 usually means either the database is not running, or the process
connecting is not having sufficient privilege to read the SGA. Refer to the
privileges of $ORACLE_HOME/dbs/sgadef<sid>.dbf. This file should be owned by
Oracle, user dba, chmod 477.
You don't have accidentally NIS running? I had a similar situation once
where the uid in my local password file was different from the one managed
by NIS. The uid is stored with the file, not the username. That was the
reason why I was getting ORA-1034s.
Hth,
Sybrand Bakker, Oracle DBA
Uwe Schneider <uwe.schneider_at_xlink.net> wrote in message
news:379DAE2C.8F5341BB_at_xlink.net...
> Hi experts,
>
> we experience a strange problem when connectiong to various Oracle
> Servers:
>
> SERVER A (Oracle 7.3.2) Client A (Linux, Oracle 8.0.5)
>
> SERVER B (Oracle 7.3.3) Client B (Solaris, Oracle 7.3.2)
>
> Client B can connect to both servers. Client A can connect only to
> Server A, but not to server B. Although a tnsping to server B is
> successful, we receive a Ora-1034 error message when actually connecting
> to the instance. During the failing connections we can see a positive
> connect line in the listener.ora of server B, but we never really access
> the instance.
>
> Any ideas?
>
> --
> uwe.schneider_at_xlink.net
Received on Tue Jul 27 1999 - 12:12:25 CDT