Re: Oracle 8.1.7 on Solaris 8: Help !!

From: Jaspreet Bakshi <jub120_at_psu.edu>
Date: Mon, 06 May 2002 16:31:24 -0400
Message-ID: <3CD6E81C.FD1758C5@psu.edu>

Hi Cecil,

I checked the SHMMAX, SHMMIN, SEMMS parameters and here they are from the O/P
of the sysdef command.  The number of processes that I am setting is 6 (in the init<SID>.ora file)
I just want to create a small test data base for now and hence have specified very low parameter
values.

The alert log and the trace file have the following error ... any idea what this error 20 is ??
/*******
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
Mon May  6 14:21:02 2002
CKPT: terminating instance due to error 20
Instance terminated by CKPT, pid = 25888
/*******

/**********
* IPC Semaphores

100  semaphore identifiers (SEMMNI)
200  semaphores in system (SEMMNS)
30  undo structures in system (SEMMNU)
100  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)
 

* IPC Shared Memory

4294967295      max shared memory segment size (SHMMAX)
1  min shared memory segment size (SHMMIN)
100  shared memory identifiers (SHMMNI)
10  max attached shm segments per process (SHMSEG)
/**********

ALso, the page link that you specified talks about shared_pool_size and timed_statistics. How can I see what these parameters are set to and how can I change them ??
 

thanks for your time,
Jas

cecildsouza wrote:

It could be a conflict between Unix parameters like SHMMAX, SHMMIN, SEMMSL etc  and Oracle Memory parameters. Also check permissions.

http://home.clara.net/dwotton/dba/ora3113.htm (details for ORA-03113)

HTH

Jaspreet Bakshi wrote:

hi everyone,

I am totally new to Oracle ... just finished installation
of Oracle 8.1.7 on Solaris 8 .. the automatic database
creation step failed for some reason.

Now when I try to use dbassist to create a new database,
I get an ORA 03114 error "not connected to ORACLE".
It does create the database creation shell scripts, so I
tried manually executing those scripts and the following
sequences of events ensued.

/*********

SVRMGR> connect internal
Connected.
SVRMGR> startup nomount pfile = "/opt/oracle/admin/B/pfile/initB.ora"
ORA-03113: end-of-file on communication channel
SVRMGR>

/*********

Any idea on what could be going on ... any help is appreciated ... the quicker
the better as this is holding a lot of work back on our research.

thanks
Jas

Received on Mon May 06 2002 - 15:31:24 CDT