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

Last updated on FEBRUARY 18, 2014

Applies to:

Oracle Clinical - Version 5.0.0 and later
Information in this document applies to any platform.

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 /@oc50win' (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 /@oc50win

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: OC50WIN (DBID=2043995452)

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