Solved

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

Posted on 2009-07-11
21
6,329 Views
Last Modified: 2013-12-06
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.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: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

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 &quot;rcat&quot; 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

Open in new window

0
Comment
Question by:ora-what
  • 11
  • 9
21 Comments
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24832186
SIGSEGV is a crash, plain and simple. Should not happen.

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.
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24832189
Also clean everything under /u01/app/oracle/diag/rdbms and other related directories with rcat
0
 

Author Comment

by:ora-what
ID: 24832546
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.
 






0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24832552
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
0
 

Author Comment

by:ora-what
ID: 24832713
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/oracle/product/11.1.0/db_1 is /u01/app/oracle

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-daemon
oracle    2835     1  0 19:42 ?        00:00:00 /usr/libexec/gnome-settings-daem
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-activation-s
oracle    2862     1  0 19:42 ?        00:00:00 /usr/libexec/gnome-vfs-daemon
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-daemon
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/bin32/vmwa
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-area-a
oracle    2941     1  0 19:42 ?        00:00:00 /usr/libexec/mixer_applet2 --oaf
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
0
 

Author Comment

by:ora-what
ID: 24832751
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-daemon
oracle    2835     1  0 19:42 ?        00:00:00 /usr/libexec/gnome-settings-daemon
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-activation-server --ac-activate --ior-output-fd=16
oracle    2862     1  0 19:42 ?        00:00:00 /usr/libexec/gnome-vfs-daemon
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:GNOME_Wncklet_Factory --oaf-ior-fd=19
oracle    2902     1  0 19:42 ?        00:00:00 /usr/libexec/trashapplet --oaf-activate-iid=OAFIID:GNOME_Panel_TrashApplet_Factory --oaf-ior-fd=25
oracle    2905     1  0 19:42 ?        00:00:00 /usr/libexec/mapping-daemon
oracle    2908     1  0 19:42 ?        00:00:00 ./escd --key_Inserted="/usr/bin/esc" --on_Signal="/usr/bin/esc"
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/bin32/vmware-user >/dev/null 2>&1 -blockFd 11
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:GNOME_ClockApplet_Factory --oaf-ior-fd=23
oracle    2939     1  0 19:42 ?        00:00:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-ior-fd=24
oracle    2941     1  0 19:42 ?        00:00:00 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID:GNOME_MixerApplet_Factory --oaf-ior-fd=31
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.
0
 

Author Comment

by:ora-what
ID: 24832782
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
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24832789
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.

0
 

Author Comment

by:ora-what
ID: 24832807
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-LogVol00
                      7.6G  4.6G  2.7G  64% /
/dev/sda1             145M   12M  126M   9% /boot
tmpfs                1014M     0 1014M   0% /dev/shm
/dev/mapper/VolGroup01-oracle
                       30G  7.4G   21G  27% /u01
[root@bd11g oracle]#
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24832837
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.

0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:ora-what
ID: 24832901
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-scripts/ifcfg-eth0

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?

0
 

Author Comment

by:ora-what
ID: 24832904
ok.. by unset it.. do you mean leave it empty?
0
 

Author Comment

by:ora-what
ID: 24832910
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
0
 

Author Comment

by:ora-what
ID: 24832912
I used 250mb sga+pga (the minimum for automatic memory management 12%)
0
 
LVL 40

Accepted Solution

by:
mrjoltcola earned 500 total points
ID: 24832946
You did not follow my directions regarding ORACLE_SID, but probably it makes no difference.

Do you have Oracle support?

0
 

Expert Comment

by:jumprooster
ID: 24832953


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?
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24832962
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)
0
 

Author Comment

by:ora-what
ID: 24832990
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?
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24833004
11.1.0.6.0 (not patched at the moment)
0
 

Author Closing Comment

by:ora-what
ID: 31602464
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 !
0
 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24833381
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.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now