2471674 - "SQL statement or script failed" "ORA-01017" during installation with SWPM | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2471674 - "SQL statement or script failed" "ORA-01017" during installation with SWPM

Symptom

During execution of SWPM you have an error like this in sapinst_dev.log:

Last error reported by the step: SQL statement or script failed.
DIAGNOSIS: Error message: Executable /oracle/SM1/121/bin/sqlplus returns 1..
SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.

ERROR <timestamp> (<user account>) ...
The step <step> with step key ...
was executed with status ERROR ( Last error reported by the step: SQL statement or script failed.
DIAGNOSIS: Error message: Executable /oracle/<SID>/121/bin/sqlplus returns 1..
SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.).

And in ora_sql_results.log you see:

<timestamp> SAPINST ORACLE start logging for

SHUTDOWN IMMEDIATE;

exit;

Output of SQL executing program:

SQL*Plus: Release 12.1.0.2.0 Production on <timestamp>

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

ERROR:
ORA-01017: invalid username/password; logon denied


Read more...

Environment

  • SWPM / 70SWPM (Software Provisioning Manager)
  • Oracle 12 or Oracle 11 with ASM/Exadata
  • Linux/Unix Operating System
  • SAP Netweaver 7.0X or higher

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

getSecacctmgrUsers, SAPinst, SWPM, Fail, Fails, Failed, Execution, Stuck, Stop, Start, Crash, Hangs, Freeze, Frozen, Bug, Solution, sapinst_dev.log, sapinst.log, root, sudo, Windows, NT, Cluster, Unix, Linux, HP-UX, Solaris, AIX, RHEL, RHEL6, RHEL 6, SUSE, Enterprise, Oracle, Software Provisioning Manager, SIDadm, Switch, Cshrc, Environment, Limits, Step, Classpath, Migration, System Copy, Refresh, Refreshing, Export, Exporting, Import, Database, OSDB, NetWeaver, Distributed, Central, Media, Installation, Installer, Install, NW, 70, 700, 7.0, 7.00, 701, 7.01, 702, 7.02, 703, 7.03, 71, 710, 7.1, 7.10, 711, 7.11, 72, 720, 7.2, 7.20, 73, 730, 7.30, 7.3, 74, 740, 7.4, 7.40, 75, 750, 7.50, 7.5, Export, Exporting, Import, Importing, authorization, NW 7.5,  profile, createDatabase, , SQL statement or script failed, For more information, see ora_sql_results.log and the Oracle documentation, ORA-01017,  invalid username/password, logon denied, Executable, sqlplus returns 1 , KBA , BC-DB-ORA-SYS , Database Interface / DBMS for Oracle , BC-DB-ORA-INS , Installation SAP System with Oracle , BC-INS-SWPM , Installation with Software Provisioning Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.