Tuesday, 12 November 2019

RAC - SYSDBA Connection Fails With ORA-01017 and ORA-17503 (Doc ID 2474161.1)

SYSDBA Connection Fails With ORA-01017 and ORA-17503 (Doc ID 2474161.1)

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
oracle@sgdcplm01:~> sqlplus sys/sxxxxxxx@smrrac as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 30 16:08:51 2019

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

ERROR:
ORA-01017: invalid username/password; logon denied
ORA-17503: ksfdopn:2 Failed to open file
+DATA/SMRRAC/PASSWORD/pwdsmrrac.256.1020157701
ORA-12536: TNS:operation would block


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


Enter user-name:

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


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
oracle@sgdcplm01:~>
oracle@sgdcplm01:~> sqlplus sys/sxxxxxxxx@smrrac as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 30 16:09:02 2019

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC    smrrac2          smrrac                         READ WRITE           PRIMARY          NO                 0

SQL> @d

NAME      INSTANCE_NAME    DB_UNIQUE_NAME                 OPEN_MODE            DATABASE_ROLE    CURRENT_SCN        FAILOVER_SCN
--------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ----------------------------------------
SMRRAC    smrrac2          smrrac                         READ WRITE           PRIMARY          NO                 0

SQL> @tablespace

NAME      OPEN_MODE            DATABASE_ROLE    DB_UNIQUE_NAME
--------- -------------------- ---------------- ------------------------------
SMRRAC    READ WRITE           PRIMARY          smrrac


Tablespace                        Allocated      Current         Used    Available   %Used (vs)
Name                               Size(GB)     Size(GB)     Size(GB)     Size(GB)  (Allocated)
------------------------------ ------------ ------------ ------------ ------------ ------------
SYSAUX                                32.00          .83          .79        31.21         2.48
SYSTEM                                32.00          .78          .77        31.23         2.42
UNDOTBS1                              32.00          .13          .01        31.99          .02
UNDOTBS2                              32.00          .05          .01        31.99          .03
USERS                                 32.00          .00          .00        32.00          .00

SQL> sho parameter dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_core_dump                 string      partial
background_dump_dest                 string      /u01/app/oracle/product/12.1.0
                                                 /dbhome_2/rdbms/log
core_dump_dest                       string      /u01/app/oracle/diag/rdbms/smr
                                                 rac/smrrac2/cdump
max_dump_file_size                   string      unlimited
shadow_core_dump                     string      partial
user_dump_dest                       string      /u01/app/oracle/product/12.1.0
                                                 /dbhome_2/rdbms/log
SQL> exit

No comments:

Post a Comment