The VagrantBox list from Oracle
Unitl now, Oracle have provide the vagrantbox in the following link in Github.
How to remove file while happening “Text file busy”?
How to install Redis3.0 in Linux 7?
Oralce 12c SP2-0618 and ORA-01919
I met the error SP2-0618 and ORA-01919 while I executed the command “set autot on” to check the execute plan of sql.
HR@PDBPROD1> set autot on
SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabled
SP2-0611: Error enabling STATISTICS report
HR@PDBPROD1>
Oralce 18c New feature - Private Temporary Tables
We use Global Temporary Tables from Oracle 8i and we can use private temporary tables from 18c.
What is Private Temporary Tables? When to use Private Temporary Table ? How to use this?
Vagrant + Oracle Linux 7.4 + Oracle Database 18c + Create DB
How to install Database 18c in Oracle Linux 7.4?
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

How to install GUI in Oracle Linux 7?
Oracle 12c - How to create new service name for PDB?
We can use service_names to name or add service for database.
However we can NOT use service_names to name or add service for PDB container. So How to create new service name for PDB?
SYS> show parameter service_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string PROD.example.com
SYS> -
I met the ORA-00119 error while I modified the hostname and restarted the node.
[oracle@dbvm01]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 5 10:35:12 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected.
SQL> startup nomount
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=dbvm01)(PORT=1521))'
SQL>
With the messages, maybe the local_listener is wrong?
I met the ORA-00205 error while I modified the control_files parameter just like the following steps…
SYS@PRODCDB> alter system set control_files='/u01/app/oracle/oradata/PRODCDB/control00001.ctl, /u01/app/oracle/fast_recovery_area/PRODCDB/control02.ctl, /u01/app/oracle/oradata/PRODCDB/control00003.ctl' scope=spfile;
System altered.
SYS@PRODCDB> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@PRODCDB> !cp /u01/app/oracle/fast_recovery_area/PRODCDB/control02.ctl /u01/app/oracle/oradata/PRODCDB/control00001.ctl
SYS@PRODCDB> !cp /u01/app/oracle/fast_recovery_area/PRODCDB/control02.ctl /u01/app/oracle/oradata/PRODCDB/control00003.ctl
SYS@PRODCDB> startup
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 2929936 bytes
Variable Size 608176880 bytes
Database Buffers 222298112 bytes
Redo Buffers 5455872 bytes
ORA-00205: error in identifying control file, check alert log for more info
SYS@PRODCDB>
What is the reason???
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20299: DBMS_RCVMAN package not compatible with the recovery catalog
Solution:

++++++++++++++++ EOF LinHong ++++++++++++++++
How to export the sql result to excel file?