|
|
|
|
|
|
| Author |
Message |
Adley
*nix forums beginner
Joined: 26 May 2006
Posts: 5
|
 Posted: Tue Jul 18, 2006 7:25 am Post subject:
Insufficient Privileges / Oracle Not Available
|
|
|
Peace all,
I encountered something strange today.
Yesterday, due to some maintenance work, everything in the office must
be shutdown. Including the Oracle servers. Today, though, when I tried
to restart the instances, not one of them would start.
My Oracle is version 8.1.7 on AIX 4.3... it's a development machine..
one of the instances to be started is ELLTRN...
Scenario 1:
-----------------
ORACLESID=elltrn> sqlplus
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 18 14:35:46 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-01031: insufficient privileges
Scenario 2:
----------------
ORACLESID=elltrn> sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 18 14:36:19 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory
Scenario 3:
----------------
ORACLESID=elltrn> sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 18 14:37:29 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges
I'm using the user 'oracle' to do all the above. The primary group is
already 'dba' as can be seen below.
ORACLESID=elltrn> id
uid=203(oracle) gid=203(dba) groups=202(oinstall),204(mincomrt)
Do I need to somehow modify the init.ora file? Even though just
yesterday everything was fine? Or is there something else I need to do?
Thanks a lot,
=adley= |
|
| Back to top |
|
 |
