Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
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=
Received on Tue Jul 18 2006 - 20:49:31 CDT