Script PIN_SP_SETUP.PL Generates Misleading Errors In Migration from 6.2-SP1- 6.2-SP4

(Doc ID 408062.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 6.2.0.1.0 and later   [Release: 6.2.0 and later ]
HP 9000 HP-UX 11.0 (32 bit)
Microsoft Windows (32-bit)
HP-UX PA-RISC (32-bit)
Oracle Solaris on SPARC (32-bit)
***Checked for relevance on 14-Apr-2010***
Checked for relevance on 28-Nov-2011

Symptoms

During the upgrade process when pin_sp_setup.pl is executed, it generates errors in the pin_setup.log as :


testnap has successfully connected to the CM.
Infranet is up and running.
#--- Executing SQL statement:
COMMIT;
#------------- SQL Results:
Executing sqlplus -s /@ < "/export/home/aghosh/Infranet_6.2/tmp/tmp.sql"
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
where <logon> ::= <username>[/<password>][@<connect_string>] | /
ERROR:
ORA-01017: invalid username/password; logon denied


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


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

#-------------
#--- Executing SQL statement:
COMMIT;
#------------- SQL Results:
Executing sqlplus -s /@ < "/export/home/aghosh/Infranet_6.2/tmp/tmp.sql"
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
where <logon> ::= <username>[/<password>][@<connect_string>] | /
ERROR:
ORA-01017: invalid username/password; logon denied



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms