Home » RDBMS Server » Server Administration » very confusing situation (XE Oracle Db)
very confusing situation [message #364386] Mon, 08 December 2008 04:22 Go to next message
meisam
Messages: 14
Registered: August 2008
Location: malaysia
Junior Member
Hi everybody.

I read a lot about pfile, spfile and init.ora but im still confused, I have an XE oracle Database, which I am trying to connect to it using sqlplus* but im getting this funny ORA-27037 each time i run the startup coommand.

here is what i have in my folders:

in here : /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs
I have these: hc_XE.dat, init.ora, lkXE, orapwXE, spfileXE.ora

I dun have pfile or somethign like that. I really need kind of serious help from the scratch. please help me out.

Thank you
Re: very confusing situation [message #364388 is a reply to message #364386] Mon, 08 December 2008 04:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-27037: unable to obtain file status
 *Cause:  stat system call returned an error, additional information
          indicates which function encountered the error
 *Action: check errno

What is the relation with pfile, spfile, init.ora?

Use SQL*Plus and copy and paste your session.

Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and use code tags.
Use the "Preview Message" button to verify.

Regards
Michel
Re: very confusing situation [message #364393 is a reply to message #364388] Mon, 08 December 2008 04:41 Go to previous messageGo to next message
meisam
Messages: 14
Registered: August 2008
Location: malaysia
Junior Member
I am sorry my mistake: I am getting this:

ORA-01078

regards
Re: very confusing situation [message #364396 is a reply to message #364393] Mon, 08 December 2008 04:56 Go to previous messageGo to next message
meisam
Messages: 14
Registered: August 2008
Location: malaysia
Junior Member
im getting this error

------------------
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initHR.ora'
-------------------
Re: very confusing situation [message #364399 is a reply to message #364396] Mon, 08 December 2008 05:10 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand in the message?

Also read forum guide and format your post.

Regards
Michel
Previous Topic: Oracle 10G schema
Next Topic: Problem starting the Oracle Sid service
Goto Forum:
  


Current Time: Sat Dec 10 05:30:10 CST 2016

Total time taken to generate the page: 0.09955 seconds