Search This Blog

Total Pageviews

Saturday, 11 November 2023

Oracle 23c SET ERRORDETAILS on

SET ERRORDETAILS on




SQL> SET ERRORDETAILS on
SQL> conn /@FREEPDB1 as sysdba
ERROR:
ORA-01017: invalid credential or not authorized; logon denied
Help: https://docs.oracle.com/error-help/db/ora-01017/    <<<< to trun off this 




SQL> SET ERRORDETAILS off
SQL> conn /@FREEPDB1 as sysdba
ERROR:
ORA-01017: invalid credential or not authorized; logon denied


Warning: You are no longer connected to ORACLE.
SQL>


******

https://docs.oracle.com/en/database/oracle/oracle-database/23/sqpug/sqlplus-users-guide-and-reference.pdf   pageno 266  !!!!

In the following example, the variable ERRORDETAILS is set to ON:
SET ERRORDETAILS ON
SELECT * FROM EMP;
SP2-0640: Not connected
Help: https://docs.oracle.com/error-help/db/sp2-0640/



[oracle@localhost admin]$ export TWO_TASK=''
[oracle@localhost admin]$ echo $TWO_TASK

[oracle@localhost admin]$ sqlplus / as sysdba

SQL*Plus: Release 23.0.0.0.0 - Production on Wed Sep 18 09:39:00 2024
Version 23.3.0.23.09

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


Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09

SQL>

Oracle DBA

anuj blog Archive