the ORA-01031 error is the common error about the password file.
when you select CREATE DATABASE ...
the Oracle Installer create a file like createSID.sh that call
other shells scripts....
the first of this scripts try to run "svrmgrl" with the params
"connect internal" and (intentionally) without password, because
the password is in the another file.
This is the cause for the message "Not logged on"
and this cause the insufficient privileges for create the
datafiles for oracle.
You need to see, too, the OS privileges like 755 or 644 (minimal) on
datafile's creation dirs
and on the tnsnames.ora file.
You can search in http://metalink.oracle.com with the ORA-01031 error.
Too, check this:
0) sqlnet.ora PATH search order :
or (depending of your OS type)
1) sqlnet.ora , will have
SQLNET.AUTHENTICATION_SERVICES = (BEQ,NONE)
AUTOMATIC_IPC = OFF
( the BEQ,NONE is for search the password in another file,
and if you set AUTOMATIC_IPC = ON then are forcing to setting
on environment the variable TWO_TASK.
2) like ROOT :
check the privileges on :
with this :
chmod 644 sqlnet.ora tnsnames.ora listener.ora
ls -l sqlnet.ora tnsnames.ora listener.ora
and thas all!
this will be go on...
Jorge Acevedo Flores
Santiago de Chile
> Hi there
> Abit of a newbie to this. Got a Sun Solaris Box today and tried to set up
> an Oracle server and database with that java configuration assistant for
> Oracle. Well got the following continual errors:
> ORA-01012 : Not logged on
> ORA-01031 : Insufficient privileges
> ORA-27101 : Shared memory realm does not exist
> Well I have since read that I should have set up raw devices in the solaris
> /dev directory (remember im new to this), because installing Oracle 8.1.7
> installation assistant requires them. All I knew was that I had this Oracle
> Enterprise Manager 8.1.7 disk and I wanted to install it. :) Abit naive yeh
> :) Ok, I just need to know how to set up raw devices/partitions in that
> /dev directory on solaris 8. Cant find any information anywhere concerning
> the specific commands to do it. Again a newbie :) Anyone help plz?
> Cheers & thanks in advance