| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01034 error
Looks like the conflict is a mismatch between the domain in the
global_dbname in listener.ora (sgms.sema.be) and the domain in
tnsnames.ora (world).
I remember sqlnet automatically appends the domain to the sid, and it
can't find the sid oem.world.
I have been unable yet to find a confirmation in the docs, but I know
net8 is more strict in this respect then sqlnet 2.
If you didn't already configure sqlnet.ora, do so now and add
names.default_domain = sgms.sema.be names.default_zone = sgms.sema.be to it.
trace_level_client = support trace_directory_client = <any directory> trace_unique_client = true
Hth,
Sybrand Bakker, Oracle DBA
In article <39ED7611.A00FF458_at_SGMS.SEMA.BE>,
Miguel Demaerel <Miguel.Demaerel_at_SGMS.SEMA.BE> wrote:
> Hoi
>
> This is one of my NT machine:
> oem =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= 172.27.150.50)(Port= 1521))
> (CONNECT_DATA = (SID = OEM))
> )
>
> oem.world =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= 172.27.150.50)(Port= 1521))
> (CONNECT_DATA = (SID = OEM))
> )
>
> This is one of the Unix machine (where also the database is running)
>
> #
> # Installation Generated Net8 Configuration
> # Version Date: Oct-27-97
> # Filename: Tnsnames.ora
> #
> oem =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= 172.27.150.50)(Port= 1521))
> (CONNECT_DATA = (SID = oem))
> )
>
> oem.world =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= 172.27.150.50)(Port= 1521))
> (CONNECT_DATA = (SID = oem))
> )
>
> oem_BEQ =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = BEQ)(PROGRAM =
> /opt/oracle/app/oracle/product/8.0.5)
> (args = '(DESCRIPTION =
> (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
> (envs =
> 'ORACLE_HOME=/opt/oracle/app/oracle/product/8.0.5,ORACLE_SID=oem')
> )
> )
>
> I get the error on both machines.
> Thanks
>
> Greetings Miguel
>
> sybrandb_at_my-deja.com wrote:
>
> > In article <39ED3F5F.EF25453A_at_SGMS.SEMA.BE>,
> > Miguel Demaerel <Miguel.Demaerel_at_SGMS.SEMA.BE> wrote:
> > > Hoi
> > >
> > > I have checked the permission and these are correct.
> > >
> > > I have tested it localy (there is a tnsnames.ora)
> > > sqlplus system/manager_at_OEM
> > Hoi
> > To keep this discussion internationally readable, I will not refrain
> > to Dutch :)
> > Post your tnsnames.ora please.
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > > ORA-01034 Oracle unavailble...
> > >
> > > I don't know how to solve this one.
> > >
> > > Thanks in advance.
> > >
> > > Greetings Miguel
> > >
> > > sybrandb_at_my-deja.com wrote:
> > >
> > > > In article <39EC2B3F.74EDFA00_at_SGMS.SEMA.BE>,
> > > > Miguel Demaerel <Miguel.Demaerel_at_SGMS.SEMA.BE> wrote:
> > > > > Hoi
> > > > >
> > > > > Can someone help me with this one?
> > > > > Running Oracle 8.05 on Solaris 2.6.
> > > > > When I connect to the database with sqlplus from an other
machine,
I
get
> > > > > the following error ORA-01034 Oracle not available (I'm using
system
as
> > > > > user).
> > > > > I get a reply with tnsping.
> > > > > I can connect with svrmgrl and sqlplus localy (I'm using
system as
user)
> > > > >
> > > > > Listener parameter file:
> > > > > #
> > > > > # Installation Generated Net8 Configuration
> > > > > # Version Date: Jun-17-97
> > > > > # Filename: Listener.ora
> > > > > #
> > > > > LISTENER =
> > > > > (ADDRESS_LIST =
> > > > > (ADDRESS= (PROTOCOL= IPC)(KEY= oem))
> > > > > (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
> > > > > (ADDRESS= (PROTOCOL= TCP)(Host= SOBUNIX)(Port= 1521))
> > > > > )
> > > > > SID_LIST_LISTENER =
> > > > > (SID_LIST =
> > > > > (SID_DESC =
> > > > > (GLOBAL_DBNAME= oem.sgms.sema.be)
> > > > > (ORACLE_HOME= /opt/oracle/app/oracle/product/8.0.5)
> > > > > (SID_NAME = oem)
> > > > > )
> > > > > )
> > > > > STARTUP_WAIT_TIME_LISTENER = 0
> > > > > CONNECT_TIMEOUT_LISTENER = 10
> > > > > TRACE_LEVEL_LISTENER = OFF
> > > > >
> > > > > Info instance:
> > > > > INSTANCE_NAME VERSION STATUS HOST_NAME
> > > > > ---------------- ----------------- -------
> > > > > ----------------------------------------------------
> > > > > OEM 8.0.5.0.0 OPEN SOBUNIX
> > > > >
> > > > > Process overview:
> > > > > $ ps -ef | grep oracle
> > > > > oracle 1249 1247 0 08:48:57 pts/5 0:00 -ksh
> > > > > oracle 1285 1 0 08:49:53 ? 0:00 ora_pmon_OEM
> > > > > oracle 1287 1 0 08:49:53 ? 0:00 ora_dbw0_OEM
> > > > > oracle 1289 1 0 08:49:53 ? 0:00 ora_lgwr_OEM
> > > > > oracle 1291 1 0 08:49:53 ? 0:00 ora_ckpt_OEM
> > > > > oracle 1293 1 0 08:49:53 ? 0:00 ora_smon_OEM
> > > > > oracle 1295 1 0 08:49:53 ? 0:00 ora_reco_OEM
> > > > > oracle 1301 1299 0 08:50:17 pts/6 0:00 -ksh
> > > > > oracle 1848 1249 0 10:00:18 pts/5 0:00 svrmgrl
> > > > > oracle 1788 1 0 09:47:46 ? 0:00
> > > > > /opt/oracle/app/oracle/product/8.0.5/bin/tnslsnt
> > > > > $
> > > > >
> > > > > What do I wrong?
> > > > >
> > > > > Thanks in advance.
> > > > >
> > > > > Greetings Miguel
> > > > >
> > > > >
> > > > Usually this is caused by incorrect protection of datafiles
and/or
> > > > executables. Also note the setuid bit should be on for the
oracle
> > > > executable.
> > > > Refer to the getting started manual for the exact protection
masks,
they
> > > > are outlined in chapter 4.
> > > >
> > > > --
> > > > Sybrand Bakker, Oracle DBA
> > > >
> > > > All standard disclaimers apply
> > > >
> >
-- Sybrand Bakker, Oracle DBA All standard disclaimers apply ------------------------------------------------------------------------ Sent via Deja.com http://www.deja.com/ Before you buy.Received on Wed Oct 18 2000 - 05:41:51 CDT
 |
 |