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
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