Home » RDBMS Server » Server Administration » problem during creation of database
problem during creation of database [message #55791] Mon, 17 February 2003 02:45 Go to next message
anirban roy
Messages: 2
Registered: February 2003
Junior Member
Hi,
i am using oracle8i in p4 windows2000 profesional
I just wish to explain my problem..
though i think its a version of old problem of
ora-03113 end of communication channel..but it
comes to me whenever i try to create new database
..else it runs well
my oracle is in d:oracle
but my database is at c:labdb
with pfile in c:pfileinitlabdb.ora
i created the service using oradim utility
then i set oracle_sid using command line
then i login to sql*plus
and as sysdba then i shutdown the earlier instance of database
and
try to mount my new instance in nomount mode
it gives end of communication channel
i need help to solve this problem
though its a variant of ora-03113
but i dont undderstand the exact problem in my case
Anirban
Re: problem during creation of database [message #55797 is a reply to message #55791] Mon, 17 February 2003 07:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
shutdown database 1 cleanly first.
now
set ur new ORACLE_SID.
login to svrmgrl
startup nomount pfile=newpfile.ora...
create the database.
and i case of errors post the complete exact error
Re: problem during creation of database [message #55800 is a reply to message #55797] Mon, 17 February 2003 10:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
make sure u have ORACLE_HOME in PATH.
or do all these operations in $ORACLE_HOMEbin
Re: problem during creation of database [message #55802 is a reply to message #55797] Mon, 17 February 2003 11:23 Go to previous message
anirban roy
Messages: 2
Registered: February 2003
Junior Member
Hi Mahesh,
Thanks for your reply again..
I have tried this just now..
but problem persists till now and its same
i am trying with this for last 4 hours ..still without solution
waiting for any possible reply from you..
and this ora-03113 error ..i am unable to understand what makes background process ending or whats it?
Regards
Anirban
Previous Topic: Enterprise manager/instance manager question
Next Topic: Printing through W2K D2K Client
Goto Forum:
  


Current Time: Fri Sep 20 05:28:14 CDT 2024