Question

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

Asked by: ora-what

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

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152:
153:
154:
155:
156:
157:
158:
159:
160:
161:
162:
163:
164:
165:
166:
167:
168:
169:
170:
171:
172:
173:
174:
175:
176:
177:
178:
179:
180:
181:
182:
183:
184:

Select all Open in new window

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

Plus...

30 Day FREE access, no risk, no obligation
Collaborate with the world's top tech experts
Unlimited access to our exclusive solution database
Never be left without tech help again

Subscribe Now

Asked On: 2009-07-11 at 11:47:58ID24562649
Tags: oracle linux vmware red hat enterprise server 11g 10g ora dbca create database instance oracle_home oracle_base oracle_sid
Topics: Oracle 11.x Database
,; Oracle Database
,; Red Hat Linux
Participating Experts: 2
Points: 500
Comments: 21

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

"The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
"Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
"Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Free Tech Articles

WARNING: 5 Reasons why you should NEVER fix a computer for free.
It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
SCCM OSD Basic troubleshooting
SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
Create a Win7 Gadget
This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
Outlook continually prompting for username and password
There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
Backup Exchange 2010 Information Store using Windows Backup
There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

Avoiding Bugs in Microsoft Access
Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
Top 10 Best New Features in Visio 2010
Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
IT Consultant Business Secrets Revealed
Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
Disaster Recovery and Business Continuity
Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
Organize Your Visio Diagrams with Containers and Lists
Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
How to Us Objects, Properties, Events and Methods in Microsoft Access
Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Watch More

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

by: mrjoltcolaPosted on 2009-07-11 at 14:11:24ID: 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.

by: mrjoltcolaPosted on 2009-07-11 at 14:12:07ID: 24832189

Also clean everything under /u01/app/oracle/diag/rdbms and other related directories with rcat

by: ora-whatPosted on 2009-07-11 at 16:15:25ID: 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.

by: mrjoltcolaPosted on 2009-07-11 at 16:17:31ID: 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

by: ora-whatPosted on 2009-07-11 at 17:05:29ID: 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

by: ora-whatPosted on 2009-07-11 at 17:21:19ID: 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.

by: ora-whatPosted on 2009-07-11 at 17:31:23ID: 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

by: mrjoltcolaPosted on 2009-07-11 at 17:33:41ID: 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.

by: ora-whatPosted on 2009-07-11 at 17:39:54ID: 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]#

by: mrjoltcolaPosted on 2009-07-11 at 17:49:05ID: 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.

by: ora-whatPosted on 2009-07-11 at 18:11:50ID: 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?

by: ora-whatPosted on 2009-07-11 at 18:12:37ID: 24832904

ok.. by unset it.. do you mean leave it empty?

by: ora-whatPosted on 2009-07-11 at 18:14:37ID: 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

by: ora-whatPosted on 2009-07-11 at 18:15:30ID: 24832912

I used 250mb sga+pga (the minimum for automatic memory management 12%)

by: mrjoltcolaPosted on 2009-07-11 at 18:28:55ID: 24832946

You did not follow my directions regarding ORACLE_SID, but probably it makes no difference.

Do you have Oracle support?

by: jumproosterPosted on 2009-07-11 at 18:32:58ID: 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?

by: mrjoltcolaPosted on 2009-07-11 at 18:37:54ID: 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)

by: ora-whatPosted on 2009-07-11 at 18:52:06ID: 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?

by: mrjoltcolaPosted on 2009-07-11 at 18:56:27ID: 24833004

11.1.0.6.0 (not patched at the moment)

by: ora-whatPosted on 2009-07-11 at 20:03:06ID: 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 !

by: mrjoltcolaPosted on 2009-07-11 at 22:49:29ID: 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.

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

For individual users
Instant access to solutions
Ask your tech questions
Start your 30-day Free Trial

Business Accounts

Perfect for organizations
Multiple users
Save over 36%
Create a Business Account

Answer for Membership

Earn free access
Showcase your knowledge
No credit card required
Sign Up to Answer

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...

Question

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

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

oracle linux vmware red hat enterprise server 11g 10g ora dbca create database instance oracle_home oracle_base oracle_sid

Oracle 11.x Database

Oracle Database

Red Hat Linux

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Need individual assistance?

Our experts are ready to help.

Want to learn from the best?

Read articles from industry experts.

Working on a long term project?

Store your work and research.

What Makes Experts Exchange Unique?

Trusted by the world's most respected brands.

Faithfully serving IT professionals since 1996.

Related Solutions

Free Tech Articles

Cloud Class Webinars

Join the Community

Give a Little. Get a Lot.

Answers

3 Ways to Join

The Experts

The Experts

Testimonials

Testimonials

Testimonials

Business Clients

Business Clients

In the Press

In the Press

In the Press