This blog contains Oracle Database and RHEL and OEL support and troubleshoot documents. Most of them are copied from Oracle support Documents and references are mentioned.
Tuesday, December 24, 2019
How to enable SQL markup
SQL> conn /as sysdba (or any user)
SQL> set markup html on spool on
SQL> spool db_info.html
SQL> SET echo on
SQL> select COMP_NAME,VERSION,STATUS from dba_registry;
SQL> show PARAMETER
SQL> select * from v$resource_limit;
SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE from dba_objects where STATUS<>'VALID';
SQL> spool off
SQL> set markup html off
Subscribe to:
Post Comments (Atom)
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time https://shivanandarao-oracle.com/2012/12/05/rman-20207-until-time-or-re...
-
DBCA Fails To Create Oracle 19c Database On AIX [DBT-05509] (Doc ID 2663388.1 ) In this Document ...
-
[oracle@db ~]$ dbca DISPLAY not set. Set DISPLAY environment variable, then re-run. [oracle@db dbhome_1]$ DISPLAY=:1.0 ; export DISPL...
-
Oracle auditing setup & configuration The Oracle audit command is used to to create specific audit trails for Oracle tables. to ena...
No comments:
Post a Comment