Oracle
oracle
扑火的小飞蛾
点滴记录自我成长
展开
-
oracle相关资料整理
【安装部署】CentOS 6.5 静默安装Oracle11gR2数据库Oracle Linux 7.5安装oracle 12cR2数据库CentOS 6.8 安装Oracle11gR2 RAC数据库【基础概念】ORACLE集群概念和原理【Dataguard】Oracle11g 搭建DataGuard【OGG】原创 2021-11-24 13:11:21 · 733 阅读 · 0 评论 -
jdbc如何连接PDB
jdbc如何连接oracle 容器数据库(PDB)?//连接cdb和12c以下版本jdbc:oracle:thin:@192.168.1.82:1521:orcl//注:连接12c+版本的pdb需要把:改成/jdbc:oracle:thin:@192.168.1.82:1521/pdb原创 2021-11-09 22:42:01 · 1014 阅读 · 0 评论 -
如何在linux中获取进程名?
查看当前grid用户下的所有进程[root@racdb01 ~]# ps -ef |grep grid |grep -v greproot 24399 1 1 21:23 ? 00:00:03 /u01/app/11.2.0/grid/bin/ohasd.bin rebootgrid 24509 1 0 21:23 ? 00:00:01 /u01/app/11.2.0/grid/bin/oraagent.bingrid原创 2021-08-26 21:34:21 · 1286 阅读 · 0 评论 -
ORA-20011
Thu Jan 21 22:00:07 2021DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.Errors in file /u01/app/oracle/diag/rdbms/esbdg/esb/trace/esb_j002_4027.trc:ORA-20011: Approximate NDV failed: ORA-29913: æ<89>§è¡<8c> ODCIEXTTABL原创 2021-01-22 10:59:15 · 275 阅读 · 1 评论 -
ORA-28003: password verification for the specified password failed
ERROR at line 1:ORA-28003: password verification for the specified password failedORA-20003: Password should contain at least one digit, one character and onepunctuation原创 2020-12-03 16:27:17 · 2486 阅读 · 0 评论 -
ORA-12012: error on auto execute of job “SYS“.“ORA$AT_OS_OPT_SY_32913“
今天早上,同事说连不上数据库,数据库版本18c,用的pdb,查看alter日志,一堆报错,摘了一段如下ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_32913"ORA-20001: Statistics Advisor: Invalid task name for the current userORA-06512: at "SYS.DBMS_STATS", line 49538ORA-06512: at "SYS原创 2020-11-30 10:33:48 · 334 阅读 · 0 评论 -
fields terminated by X‘1B‘
https://iter01.com/310588.html原创 2020-11-08 14:58:54 · 883 阅读 · 0 评论 -
ORA-01565: error in identifying file ‘?/dbs/spfile@.ora‘
SQL> create pfile='/home/oracle/pfile_bup2_20201105.ora' from spfile;create pfile='/home/oracle/pfile_bup2_20201105.ora' from spfile*ERROR at line 1:ORA-01565: error in identifying file '?/dbs/spfile@.ora'ORA-27037: unable to obtain file statusLi.原创 2020-11-05 15:58:08 · 3094 阅读 · 0 评论 -
ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set sga_max_size=4G scope=both sid='*';alter system set sga_max_size=4G scope=both sid='*' *ERROR at line 1:ORA-02095: specified initialization parameter cannot be modified有些参数不能动态修改,需要使用alter system set paramet.翻译 2020-11-05 10:49:55 · 2607 阅读 · 0 评论