Home » RDBMS Server » Server Administration » pls. help! Control file problem
pls. help! Control file problem [message #291583] Sat, 05 January 2008 03:02 Go to next message
gunsbong
Messages: 44
Registered: May 2007
Member
SQL> startup mount
ORACLE instance started.

Total System Global Area 8002732032 bytes
Fixed Size 2056632 bytes
Variable Size 838864456 bytes
Database Buffers 7147094016 bytes
Redo Buffers 14716928 bytes
ORA-00221: error on write to control file
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/u01/app/oradata/orcl/control01.ctl'
ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied
Additional information: 3


what possible way to recover from this problem...?

pls anyone...

Report message to a moderator

Re: pls. help! Control file problem [message #291585 is a reply to message #291583] Sat, 05 January 2008 03:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

ORA-27041: unable to open file
HPUX-ia64 Error: 13: Permission denied

I think the problem is clear: the user that try to start the instance (the owner of the "oracle" binary if your are on Unix and privileges are correctly set, the user that starts the service if you are on Windows) does not have the privilege to read the control file.
Either change user or the autorizations on the file.

Regards
Michel

[Updated on: Sat, 05 January 2008 03:07]

Report message to a moderator

Re: pls. help! Control file problem [message #291586 is a reply to message #291585] Sat, 05 January 2008 03:40 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
sir,

like what i PM...im using sysadmin account..

how do i recover the control file? or is it possible to fix this kind of problem?

thanks..

Report message to a moderator

Re: pls. help! Control file problem [message #291592 is a reply to message #291586] Sat, 05 January 2008 04:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you want to recover, for the moment and what you posted you just have to have the correct user or privileges.

Don't use a sysadmin user, use an Oracle admin one.

Regards
Michel

Report message to a moderator

Re: pls. help! Control file problem [message #291594 is a reply to message #291583] Sat, 05 January 2008 04:46 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
sir,

im using sysdba...but still... same message

sir, can you guide me in solving this problem?

thanks

Report message to a moderator

Re: pls. help! Control file problem [message #291610 is a reply to message #291594] Sat, 05 January 2008 07:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know your environment.
I already told you what to first check: owner/group/permissions for oracle binary and control file and all directories in their path.

Regards
Michel

Report message to a moderator

Re: pls. help! Control file problem [message #291690 is a reply to message #291610] Sun, 06 January 2008 00:30 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
sorry sir, but since im new to the oracle environment i could not locate the directory : owner/group/permissions from Oracle files...

from where can i find it?

thank's

Report message to a moderator

Re: pls. help! Control file problem [message #291695 is a reply to message #291690] Sun, 06 January 2008 00:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
owner/group/permissions is not a path it is a list I meant "owner, group, permissions", that is "ls -l".

Regards
Michel

[Updated on: Sun, 06 January 2008 00:44]

Report message to a moderator

Re: pls. help! Control file problem [message #291704 is a reply to message #291583] Sun, 06 January 2008 03:25 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
type
$ cd $ORACLE_HOME
$ ls -l

[Updated on: Sun, 06 January 2008 03:35]

Report message to a moderator

Re: pls. help! Control file problem [message #291707 is a reply to message #291704] Sun, 06 January 2008 03:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Your control files are corrupted most likely it is not a problem of privileges.

And what "Permission denied" means?

Quote:

alter database backup control file to trace;

If Oracle can't read the control file I wonder how it could execute this statement?

Regards
Michel

Report message to a moderator

Re: pls. help! Control file problem [message #291709 is a reply to message #291583] Sun, 06 January 2008 03:39 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
My mistake Michel..thats why i corrected it.

Report message to a moderator

Re: pls. help! Control file problem [message #291711 is a reply to message #291709] Sun, 06 January 2008 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68683
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put back your post as it was.
Don't erase the whole post it if you see a mistake, just add a comment to explain the error.

Regards
Michel

Report message to a moderator

Re: pls. help! Control file problem [message #291804 is a reply to message #291583] Sun, 06 January 2008 23:45 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member

Please give a little polish to your Unix administration fundamentals. If you can not handle Unix do not try to handle Oracle running on it.I am sorry and my sincere apologies for being rude, but it is the basic requirement that you understand the OS first than handle Oracle.

Your control files are intact,please do not try recreating them just resolve correct file permissions on it.

Regards

Report message to a moderator

Re: pls. help! Control file problem [message #291846 is a reply to message #291804] Mon, 07 January 2008 01:11 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
mkbhati

sir,

i accept your opinion that i should know first my OS.i have already done with permission issues right after sir michel guided me...

im currently checking my alert logs as the new error refers to it..

thanks

Report message to a moderator

Re: pls. help! Control file problem [message #291991 is a reply to message #291583] Mon, 07 January 2008 06:42 Go to previous message
gunsbong
Messages: 44
Registered: May 2007
Member
its done now...

thank you mr. michel for your support and guidance...

thank you mr.mkbhati for your effort and inspirational opinion...


Thanks a lot!

Report message to a moderator

Previous Topic: logminer and dictionary file from another database
Next Topic: Checkpoint types
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 16 05:54:19 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.