| Error in creating database (merged) [message #267889] |
Sun, 16 September 2007 02:26  |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
I have installed 11g Home in Unix and have created the pfile .
Now after connecting as sysdba and starting database in nomount mode I tried with a simple create database statement but it gave me the following error .
create database adorcl ;
ERROR:
ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 170 Serial number: 3
Let me know what is the cause of this error ?
|
|
|
|
| Re: Error in creating database [message #267890 is a reply to message #267889] |
Sun, 16 September 2007 02:32  |
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
|
Senior Member |
|
|
ORA-03113 end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel.
The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.
In addition, this message could occur when any of the following
statements/commands have been issued:
ALTER SYSTEM KILL SESSION ... IMMEDIATE
ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of Oracle Support Services.
|
|
|
|
| Re: Error in creating database [message #267891 is a reply to message #267889] |
Sun, 16 September 2007 02:32 |
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
|
Senior Member |
 
|
|
ORA-03113: end-of-file on communication channel
Cause: The connection between Client and Server process was broken.
Action: There was a communication error that requires further
investigation. First, check for network problems and review the
SQL*Net setup. Also, look in the alert.log file for any errors.
Finally, test to see whether the server process is dead and whether
a trace file was generated at failure time. [Updated on: Sun, 16 September 2007 02:32] Report message to a moderator |
|
|
|
|
|
| Re: Error in creating database [message #267902 is a reply to message #267899] |
Sun, 16 September 2007 04:29 |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
Once i issue startup nomount the instance is getting started
SQL> startup nomount
ORACLE instance started.
Total System Global Area 2750386176 bytes
Fixed Size 1299656 bytes
Variable Size 1249975096 bytes
Database Buffers 1493172224 bytes
Redo Buffers 5939200 bytes
But i dont find any background process running ?
I find background process running for other databases but not for mine .
Audit files are getting generated for this instance but not trace files etc .
Let me know what went wrong ?
|
|
|
|
| ORA-00704: bootstrap process failure [message #267922 is a reply to message #267889] |
Sun, 16 September 2007 08:21 |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
I have installed 11g database in Unix machine .
After completing my installation I tried executing catalog.sql and catproc.sql but I faced this issue
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible
So I tried running standard.sql script to resolve the same
but I faced this error when i executed standard.sql
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","select
obj#,type#,ctime,mtim...","sql area","tmp")
So I thought of changing parameters in SGA as
log_buffer = 1048576
shared_pool_size = 80M
java_pool_size = 10048576
db_cache_size = 10M
workarea_size_policy = AUTO
pga_aggregate_target = 10M
in init.ora file . The I did shutdown by db and tried starting it .
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 140365824 bytes
Fixed Size 1295952 bytes
Variable Size 103090608 bytes
Database Buffers 33554432 bytes
Redo Buffers 2424832 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 13774
Session ID: 49 Serial number: 5
So I tried checking the alert.log file to resolve the same , but i was not able to understand what has to be done
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Error 704 happened during db open, shutting down database
USER (ospid: 15636): terminating the instance due to error 704
Instance terminated by USER, pid = 15636
Let me know what has to be done ?
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-00704: bootstrap process failure [message #268342 is a reply to message #267930] |
Tue, 18 September 2007 04:39 |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
Once we install ORACLE_HOME we get a prompt asking us to run root.sh script .
What does this root.sh script do ?
Once I completed Oracle home installation I tried connecting as sysdba to install the database but it didn't allow me to do so saying
ORA-01031: insufficient privileges
Will running root.sh resolve the same?
|
|
|
|
|
|
| Re: ORA-00704: bootstrap process failure [message #268354 is a reply to message #268344] |
Tue, 18 September 2007 05:26 |
rolex.mp
Messages: 161
Registered: February 2007
|
Senior Member |
|
|
I did open it and see but I was not able to understand much . I am new to shell scripting and Unix platform
I even googled out to check if i can find anything before I posted my query here.
These were the things I did .
I checked the SQLNET.AUTHENTICATION_SERVICES parameter and it is set to (NTS)
remote_login_passwordfile is set to NONE .
So i think the issue might be adding this user to the DBA group . I just want to know whether this will be done by root.sh script since I dont have permissions to run root.sh and in that case I need to get the permission to do so .
Also once we get the permission and consider now remote_login_passwordfile is set to EXCLUSIVE and SQLNET.AUTHENTICATION_SERVICES parameter is removed . I haven't created datbase yet and now
If we issue this command
sqlplus / as sysdba
will this work ? since password file authentication has been enabled now ?
I was just learning Oracle10g and 11g installation in Unix, so wanted to get a few things clarified which I was not clear searching in the net.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