Jeroen van den Broek
*nix forums beginner
Joined: 14 Jul 2005
Posts: 36
|
| Posted: Tue Jul 18, 2006 11:54 am Post subject:
Re: Insufficient Privileges / Oracle Not Available
|
|
|
Adley wrote:
| Quote: | Peace all,
I encountered something strange today.
Yesterday, due to some maintenance work, everything in the office must
be shutdown. Including the Oracle servers. Today, though, when I tried
to restart the instances, not one of them would start.
|
All your scenario's describe how you try to *connect* to Oracle, not
how you try to *start* it.
Your second step, after 'sqlplus /nolog', should be to startup the
instance via a command that is - surprisingly - called 'startup'.
--
Jeroen |
|
| Back to top |
|
|
EdStevens
*nix forums Guru Wannabe
Joined: 06 Sep 2005
Posts: 180
|
| Posted: Tue Jul 18, 2006 12:08 pm Post subject:
Re: Insufficient Privileges / Oracle Not Available
|
|
|
Jeroen van den Broek wrote:
| Quote: | Adley wrote:
Peace all,
I encountered something strange today.
Yesterday, due to some maintenance work, everything in the office must
be shutdown. Including the Oracle servers. Today, though, when I tried
to restart the instances, not one of them would start.
All your scenario's describe how you try to *connect* to Oracle, not
how you try to *start* it.
Your second step, after 'sqlplus /nolog', should be to startup the
instance via a command that is - surprisingly - called 'startup'.
--
Jeroen
|
If the problem were simply that the db hadn't been started, he would
have gotten this:
SQL> conn / as sysdba
Connected to an idle instance.
THEN he could simply issue the 'startup'. In the OP's case, something
else is going on, but I don't know what it is. Perhaps the value of
$ORACLE_SID isn't what he thinks it is? |
|
| Back to top |
|
|
jon.fife@gmail.com
*nix forums beginner
Joined: 07 Jun 2006
Posts: 8
|
| Posted: Tue Jul 18, 2006 1:08 pm Post subject:
Re: Insufficient Privileges / Oracle Not Available
|
|
|
Adley wrote:
| Quote: | SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory
|
I've had similar error messages when my ORACLE_HOME environment
variable had a trailing slash on it -- e.g. /opt/oracle/product/8.1.7/
instead of /opt/oracle/product/8.1.7
As for the other scenarios...is your OS user part of the dba group?
Jon |
|
| Back to top |
|
|
satish
*nix forums beginner
Joined: 18 Jul 2006
Posts: 1
|
| Posted: Tue Jul 18, 2006 5:33 pm Post subject:
Re: Insufficient Privileges / Oracle Not Available
|
|
|
Two of the reasons are
1)check ORACLE_HOME is pointing to correct location
2)check user who is going to connect database permessions etc
Jon Fife wrote:
| Quote: | Adley wrote:
SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory
I've had similar error messages when my ORACLE_HOME environment
variable had a trailing slash on it -- e.g. /opt/oracle/product/8.1.7/
instead of /opt/oracle/product/8.1.7
As for the other scenarios...is your OS user part of the dba group?
Jon |
|
|
| Back to top |
|
|
Joel Garry
*nix forums Guru
Joined: 24 Mar 2005
Posts: 1044
|
| Posted: Tue Jul 18, 2006 11:08 pm Post subject:
Re: Insufficient Privileges / Oracle Not Available
|
|
|
Adley wrote:
| Quote: | Peace all,
I encountered something strange today.
Yesterday, due to some maintenance work, everything in the office must
be shutdown. Including the Oracle servers. Today, though, when I tried
to restart the instances, not one of them would start.
My Oracle is version 8.1.7 on AIX 4.3... it's a development machine..
one of the instances to be started is ELLTRN...
Scenario 1:
-----------------
ORACLESID=elltrn> sqlplus
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 18 14:35:46 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter user-name: / as sysdba
ERROR:
ORA-01031: insufficient privileges
Scenario 2:
----------------
ORACLESID=elltrn> sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 18 14:36:19 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory
Scenario 3:
----------------
ORACLESID=elltrn> sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 18 14:37:29 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges
I'm using the user 'oracle' to do all the above. The primary group is
already 'dba' as can be seen below.
ORACLESID=elltrn> id
uid=203(oracle) gid=203(dba) groups=202(oinstall),204(mincomrt)
Do I need to somehow modify the init.ora file? Even though just
yesterday everything was fine? Or is there something else I need to do?
Thanks a lot,
=adley=
|
As the others have said, it is almost certainly a wrong ORACLE_HOME.
See if you have something like /etc/oraenv to perform. Things may be
setup differently by strange people, but you should have a file
/etc/oratab that says where all your ORACLE_HOMEs are. Also, see if
you perhaps have /usr/local/bin files to condition your environment.
See if your .profile for the oracle user has anything, I've seen people
put in new versions and leave old setups, especially on dev machines
since they're doing everything manually anyways.
Since you've perhaps used up some shared memory segments, see if the
ipcs command tells you anything - on some unix, starting up with a
bogus ORACLE_HOME will use up shared memory, so you have to use ipcrm
to free it. I can't recall if AIX/O8 does it that way, or whether it
leaves bogus memory mapping files around that you have to remove.
jg
--
@home.com is bogus.
http://www.winternals.com/Faq.aspx |
|
| Back to top |
|
|
Adley
*nix forums beginner
Joined: 26 May 2006
Posts: 5
|
| Posted: Wed Jul 19, 2006 1:49 am Post subject:
Re: Insufficient Privileges / Oracle Not Available
|
|
|
Peace EdStevens,
The SID should be ELLTST. I've confirmed it with my senior, and it was
ELLTST until before this happens.
Peace Jeroen,
I'm sorry if I'm not making myself clear enough. Yes, I wanted to
startup by issuing "startup" command to an idle instance. The problem
is, I couldn't even use SYS AS SYSDBA to connect due to insufficient
privilege, much less starting the instance up. :D
Peace Jon Fife,
I am using the user 'oracle' and I don't see any problem with this user
as the primary group is already 'dba' as can be seen below:
ORACLESID=elltst> id
uid=203(oracle) gid=203(dba) groups=202(oinstall),204(mincomrt)
ORACLESID=elltst> env | grep ORACLE
ORACLE_SID=elltst
PS1=ORACLESID=$ORACLE_SID>
ORACLE_HOME=/usr/oracle/product/8.1.7
ORACLESID=elltst> cat /etc/oratab | grep elltst
elltst:/usr/oracle/product/8.1.7:Y
No trailing "/" either on the ORACLE_HOME. :D
Peace JG,
This is my oratab file:
elltst:/usr/oracle/product/8.1.7:Y
ellacme:/usr/oracle/product/8.1.7:Y
*:/usr/oracle/product/8.1.7:N
ellgpd:/usr/oracle/product/8.1.7:N
ellip:/usr/oracle/product/8.1.7:N
ellmig:/usr/oracle/product/8.1.7:Y
elltrn:/usr/oracle/product/8.1.7:N
ellnew:/usr/oracle/product/8.1.7:N
elldev:/usr/oracle/product/8.1.7:N
ellptba:/usr/oracle/product/8.1.7:N
elltry:/usr/oracle/product/8.1.7:N
I might try rebooting the machine and see if that helps. But I have to
wait until tonight.
Regarding ipcs, this is what I got:
IPC status from /dev/mem as of Wed Jul 19 09:05:46 WIB 2006
T ID KEY MODE OWNER GROUP
Message Queues:
q 2097152 0x4107001c -Rrw-rw---- root printq
q 2 0x0b033801 -Rrw-rw-rw- root system
Shared Memory:
m 786432 0x58002097 --rw-rw-rw- root system
m 1 0x470010ca --rw-r--r-- imnadm imnadm
m 2 0x580010ca --rw-r--r-- imnadm imnadm
m 3 0x4d0010ca --rw-r--r-- imnadm imnadm
m 4 0x490010ca --rw-r--r-- imnadm imnadm
m 5 0x500010ca --rw-r--r-- imnadm imnadm
m 6 0x450010d0 --rw-rw-rw- imnadm imnadm
m 7 0x430010d0 --rw-rw-rw- imnadm imnadm
m 8 0x420010d0 --rw-rw-rw- imnadm imnadm
m 9 0x410010d0 --rw-rw-rw- imnadm imnadm
m 10 0x440010d0 --rw-rw-rw- imnadm imnadm
m 11 0x435dce60 --rw-rw-rw- root system
m 12 0x0d002a4a --rw-rw-rw- root system
m 131086 0x15033801 --rw-rw-rw- root system
m 131087 0x20033801 --rw-rw-rw- root system
m 131088 0x16033801 --rw-rw-rw- root system
m 131092 0x741cc1a0 --rw-rw-rw- root system
m 21 0x741cc1a1 --rw-rw-rw- root system
m 22 0x741cc1a2 --rw-rw-rw- root system
m 23 0x741cc1a3 --rw-rw-rw- root system
Semaphores:
s 1048576 0x58002097 --ra-ra-ra- root system
s 786433 0x44002097 --ra-ra-ra- root system
s 131074 00000000 --ra-ra-ra- imnadm imnadm
s 3 0x6200281c --ra-r--r-- root system
s 4 00000000 --ra-ra-ra- imnadm imnadm
s 5 00000000 --ra-ra-ra- imnadm imnadm
s 6 00000000 --ra-ra-ra- imnadm imnadm
s 7 00000000 --ra-ra-ra- imnadm imnadm
s 8 00000000 --ra-ra-ra- imnadm imnadm
s 9 00000000 --ra-ra-ra- imnadm imnadm
s 10 0x450010d0 --ra-ra-ra- imnadm imnadm
s 11 00000000 --ra-ra-ra- imnadm imnadm
s 12 00000000 --ra-ra-ra- imnadm imnadm
s 13 0x01002885 --ra------- root system
s 393231 0x0101c6e8 --ra-ra-ra- root system
I'm not sure what to look here. Do you see any problems?
Thanks alot to you all,
=adley= |
|
| Back to top |
|
|
gazzag
*nix forums Guru Wannabe
Joined: 08 Jun 2005
Posts: 277
|
| Posted: Wed Jul 19, 2006 9:15 am Post subject:
Re: Insufficient Privileges / Oracle Not Available
|
|
|
Adley wrote:
| Quote: | ORACLESID=elltst> env | grep ORACLE
ORACLE_SID=elltst
PS1=ORACLESID=$ORACLE_SID
ORACLE_HOME=/usr/oracle/product/8.1.7
ORACLESID=elltst> cat /etc/oratab | grep elltst
elltst:/usr/oracle/product/8.1.7:Y
No trailing "/" either on the ORACLE_HOME. :D
|
What does the following command show?
ls -l ${ORACLE_HOME}
HTH
-g |
|
| Back to top |
|
|
Rauf Sarwar
*nix forums Guru
Joined: 03 May 2005
Posts: 353
|
| Posted: Wed Jul 19, 2006 2:27 pm Post subject:
Re: Insufficient Privileges / Oracle Not Available
|
|
|
Adley wrote:
| Quote: | Peace EdStevens,
The SID should be ELLTST. I've confirmed it with my senior, and it was
ELLTST until before this happens.
Peace Jeroen,
I'm sorry if I'm not making myself clear enough. Yes, I wanted to
startup by issuing "startup" command to an idle instance. The problem
is, I couldn't even use SYS AS SYSDBA to connect due to insufficient
privilege, much less starting the instance up. :D
Peace Jon Fife,
I am using the user 'oracle' and I don't see any problem with this user
as the primary group is already 'dba' as can be seen below:
ORACLESID=elltst> id
uid=203(oracle) gid=203(dba) groups=202(oinstall),204(mincomrt)
ORACLESID=elltst> env | grep ORACLE
ORACLE_SID=elltst
PS1=ORACLESID=$ORACLE_SID
ORACLE_HOME=/usr/oracle/product/8.1.7
ORACLESID=elltst> cat /etc/oratab | grep elltst
elltst:/usr/oracle/product/8.1.7:Y
No trailing "/" either on the ORACLE_HOME. :D
Peace JG,
This is my oratab file:
elltst:/usr/oracle/product/8.1.7:Y
ellacme:/usr/oracle/product/8.1.7:Y
*:/usr/oracle/product/8.1.7:N
ellgpd:/usr/oracle/product/8.1.7:N
ellip:/usr/oracle/product/8.1.7:N
ellmig:/usr/oracle/product/8.1.7:Y
elltrn:/usr/oracle/product/8.1.7:N
ellnew:/usr/oracle/product/8.1.7:N
elldev:/usr/oracle/product/8.1.7:N
ellptba:/usr/oracle/product/8.1.7:N
elltry:/usr/oracle/product/8.1.7:N
I might try rebooting the machine and see if that helps. But I have to
wait until tonight.
Regarding ipcs, this is what I got:
IPC status from /dev/mem as of Wed Jul 19 09:05:46 WIB 2006
T ID KEY MODE OWNER GROUP
Message Queues:
q 2097152 0x4107001c -Rrw-rw---- root printq
q 2 0x0b033801 -Rrw-rw-rw- root system
Shared Memory:
m 786432 0x58002097 --rw-rw-rw- root system
m 1 0x470010ca --rw-r--r-- imnadm imnadm
m 2 0x580010ca --rw-r--r-- imnadm imnadm
m 3 0x4d0010ca --rw-r--r-- imnadm imnadm
m 4 0x490010ca --rw-r--r-- imnadm imnadm
m 5 0x500010ca --rw-r--r-- imnadm imnadm
m 6 0x450010d0 --rw-rw-rw- imnadm imnadm
m 7 0x430010d0 --rw-rw-rw- imnadm imnadm
m 8 0x420010d0 --rw-rw-rw- imnadm imnadm
m 9 0x410010d0 --rw-rw-rw- imnadm imnadm
m 10 0x440010d0 --rw-rw-rw- imnadm imnadm
m 11 0x435dce60 --rw-rw-rw- root system
m 12 0x0d002a4a --rw-rw-rw- root system
m 131086 0x15033801 --rw-rw-rw- root system
m 131087 0x20033801 --rw-rw-rw- root system
m 131088 0x16033801 --rw-rw-rw- root system
m 131092 0x741cc1a0 --rw-rw-rw- root system
m 21 0x741cc1a1 --rw-rw-rw- root system
m 22 0x741cc1a2 --rw-rw-rw- root system
m 23 0x741cc1a3 --rw-rw-rw- root system
Semaphores:
s 1048576 0x58002097 --ra-ra-ra- root system
s 786433 0x44002097 --ra-ra-ra- root system
s 131074 00000000 --ra-ra-ra- imnadm imnadm
s 3 0x6200281c --ra-r--r-- root system
s 4 00000000 --ra-ra-ra- imnadm imnadm
s 5 00000000 --ra-ra-ra- imnadm imnadm
s 6 00000000 --ra-ra-ra- imnadm imnadm
s 7 00000000 --ra-ra-ra- imnadm imnadm
s 8 00000000 --ra-ra-ra- imnadm imnadm
s 9 00000000 --ra-ra-ra- imnadm imnadm
s 10 0x450010d0 --ra-ra-ra- imnadm imnadm
s 11 00000000 --ra-ra-ra- imnadm imnadm
s 12 00000000 --ra-ra-ra- imnadm imnadm
s 13 0x01002885 --ra------- root system
s 393231 0x0101c6e8 --ra-ra-ra- root system
I'm not sure what to look here. Do you see any problems?
Thanks alot to you all,
=adley=
|
What is this maintenance work that you mentioned? Did it involve this
AIX server and if so, what was it?
Regards
/Rauf |
|
| Back to top |
|
|
Joel Garry
*nix forums Guru
Joined: 24 Mar 2005
Posts: 1044
|
| Posted: Wed Jul 19, 2006 6:46 pm Post subject:
Re: Insufficient Privileges / Oracle Not Available
|
|
|
Adley wrote:
| Quote: | Peace EdStevens,
The SID should be ELLTST. I've confirmed it with my senior, and it was
ELLTST until before this happens.
Peace Jeroen,
I'm sorry if I'm not making myself clear enough. Yes, I wanted to
startup by issuing "startup" command to an idle instance. The problem
is, I couldn't even use SYS AS SYSDBA to connect due to insufficient
privilege, much less starting the instance up. :D
Peace Jon Fife,
I am using the user 'oracle' and I don't see any problem with this user
as the primary group is already 'dba' as can be seen below:
ORACLESID=elltst> id
uid=203(oracle) gid=203(dba) groups=202(oinstall),204(mincomrt)
ORACLESID=elltst> env | grep ORACLE
ORACLE_SID=elltst
PS1=ORACLESID=$ORACLE_SID
ORACLE_HOME=/usr/oracle/product/8.1.7
ORACLESID=elltst> cat /etc/oratab | grep elltst
elltst:/usr/oracle/product/8.1.7:Y
No trailing "/" either on the ORACLE_HOME. :D
Peace JG,
This is my oratab file:
elltst:/usr/oracle/product/8.1.7:Y
ellacme:/usr/oracle/product/8.1.7:Y
*:/usr/oracle/product/8.1.7:N
ellgpd:/usr/oracle/product/8.1.7:N
ellip:/usr/oracle/product/8.1.7:N
ellmig:/usr/oracle/product/8.1.7:Y
elltrn:/usr/oracle/product/8.1.7:N
ellnew:/usr/oracle/product/8.1.7:N
elldev:/usr/oracle/product/8.1.7:N
ellptba:/usr/oracle/product/8.1.7:N
elltry:/usr/oracle/product/8.1.7:N
I might try rebooting the machine and see if that helps. But I have to
wait until tonight.
Regarding ipcs, this is what I got:
IPC status from /dev/mem as of Wed Jul 19 09:05:46 WIB 2006
T ID KEY MODE OWNER GROUP
Message Queues:
q 2097152 0x4107001c -Rrw-rw---- root printq
q 2 0x0b033801 -Rrw-rw-rw- root system
Shared Memory:
m 786432 0x58002097 --rw-rw-rw- root system
m 1 0x470010ca --rw-r--r-- imnadm imnadm
m 2 0x580010ca --rw-r--r-- imnadm imnadm
m 3 0x4d0010ca --rw-r--r-- imnadm imnadm
m 4 0x490010ca --rw-r--r-- imnadm imnadm
m 5 0x500010ca --rw-r--r-- imnadm imnadm
m 6 0x450010d0 --rw-rw-rw- imnadm imnadm
m 7 0x430010d0 --rw-rw-rw- imnadm imnadm
m 8 0x420010d0 --rw-rw-rw- imnadm imnadm
m 9 0x410010d0 --rw-rw-rw- imnadm imnadm
m 10 0x440010d0 --rw-rw-rw- imnadm imnadm
m 11 0x435dce60 --rw-rw-rw- root system
m 12 0x0d002a4a --rw-rw-rw- root system
m 131086 0x15033801 --rw-rw-rw- root system
m 131087 0x20033801 --rw-rw-rw- root system
m 131088 0x16033801 --rw-rw-rw- root system
m 131092 0x741cc1a0 --rw-rw-rw- root system
m 21 0x741cc1a1 --rw-rw-rw- root system
m 22 0x741cc1a2 --rw-rw-rw- root system
m 23 0x741cc1a3 --rw-rw-rw- root system
Semaphores:
s 1048576 0x58002097 --ra-ra-ra- root system
s 786433 0x44002097 --ra-ra-ra- root system
s 131074 00000000 --ra-ra-ra- imnadm imnadm
s 3 0x6200281c --ra-r--r-- root system
s 4 00000000 --ra-ra-ra- imnadm imnadm
s 5 00000000 --ra-ra-ra- imnadm imnadm
s 6 00000000 --ra-ra-ra- imnadm imnadm
s 7 00000000 --ra-ra-ra- imnadm imnadm
s 8 00000000 --ra-ra-ra- imnadm imnadm
s 9 00000000 --ra-ra-ra- imnadm imnadm
s 10 0x450010d0 --ra-ra-ra- imnadm imnadm
s 11 00000000 --ra-ra-ra- imnadm imnadm
s 12 00000000 --ra-ra-ra- imnadm imnadm
s 13 0x01002885 --ra------- root system
s 393231 0x0101c6e8 --ra-ra-ra- root system
I'm not sure what to look here. Do you see any problems?
|
What we'd be looking for is something owned by oracle. In general,
there would be one semaphore and one message area per instance
(although that can be changed and also varies by platform and
configuration). On some unix platforms, if you crash an instance these
areas can remain in use, not letting you get new ones to bring an
instance up. It is also possible to have two instances hash to the
same ID, giving the same sort of realm error as you got. It is also
possible (but bizzarro, and probably nothing to do with your situation)
to have ownership issues by changing oracle ownership or the executable
protection while the instance is up.
Are you sure you didn't change unix kernel configurations when you did
the "AIX maintenance?" If you changed the shared memory settings, that
could give your symptoms. There just mightn't be enough shared memory
for oracle to start. Doublecheck your install guide and
https://metalink.oracle.com/metalink/plsql/f?p=130:3:4291818653361394759::::p3_database_id,p3_docid,p3_show_header,p3_show_help,p3_black_frame,p3_font:NOT,169706.1,1,1,1,helvetica#AIX
(on other unix there are specific manual kernel settings, on AIX I
believe it is implicit in the patching - are you getting any coredumps
or other symptoms?).
On a more ridiculous note, I've seen admins mess up the groups, so the
oracle dba group is another number than the one everything is installed
under...
jg
--
@home.com is bogus.
http://home.pacific.net.au/~turner23/2002/hippy-peace.jpg |
|
| Back to top |
|
|
Adley
*nix forums beginner
Joined: 26 May 2006
Posts: 5
|
| Posted: Fri Jul 21, 2006 4:15 am Post subject:
Re: Insufficient Privileges / Oracle Not Available
|
|
|
Peace all,
Sorry for the late reply.
The good news is that the problem has been solved.
I am not completely sure how I did it, but after getting frustrated I
ask the maintenance guy whether I can shut down the machine and
rebooted it.
The maintenance work was doing a complete machine backup, almost all
contents from the hard disks are transfered to tape.
After I reboot the machine, the problem still persisted. I reboot it
again.
Now, after a while, I began to just searching for ownerships and
permissions, etc. All to no avail.
The only thing I remember before everything went well was I edited the
sqlnet.ora file (comment out the authentication_services line).
Stop-start the listener, make sure tnsping works, and after that, SYS
AS SYSDBA can then connect to the idle instance.
I issued "startup" and thank God it started up without problems.
Well, I honestly don't understand how things turned out well.
But at least my work has become less today, the only problem that still
remains is the CICS region that still problematic.
But that's another story.
Thanks all,
=adley= |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Sun Nov 23, 2008 2:47 pm | All times are GMT
|
|
Credit Cards | Debt | 0 Credit Cards | eBay | Free Advertising
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Server
