Oracle 11g

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

2016-08-19 12:56
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory   要在 LD_LIBRARY_PATH 裡面設定 libsqlplus.so 的所在路徑 export LD_LIBRARY_PATH=/opt/oracle/product/11.2.0/dbhome_1

帳號密碼過期處理方法

2014-02-10 18:05
ERROR: ORA-28002: the password will expire within 6 days   select username,account_status from dba_users;   ALTER PROFILE DeFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;   alter user nagios identified by nagios123;

再说Oracle Listener动静态注册

2014-01-13 18:19
监听器Listener是Oracle Client Process和实例远程建立连接关系的必经之路。借助Listener，Client Process可以实现和一个特定的Server Process建立连接关系，开启Session会话，操作Oracle Instance。   在Oracle体系中，Listener是一个独立的进程。Listener的运行是独立于Oracle实例的。在Windows或者Unix/Linux架构中，监听器都是被实现为一个独立的系统进程Process。监听器在工作中，是侍候在特定的端口Port上，接受Client Process通过Oracle...

Sqlplus 連遠端主機的方法

2013-12-30 11:01
sqlplus usr/pass@hostname.network/remote_service_name

設置oracle資料庫IP訪問限制 (IP白名單黑名單)

2013-09-14 15:16
可以通過修改sqlnet.ora檔來限制某些IP位址的訪問，修改完成後，可能需重啟監聽生效。(可以lsnrctl...

刪除過期的 archive log 和 backup

2013-07-30 00:05
  1. 進入 rman 2. connect target / 3. crosscheck archivelog all; 4. delete expired archivelog all; 5. report obsolete; 6. delete obsolete;         1. 進入 rman 2. connect target / 3. crosscheck backup; 4. delete expired backup; 5. report obsolete; 6. delete...

執行 awr report

2013-07-29 23:44
[oracle@SIPDB admin]$ cd /opt/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/admin [oracle@SIPDB admin]$ sqlplus / as sysdba   SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 29 23:40:28 2013   Copyright (c) 1982, 2009, Oracle.  All rights...

移除 Oracle 時，另外要手動移除的檔案

2013-07-29 18:20
[root@voipdb1 ~]# cat /etc/oraInst.loc inventory_loc=/u01/app/oraInventory inst_group=oinstall     [root@voipdb1 ~]# cat /etc/oratab #       # This file is used by ORACLE utilities.  It is created by root.sh # and updated by either Database...

Oracle 11g 安裝

2013-06-27 17:12

CentOS 6.2 安裝 Oracle 11gR2

2013-06-26 14:35
  1. 安裝 OS rpm yum -y install binutils "compat-libstdc++" elfutils-libelf elfutils-libelf-devel expat gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++ make "pdksh" sysstat unixODBC unixODBC-devel compat-libstdc++-33...