Home » RDBMS Server » Server Administration » Error in creating database (merged)
Error in creating database (merged) [message #267889] Sun, 16 September 2007 02:26 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #267899 is a reply to message #267889] Sun, 16 September 2007 03:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at your alert.log file.

Regards
Michel
Re: Error in creating database [message #267902 is a reply to message #267899] Sun, 16 September 2007 04:29 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #267924 is a reply to message #267922] Sun, 16 September 2007 08:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-39700: database must be opened with UPGRADE option
 *Cause:  A normal database open was attempted, but the database has not
          been upgraded to the current server version.
 *Action: Use the UPGRADE option when opening the database to run
          catupgrd.sql (for database upgrade), or to run catalog.sql
          and catproc.sql (after initial database creation)

=> "startup upgrade/migrate" or whatever is the option in your version.

Regards
Michel
Re: Error in creating database (merged) [message #267926 is a reply to message #267889] Sun, 16 September 2007 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please post your topics in the appropriate forum.
Creating database questions are Server Administration ones and not SQL or PL/SQL ones.

Regards
Michel
Re: ORA-00704: bootstrap process failure [message #267929 is a reply to message #267924] Sun, 16 September 2007 09:41 Go to previous messageGo to next message
rolex.mp
Messages: 161
Registered: February 2007
Senior Member
The database created is a fresh DB and as you said I started the db in upgrade mode but still I am facing the same issues again .

Should I do any other changes?
Re: ORA-00704: bootstrap process failure [message #267930 is a reply to message #267929] Sun, 16 September 2007 09:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop all, restart from scratch using dbca.

Regards
Michel
Re: ORA-00704: bootstrap process failure [message #268342 is a reply to message #267930] Tue, 18 September 2007 04:39 Go to previous messageGo to next message
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 #268344 is a reply to message #268342] Tue, 18 September 2007 04:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What does this root.sh script do ?

You have to either:
- cat root.sh
- don't care

Quote:
I tried connecting as sysdba to install the database but it didn't allow me to do so saying

ORA-01031: insufficient privileges

Getting ORA-1031 when trying to connect as SYSDBA is one of most asked questions. Don't you find a solution in the numerious topics talking about this here, in Google and everywhere?

Regards
Michel
Re: ORA-00704: bootstrap process failure [message #268354 is a reply to message #268344] Tue, 18 September 2007 05:26 Go to previous messageGo to next message
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.
Re: ORA-00704: bootstrap process failure [message #268363 is a reply to message #268354] Tue, 18 September 2007 06:06 Go to previous message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to execute root.sh with root.
This is mandatory.
Stop.

You have to be in the osdba group (usually "dba") to create a database.
Stop.

Regards
Michel
Previous Topic: DBCA does not show made template
Next Topic: Problem with User getting locked on database startup
Goto Forum:
  


Current Time: Fri Dec 02 16:52:53 CST 2016

Total time taken to generate the page: 0.11367 seconds