cancel
Showing results for 
Search instead for 
Did you mean: 

Need help with NW7.3 installation error (ORA-01031: insufficient privileges)

Former Member
0 Kudos

Hi experts.

Need your help please.

I'm trying to install NW7.3 but stacked "Create Database" phase:

Error detail:

+++++++++

       An error occurred while processing option SAP NetWeaver 7.3 > Oracle > SAP Systems > Process Integration > Standard System > Standard System( Last error reported by the step: SQL statement or script failed. DIAGNOSIS: Error message: Executable C:\oracle\ORA\11203/bin/sqlplus returns 1.. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.). You can now:

  • Choose Retry to repeat the current step.
  • Choose Log Files to get more information about the error.
  • Stop the option and continue with it later.

Log files are written to C:\Program Files/sapinst_instdir/NW730/ORA/INSTALL/NW730/ORA/STD/AS.    

The ora_sql_results.log content:

++++++++++++++++++++++++

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

2013-06-01, 19:45:43 SAPINST ORACLE start logging for

SHUTDOWN ABORT;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 1 19:45:44 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:

ORA-12560: TNS:protocol adapter error

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

SAPINST: End of output of SQL executing program C:\oracle\ORA\11203/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2013-06-01, 19:45:45 SAPINST ORACLE stop logging

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

2013-06-01, 19:46:07 SAPINST ORACLE start logging for

SHUTDOWN IMMEDIATE;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 1 19:46:07 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:

ORA-01031: insufficient privileges

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

SAPINST: End of output of SQL executing program C:\oracle\ORA\11203/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2013-06-01, 19:46:09 SAPINST ORACLE stop logging

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

2013-06-01, 19:46:09 SAPINST ORACLE start logging for

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jun 1 19:46:09 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:

ORA-01031: insufficient privileges

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

SAPINST: End of output of SQL executing program C:\oracle\ORA\11203/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2013-06-01, 19:46:10 SAPINST ORACLE stop logging

Thanks in advance

Salah

Accepted Solutions (1)

Accepted Solutions (1)

mstitsel
Active Participant
0 Kudos

Hi Salah,

You are at the beginning of your installation process.

I advise you to just start from the beginning.

Just make sure your operating system user has enough authorizations (local admin or domain admin).

Regards, Marco

Former Member
0 Kudos

Thank you Stitselaar for you reply,

I fixed the issue. I just had to add user <SID>adm to ORA_DBA groupe

Thank you any way

Answers (2)

Answers (2)

Akshay_G
Contributor
0 Kudos

Hi Salah,

Before the step "Create Database", you must have installed Oracle DB Software as per the Installer directions. Can you please check and let me know the user/group permissions you set while installing the Software i.e. User Should be ora<sid> and group should be dba or something. Additionally sapsys group is also required.

You can check directly the user group ownership of /oracle/<SID>

Regards,

Akshay.

Former Member
0 Kudos

Hello Salah,

Error says "ORA-01031: insufficient privileges"

Can you please check SAP Note 480266 - Problems with the SYSDBA/SYSOPER/INTERNAL connect.

Also check if the users <sid>adm and <ora>sid belongs to correct group. Installation guide has details about the groups and users.

Regards,

Denish