ora-what
asked on
Unable to create another database instance in same Oracle Home directory Error ORA-03113 end-of-file on communication channel Oracle 11g Linux Red Hat Enterprise Server 5 VMware Workstation 6
Hello,
I am running Linux Red Hat Enterprise Server 5 and Oracle 11g 11.0.7.0 (patched) in VMware Workstation 6 on Windows Vista.
I already have 1 db instance installed called orcl that works fine.
I have a problem creating a second database instance in the same Oracle Home.
I've been trying for many hours over days to create another db instance called rcat in the same Oracle home.
If I install the Oracle Database software into a different Oracle Home and then use dbca to create the database
in the second Oracle Home is works ok.
I want to use the dbca to create a database called rcat in the same Oracle Home as my first instance.
The dbca always stops at exactly 40% with ORA-3113 end-of-file on communication channel and I abort.
I've tried this on 2 different machines on completely different networks and the exact thing happens on both. And it also stops at 40% on both.
I've looked at my trace logs and alert logs.
Here is what I foud:
I was also thinking that maybe it's the listener or the way I set the environment variables.
To create the dbca I do:
First I shut down the orcl instance to save resources
I stop and restart the listener
export ORACLE_SID=rcat
export ORACLE_HOME=<my oracle home path> (I only have 1 home so I know this is it)
export ORACLE_BASE=<my oracle base path> (I only have 1 base so I know this is it)
dbca
I go through the steps to configure the database I want to create and then Finish.
It gets to 40% and ORA-03113 everytime.
When I run the Oracle Database software installer (not the dbca) I get a message recommending me to use a static ip instead of DHCP.
Would this affect my database creation?
I can connect to the Internet and also connect to Enterprise Manager for the orcl instance no problem.
I've included the errors found in the logs, notice the problem happens after a open resetlogs during instance creation
You will notice in the DBCA TRACE LOG that the ORA-03113 error that I received was actually preceded in the clone database process by the following ORA errors
[Thread-13] [14:8:13:512] [StepErrorHandler.setFatal
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatal
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatal
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatal
[Thread-13] [14:8:13:513] [StepErrorHandler.setIgnor
[Thread-13] [14:11:43:95] [StepErrorHandler.setIgnor
[Thread-13] [14:11:43:96] [StepErrorHandler.setIgnor
[Thread-13] [14:11:43:96] [StepErrorHandler.setIgnor
ORA-03113
I am running Linux Red Hat Enterprise Server 5 and Oracle 11g 11.0.7.0 (patched) in VMware Workstation 6 on Windows Vista.
I already have 1 db instance installed called orcl that works fine.
I have a problem creating a second database instance in the same Oracle Home.
I've been trying for many hours over days to create another db instance called rcat in the same Oracle home.
If I install the Oracle Database software into a different Oracle Home and then use dbca to create the database
in the second Oracle Home is works ok.
I want to use the dbca to create a database called rcat in the same Oracle Home as my first instance.
The dbca always stops at exactly 40% with ORA-3113 end-of-file on communication channel and I abort.
I've tried this on 2 different machines on completely different networks and the exact thing happens on both. And it also stops at 40% on both.
I've looked at my trace logs and alert logs.
Here is what I foud:
I was also thinking that maybe it's the listener or the way I set the environment variables.
To create the dbca I do:
First I shut down the orcl instance to save resources
I stop and restart the listener
export ORACLE_SID=rcat
export ORACLE_HOME=<my oracle home path> (I only have 1 home so I know this is it)
export ORACLE_BASE=<my oracle base path> (I only have 1 base so I know this is it)
dbca
I go through the steps to configure the database I want to create and then Finish.
It gets to 40% and ORA-03113 everytime.
When I run the Oracle Database software installer (not the dbca) I get a message recommending me to use a static ip instead of DHCP.
Would this affect my database creation?
I can connect to the Internet and also connect to Enterprise Manager for the orcl instance no problem.
I've included the errors found in the logs, notice the problem happens after a open resetlogs during instance creation
You will notice in the DBCA TRACE LOG that the ORA-03113 error that I received was actually preceded in the clone database process by the following ORA errors
[Thread-13] [14:8:13:512] [StepErrorHandler.setFatal
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatal
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatal
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatal
[Thread-13] [14:8:13:513] [StepErrorHandler.setIgnor
[Thread-13] [14:11:43:95] [StepErrorHandler.setIgnor
[Thread-13] [14:11:43:96] [StepErrorHandler.setIgnor
[Thread-13] [14:11:43:96] [StepErrorHandler.setIgnor
ORA-03113
TRACE LOG alert_rcat.log /u01/app/oracle/diag/rdbms/rcat/rcat/trace
---------------------
alter database "rcat" open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 531401
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x83900490] [PC:0x86E4932, knl_get_min_req_scn()+6]
Errors in file /u01/app/oracle/diag/rdbms/rcat/rcat/trace/rcat_ora_3963.trc (incident=1345):
ORA-07445: exception encountered: core dump [knl_get_min_req_scn()+6] [SIGSEGV] [ADDR:0x83900490] [PC:0x86E4932] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/rcat/rcat/incident/incdir_1345/rcat_ora_3963_i1345.trc
Sat Jul 11 13:46:27 2009
ALERT LOG log.xml /u01/app/oracle/diag/rdbms/rcat/rcat/alert
----------------
<msg time='2009-07-11T13:46:20.103-04:00' org_id='oracle' comp_id='rdbms'
msg_id='opiexe:2935:4222364190' client_id='' type='NOTIFICATION'
group='admin_ddl' level='16' host_id='bd11g'
host_addr='127.0.0.1' module='sqlplus@bd11g (TNS V1-V3)' pid='3963'>
<txt>alter database "rcat" open resetlogs
</txt>
</msg>
<msg time='2009-07-11T13:46:20.283-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='bd11g' host_addr='127.0.0.1' module='sqlplus@bd11g (TNS V1-V3)'
pid='3963'>
<txt>RESETLOGS after incomplete recovery UNTIL CHANGE 531401
</txt>
</msg>
<msg time='2009-07-11T13:46:20.379-04:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='bd11g' host_addr='127.0.0.1' module='sqlplus@bd11g (TNS V1-V3)'
pid='3963'>
<txt>Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x83900490] [PC:0x86E4932, knl_get_min_req_scn()+6]
</txt>
</msg>
<msg time='2009-07-11T13:46:22.145-04:00' org_id='oracle' comp_id='rdbms'
msg_id='63653510' type='INCIDENT_ERROR' group='Access Violation'
level='1' host_id='bd11g' host_addr='127.0.0.1'
prob_key='ORA 7445 [knl_get_min_req_scn()+6]' upstream_comp='' downstream_comp=''
ecid='' errid='1345' detail_path='/u01/app/oracle/diag/rdbms/rcat/rcat/trace/rcat_ora_3963.trc'>
<txt>Errors in file /u01/app/oracle/diag/rdbms/rcat/rcat/trace/rcat_ora_3963.trc (incident=1345):
ORA-07445: exception encountered: core dump [knl_get_min_req_scn()+6] [SIGSEGV] [ADDR:0x83900490] [PC:0x86E4932] [Address not mapped to object] []
</txt>
</msg>
<msg time='2009-07-11T13:46:22.310-04:00' org_id='oracle' comp_id='rdbms'
msg_id='dbgexProcessError:1097:3370026720' type='TRACE' level='16'
host_id='bd11g' host_addr='127.0.0.1'>
<txt>Incident details in: /u01/app/oracle/diag/rdbms/rcat/rcat/incident/incdir_1345/rcat_ora_3963_i1345.trc
</txt>
</msg>
DBCA TRACE LOG trace.log /u01/app/oracle/cfgtoollogs/dbca/rcat
------------------------
[Thread-10] [14:8:9:116] [UIHost.getHtmlSummary:1055] UIHost:getHtmlSummary: running createTemplateDocument NOT for SHOW_TEMPLATE condition
[Thread-10] [14:8:9:125] [UIHost.getHtmlSummary:1061] UIHost:getHtmlSummary: after running createTemplateDocument NOT for SHOW_TEMPLATE condition
[Thread-10] [14:8:9:133] [XSLConst.generateHeaderXSL:211] NLS:Template Name:= null
[Thread-10] [14:8:9:134] [XSLConst.generateHeaderXSL:216] Template Description:= Use this database template to create a pre-configured database optimized for general purpose or transaction processing usage.
[Thread-10] [14:8:10:753] [UIHost.getHtmlSummary:1100] UIHost->getHtmlSummary: start printing of transformed document
[TaskScheduler timer] [14:8:12:553] [Host.executeSteps:4426] Executing steps....
[TaskScheduler timer] [14:8:12:554] [Host.setUpForOperation:3198] setUpForOperation: Mode = 128
[TaskScheduler timer] [14:8:12:555] [OsUtilsBase.copyFile:716] OsUtilsBase.copyFile:
[TaskScheduler timer] [14:8:12:578] [Host.executeSteps:4605] setupForOperation returned: true
[TaskScheduler timer] [14:8:12:579] [Host.createStepSQLInterface:6444] sid =rcat
[TaskScheduler timer] [14:8:12:587] [SQLEngine.initialize:253] Execing SQLPLUS/SVRMGR process...
[TaskScheduler timer] [14:8:12:688] [SQLEngine.initialize:281] m_bReaderStarted: false
[TaskScheduler timer] [14:8:12:689] [SQLEngine.initialize:285] Starting Reader Thread...
[Thread-13] [14:8:12:762] [StepContext$ModeRunner.run:2495] ---- Progress Needed:=true
[Thread-13] [14:8:13:511] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION_RMAN_RESTORE
[Thread-13] [14:8:13:512] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01092
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01034
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-03114
[Thread-13] [14:8:13:513] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-12560
[Thread-13] [14:8:13:513] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109
[Thread-13] [14:8:13:513] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-13] [14:8:13:517] [BasicStep.execute:202] Executing Step : INSTANCE_CREATION
[Thread-13] [14:8:13:518] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-13] [14:8:13:530] [InitParamAttributes.sortParams:3575] m_sortOn:-1 sortOn:4
[Thread-13] [14:8:13:569] [InitParamAttributes.createInitFile:1710] Processing init param db_block_size
[Thread-13] [14:8:13:570] [InitParamAttributes.createInitFile:1715] The value is 8192
[Thread-13] [14:8:13:570] [InitParamAttributes.createInitFile:1710] Processing init param open_cursors
[Thread-13] [14:8:13:571] [InitParamAttributes.createInitFile:1715] The value is 300
[Thread-13] [14:8:13:571] [InitParamAttributes.createInitFile:1710] Processing init param db_domain
[Thread-13] [14:8:13:575] [InitParamAttributes.createInitFile:1715] The value is ""
[Thread-13] [14:8:13:576] [InitParamAttributes.createInitFile:1710] Processing init param db_name
[Thread-13] [14:8:13:576] [InitParamAttributes.createInitFile:1715] The value is rcat
...
racle.sysman.assistants.dbca.backend.CloneRmanRestoreStep$ProgressTracker.run(CloneRmanRestoreStep.java:935)
java.lang.Thread.run(Thread.java:595)
[Thread-13] [14:11:43:80] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@19ccb73
[Thread-13] [14:11:43:81] [StepContext$ModeRunner.run:2495] ---- Progress Needed:=true
[Thread-13] [14:11:43:95] [BasicStep.execute:202] Executing Step : CLONE_DB_CREATION
[Thread-13] [14:11:43:95] [StepErrorHandler.setFatalErrors:322] setting Fatal Error: ORA-01503
[Thread-13] [14:11:43:95] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-01109
[Thread-13] [14:11:43:96] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-12712
[Thread-13] [14:11:43:96] [StepErrorHandler.setIgnorableErrors:250] setting Ignorable Error: ORA-00942
[Thread-13] [14:11:43:96] [BasicStep.configureSettings:304] messageHandler being set=null
[Thread-13] [14:11:43:266] [SQLEngine.spoolOff:1874] Setting spool off = /u01/app/oracle/cfgtoollogs/dbca/rcat/CloneRmanRestore.log
[Thread-13] [14:11:43:266] [SQLEngine.setSpool:1806] old Spool = null
[Thread-13] [14:11:43:266] [SQLEngine.setSpool:1807] Setting Spool = /u01/app/oracle/cfgtoollogs/dbca/rcat/cloneDBCreation.log
[Thread-13] [14:11:43:267] [SQLEngine.setSpool:1808] Is spool appendable? --> true
[Thread-13] [14:11:43:273] [CloneDBCreationStep.executeImpl:342] a.createCtlFileSql = Create controlfile reuse set database "rcat"
MAXINSTANCES 8
Datafile
'/u01/app/oracle/oradata/rcat/system01.dbf',
'/u01/app/oracle/oradata/rcat/sysaux01.dbf',
'/u01/app/oracle/oradata/rcat/undotbs01.dbf',
'/u01/app/oracle/oradata/rcat/users01.dbf'
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/rcat/redo01.log') SIZE 51200K,
GROUP 2 ('/u01/app/oracle/oradata/rcat/redo02.log') SIZE 51200K,
GROUP 3 ('/u01/app/oracle/oradata/rcat/redo03.log') SIZE 51200K RESETLOGS;
[Thread-13] [14:11:44:665] [CloneDBCreationStep.executeImpl:421] calling zerodbid
[Thread-13] [14:11:51:70] [CloneDBCreationStep.executeImpl:431] Shutdown database
[Thread-13] [14:11:51:86] [CloneDBCreationStep.executeImpl:453] Startup ......nomount......
[Thread-13] [14:11:57:598] [CloneDBCreationStep.executeImpl:472] Enabling restricted session.
[Thread-13] [14:11:57:856] [CloneDBCreationStep.executeImpl:474] alter database "rcat" open resetlogs;
[Thread-11] [14:12:3:412] [BasicStep.handleNonIgnorableError:430] oracle.sysman.assistants.util.UIMessageHandler@19ccb73:messageHandler
[Thread-11] [14:12:3:412] [BasicStep.handleNonIgnorableError:431] ORA-03113: end-of-file on communication channel
:msg
[Thread-13] [14:12:8:846] [SQLEngine.done:2014] Done called
[Thread-13] [14:12:8:847] [SQLEngine.spoolOff:1874] Setting spool off = /u01/app/oracle/cfgtoollogs/dbca/rcat/cloneDBCreation.log
[Thread-13] [14:12:8:848] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@19ccb73
[Thread-13] [14:12:8:848] [StepContext$ModeRunner.run:2521] oracle.sysman.assistants.dbca.backend.CloneDBCreationStep.executeImpl(CloneDBCreationStep.java:894)
oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2505)
java.lang.Thread.run(Thread.java:595)
[Thread-13] [14:12:10:157] [SQLEngine.done:2014] Done called
CLONE DB CREATION LOG cloneDBCreation.log /u01/app/oracle/cfgtoollogs/dbca/rcat
-----------------------------------
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1313092 bytes
Variable Size 197134012 bytes
Database Buffers 109051904 bytes
Redo Buffers 6361088 bytes
alter database "rcat" open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 3963
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 313860096 bytes
Fixed Size 1313092 bytes
Variable Size 197134012 bytes
Database Buffers 109051904 bytes
Redo Buffers 6361088 bytes
alter database "rcat" open resetlogs
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 7521
Also clean everything under /u01/app/oracle/diag/rdbms
ASKER
I copied over the original image with only the orcl instance installed so there was no need to clean out the rcat instance partial files.
I put the SGA+PGA size using Automatic Memory Management down to 12% ( 250MB) and the same thing happened.
Befoe running the process I did a ipcs and got this:
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 65536 oracle 600 393216 2 dest
0x00000000 98305 oracle 600 393216 2 dest
0x00000000 131074 oracle 600 393216 2 dest
0x00000000 163843 oracle 600 393216 2 dest
0x00000000 196612 oracle 600 393216 2 dest
0x00000000 229381 oracle 600 393216 2 dest
0x00000000 262150 oracle 600 393216 2 dest
0x00000000 294919 oracle 600 393216 2 dest
0x00000000 327688 oracle 600 393216 2 dest
0x00000000 589835 oracle 600 393216 2 dest
0x00000000 491532 oracle 600 393216 2 dest
------ Semaphore Arrays --------
key semid owner perms nsems
------ Message Queues --------
key msqid owner perms used-bytes messages
I did a ipcrm and got:
no result here
I figure the problem is with my Linux memory configuration, Oracle or VMware.
The virtual machine has 2048MB of RAM.
It has 4 scsi hard disk 3 of which are on 1 logical partition called oracle.
Total oracle partition size is 29.99GB.
Do you know of any other way I can find out more about the processes/memory on linux, I'm not that familiar.
also btw it's not the Red Hat linux, it Oracle Enterprise Linux 5 Update 1 which is 100% certified with Red Linux Enterprise Server 5 Update 1.
Also, Oracle 11g was certified tested for Oracle Enterprise Linux 5 Update 1 so it seems that I have the right setup.
It leads me think that there's some Linux configuration not working.
I put the SGA+PGA size using Automatic Memory Management down to 12% ( 250MB) and the same thing happened.
Befoe running the process I did a ipcs and got this:
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 65536 oracle 600 393216 2 dest
0x00000000 98305 oracle 600 393216 2 dest
0x00000000 131074 oracle 600 393216 2 dest
0x00000000 163843 oracle 600 393216 2 dest
0x00000000 196612 oracle 600 393216 2 dest
0x00000000 229381 oracle 600 393216 2 dest
0x00000000 262150 oracle 600 393216 2 dest
0x00000000 294919 oracle 600 393216 2 dest
0x00000000 327688 oracle 600 393216 2 dest
0x00000000 589835 oracle 600 393216 2 dest
0x00000000 491532 oracle 600 393216 2 dest
------ Semaphore Arrays --------
key semid owner perms nsems
------ Message Queues --------
key msqid owner perms used-bytes messages
I did a ipcrm and got:
no result here
I figure the problem is with my Linux memory configuration, Oracle or VMware.
The virtual machine has 2048MB of RAM.
It has 4 scsi hard disk 3 of which are on 1 logical partition called oracle.
Total oracle partition size is 29.99GB.
Do you know of any other way I can find out more about the processes/memory on linux, I'm not that familiar.
also btw it's not the Red Hat linux, it Oracle Enterprise Linux 5 Update 1 which is 100% certified with Red Linux Enterprise Server 5 Update 1.
Also, Oracle 11g was certified tested for Oracle Enterprise Linux 5 Update 1 so it seems that I have the right setup.
It leads me think that there's some Linux configuration not working.
I'm running 10g and 11g on Oracle Enterprise 5.0 and 5.3, so thats not the problem.
Are you seeing those memory segments while orcl instances is down? If so, and you cannot remove them with ipcrm, reboot the whole VM. When Oracle is down, there should be zero shared memory segments in the kernel.
Check all instances are down with:
ps -ef | grep smon
Are you seeing those memory segments while orcl instances is down? If so, and you cannot remove them with ipcrm, reboot the whole VM. When Oracle is down, there should be zero shared memory segments in the kernel.
Check all instances are down with:
ps -ef | grep smon
ASKER
My original image with just the orcl installed, when I boot the machine and haven't done anything yet I issue the commands and get these results.
So this means that when I boot the system these processes are alreay running.
Continued below...
--------------------------
ipcs
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 65536 oracle 600 393216 2 dest
0x00000000 98305 oracle 600 393216 2 dest
0x00000000 131074 oracle 600 393216 2 dest
0x00000000 163843 oracle 600 393216 2 dest
0x00000000 196612 oracle 600 393216 2 dest
0x00000000 229381 oracle 600 393216 2 dest
0x00000000 425990 oracle 600 393216 2 dest
0x00000000 294919 oracle 600 393216 2 dest
0x00000000 327688 oracle 600 393216 2 dest
------ Semaphore Arrays --------
key semid owner perms nsems
------ Message Queues --------
key msqid owner perms used-bytes messages
--------------------------
ps -ef | grep smon
oracle 4131 4063 0 19:46 pts/1 00:00:00 grep smon
So I check my oracle environment like this
$ . oraenv
ORACLE_SID = [orcl] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracl
so then I try to connect with sqlplus to see if the database is started
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jul 11 19:50:04 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
ok so I try a shutdown
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL>
so when i see this message I assume that the orcl instance is NOT running
Where then I wonder do these oracle processes come from?
SQL>
--------------------------
it looks like these are defintely from the oracle software
the group is oinstall and the user is oracle
# ipcs -c
------ Shared Memory Segment Creators/Owners --------
shmid perms cuid cgid uid gid
65536 600 oracle oinstall oracle oinstall
98305 600 oracle oinstall oracle oinstall
131074 600 oracle oinstall oracle oinstall
163843 600 oracle oinstall oracle oinstall
196612 600 oracle oinstall oracle oinstall
229381 600 oracle oinstall oracle oinstall
425990 600 oracle oinstall oracle oinstall
294919 600 oracle oinstall oracle oinstall
327688 600 oracle oinstall oracle oinstall
------ Semaphore Arrays Creators/Owners --------
semid perms cuid cgid uid gid
------ Message Queues: Creators/Owners --------
msqid perms cuid cgid uid gid
--------------------------
These are all the processes running on my machine at this state:
# ps -ef
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 19:39 ? 00:00:01 init [5]
root 2 1 0 19:39 ? 00:00:00 [migration/0]
root 3 1 0 19:39 ? 00:00:00 [ksoftirqd/0]
root 4 1 0 19:39 ? 00:00:00 [watchdog/0]
root 5 1 0 19:39 ? 00:00:00 [events/0]
root 6 1 0 19:39 ? 00:00:00 [khelper]
root 7 1 0 19:39 ? 00:00:00 [kthread]
root 10 7 0 19:39 ? 00:00:00 [kblockd/0]
root 11 7 0 19:39 ? 00:00:00 [kacpid]
root 71 7 0 19:39 ? 00:00:00 [cqueue/0]
root 74 7 0 19:39 ? 00:00:00 [khubd]
root 76 7 0 19:39 ? 00:00:00 [kseriod]
root 139 7 0 19:39 ? 00:00:00 [pdflush]
root 140 7 0 19:39 ? 00:00:00 [pdflush]
root 141 7 0 19:39 ? 00:00:00 [kswapd0]
root 142 7 0 19:39 ? 00:00:00 [aio/0]
root 295 7 0 19:39 ? 00:00:00 [kpsmoused]
root 325 7 0 19:39 ? 00:00:00 [scsi_eh_0]
root 328 7 0 19:39 ? 00:00:00 [ata/0]
root 329 7 0 19:39 ? 00:00:00 [ata_aux]
root 340 7 0 19:39 ? 00:00:00 [ksnapd]
root 343 7 0 19:39 ? 00:00:02 [kjournald]
root 371 7 0 19:39 ? 00:00:00 [kauditd]
root 405 1 0 19:39 ? 00:00:01 /sbin/udevd -d
root 1336 7 0 19:40 ? 00:00:00 [kmpathd/0]
root 1377 7 0 19:40 ? 00:00:00 [kjournald]
root 1379 7 0 19:40 ? 00:00:02 [kjournald]
root 1800 1 0 19:40 ? 00:00:00 /sbin/dhclient -1 -q -cf /etc/dh
root 1840 1 0 19:40 ? 00:00:00 auditd
root 1842 1840 0 19:40 ? 00:00:00 python /sbin/audispd
root 1864 1 0 19:40 ? 00:00:00 syslogd -m 0
root 1867 1 0 19:40 ? 00:00:00 klogd -x
rpc 1900 1 0 19:40 ? 00:00:00 portmap
root 1929 1 0 19:40 ? 00:00:00 rpc.statd
root 1965 1 0 19:40 ? 00:00:00 rpc.idmapd
root 2027 1 0 19:40 ? 00:00:00 [vmhgfs]
root 2044 1 0 19:40 ? 00:00:00 [vmmemctl]
root 2092 1 0 19:40 ? 00:00:06 /usr/sbin/vmware-guestd --backgr
dbus 2143 1 0 19:40 ? 00:00:00 dbus-daemon --system
root 2154 1 0 19:40 ? 00:00:00 /usr/sbin/hcid
root 2167 1 0 19:40 ? 00:00:00 /usr/sbin/sdpd
root 2178 1 0 19:40 ? 00:00:00 [krfcommd]
root 2217 1 0 19:41 ? 00:00:00 pcscd
root 2237 1 0 19:41 ? 00:00:00 /usr/bin/hidd --server
root 2252 1 0 19:41 ? 00:00:00 automount
root 2271 1 0 19:41 ? 00:00:00 /usr/sbin/acpid
root 2282 1 0 19:41 ? 00:00:00 ./hpiod
root 2287 1 0 19:41 ? 00:00:00 python ./hpssd.py
root 2302 1 0 19:41 ? 00:00:00 /usr/sbin/sshd
root 2313 1 0 19:41 ? 00:00:00 cupsd
root 2333 1 0 19:41 ? 00:00:00 sendmail: accepting connections
smmsp 2341 1 0 19:41 ? 00:00:00 sendmail: Queue runner@01:00:00
root 2353 1 0 19:41 ? 00:00:00 gpm -m /dev/input/mice -t exps2
root 2364 1 0 19:41 ? 00:00:00 crond
xfs 2395 1 0 19:41 ? 00:00:00 xfs -droppriv -daemon
root 2406 1 0 19:41 ? 00:00:00 smbd -D
root 2409 1 0 19:41 ? 00:00:01 nmbd -D
root 2420 1 0 19:41 ? 00:00:00 anacron -s
root 2430 1 0 19:41 ? 00:00:00 /usr/sbin/atd
root 2443 2406 0 19:41 ? 00:00:00 smbd -D
root 2456 1 0 19:41 ? 00:00:03 /usr/bin/python /usr/sbin/yum-up
avahi 2468 1 0 19:41 ? 00:00:00 avahi-daemon: running [bd11g.loc
avahi 2469 2468 0 19:41 ? 00:00:00 avahi-daemon: chroot helper
68 2480 1 0 19:41 ? 00:00:02 hald
root 2481 2480 0 19:41 ? 00:00:00 hald-runner
68 2501 2481 0 19:41 ? 00:00:00 hald-addon-acpi: listening on ac
68 2508 2481 0 19:41 ? 00:00:00 hald-addon-keyboard: listening o
root 2517 2481 0 19:41 ? 00:00:01 hald-addon-storage: polling /dev
root 2613 1 0 19:41 ? 00:00:00 /usr/sbin/smartd -q never
root 2618 1 0 19:41 tty1 00:00:00 /sbin/mingetty tty1
root 2621 1 0 19:41 tty2 00:00:00 /sbin/mingetty tty2
root 2622 1 0 19:41 tty3 00:00:00 /sbin/mingetty tty3
root 2623 1 0 19:41 tty4 00:00:00 /sbin/mingetty tty4
root 2637 1 0 19:41 tty5 00:00:00 /sbin/mingetty tty5
root 2640 1 0 19:41 tty6 00:00:00 /sbin/mingetty tty6
root 2641 1 0 19:41 ? 00:00:00 /usr/sbin/gdm-binary -nodaemon
root 2721 2641 0 19:41 ? 00:00:00 /usr/sbin/gdm-binary -nodaemon
root 2724 1 0 19:41 ? 00:00:00 /usr/sbin/gdm-binary -nodaemon
root 2727 2721 3 19:41 tty7 00:00:42 /usr/bin/Xorg :0 -br -audit 0 -a
oracle 2761 2721 0 19:42 ? 00:00:00 /usr/bin/gnome-session
oracle 2820 2761 0 19:42 ? 00:00:00 /usr/bin/ssh-agent /usr/bin/dbus
oracle 2823 1 0 19:42 ? 00:00:00 /usr/bin/dbus-launch --exit-with
oracle 2824 1 0 19:42 ? 00:00:00 /bin/dbus-daemon --fork --print-
oracle 2830 1 0 19:42 ? 00:00:00 /usr/libexec/gconfd-2 11
oracle 2833 1 0 19:42 ? 00:00:00 /usr/bin/gnome-keyring-dae
oracle 2835 1 0 19:42 ? 00:00:00 /usr/libexec/gnome-setting
oracle 2850 1 0 19:42 ? 00:00:01 metacity --sm-client-id=default1
oracle 2854 1 0 19:42 ? 00:00:01 gnome-panel --sm-client-id defau
oracle 2856 1 0 19:42 ? 00:00:02 nautilus --no-default-window --s
oracle 2860 1 0 19:42 ? 00:00:00 /usr/libexec/bonobo-activa
oracle 2862 1 0 19:42 ? 00:00:00 /usr/libexec/gnome-vfs-dae
oracle 2866 1 0 19:42 ? 00:00:00 eggcups --sm-client-id default4
oracle 2869 1 0 19:42 ? 00:00:00 gnome-volume-manager --sm-client
oracle 2876 1 0 19:42 ? 00:00:00 bt-applet --sm-disable
oracle 2887 1 0 19:42 ? 00:00:00 /usr/bin/python -tt /usr/bin/pup
oracle 2898 1 0 19:42 ? 00:00:00 /usr/libexec/gam_server
oracle 2900 1 0 19:42 ? 00:00:01 /usr/libexec/wnck-applet --oaf-a
oracle 2902 1 0 19:42 ? 00:00:00 /usr/libexec/trashapplet --oaf-a
oracle 2905 1 0 19:42 ? 00:00:00 /usr/libexec/mapping-daemo
oracle 2908 1 0 19:42 ? 00:00:00 ./escd --key_Inserted="/usr/bin/
oracle 2911 1 0 19:42 ? 00:00:00 nm-applet --sm-disable
oracle 2920 2092 0 19:42 ? 00:00:02 /usr/lib/vmware-tools/bin3
oracle 2925 1 0 19:42 ? 00:00:00 pam-panel-icon --sm-client-id de
oracle 2931 1 0 19:42 ? 00:00:00 /usr/libexec/clock-applet --oaf-
oracle 2939 1 0 19:42 ? 00:00:00 /usr/libexec/notification-
oracle 2941 1 0 19:42 ? 00:00:00 /usr/libexec/mixer_applet2
oracle 2942 1 0 19:42 ? 00:00:00 gnome-power-manager
root 2943 2925 0 19:42 ? 00:00:00 /sbin/pam_timestamp_check -d roo
oracle 2948 1 0 19:42 ? 00:00:02 /usr/bin/python -E /usr/bin/seal
oracle 3009 1 0 19:42 ? 00:00:01 gnome-screensaver
oracle 4060 1 0 19:45 ? 00:00:06 gnome-terminal
oracle 4062 4060 0 19:45 ? 00:00:00 gnome-pty-helper
oracle 4063 4060 0 19:45 pts/1 00:00:00 bash
root 4300 4063 0 19:52 pts/1 00:00:00 su
root 4303 4300 0 19:52 pts/1 00:00:00 bash
root 4611 4303 0 20:01 pts/1 00:00:00 ps -ef
[root@bd11g oracle]#
I would like to kill the ones that seem to be owned by the oinstall group from the ipc -c command however the kill command
only seems to be able to let you kill a pid and the ipc uses shmid (shared memory id I would guess)
or maybe you can see that I'm a little fuzzy on it..
what do you suggest?
btw thanks for your help up to this point
So this means that when I boot the system these processes are alreay running.
Continued below...
--------------------------
ipcs
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 65536 oracle 600 393216 2 dest
0x00000000 98305 oracle 600 393216 2 dest
0x00000000 131074 oracle 600 393216 2 dest
0x00000000 163843 oracle 600 393216 2 dest
0x00000000 196612 oracle 600 393216 2 dest
0x00000000 229381 oracle 600 393216 2 dest
0x00000000 425990 oracle 600 393216 2 dest
0x00000000 294919 oracle 600 393216 2 dest
0x00000000 327688 oracle 600 393216 2 dest
------ Semaphore Arrays --------
key semid owner perms nsems
------ Message Queues --------
key msqid owner perms used-bytes messages
--------------------------
ps -ef | grep smon
oracle 4131 4063 0 19:46 pts/1 00:00:00 grep smon
So I check my oracle environment like this
$ . oraenv
ORACLE_SID = [orcl] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracl
so then I try to connect with sqlplus to see if the database is started
$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jul 11 19:50:04 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
ok so I try a shutdown
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL>
so when i see this message I assume that the orcl instance is NOT running
Where then I wonder do these oracle processes come from?
SQL>
--------------------------
it looks like these are defintely from the oracle software
the group is oinstall and the user is oracle
# ipcs -c
------ Shared Memory Segment Creators/Owners --------
shmid perms cuid cgid uid gid
65536 600 oracle oinstall oracle oinstall
98305 600 oracle oinstall oracle oinstall
131074 600 oracle oinstall oracle oinstall
163843 600 oracle oinstall oracle oinstall
196612 600 oracle oinstall oracle oinstall
229381 600 oracle oinstall oracle oinstall
425990 600 oracle oinstall oracle oinstall
294919 600 oracle oinstall oracle oinstall
327688 600 oracle oinstall oracle oinstall
------ Semaphore Arrays Creators/Owners --------
semid perms cuid cgid uid gid
------ Message Queues: Creators/Owners --------
msqid perms cuid cgid uid gid
--------------------------
These are all the processes running on my machine at this state:
# ps -ef
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 19:39 ? 00:00:01 init [5]
root 2 1 0 19:39 ? 00:00:00 [migration/0]
root 3 1 0 19:39 ? 00:00:00 [ksoftirqd/0]
root 4 1 0 19:39 ? 00:00:00 [watchdog/0]
root 5 1 0 19:39 ? 00:00:00 [events/0]
root 6 1 0 19:39 ? 00:00:00 [khelper]
root 7 1 0 19:39 ? 00:00:00 [kthread]
root 10 7 0 19:39 ? 00:00:00 [kblockd/0]
root 11 7 0 19:39 ? 00:00:00 [kacpid]
root 71 7 0 19:39 ? 00:00:00 [cqueue/0]
root 74 7 0 19:39 ? 00:00:00 [khubd]
root 76 7 0 19:39 ? 00:00:00 [kseriod]
root 139 7 0 19:39 ? 00:00:00 [pdflush]
root 140 7 0 19:39 ? 00:00:00 [pdflush]
root 141 7 0 19:39 ? 00:00:00 [kswapd0]
root 142 7 0 19:39 ? 00:00:00 [aio/0]
root 295 7 0 19:39 ? 00:00:00 [kpsmoused]
root 325 7 0 19:39 ? 00:00:00 [scsi_eh_0]
root 328 7 0 19:39 ? 00:00:00 [ata/0]
root 329 7 0 19:39 ? 00:00:00 [ata_aux]
root 340 7 0 19:39 ? 00:00:00 [ksnapd]
root 343 7 0 19:39 ? 00:00:02 [kjournald]
root 371 7 0 19:39 ? 00:00:00 [kauditd]
root 405 1 0 19:39 ? 00:00:01 /sbin/udevd -d
root 1336 7 0 19:40 ? 00:00:00 [kmpathd/0]
root 1377 7 0 19:40 ? 00:00:00 [kjournald]
root 1379 7 0 19:40 ? 00:00:02 [kjournald]
root 1800 1 0 19:40 ? 00:00:00 /sbin/dhclient -1 -q -cf /etc/dh
root 1840 1 0 19:40 ? 00:00:00 auditd
root 1842 1840 0 19:40 ? 00:00:00 python /sbin/audispd
root 1864 1 0 19:40 ? 00:00:00 syslogd -m 0
root 1867 1 0 19:40 ? 00:00:00 klogd -x
rpc 1900 1 0 19:40 ? 00:00:00 portmap
root 1929 1 0 19:40 ? 00:00:00 rpc.statd
root 1965 1 0 19:40 ? 00:00:00 rpc.idmapd
root 2027 1 0 19:40 ? 00:00:00 [vmhgfs]
root 2044 1 0 19:40 ? 00:00:00 [vmmemctl]
root 2092 1 0 19:40 ? 00:00:06 /usr/sbin/vmware-guestd --backgr
dbus 2143 1 0 19:40 ? 00:00:00 dbus-daemon --system
root 2154 1 0 19:40 ? 00:00:00 /usr/sbin/hcid
root 2167 1 0 19:40 ? 00:00:00 /usr/sbin/sdpd
root 2178 1 0 19:40 ? 00:00:00 [krfcommd]
root 2217 1 0 19:41 ? 00:00:00 pcscd
root 2237 1 0 19:41 ? 00:00:00 /usr/bin/hidd --server
root 2252 1 0 19:41 ? 00:00:00 automount
root 2271 1 0 19:41 ? 00:00:00 /usr/sbin/acpid
root 2282 1 0 19:41 ? 00:00:00 ./hpiod
root 2287 1 0 19:41 ? 00:00:00 python ./hpssd.py
root 2302 1 0 19:41 ? 00:00:00 /usr/sbin/sshd
root 2313 1 0 19:41 ? 00:00:00 cupsd
root 2333 1 0 19:41 ? 00:00:00 sendmail: accepting connections
smmsp 2341 1 0 19:41 ? 00:00:00 sendmail: Queue runner@01:00:00
root 2353 1 0 19:41 ? 00:00:00 gpm -m /dev/input/mice -t exps2
root 2364 1 0 19:41 ? 00:00:00 crond
xfs 2395 1 0 19:41 ? 00:00:00 xfs -droppriv -daemon
root 2406 1 0 19:41 ? 00:00:00 smbd -D
root 2409 1 0 19:41 ? 00:00:01 nmbd -D
root 2420 1 0 19:41 ? 00:00:00 anacron -s
root 2430 1 0 19:41 ? 00:00:00 /usr/sbin/atd
root 2443 2406 0 19:41 ? 00:00:00 smbd -D
root 2456 1 0 19:41 ? 00:00:03 /usr/bin/python /usr/sbin/yum-up
avahi 2468 1 0 19:41 ? 00:00:00 avahi-daemon: running [bd11g.loc
avahi 2469 2468 0 19:41 ? 00:00:00 avahi-daemon: chroot helper
68 2480 1 0 19:41 ? 00:00:02 hald
root 2481 2480 0 19:41 ? 00:00:00 hald-runner
68 2501 2481 0 19:41 ? 00:00:00 hald-addon-acpi: listening on ac
68 2508 2481 0 19:41 ? 00:00:00 hald-addon-keyboard: listening o
root 2517 2481 0 19:41 ? 00:00:01 hald-addon-storage: polling /dev
root 2613 1 0 19:41 ? 00:00:00 /usr/sbin/smartd -q never
root 2618 1 0 19:41 tty1 00:00:00 /sbin/mingetty tty1
root 2621 1 0 19:41 tty2 00:00:00 /sbin/mingetty tty2
root 2622 1 0 19:41 tty3 00:00:00 /sbin/mingetty tty3
root 2623 1 0 19:41 tty4 00:00:00 /sbin/mingetty tty4
root 2637 1 0 19:41 tty5 00:00:00 /sbin/mingetty tty5
root 2640 1 0 19:41 tty6 00:00:00 /sbin/mingetty tty6
root 2641 1 0 19:41 ? 00:00:00 /usr/sbin/gdm-binary -nodaemon
root 2721 2641 0 19:41 ? 00:00:00 /usr/sbin/gdm-binary -nodaemon
root 2724 1 0 19:41 ? 00:00:00 /usr/sbin/gdm-binary -nodaemon
root 2727 2721 3 19:41 tty7 00:00:42 /usr/bin/Xorg :0 -br -audit 0 -a
oracle 2761 2721 0 19:42 ? 00:00:00 /usr/bin/gnome-session
oracle 2820 2761 0 19:42 ? 00:00:00 /usr/bin/ssh-agent /usr/bin/dbus
oracle 2823 1 0 19:42 ? 00:00:00 /usr/bin/dbus-launch --exit-with
oracle 2824 1 0 19:42 ? 00:00:00 /bin/dbus-daemon --fork --print-
oracle 2830 1 0 19:42 ? 00:00:00 /usr/libexec/gconfd-2 11
oracle 2833 1 0 19:42 ? 00:00:00 /usr/bin/gnome-keyring-dae
oracle 2835 1 0 19:42 ? 00:00:00 /usr/libexec/gnome-setting
oracle 2850 1 0 19:42 ? 00:00:01 metacity --sm-client-id=default1
oracle 2854 1 0 19:42 ? 00:00:01 gnome-panel --sm-client-id defau
oracle 2856 1 0 19:42 ? 00:00:02 nautilus --no-default-window --s
oracle 2860 1 0 19:42 ? 00:00:00 /usr/libexec/bonobo-activa
oracle 2862 1 0 19:42 ? 00:00:00 /usr/libexec/gnome-vfs-dae
oracle 2866 1 0 19:42 ? 00:00:00 eggcups --sm-client-id default4
oracle 2869 1 0 19:42 ? 00:00:00 gnome-volume-manager --sm-client
oracle 2876 1 0 19:42 ? 00:00:00 bt-applet --sm-disable
oracle 2887 1 0 19:42 ? 00:00:00 /usr/bin/python -tt /usr/bin/pup
oracle 2898 1 0 19:42 ? 00:00:00 /usr/libexec/gam_server
oracle 2900 1 0 19:42 ? 00:00:01 /usr/libexec/wnck-applet --oaf-a
oracle 2902 1 0 19:42 ? 00:00:00 /usr/libexec/trashapplet --oaf-a
oracle 2905 1 0 19:42 ? 00:00:00 /usr/libexec/mapping-daemo
oracle 2908 1 0 19:42 ? 00:00:00 ./escd --key_Inserted="/usr/bin/
oracle 2911 1 0 19:42 ? 00:00:00 nm-applet --sm-disable
oracle 2920 2092 0 19:42 ? 00:00:02 /usr/lib/vmware-tools/bin3
oracle 2925 1 0 19:42 ? 00:00:00 pam-panel-icon --sm-client-id de
oracle 2931 1 0 19:42 ? 00:00:00 /usr/libexec/clock-applet --oaf-
oracle 2939 1 0 19:42 ? 00:00:00 /usr/libexec/notification-
oracle 2941 1 0 19:42 ? 00:00:00 /usr/libexec/mixer_applet2
oracle 2942 1 0 19:42 ? 00:00:00 gnome-power-manager
root 2943 2925 0 19:42 ? 00:00:00 /sbin/pam_timestamp_check -d roo
oracle 2948 1 0 19:42 ? 00:00:02 /usr/bin/python -E /usr/bin/seal
oracle 3009 1 0 19:42 ? 00:00:01 gnome-screensaver
oracle 4060 1 0 19:45 ? 00:00:06 gnome-terminal
oracle 4062 4060 0 19:45 ? 00:00:00 gnome-pty-helper
oracle 4063 4060 0 19:45 pts/1 00:00:00 bash
root 4300 4063 0 19:52 pts/1 00:00:00 su
root 4303 4300 0 19:52 pts/1 00:00:00 bash
root 4611 4303 0 20:01 pts/1 00:00:00 ps -ef
[root@bd11g oracle]#
I would like to kill the ones that seem to be owned by the oinstall group from the ipc -c command however the kill command
only seems to be able to let you kill a pid and the ipc uses shmid (shared memory id I would guess)
or maybe you can see that I'm a little fuzzy on it..
what do you suggest?
btw thanks for your help up to this point
ASKER
well the user on my machine is called oracle and its group is oinstall
this is the user I use when im not root
so i check the processes for all ora_* processes
# ps -ef | grep ora_*
root 2517 2481 0 19:41 ? 00:00:03 hald-addon-storage: polling /dev/hdc
oracle 2761 2721 0 19:42 ? 00:00:00 /usr/bin/gnome-session
oracle 2820 2761 0 19:42 ? 00:00:00 /usr/bin/ssh-agent /usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xclients
oracle 2823 1 0 19:42 ? 00:00:00 /usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xclients
oracle 2824 1 0 19:42 ? 00:00:00 /bin/dbus-daemon --fork --print-pid 4 --print-address 6 --session
oracle 2830 1 0 19:42 ? 00:00:00 /usr/libexec/gconfd-2 11
oracle 2833 1 0 19:42 ? 00:00:00 /usr/bin/gnome-keyring-dae
oracle 2835 1 0 19:42 ? 00:00:00 /usr/libexec/gnome-setting
oracle 2850 1 0 19:42 ? 00:00:02 metacity --sm-client-id=default1
oracle 2854 1 0 19:42 ? 00:00:01 gnome-panel --sm-client-id default2
oracle 2856 1 0 19:42 ? 00:00:02 nautilus --no-default-window --sm-client-id default3
oracle 2860 1 0 19:42 ? 00:00:00 /usr/libexec/bonobo-activa
oracle 2862 1 0 19:42 ? 00:00:00 /usr/libexec/gnome-vfs-dae
oracle 2866 1 0 19:42 ? 00:00:00 eggcups --sm-client-id default4
oracle 2869 1 0 19:42 ? 00:00:00 gnome-volume-manager --sm-client-id default5
oracle 2876 1 0 19:42 ? 00:00:00 bt-applet --sm-disable
oracle 2887 1 0 19:42 ? 00:00:00 /usr/bin/python -tt /usr/bin/puplet
oracle 2898 1 0 19:42 ? 00:00:00 /usr/libexec/gam_server
oracle 2900 1 0 19:42 ? 00:00:01 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:
oracle 2902 1 0 19:42 ? 00:00:00 /usr/libexec/trashapplet --oaf-activate-iid=OAFIID:
oracle 2905 1 0 19:42 ? 00:00:00 /usr/libexec/mapping-daemo
oracle 2908 1 0 19:42 ? 00:00:00 ./escd --key_Inserted="/usr/bin/e
oracle 2911 1 0 19:42 ? 00:00:00 nm-applet --sm-disable
oracle 2920 2092 0 19:42 ? 00:00:02 /usr/lib/vmware-tools/bin3
oracle 2925 1 0 19:42 ? 00:00:00 pam-panel-icon --sm-client-id default0
oracle 2931 1 0 19:42 ? 00:00:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:
oracle 2939 1 0 19:42 ? 00:00:00 /usr/libexec/notification-
oracle 2941 1 0 19:42 ? 00:00:00 /usr/libexec/mixer_applet2
oracle 2942 1 0 19:42 ? 00:00:01 gnome-power-manager
oracle 2948 1 0 19:42 ? 00:00:02 /usr/bin/python -E /usr/bin/sealert -s
oracle 3009 1 0 19:42 ? 00:00:01 gnome-screensaver
oracle 4060 1 0 19:45 ? 00:00:10 gnome-terminal
oracle 4062 4060 0 19:45 ? 00:00:00 gnome-pty-helper
oracle 4063 4060 0 19:45 pts/1 00:00:00 bash
root 5089 4303 0 20:17 pts/1 00:00:00 grep ora_*
it appears there are none.
this is the user I use when im not root
so i check the processes for all ora_* processes
# ps -ef | grep ora_*
root 2517 2481 0 19:41 ? 00:00:03 hald-addon-storage: polling /dev/hdc
oracle 2761 2721 0 19:42 ? 00:00:00 /usr/bin/gnome-session
oracle 2820 2761 0 19:42 ? 00:00:00 /usr/bin/ssh-agent /usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xclients
oracle 2823 1 0 19:42 ? 00:00:00 /usr/bin/dbus-launch --exit-with-session /etc/X11/xinit/Xclients
oracle 2824 1 0 19:42 ? 00:00:00 /bin/dbus-daemon --fork --print-pid 4 --print-address 6 --session
oracle 2830 1 0 19:42 ? 00:00:00 /usr/libexec/gconfd-2 11
oracle 2833 1 0 19:42 ? 00:00:00 /usr/bin/gnome-keyring-dae
oracle 2835 1 0 19:42 ? 00:00:00 /usr/libexec/gnome-setting
oracle 2850 1 0 19:42 ? 00:00:02 metacity --sm-client-id=default1
oracle 2854 1 0 19:42 ? 00:00:01 gnome-panel --sm-client-id default2
oracle 2856 1 0 19:42 ? 00:00:02 nautilus --no-default-window --sm-client-id default3
oracle 2860 1 0 19:42 ? 00:00:00 /usr/libexec/bonobo-activa
oracle 2862 1 0 19:42 ? 00:00:00 /usr/libexec/gnome-vfs-dae
oracle 2866 1 0 19:42 ? 00:00:00 eggcups --sm-client-id default4
oracle 2869 1 0 19:42 ? 00:00:00 gnome-volume-manager --sm-client-id default5
oracle 2876 1 0 19:42 ? 00:00:00 bt-applet --sm-disable
oracle 2887 1 0 19:42 ? 00:00:00 /usr/bin/python -tt /usr/bin/puplet
oracle 2898 1 0 19:42 ? 00:00:00 /usr/libexec/gam_server
oracle 2900 1 0 19:42 ? 00:00:01 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:
oracle 2902 1 0 19:42 ? 00:00:00 /usr/libexec/trashapplet --oaf-activate-iid=OAFIID:
oracle 2905 1 0 19:42 ? 00:00:00 /usr/libexec/mapping-daemo
oracle 2908 1 0 19:42 ? 00:00:00 ./escd --key_Inserted="/usr/bin/e
oracle 2911 1 0 19:42 ? 00:00:00 nm-applet --sm-disable
oracle 2920 2092 0 19:42 ? 00:00:02 /usr/lib/vmware-tools/bin3
oracle 2925 1 0 19:42 ? 00:00:00 pam-panel-icon --sm-client-id default0
oracle 2931 1 0 19:42 ? 00:00:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:
oracle 2939 1 0 19:42 ? 00:00:00 /usr/libexec/notification-
oracle 2941 1 0 19:42 ? 00:00:00 /usr/libexec/mixer_applet2
oracle 2942 1 0 19:42 ? 00:00:01 gnome-power-manager
oracle 2948 1 0 19:42 ? 00:00:02 /usr/bin/python -E /usr/bin/sealert -s
oracle 3009 1 0 19:42 ? 00:00:01 gnome-screensaver
oracle 4060 1 0 19:45 ? 00:00:10 gnome-terminal
oracle 4062 4060 0 19:45 ? 00:00:00 gnome-pty-helper
oracle 4063 4060 0 19:45 pts/1 00:00:00 bash
root 5089 4303 0 20:17 pts/1 00:00:00 grep ora_*
it appears there are none.
ASKER
I even tried to connect to sql plus and query for a session, the orcl instance is not up so it doesn't return anything,
sqlplus
SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jul 11 20:28:37 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: sys
Enter password:
Connected to an idle instance.
SQL> select
vs.program,
vp.spid
from
v$session vs inner join v$process vp
on vs.paddr = vp.addr;
select
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
sqlplus
SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jul 11 20:28:37 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: sys
Enter password:
Connected to an idle instance.
SQL> select
vs.program,
vp.spid
from
v$session vs inner join v$process vp
on vs.paddr = vp.addr;
select
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
1) No need to list all processes, to find if any Oracle instance is running you use: ps -ef | grep smon
2) To killall process of a given user, you can use (from oracle or root login): killall -u oracle
3) When you see: "Connected to idle instance" it means either the instance is not running or you've set an invalid ORACLE_HOME
So I cannot see that any oracle instances are running, but since you have shared memory segments that wont remove, try rebooting the whole Linux kernel VM.
2) To killall process of a given user, you can use (from oracle or root login): killall -u oracle
3) When you see: "Connected to idle instance" it means either the instance is not running or you've set an invalid ORACLE_HOME
So I cannot see that any oracle instances are running, but since you have shared memory segments that wont remove, try rebooting the whole Linux kernel VM.
ASKER
I will try, and thank you for the points,..
I will try to reboot now and create an rcat db instance with minimum SGA+PGA size
here is the info on the free space in my system:
df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-Log
7.6G 4.6G 2.7G 64% /
/dev/sda1 145M 12M 126M 9% /boot
tmpfs 1014M 0 1014M 0% /dev/shm
/dev/mapper/VolGroup01-ora
30G 7.4G 21G 27% /u01
[root@bd11g oracle]#
I will try to reboot now and create an rcat db instance with minimum SGA+PGA size
here is the info on the free space in my system:
df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-Log
7.6G 4.6G 2.7G 64% /
/dev/sda1 145M 12M 126M 9% /boot
tmpfs 1014M 0 1014M 0% /dev/shm
/dev/mapper/VolGroup01-ora
30G 7.4G 21G 27% /u01
[root@bd11g oracle]#
Again, make sure to unset ORACLE_SID before running dbca
Running dbca with ORACLE_SID=foo and then choosing foo1 for database name will cause problems so best not to set it.
Running dbca with ORACLE_SID=foo and then choosing foo1 for database name will cause problems so best not to set it.
ASKER
When I shut down the machine everything showed a green OK status except for eth0
eth0 was failed mac address was not the same as generated address so when it restarted I corrected this
by putting the generated mac address from my vmware file into
/etc/sysconfig/network-scr
this is my ifcfg-eth0 file now
# Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE]
DEVICE=eth0
BOOTPROTO=dhcp
HWADDR=00:0c:29:43:16:14
ONBOOT=yes
TYPE=Ethernet
USERCTL=no
IPV6INIT=no
PEERDNS=yes
DHCP_HOSTNAME=bd11g
when i restarted it was ok, i was able to browse the internet anyways
also my vmware network for this machine is set to bridged
notice that its set to dhcp
when i ran the oracle installer the pre-requiste check recommended I use a static ip
would this have an effect, I'm not too sure how to set it to static.. or if you could recommend anything else?
eth0 was failed mac address was not the same as generated address so when it restarted I corrected this
by putting the generated mac address from my vmware file into
/etc/sysconfig/network-scr
this is my ifcfg-eth0 file now
# Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE]
DEVICE=eth0
BOOTPROTO=dhcp
HWADDR=00:0c:29:43:16:14
ONBOOT=yes
TYPE=Ethernet
USERCTL=no
IPV6INIT=no
PEERDNS=yes
DHCP_HOSTNAME=bd11g
when i restarted it was ok, i was able to browse the internet anyways
also my vmware network for this machine is set to bridged
notice that its set to dhcp
when i ran the oracle installer the pre-requiste check recommended I use a static ip
would this have an effect, I'm not too sure how to set it to static.. or if you could recommend anything else?
ASKER
ok.. by unset it.. do you mean leave it empty?
ASKER
I set it to rcat with the same oracle home when i tried this time
I tired again to create the database.. at 40% it still craps out
I tired again to create the database.. at 40% it still craps out
ASKER
I used 250mb sga+pga (the minimum for automatic memory management 12%)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
no I don't
I just deleted the orcl instance to have 0 instances
I was able to delete orcl
when I tried to create a db I got the same problem
so I can't even delete the 1 instance and create 1
I going to try setting up Oracle VM see how it goes
I'd still like to get this working though.. so just a quick question
sorry, I didn't understand.. what do you mean by "unset" the ORACLE_SID?
unset ORACLE_SID
It is a Linux shell command to remove an environment variable.
I recommend trying to install 5.3 Oracle Enterprise Linux. You said 5.0 but 5.3 is available. I have had no problems with 5.3 and 11g (using x86-64-bit by the way)
It is a Linux shell command to remove an environment variable.
I recommend trying to install 5.3 Oracle Enterprise Linux. You said 5.0 but 5.3 is available. I have had no problems with 5.3 and 11g (using x86-64-bit by the way)
ASKER
i'm trying now with the unset ORACLE_SID
what version of Oracle 11g are you using on 5.3?
is your Oracle 11g patched?
what version of Oracle 11g are you using on 5.3?
is your Oracle 11g patched?
11.1.0.6.0 (not patched at the moment)
ASKER
sometimes it's better to just install from the beginning than to waist time trying to solve something that can't be fixed
thanks for the support !
thanks for the support !
Just had a thought.
When creating a DB from DBCA and choosing one of the pre-built ones (Data Warehousing, General Purpose or Transaction Processing) Oracle uses RMAN to clone an existing template DB. This appears to be what is failing for you.
You can try the alternate route and choose Custom. This way new datafiles will be created in the usual way, just as if you ran "CREATE DATABASE" from sqlplus. It will take a while longer, as it runs catalog.sql, etc. but it may work.
Give that a shot.
When creating a DB from DBCA and choosing one of the pre-built ones (Data Warehousing, General Purpose or Transaction Processing) Oracle uses RMAN to clone an existing template DB. This appears to be what is failing for you.
You can try the alternate route and choose Custom. This way new datafiles will be created in the usual way, just as if you ran "CREATE DATABASE" from sqlplus. It will take a while longer, as it runs catalog.sql, etc. but it may work.
Give that a shot.
I would first try re-creating with less resources just for grins. Make sure to choose a minimal amount for SGA sizing (15% of the OS).
First clean any directories that were created for the rcat instance (oradata, etc.), rcat files under $ORACLE_HOME/dbs, all of the control files and data files that it created during the install, then start over. Check for any processes that are still running. Probably best to shutdown the other instance, then clean out any orphaned oracle shared memory segments (ipcs / ipcrm)
You do not need to set ORACLE_SID prior to running DBCA (though it should not hurt), the others are ok.
The times I have seen this have been when too large of an SGA was chosen, but I don't recall the failure being a SIGSEGV.
I have also seen it happen when the ORACLE_SID was set wrong prior to running DBCA, and a different db name was chosen during the setup, so this is why I recommend unsetting it altogether until after the DB is created so there is no mismatch.