Re: New Oracle 9i installation

Exactly. This is supposed to be an instance configuration file and Oracle reads all initialization parameters from it. $ORACLE_HOME/dbs is the directory where the init<SID>.ora file should be (on *ixes this is usually a symlink to actual file though). <SID> == $ORACLE_SID set in the environment when you are starting the instance. I guess it is O901DB in your case. Seems that the file isn't there. There also is init.ora sample file in that directory - try looking at it. Copy it to initO901DB.ora and modify some parameters like db_name, instance_name, service_names and others (*_dest in particular should point to existing directories) to match your intended Oracle configuration. Then try bringing instance online again.

And just so you know, ORA-03113s are usually attributed to core dumps. :) So if you are connected locally and there is no possibility of network failures, you can be sure that 3113 is resulted by core dump (you can see that in your own alert file).

One more thing: make sure that this file has 640 or 600 permissions and chown it to the user under which Oracle starts so that only Oracle itself can read and modify this file (of course, root will be able to override).

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Morten" <solbjerg@.post.opasia.dk> wrote in message
news:3c03be9e$0$251$edfadb0f_at_dspool01.news.tele.dk...


> Hi!

>

> Thanks for the reply. After having read a few documents scattered around

> various news groups and on otn.oracle.com I tried to change the "processes"

> parameter in init.ora. That seems to have gotten rid of the ORA-03113 error.

>

> However now when I use the startup command in sqlplus I get the following:

>

> ORA-24324: service handle not initialized

> ORA-01041: internal error. hostdef extension doesn't exist

>

> If I look in the log file "alert_0901DB.log" (I'm not sure if this is the

> right file to look in...) I see the following:

>

> Tue Nov 27 16:40:42 2001

> Errors in file /u01/app/oracle/product/9.0.1/rdbms/log/ora_5442.trc:

> ORA-07445: exception encountered: core dump [strcpy()+64] [SIGSEGV]

> [Address not mapped to object] [0x0] [] []

> ORA-07445: exception encountered: core dump [strcpy()+64] [SIGSEGV]

> [Address not mapped to object] [0x0] [] []

> ORA-07445: exception encountered: core dump [lrmtrm()+43] [SIGSEGV]

> [Address not mapped to object] [0x40585050] [] []

> ORA-01078: failure in processing system parameters

> LRM-00109: could not open parameter file

> '/u01/app/oracle/product/9.0.1/dbs/initO901DB.ora'

>

> I'm absolutely without clues so any help is really appreciated.

>

> Thanks in advance.

>

> Morten

>

> PS: The file '/u01/app/oracle/product/9.0.1/dbs/initO901DB.ora' didn't

> exist so I tried to create it and change permissions to 777 but it didn't

> change anything. I guess Oracle expects to be able to read something from

> this file?

>

> Stephan Bressler wrote:

>

> > Hi,

> >

> > seems that the shadow process crashed. Maybe some of the directories

> > (user_dump_dest, etc) in init.ora doesn't exist or exist with wrong

> > permissions.

> >

> > Have a look at messages in the alert file.

> >

> > Regards

> > Stephan

> >

> >

> > "Morten" <solbjerg@.post.opasia.dk> schrieb im Newsbeitrag

> > news:3c02b4f2$0$25409$edfadb0f_at_dspool01.news.tele.dk...

> >> Hi!

> >>

> >> I've just installed an Oracle 9i database server on my RedHat 7.2 system.

> >> The installation went well. However if I try to follow the post

> >> installation instructions from the Oracle web sites I get an error.

> >>

> >> I've done the following as Oracle user:

> >>

> >> sqlplus /nolog

> >> connect SYS/password AS SYSDBA

> >>

> >> response: "Connected to an idle instance."

> >>

> >> startup

> >>

> >> response: "ORA-03113: end-of-file on communication channel"

> >>

> >> Now what? Can anybody help me out here?

> >>

> >> Thanks very much in advance.

> >>

> >> Morten

> >>

>