ORA-27101:Shared memory realm does not exist when connecting to created database
S.Satoru
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
空き容量
/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
Christopher Merry
SYS user with SYSDBA privileges (ie. "SYS/ORACLE AS SYSDBA" or whatever
your password is. If you have not changed the SYS password, try ORACLE
first).
Once connected, STARTUP.
Since you are running Oracle8i, I would suggest using Server Manager
(command line: svrmgrl). If there are more serious errors or problems, they
are typically easier to debug using this utility.
I hope this helps.
cm
"S.Satoru" <sh_s...@yahoo.co.jp> wrote in message
news:1c34d810.02061...@posting.google.com...
Hassan
when the systems checks for authentication while rebooting.
I thinking if u comment out the following in sqlnet.ora file it will
help you.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
Goodluck.
Hassan
DBA, Glo-Tek
sh_s...@yahoo.co.jp (S.Satoru) wrote in message news:<1c34d810.02061...@posting.google.com>...
Hassan
when the systems checks for authentication while rebooting.
you.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
Goodluck.
Hassan
DBA, Glo-Tek
sh_s...@yahoo.co.jp (S.Satoru) wrote in message news:<1c34d810.02061...@posting.google.com>...
David Johnson
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...@glo-tek.com.pk (Hassan) wrote in message news:<2b742be.02062...@posting.google.com>...