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?
How to Impdp/Expdp Oracle 11g Schema’s data to Oracle 12c?
Sample steps are the following.
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…
[原创]Oracle自增序列
自增列是数据库中值随插入的每个行自动增加的一列。常用于主键或 ID 字段,这样每次增加一行时,不用指该字段的值,它就会自动增加,而且是唯一的。减少了每次insert时候需要人工维护追加这一列。
APEX Barcode扫描小程序
简单扫描EAN, CODE 128, CODE 39, EAN 8, UPC-A, UPC-C, I2of5, CODABAR的Barcode。
[原创]Win10 Python3.6 连接Oracle12c的简单步骤
开始研究Python学习,首先配置好环境,目前使用windows10.
[原创]Linux 删除大量文件报错-[Argument list too long]
一个目录下面有上千上万个日志文件,通过通配符*匹配删除,碰到-[Argument list too long]错误。
如下
$ls -lrt| wc -l
250,213
$
大概有250k的文件个数,这个时候通过rm删除,报错
$ rm *.env
ksh: rm: /bin/rm: cannot execute [Argument list too long]
$
通过变通方法删除,如下
$find ./ -name "*.log" -delete
[原创]Linux更新python版本
Linux默认版本2.6,更新2.7版本的简单汇总