Error in Create Database Phase

[former_member270768]

Hi All

We are facing following error during Create Database Phase of Installation on Redhat Linux with Oracle 10g.

ERROR 2011-07-21 12:20:30.480

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: Executable /oracle/ED1/102_64/bin/sqlplus returns 1.. SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

The ora_sql_results.log contains following details:

================================================================================

2011-07-20, 11:52:37 SAPINST ORACLE start logging for

SHUTDOWN ABORT;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jul 20 11:52:38 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

ERROR:

ORA-01031: insufficient privileges

SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus

Kindly suggest the necessary action.

Regards

Mahesh

[Former Member · Accepted solution]

Hi Mahesh,

It looks like permission issue. Check the ./etc/groups first;

dba -> ora<sid>, <sid>adm
oper -> ora<sid>, <sid>adm
sapsys -> <sid>adm

Best regards,

Orkun Gedik

[former_member270768 · Accepted solution]

Dear Orkun

Thank you for your reply.

I have added the users ora<sid and <sid>adm to the dba group in the file you mentioned still the problem persists.

Suggest further action

Regards

Mahesh

[Former Member · Accepted solution]

Mahesh,

Try this:

As oraedi:

sqlplus "/as sysdba"

shutdown immediate

startup

As ediadm:

sqlplus "/as sysdba"

shutdown immediate

startup

Do you get the 1031 error with these two users?

Good luck.

Mike Kennedy

[Former Member · Accepted solution]

Hi Kennedy,

I am also facing same error and I did above steps and I am not even able to execute sqlplus "/as sysdba"

It is giving following error

ORA-12547- TNS lost contact

Can you please suggest something.

Thanks,

Kalyan

[Former Member · Accepted solution]

Hi Mazumdar,

I don't think 12547 is connected to the problem in this thread, so I propose to open an own thread for your particular problem.

ORA-12547 often is connected to filesystem authorizations, so kindly check

- group assignments of sidadm and orasid

- filesystem permissions of your oracle executables

- sticky bit of ../bin/oracle

I experienced this problem when I chwon or chmod /oracle recursively (by accident), and in consequence the stick bits disappeared. Relinking the binaries may help here.

Regards,

Peter