OraFAQ Forum: Server Administration » DIFFERENCE BETWEEN LRM AND ORA ERROR(2 Merged)

Home » RDBMS Server » Server Administration » DIFFERENCE BETWEEN LRM AND ORA ERROR(2 Merged) (10.1.0, 10G,WINDOWS XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DIFFERENCE BETWEEN LRM AND ORA ERROR(2 Merged) [message #513327]

Sun, 26 June 2011 20:51

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

WHAT IS THE DIFFERENCE BETWEEN ORA ERROR AND LRM ERROR???

Report message to a moderator

DIFF BETWEEN LRM AND ORA EROR. [message #513328 is a reply to message #513327]

Sun, 26 June 2011 20:53

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

WHAT IS THE DIFFERENCE BETWEEN ORA ERROR AND LRM ERROR???

Report message to a moderator

Re: DIFFERENCE BETWEEN LRM AND ORA ERROR [message #513329 is a reply to message #513327]

Sun, 26 June 2011 20:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
ERROR? What Error? I don't see any error.

Report message to a moderator

Re: DIFFERENCE BETWEEN LRM AND ORA ERROR [message #513330 is a reply to message #513329]

Sun, 26 June 2011 20:59

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

PLEASE DONT MIND BUT WHY YOU ALWAYS TELL ME TO FOLLOW THE POSTING GUIDELINE.....??? I HAVE READ IT 3 TIMES.

ONLY I JUST WANTED TO KNOW WHAT IS MEANT BY ORA AND LRM AND THE NUMBER WRITTEN IN FRONT OF THEM?
EG. ORA-00107:

Report message to a moderator

Re: DIFFERENCE BETWEEN LRM AND ORA ERROR [message #513332 is a reply to message #513330]

Sun, 26 June 2011 21:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.lmgtfy.com/?q=Oracle+LRM+facility

I am sorry to see that GOOGLE is broken for you.

Report message to a moderator

Re: DIFFERENCE BETWEEN LRM AND ORA ERROR [message #513339 is a reply to message #513330]

Sun, 26 June 2011 22:24

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

abhisheksolankicse12 wrote on Mon, 27 June 2011 07:29

PLEASE DONT MIND BUT WHY YOU ALWAYS TELL ME TO FOLLOW THE POSTING GUIDELINE.....??? I HAVE READ IT 3 TIMES.

ONLY I JUST WANTED TO KNOW WHAT IS MEANT BY ORA AND LRM AND THE NUMBER WRITTEN IN FRONT OF THEM?
EG. ORA-00107:

point no# 6 Do not post in all capitals

Report message to a moderator

Re: DIFFERENCE BETWEEN LRM AND ORA ERROR [message #513341 is a reply to message #513339]

Sun, 26 June 2011 22:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://download.oracle.com/docs/cd/B10501_01/server.920/a96525/lrmus.htm

Report message to a moderator

Re: DIFFERENCE BETWEEN LRM AND ORA ERROR [message #513342 is a reply to message #513341]

Sun, 26 June 2011 22:41

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

ORA-Oracle Database Server Messages
LRM-Core Library Messages
http://download.oracle.com/docs/cd/B10501_01/server.920/a96525/oracore_.htm
http://download.oracle.com/docs/cd/B19306_01/server.102/b14219/lrmus.htm#sthref13297

[Updated on: Sun, 26 June 2011 22:42]

Report message to a moderator

Re: DIFFERENCE BETWEEN LRM AND ORA ERROR [message #513744 is a reply to message #513342]

Wed, 29 June 2011 04:17

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

thanx buddies.....
i am highly obliged....
but what to do if i am not able to startup my database????
as and when i try to do this i get following...
SQL*Plus: Release 10.1.0.2.0 - Production on Mon Jun 27 22:15:55 2011

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to an idle instance.

SQL> connect / as sysdba;
Connected to an idle instance.
SQL> startup pfile='C:\Documents and Settings\Administrator\Desktop\init.ora';
LRM-00109: could not open parameter file 'C:\Documents and Settings\Administrator\Desk
ORA-01078: failure in processing system parameters
SQL> startup pflie='F:\oracle\product\10.1.0\admin\orcl1\pfile\init525201118246.ora';
SP2-0714: invalid combination of STARTUP options
SQL> create spfile form pfile;
create spfile form pfile
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

SQL> create spfile='F:\oracle\product\10.1.0\admin\orcl1\spfile\abhishek.ora'
2 from pfile='F:\oracle\product\10.1.0\admin\orcl1\pfile\init525201118246.ora';
create spfile='F:\oracle\product\10.1.0\admin\orcl1\spfile\abhishek.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'F:\ORACLE\PRODUCT\10.1.0\ADMIN\ORCL1\PFILE\INIT525201118246.ORA'

SQL>

Report message to a moderator

Re: DIFFERENCE BETWEEN LRM AND ORA ERROR [message #513746 is a reply to message #513744]

Wed, 29 June 2011 04:22

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ You cannot have a space inside the path
2/ You have to name a file that exists
3/ You have to give a file that you and Oracle can access
4/ You have to write a valid statement

Regards
Michel

Report message to a moderator

Previous Topic:	creating spfile from pfile error
Next Topic:	Database Server Startup/Shutdown

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 23:09:37 CDT 2024