'sqlplus /' or 'rman target /' does not work on a Oracle Clinical 5.0 Database Server (Doc ID 1622453.1)

Last updated on JULY 22, 2024

Applies to:

Symptoms

i.

The following error is returned when using 'sqlplus /' on a Oracle Clinical 5.0 database server :

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

ii.

The above command however works when the database is appended ie 'sqlplus /@<db_sid><DB_SID>' (and connects as OCPSUB / confirmed via 'show user' command).

iii.

A similar behaviour is observed with the 'rman connect /' command but in this case the 'ORA-01031: insufficient privileges' error appears (even when the OS user is in the ORA_DBA group as needed for RMAN *and* the OCPSUB database user has the SYSDBA privilege) :  

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Feb 10 06:30:11 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

However it works when the OCPSUB DB user has the SYSDBA privilege (sysdba privilege ,when assigned, updates the external password file and is tracked in this table => select * from v$pwfile_users) and the database connect string is specified ie

C:\app\oracle\product\11.2.0\dbhome_1\BIN>rman target /@<db_sid>

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Feb 10 06:44:18 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: <db_sid> (DBID=2043995452)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.