| ORA-24323 Value not allowed [message #50274] |
Fri, 08 March 2002 04:32  |
James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)
|
Member |
|
|
I'm creating a new database called play. Before running the create database command i've been trying to run the command "startup nomount pfile=/u01/app/oracle/admin/play/pfile/initplay.ora;" but this keeps failing with ORA-24323 Value not allowed followed by ORA-01031: insufficient privileges. I've checked the contents of the initplay.ora file and all is ok (anyway these errors still occur if initplay.ora is empty).
I've done ORACLE_SID=play;export ORACLE_SID then logged into user SYS by doing sqlplus 'sys/change_on_install as sysdba' before hand. I've created a database before for RMAN but never encountered this problem. We're using Oracle 8i on Sun solaris 8.
Thanks.
P.S there is no urgency for any reply.
|
|
|
|
| Re: ORA-24323 Value not allowed [message #50324 is a reply to message #50274] |
Mon, 11 March 2002 12:07  |
Wei Lang
Messages: 23
Registered: March 2002
|
Junior Member |
|
|
You do not create database yet so there are on sys user.
Try this
>sqlplus /nolog
sqlplus> connect / as sysdba
or you can use internal as user for Oracle8i
Then startup nomount your instance.
Hope it helps.
Wei
|
|
|
|
| Re: ORA-24323 Value not allowed [message #50338 is a reply to message #50324] |
Mon, 11 March 2002 23:58 |
James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)
|
Member |
|
|
|
Hello Wei, I've now fixed the problem (thanks to nigel bishop@ioko365.com). The problem was a memory one. To fix the problem i had to change the kernel value SEMMNS from 530 to 860 (edited the file /etc/system) and reboot the system. The database then created ok. Nigel Bishop sent me a document on how to configure the Sun Solaris unix kernel for Oracle 8i. This showed how to amend the kernel values to allow for extra Oracle databases on the system. Thanks very much for your reply.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
