Lin Hong's TECH Blog!

【学习】 2025年阅读清单

Oralce 12c SP2-0618 and ORA-01919

2018-03-03

Oracle

Oracle 12c ORA-01919
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> 
```
Read All
Oralce 18c New feature

2018-03-02

Oracle

Oracle 18c NewFeatures

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?

Read All
Oracle 18c

2018-03-01

Oracle

Oracle 18c vagrant Box Linux

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

Read All
How to install GUI in Oracle Linux 7?

2018-02-01

Unix

Oracle Linux7 GUI yum

How to install GUI in Oracle Linux 7?

Read All
Oracle 12c - How to create new service name for PDB?

2018-01-10

Oracle

Oracle 12c Service name
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>  -
```
Read All

Oracle 11g - Startup Error #ORA-00119#ORA-00130

2018-01-05

Oracle

Oracle ORA-00130 ORA-00119 11g

Oracle 11g - Startup Error #ORA-00119#ORA-00130

Oracle 11g - Startup Error #ORA-00119#ORA-00130

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?

Read All

Oracle 12c - The control file error#ORA-00205#ORA-00202

2018-01-03

Oracle

Oracle ORA-00202 ORA-00205 12c

Oracle 12c - The control file error#ORA-00205#ORA-00202

Oracle 12c - The control file error#ORA-00205#ORA-00202

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

Read All

Oracle 12c - RMAN-20299

2018-01-03

Oracle

Oracle 12c RMAN-20299
- Oracle 12c - RMAN-20299
Oracle 12c - RMAN-20299

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20299: DBMS_RCVMAN package not compatible with the recovery catalog

Solution:

++++++++++++++++ EOF LinHong ++++++++++++++++
Read All
[Original]Oracle 11g Output the result to Excel file via SQL

2018-01-02

Oracle

Oracle Excel SQL
- [Original]Oracle 11g Output the result to Excel file via SQL
[Original]Oracle 11g Output the result to Excel file via SQL

How to export the sql result to excel file?
Read All
[Original]Impdp/Expdp Oracle 11g Schema's data to Oracle 12c

2018-01-02

Oracle

Oracle 12c impdp expdp
- [Original]Impdp/Expdp Oracle 11g Schema’s data to Oracle 12c
[Original]Impdp/Expdp Oracle 11g Schema’s data to Oracle 12c

How to Impdp/Expdp Oracle 11g Schema’s data to Oracle 12c?

Sample steps are the following.
Read All
[Original]Import Oracle Sample schema and create big test table and Test

2017-12-26

Oracle

Oracle Schema
- [Original]Import Oracle Sample schema and create big test table and Test
[Original]Import Oracle Sample schema and create big test table and Test

How to import the sample schema if you did not install the sample schema while installed the Database product?

How to create big table for test?

How to use STS/SPA/SAA to get the partition advisor and use Online re-defined to change table type(interval partition)?

Simply describe the steps…
Read All
[原创]Oracle自增序列

2017-12-08

Oracle

Oracle Sequence
- 自增序列简单介绍
[原创]Oracle自增序列

自增序列简单介绍

自增列是数据库中值随插入的每个行自动增加的一列。常用于主键或 ID 字段，这样每次增加一行时，不用指该字段的值，它就会自动增加，而且是唯一的。减少了每次insert时候需要人工维护追加这一列。
Read All

24/37

Oracle 11g - Startup Error #ORA-00119#ORA-00130

Oracle 12c - The control file error#ORA-00205#ORA-00202

Oracle 12c - RMAN-20299

[Original]Oracle 11g Output the result to Excel file via SQL

[Original]Impdp/Expdp Oracle 11g Schema’s data to Oracle 12c

[Original]Import Oracle Sample schema and create big test table and Test

自增序列简单介绍