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-27101:Shared memory realm does not exist when connecting to created database

Re: ORA-27101:Shared memory realm does not exist when connecting to created database

From: David Johnson <junk_at_discursion.com>
Date: 23 Jul 2002 16:59:23 -0700
Message-ID: <4ad562b2.0207231559.33353d67@posting.google.com>


I had the same problem as the original poster, and this response solved my problem completely. Must've been something new in 8.1.7, because it never happened to me before, but kept happening after installing 8.1.7. Thanks so much for your help!

-Dave

hassan.akbar_at_glo-tek.com.pk (Hassan) wrote in message news:<2b742be.0206240425.15b7667b_at_posting.google.com>...
> This error has nothing to to with shared memory. There is some problem
> when the systems checks for authentication while rebooting.
> I think if u comment out the following in sqlnet.ora file it will help
> you.
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
>
> Goodluck.
>
> Hassan
> DBA, Glo-Tek
>
> sh_satoru_at_yahoo.co.jp (S.Satoru) wrote in message news:<1c34d810.0206192148.103b3bc4_at_posting.google.com>...
> > Please help
> >
> > I installed Oracle 8.1.7 on a Sun Blade 100 running Solaris 8
> > following the Installation Guide and this mailing list.
> >
> > I have a machine like this.
> > SUN Blade 100 with 2GB membory, 7GB disk space for /opt
> > which is the place to install oracle software and data files.
> >
> > sysdef command below:
> >
> > ........
> >
> > swap files device swaplo block
> > &#31354;&#12365;&#23481;&#37327;
> > /dev/dsk/c0t0d0s4 136,4 16 2097632 2097632
> >
> > ........
> >
> > 23330816 maximum memory allowed in buffer cache (bufhwm)
> > 17802 maximum number of processes (v.v_proc)
> >
> > ........
> >
> > 200 semaphore identifiers (SEMMNI)
> > 2000 semaphores in system (SEMMNS)
> > 30 undo structures in system (SEMMNU)
> > 1000 max semaphores per id (SEMMSL)
> > 100 max operations per semop call (SEMOPM)
> > 10 max undo entries per process (SEMUME)
> > 32767 semaphore maximum value (SEMVMX)
> > 16384 adjust on exit max value (SEMAEM)
> >
> > ........
> >
> > 4294967295 max shared memory segment size (SHMMAX)
> > 1 min shared memory segment size (SHMMIN)
> > 200 shared memory identifiers (SHMMNI)
> > 20 max attached shm segments per process (SHMSEG)
> >
> > ........
> >
> > All installation went well. I created database by
> > DBCA(select:Typical).
> > That results in an SGA:
> >
> > Total System Global Area 692265120 bytes
> >
> > And inittestdb.ora is below:
> >
> > db_name = "testdb"
> > db_domain = sd1.agrex.co.jp
> > instance_name = testdb
> > service_names = testdb.sd1.agrex.co.jp
> > control_files = ("/opt/oradb01/app/oracle/oradata/testdb/control01.ctl",
> > "/opt/oradb01/app/oracle/oradata/testdb/control02.ctl",
> > "/opt/oradb01/app/oracle/oradata/testdb/control03.ctl")
> > open_cursors = 300
> > max_enabled_roles = 30
> > db_block_buffers = 62322
> > shared_pool_size = 170180812
> > large_pool_size = 614400
> > java_pool_size = 0
> > log_checkpoint_interval = 10000
> > log_checkpoint_timeout = 1800
> > processes = 50
> > log_buffer = 163840
> > user_dump_dest = /opt/oradb01/app/oracle/admin/testdb/udump
> > db_block_size = 8192
> > remote_login_passwordfile = exclusive
> > os_authent_prefix = ""
> > compatible = "8.1.0"
> > sort_area_size = 65536
> > sort_area_retained_size = 65536
> >
> > There were no apparent problems during Installation and creation.
> > However, when I try to run sqlplus on the machine running oracle
> > installed, I get the following:
> >
> > ORA-01034: ORACLE not available
> > ORA-27101: shared memory realm does not exist
> > SVR4 Error: 2: No such file or directory
> >
> > I checked the settings in /etc/system and DBSTART up and listener up
> > and environment parameter(ORACLE_SID,ORACLE_BASE,ORACLE_HOME) and
> > path.
> > I have checked that but that does not seem to be the problem.
> >
> > I cannot figure out why I cannot connect to database.
> >
> > Any suggestion on troubleshooting,please.
> >
> > Thanks, S.Satoru
Received on Tue Jul 23 2002 - 18:59:23 CDT

Original text of this message

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