-
编辑 删除
oracle 重建EM database
recreate em database control[oracle@zdtdbatest ~]$ emctl start EM Configuration ---檢查是否安裝[oracle@zdtdbatest ~]$ emca -config dbcontrol db -repos recreate －－重新安裝 D...
-
编辑 删除
oracle 重設置sga_target
SQL> alter system set sga_target=330M scope=both;alter system set sga_target=330M scope=both*ERROR at line 1:ORA-02097: parameter cannot be modified because specified value is invalidORA-00823: Specif...
-
编辑 删除
oracle修改進程數
SQL> alter system set processes=400 scope=spfile ;System altered.SQL> show parameter processes; processes &nbs...
-
编辑 删除
Linux 自動增加oracle 表空間
[oracle@zdtdbatest testtablespace]$ cat /home/oracle/check/testtablespace/scrip.sh. $HOME/.bash_profileexport ORACLE_SID=zdtdbat1if [ $ORACLE_SID != 'zdtdbat1' ];then &n...
-
编辑 删除
linux oracle 建立informix dblink 錯誤解決
常見錯誤 ORA_28545，ORA_02063解決：[root@zfkapsdb01 ~]# export INFORMIXDIR=/u/infor[root@zfkapsdb01 ~]# export DBCINI=/etc/odbc.ini [root@zfkapsdb01 etc]# isql -v infuse1SQL> select count(...
