Oracle 安装和卸载问题收集（集合篇）第1/6页
{"5":"
\u65e5\u671f\u4e71\u7801
Oracle Server\u7684\u8bbe\u7f6e\u5982\u4e0b
NLS_CHARACTERSET WE8ISO8859P1
NLS_LANGUAGE AMERICAN
NLS_NCHAR_CHARACTERSET AL16UTF16
\u673a\u5668\u4e0a\u7684\u6ce8\u518c\u8868
NLS_LANGUAGE AMERICAN_AMERICA.WE8ISO8859P1
\u95ee\u9898\uff1a
Java\u7a0b\u5e8f\u4f20\u65e5\u671f\u5230Oracle\u7684function\u91cc,\u7ecf\u8fc7lower(to_char(xsched_date,'DY'))\u51fd\u6570\u540e\uff0c\u65e5\u671f\u53d8\u6210\u4e86\u4e71\u7801\u3002\u8bf7\u95ee\uff1a
1. \u6211\u7684\u5b57\u7b26\u96c6\u5e94\u5f53\u600e\u6837\u8bbe\u7f6e\u5462\uff1f
2. server\u7684 NLS_CHARACTERSET \u548c NLS_NCHAR_CHARACTERSET \u4e0d\u4e00\u6837\uff0c\u6ca1\u5173\u7cfb\u5427\uff1fNLS_NCHAR_CHARACTERSET \u662f\u4ec0\u4e48\u610f\u601d?
\u89e3\u7b54\uff1a
1 \u5148\u67e5\u770b\u6709\u5173\u5b57\u7b26\u96c6\u7684\u4fe1\u606f
SQL>col value$ format a40
SQL> select * from nls_database_parameters;
SQL> select * from V$NLS_PARAMETERS;
2 \u67e5\u5f97\u7684\u4e3b\u8981\u5bf9\u5e94client\u7aef\u7684\u663e\u793a
SQL> select * from sys.props$ WHERE NAME='NLS_LANGUAGE';
\/\/\u53ef\u4ee5\u628a'AMERICAN' \u6539\u4e3a'SIMPLIFIED CHINESE ',\u4e0d\u8fc7\u8fd9\u4e2a\u4e8e\u672c\u95ee\u9898\u65e0\u5173
3\u4fee\u6539\u5b57\u7b26\u96c6
SQL> select * from sys.props$ WHERE NAME='NLS_CHARACTERSET';
\/\/\u628a\u4f60\u673a\u5668\u4e0a\u7684WE8ISO8859P1\u6539\u4e3a
SQL>UPDATE sys.PROPS$ SET VALUE$='ZHS16GBK' WHERE NAME='NLS_CHARACTERSET';
SQL>commit;
4 NLS_NCHAR_CHARACTERSET AL16UTF16 \u5176\u4e2d\u7684UTF16\u4e3aZHS16GBK\u7684\u5b50\u96c6,\u53ef\u663e\u793a\u5927\u591a\u6570\u6c49\u5b57\u3002
\u66f4\u6539\u5b57\u7b26\u96c6
\u6700\u597d\u4e0d\u8981\u4fee\u6539 props$\u8868\uff0c\u53ef\u80fd\u4f1a\u5f15\u8d77\u4e0d\u6b63\u5e38\u7684\u5de5\u4f5c\u3002
\u5982\u679c\u662f\u5ba2\u6237\u7aef \uff0c\u4fee\u6539\u6ce8\u518c\u8868\u5373\u53ef\uff1b
\u670d\u52a1\u5668\u7aef \"alter database character set \u5b57\u7b26\u96c6\"\u5373\u53ef
Oracle\u5ba2\u6237\u7aef\u6253\u5305\u5b89\u88c5\u95ee\u9898
\u6211\u7684\u7a0b\u5e8f\u662fC\/S\u67b6\u6784\u7684\uff0c\u6240\u4ee5\u5ba2\u6237\u7aef\u7535\u8111\u90fd\u8981\u5b89\u88c5ORACLE\u7684\u5ba2\u6237\u7aef\u7a0b\u5e8f\uff0c\u4e0d\u77e5\u9053\u6709\u6ca1\u6709\u529e\u6cd5\uff0c\u5c06ORACLE\u7684\u5ba2\u6237\u7aef\u5b89\u88c5\u7a0b\u5e8f\u6253\u5305\u8fdb\u6211\u7684\u5b89\u88c5\u7a0b\u5e8f\uff0c\u8fdb\u884c\u81ea\u52a8\u5b89\u88c5\u3002
\u89e3\u7b54\uff1a
1.\u5176\u5b9eORACLE\u7684\u5b89\u88c5\u5f88\u7b80\u5355\uff0c\u4f60\u5148\u5b89\u88c5\u4e00\u5957\u5ba2\u6237\u7aef\uff0c\u7136\u540e\u628a\u8fd9\u4e9b\u6587\u4ef6\u6253\u5305\uff08\u4eceORACLE_HOME\u5f00\u59cb\u5168\u90e8\u53d6\u51fa\uff09\uff0c\u628a\u6ce8\u518c\u8868\u4e2d\u7684ORACLE\u90e8\u5206\u5bfc\u51fa\u3002\u7136\u540e\u81ea\u5df1\u7f16\u5199\u4e00\u4e2a\u5b89\u88c5\u7a0b\u5e8f\uff0c\u628a\u8fd9\u4e9b\u6587\u4ef6\u6309\u7167\u67d0\u4e2a\u8def\u5f84\u62f7\u8d1d\uff08\u4e0d\u8981\u4fee\u6539\u76f8\u5bf9\u8def\u5f84\uff09\uff0c\u5982\u679c\u4f60\u5b89\u88c5\u7684ORACLE_HOME\u6539\u53d8\u4e86\uff0c\u5c31\u4fee\u6539REG\u4e2d\u7684ORACLE_hone\u53c2\u6570\uff0c\u7136\u540e\u5c06REG\u6587\u4ef6\u88c5\u5165\u3002\u8fd9\u4e9b\u90fd\u53ef\u4ee5\u901a\u8fc7\u7f16\u5199\u7a0b\u5e8f\u6765\u5b9e\u73b0\u3002
2.\u5b9e\u9645\u4e0aOracle\u9a71\u52a8\u5fae\u8f6f\u4e5f\u6709\uff0c\u4e3b\u8981\u5c31\u7f3a\u90a3\u4e2a\u7f51\u7edc\u670d\u52a1\u540d\uff0c\u7528Filemon.exe\u8f6f\u4ef6\u8ddf\u8e2a\u4e00\u4e0b\uff0c\u770b\u770b\u8981\u7528\u5230\u4e9b\u4ec0\u4e48\u4e1c\u897f\u3002
\u65e0\u6cd5\u786e\u5b9a\u4e3b\u673aIP\u9519\u8bef
\u95ee\u9898\uff1a
Win2003+Oracle 9iR2
\u5b89\u88c5\u7684\u65f6\u5019\u544a\u8bc9\u6211\u65e0\u6cd5\u786e\u5b9a\u4e3b\u673a\u7684IP\uff0c\u5ffd\u7565\u540e\u53c8\u62a5\u4e86\u51e0\u6b21\uff0c\u6700\u540e\u8fd8\u662f\u4e0d\u80fd\u5b89\u88c5
\u89e3\u7b54\uff1a\u4fee\u6539hosts\u6587\u4ef6\u3002\u786e\u8ba4nslookup\u547d\u4ee4\u53ef\u4ee5\u6b63\u786e\u6267\u884c
\u6ca1\u6709\u57df\u540d\u65f6\u8bbe\u7f6eOracle9i\u4e2d\u5168\u5c40\u6570\u636e\u5e93\u540d
set globle_name=false
\u53cc\u7f51\u5361\u8fde\u63a5\u5916\u7f51\u95ee\u9898
\u95ee\u9898\uff1a
\u670d\u52a1\u5668\u53cc\u7f51\u5361,\u4e00\u4e2a\u5185\u90e8\u7528,\u4e00\u4e2a\u901a\u5916\u7f51,\u88c5ORACLE8I,\u5ba2\u6237\u7aef\u8fde\u63a5\u670d\u52a1\u5668,\u5f53\u628a\u5916\u7f51\u7f51\u7ebf\u62d4\u6389,\u8fde\u63a5\u6b63\u5e38,\u628a\u5916\u7f51\u7f51\u7ebf\u63d2\u4e0a,\u8fde\u4e0d\u4e0a\u3002
\u89e3\u7b54\uff1a\u628a\u5185\u90e8\u7f51\u7684\u7f51\u5173\u53bb\u6389\uff0c\u518d\u5728\u4e0a\u9762\u52a0\u4e00\u4e2aNETBEUI\u534f\u8bae\u8fd9\u6837\u5c31\u53ef\u4ee5\u4e86\u3002
Oracle9i\u6570\u636e\u5e93\u7684\u4f01\u4e1a\u7248\u548c\u6807\u51c6\u7248\u7684\u533a\u522b
Oracle9i\u6570\u636e\u5e93\u7684\u4f01\u4e1a\u7248\u548c\u6807\u51c6\u7248\u6700\u4e3b\u8981\u7684\u533a\u522b\u5728\u4e8e\u4f01\u4e1a\u7248\u6709\u66f4\u5f3a\u5927\u7684\u5e76\u884c\u548c\u5206\u5e03\u5f0f\u5904\u7406\u80fd\u529b\uff0c\u6807\u51c6\u7248\u662f\u4e13\u4e3a\u5f00\u53d1\u3001\u90e8\u7f72\u548c\u7ba1\u7406\u90e8\u95e8\u7ea7 Internet \u5e94\u7528\u7a0b\u5e8f\u800c\u8bbe\u8ba1\u7684\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u662f\u7528\u4e8e\u4f20\u7edf\u7684\u90e8\u95e8\u7ea7\u5e94\u7528\u7a0b\u5e8f\u7684\u4e00\u6d41\u6570\u636e\u5e93\u3002\u800c\u5e94\u7528\u8d85\u51fa\u90e8\u95e8\u7ea7\u6807\u51c6\u6216\u8bbf\u95ee\u6570\u636e\u5e93\u7684\u4eba\u8f83\u591a\u65f6\uff0c\u5219\u5e94\u5f53\u9009\u7528\u4f01\u4e1a\u7248\u3002
\u6807\u51c6\u7248\u5305\u542b\u4e0b\u5217\u7ec4\u4ef6\uff1a Jserver Enterprise Edition
InterMedia
Enterprise Manager
Workflow Standard Edition
Standard Management Pack
Object Option
Networking kit
Object for OLE
Distributed Option
64 bit Option
ODBC Driver
Sql*Plus
OCI
\u4f01\u4e1a\u7248\u5305\u62ec\u6807\u51c6\u7248\u4e2d\u6240\u6709\u7ec4\u4ef6\uff0c\u5e76\u4e14\u8fd8\u542b\u6709\u4e0b\u5217\u989d\u5916\u7684\u7ec4\u4ef6\uff1a
Jserver Enterprise Edition
InterMedia
Object Option
Networking kit
Object for OLE
Advance Replication Option
Distributed Option
Parallel Query Option
SQL*Plus
VIR
Workflow Enterprise Edition
Advanced backup & recovery
Connection Pool
64 bit Option
ODBC Driver
OCI
Enterprise Manager
Enterprise Backup Utility
\u53e6\u8bf7\u53c2\u8003http:\/\/www.Oracle.com.cn\/cgi-bin\/topic_show.cgi?id=117&h=1&bpg=13&age=0
Oracle\u4e0eIIS\u5730\u5740\u51b2\u7a81
\u95ee\u9898\uff1a
\u6211\u7684\u673a\u5668\u7684\u7cfb\u7edf\u76d8\u662f c \u76d8\uff0cOracle8i\u4e5f\u5b89\u88c5\u5728c\u76d8\uff0c\u4ee5\u524d\u6211\u628a\u6211\u7684\u7f51\u7ad9\u5728\u201c\u63a7\u5236\u9762\u677f----\u7ba1\u7406\u5de5\u5177\u2014\u2014Internet\u670d\u52a1\u7ba1\u7406\u5668\u201d\u4e2d\u5df2\u7ecf\u8bbe\u7f6e\u597d\u4e86IIS\u7684\u914d\u7f6e\uff0c\u6240\u4ee5\u5728\u4ee5\u524d\u4e00\u6253\u5f00http:\/\/127.0.0.1\/\u5c31\u53ef\u4ee5\u770b\u89c1\u6211\u7684\u7f51\u7ad9\uff0c\u81ea\u4ece\u5b89\u88c5\u4e86Oracle8i\u540e\uff0c\u5728\u6253\u5f00http:\/\/127.0.0.1\/\u65f6\uff0c\u663e\u793a\u7684\u662f\u5173\u4e8eOracle\u7684\u4e00\u4e2a\u9875\u9762\uff0c\u5728IIS\u4e2d\u7684\u9ed8\u8ba4WEB\u7ad9\u70b9\u5df2\u7ecf\u201c\u505c\u6b62\u201d\u4e86\uff0c\u5f53\u6211\u518d\u91cd\u65b0\u542f\u52a8\u7684\u65f6\u5019\uff0c\u8bf4\u662f\u201c\u5730\u5740\u5df2\u88ab\u4f7f\u7528\uff01\u201d\u3002\u6211\u4e0d\u77e5\u9053\u8be5\u600e\u6837\u6062\u590d\u6210\u4ee5\u524d\u7684\u60c5\u5f62\u3002
\u89e3\u7b54\uff1a\u5728\u670d\u52a1\u7ba1\u7406\u91cc\u9762\u505c\u6b62ORACLE HTTP\u670d\u52a1
\u4e00\u4e2a\u63a7\u5236\u6587\u4ef6\u88ab\u635f\u574f\uff0c\u5982\u4f55\u542f\u52a8
\u7cfb\u7edf\u73af\u5883\uff1a
1\u3001\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 2000 Server\uff0c\u673a\u5668\u5185\u5b58128M
2\u3001\u6570\u636e\u5e93\uff1aOracle 8i R2 (8.1.6) for NT \u4f01\u4e1a\u7248
3\u3001\u5b89\u88c5\u8def\u5f84\uff1aC:\\ORACLE\u9519\u8bef\u73b0\u8c61\uff1a\u56e0\u786c\u76d8\u6709\u574f\u9053\uff0c\u4e00\u4e2a\u63a7\u5236\u6587\u4ef6\u635f\u574f\u4e86\uff0c\u6216\u4eba\u5de5\u8bef\u5220\u4e00\u4e2a\u63a7\u5236\u6587\u4ef6\uff0c\u63a7\u5236\u9762\u677f\u7684Oracle\u76f8\u5173\u670d\u52a1\u53ef\u4ee5\u542f\u52a8\u6210\u529f\uff0c\u4f46\u7528SQL*Plus\u65e0\u6cd5\u8fde\u63a5\uff0c\u663e\u793a\u4ee5\u4e0b\u9519\u8bef
ORA-01034: ORACLE not available\u89e3\u51b3\u65b9\u6cd5\uff1a
C:\\>svrmgrl
svrmgrl>connect internal
svrmgrl>shutdown abort\u4fee\u6539init.ora\uff08C:\\Oracle\\admin\\oradb\\pfile\\init.ora\uff09\u6587\u4ef6\uff0c\u4f7f\u65e0\u6cd5\u4f7f\u7528\u7684\u63a7\u5236\u6587\u4ef6\u4e0d\u5728control_files\u53c2\u6570\u4e2d\u5b9a\u4e49\u4fee\u6539\u524d
control_files = (\"C:\\Oracle\\oradata\\oradb\\control01.ctl\", \"C:\\Oracle\\oradata\\oradb\\control02.ctl\",
\"C:\\Oracle\\oradata\\oradb\\control03.ctl\")
\u4fee\u6539\u540e
control_files = (\"C:\\Oracle\\oradata\\oradb\\control01.ctl\", \"C:\\Oracle\\oradata\\oradb\\control02.ctl\")svrmgrl>startup
\u6ce8\u610f\uff1a\u6700\u5c11\u8981\u6709\u4e24\u4e2a\u63a7\u5236\u6587\u4ef6\u7684\u5b58\u5728\uff0c\u5373\u4f7f\u4e00\u4e2a\u4e5f\u53ef\u4ee5\u6b63\u5e38\u5e94\u7528\u3002
\u67d0\u4e2a\u6570\u636e\u6587\u4ef6\u635f\u574f\uff0c\u5982\u4f55\u6253\u5f00\u6570\u636e\u5e93\u2014\u2014ORA-01033: ORACLE initialization or shutdown in progress\u9519\u8bef
\u7cfb\u7edf\u73af\u5883\uff1a
1\u3001\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 2000 Server\uff0c\u673a\u5668\u5185\u5b58128M
2\u3001\u6570\u636e\u5e93\uff1a\u3000Oracle 8i R2 (8.1.6) for NT \u4f01\u4e1a\u7248
3\u3001\u5b89\u88c5\u8def\u5f84\uff1aC:\\ORACLE
\u9519\u8bef\u73b0\u8c61\uff1a
\u56e0\u8bef\u64cd\u4f5c\uff0c\u6570\u636e\u5e93\u4e2d\u67d0\u4e00\u6570\u636e\u6587\u4ef6\u88ab\u8bef\u5220\uff0c
\u63a7\u5236\u9762\u677f\u7684Oracle\u76f8\u5173\u670d\u52a1\u663e\u793a\u5df2\u542f\u52a8\uff0c\u4f46\u7528SQL*Plus\u65e0\u6cd5\u8fde\u63a5\uff0c
\u663e\u793a\u4ee5\u4e0b\u9519\u8bef
ORA-01033: ORACLE initialization or shutdown in progress
\u6a21\u62df\u73b0\u8c61\uff1a
create tablespace test datafile
'c:\\test.ora' size 5M
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
default storage (initial 128K next 1M pctincrease 0)
\/
\u5173\u95ed\u6240\u6709\u670d\u52a1stop.bat
net stop \"OracleWebAssistant0\"
net stop \"OracleOraHome81TNSListener\"
net stop \"OracleServiceORADB\"
shutdown
\u5728\u64cd\u4f5c\u7cfb\u7edf\u4e2d\u5220\u9664test.ora\u6587\u4ef6
\u91cd\u65b0\u542f\u52a8\u670d\u52a1start.bat
net start \"OracleWebAssistant0\"
net start \"OracleOraHome81TNSListener\"
net start \"OracleServiceORADB\"
\u670d\u52a1\u91ccOracleServiceORADB\u663e\u793a\u5df2\u542f\u52a8\uff0c\u4f46\u7528SQL*Plus\u65e0\u6cd5\u8fde\u63a5\uff0c
\u663e\u793aORA-01033: ORACLE initialization or shutdown in progress
\u89e3\u51b3\u65b9\u6cd5\uff1a
\u5148\u8ba9\u8be5\u6570\u636e\u6587\u4ef6\u8131\u673a,\u5c31\u53ef\u4ee5\u6253\u5f00\u6570\u636e\u5e93
C:\\>svrmgrl
svrmgrl>connect internal
svrmgrl>shutdown
svrmgrl>startup mount
--ARCHIVELOG\u6a21\u5f0f\u547d\u4ee4\uff0c\u6587\u4ef6\u540d\u8981\u5927\u5199
svrmgrl>alter database datafile 'C:\\TEST.ORA' offline;
--NOARCHIVELOG\u6a21\u5f0f\u547d\u4ee4
svrmgrl>alter database datafile 'C:\\TEST.ORA' offline drop;
svrmgrl>alter database open;
--\u67e5\u8be2\u6570\u636e\u6587\u4ef6\u8054\u3001\u8131\u673a\u72b6\u6001
SQL> select file#,name,status from v$datafile;
SQL> drop tablespace test;
\u8868\u7a7a\u95f4\u5df2\u4e22\u5f03\u3002
\u4e22\u5931\u8054\u673a\u65e5\u5fd7\u6587\u4ef6
\u5206\u4e24\u79cd\u60c5\u51b5\u5904\u7406
1\u3001\u4e22\u5931\u7684\u662f\u975e\u6d3b\u52a8\u7684\u65e5\u5fd7\u6587\u4ef6\uff1b
2\u3001\u4e22\u5931\u7684\u662f\u5f53\u524d\u6fc0\u6d3b\u7684\u65e5\u5fd7\u6587\u4ef6\u3002
\u5982\u679c\u662f\u7b2c\u4e00\u79cd\u60c5\u51b5\uff0c\u800c\u53d1\u751f\u6545\u969c\u7684\u65e5\u5fd7\u6587\u4ef6\u7ec4\u53c8\u5177\u6709\u591a\u4e2a\u6210\u5458\uff0c\u53ef\u4ee5\u5148\u5c06\u6570\u636e\u5e93shutdown\uff0c\u7136\u540e\u7528\u64cd\u4f5c\u7cfb\u7edf\u547d\u4ee4\u5c06\u635f\u574f\u65e5\u5fd7\u6587\u4ef6\u7ec4\u4e2d\u597d\u7684\u65e5\u5fd7\u6210\u5458\u6587\u4ef6\u628a\u635f\u574f\u7684\u6210\u5458\u6587\u4ef6\u8986\u76d6\uff08\u5728\u540c\u4e00\u4e2a\u65e5\u5fd7\u6210\u5458\u7ec4\u4e2d\u7684\u6240\u6709\u65e5\u5fd7\u6587\u4ef6\u7684\u5404\u4e3a\u955c\u8c61\u7684\uff09\uff0c\u5982\u679c\u5176\u7269\u7406\u4f4d\u7f6e\u4e0d\u53ef\u7528\u53ef\u5c06\u5176\u62f7\u8d1d\u5230\u65b0\u7684\u9a71\u52a8\u5668\u4e0a\uff0c\u4f7f\u7528alter database rename file \u2018xxxx' to \u2018xxxx'\u6539\u53d8\u6587\u4ef6\u4f4d\u7f6e\uff0c\u4e4b\u540e\u542f\u52a8\u6570\u636e\u5e93\uff0c\u5982\u679c\u6b63\u5e38\u9a6c\u4e0a\u8fdb\u884c\u4e00\u4e2a\u51b7\u5907\u4efd\u3002\u5982\u679c\u635f\u574f\u7684\u65e5\u5fd7\u7ec4\u4e2d\u53ea\u6709\u4e00\u4e2a\u65e5\u5fd7\u6210\u5458\uff0c\u5148mount\u4e0a\u6570\u636e\u5e93\uff0c\u5c06\u5176\u8f6c\u6362\u4e3anoarchivelog\u6a21\u5f0f\uff0c\u6267\u884calter database add logfile member \u2018xxx' to group \u2018x'\u7ed9\u76f8\u5173\u7ec4\u589e\u52a0\u4e00\u4e2a\u6210\u5458\uff0c\u518d\u6267\u884calter database drop logfile member \u2018bad_file'\u5c06\u635f\u574f\u7684\u65e5\u5fd7\u6587\u4ef6\u5220\u9664\uff0c\u7531\u4e8e\u6570\u636e\u5e93\u7684\u7ed3\u6784\u53d1\u751f\u53d8\u52a8\u9700\u8981\u5907\u4efd\u63a7\u5236\u6587\u4ef6\uff0c\u4e4b\u540e\u5c06\u6570\u636e\u5e93\u6539\u56dearchivelog\u6a21\u5f0f\uff0c\u505a\u4e00\u4e2a\u51b7\u5907\u4efd\u3002
\u5982\u679c\u4e22\u5931\u7684\u662f\u5f53\u524d\u6fc0\u6d3b\u7684\u65e5\u5fd7\u6587\u4ef6\uff0c\u6570\u636e\u5e93\u53c8\u6ca1\u6709\u955c\u50cf\u800c\u4e14\u5f53\u524d\u65e5\u5fd7\u7ec4\u4e2d\u6240\u6709\u6210\u5458\u5747\u53d8\u4e3a\u4e0d\u53ef\u7528\u3002\u9996\u5148\u5c06\u6570\u636e\u5e93shutdown abort\uff0c\u4ece\u6700\u8fd1\u7684\u4e00\u6b21\u5168\u5907\u4efd\u4e2d\u6062\u590d\u6240\u6709\u7684\u6570\u636e\u6587\u4ef6\uff0c\u5c06\u6570\u636e\u5e93\u542f\u52a8\u5230mount\u72b6\u6001\u3002\u5982\u679c\u539f\u6765\u7684\u65e5\u5fd7\u6587\u4ef6\u7269\u7406\u4f4d\u7f6e\u4e0d\u53ef\u7528\uff0c\u4f7f\u7528alter database rename file \u2018xxx' to \u2018xxx'\u6539\u53d8\u6587\u4ef6\u7684\u5b58\u653e\u4f4d\u7f6e\u3002\u7136\u540e\uff0c\u4f7f\u7528recover database until cancel\u547d\u4ee4\u6765\u6062\u590d\u6570\u636e\u5e93\uff0c\u76f4\u5230\u63d0\u793a\u6700\u540e\u4e00\u4e2a\u5f52\u6863\u65e5\u5fd7\u8fd0\u7528\u5b8c\u4e4b\u540e\uff0c\u8f93\u5165cancel\u3002\u4e4b\u540e\u7528alter database open resetlogs\u6253\u5f00\u6570\u636e\u5e93\uff0c\u5982\u679c\u6ca1\u6709\u95ee\u9898\uff0c\u7acb\u5373\u8fdb\u884c\u4e00\u4e2a\u51b7\u5907\u4efd\u3002\u6ce8\u610f\uff01\u6240\u6709\u5305\u542b\u5728\u635f\u574f\u7684redo log\u4e2d\u7684\u4fe1\u606f\u5c06\u4f1a\u4e22\u5931\uff0c\u4e5f\u5c31\u662f\u8bf4\u6570\u636e\u5e93\u5d29\u6e83\u524d\u5df2\u7ecf\u63d0\u4ea4\u7684\u6570\u636e\u6709\u53ef\u80fd\u4f1a\u4e22\u5931\u3002\u8fd9\u5bf9\u4e8e\u67d0\u4e9b\u8981\u6c42\u5f88\u9ad8\u7684\u5e94\u7528\u5c06\u4f1a\u635f\u5931\u60e8\u91cd\uff0c\u56e0\u6b64\u5e94\u5c3d\u91cf\u4f7f\u6bcf\u4e2a\u65e5\u5fd7\u7ec4\u5177\u6709\u591a\u4e2a\u65e5\u5fd7\u6210\u5458\uff0c\u5e76\u4e14\u653e\u7f6e\u5728\u4e0d\u540c\u7684\u9a71\u52a8\u5668\u4e0a\u9632\u6b62\u53d1\u751f\u4ecb\u8d28\u6545\u969c\u3002
\u9700\u8981\u5347\u7ea7\u6216\u8005\u8d2d\u4e70\u670d\u52a1\u4e86\u5417
\u95ee\u9898\uff1a
\u7ba1\u7406\u6211\u5355\u4f4d\u7684\u6570\u636e\u5e93\u670d\u52a1\u5668\uff0c\u914d\u7f6e\u662f: Compaq Alpha Es40 +512M+\u5355800Mhz CPU. \u53ea\u8dd1ORACLE\u6570\u636e\u5e93\u3002
\u56e0\u4e3a\u5bf9\u672c\u5355\u4f4d\u7684\u9700\u6c42\u5728\u7cfb\u7edf\u8bbe\u8ba1\u7684\u65f6\u5019\u4e0d\u5f88\u660e\u786e\uff0c\u4ee5\u4e0a\u914d\u7f6e\u662f\u4f9b\u8d27\u5546\u6839\u636e\u6211\u5355\u4f4d\u5f53\u65f6\u7684\u8ba1\u7b97\u673a\u5e94\u7528\u60c5\u51b5\u914d\u7f6e\u7684\uff0cCompaq\u7684\u5de5\u7a0b\u5e08\u5728\u5b89\u88c5\u7684\u65f6\u5019\u8bf4\u673a\u5668\u5f88\u597d\uff0c\u5c31\u662f\u5185\u5b58\u548cCPU\u7684\u914d\u7f6e\u5c0f\u4e86\u70b9\uff0c\u6211\u4e0d\u592a\u660e\u767d\u5f71\u54cd\u5927\u4e0d\u5927\u3002
\u6ca1\u60f3\u5230\u7684\u662f\uff0c\u4e1a\u52a1\u9700\u6c42\u7684\u589e\u957f\u5927\u5927\u8d85\u8fc7\u4e86\u5f53\u521d\u7684\u9884\u671f\uff0c\u5728\u6700\u5f00\u59cb\u7684\u65f6\u5019\u5ba2\u6237\u7aef\u7684PC\u6570\u91cf\u53ea\u6709\u4e0d\u8d85\u8fc750\u53f0\uff0c\u4e0d\u4e45\u5f88\u5feb\u5c31\u8d85\u8fc7\u4e86100\u53f0\uff0c\u6211\u628aunix\u7cfb\u7edf\u4e0b\u7684\u5355\u7528\u6237\u8fdb\u7a0b\u6570\u91cf\u8c03\u5230\u4e86200\uff0c\u5fc3\u60f3\u8fd9\u5e94\u8be5\u6ca1\u591a\u5927\u95ee\u9898\u4e86\u5427\uff0c\u7ed3\u679c\u662f\u597d\u666f\u4e0d\u957f\uff0c\u4e0d\u5230\u534a\u5e74200\u4e5f\u4e0d\u591f\u4e86\uff0c\u6211\u73b0\u5728\u628a\u6700\u5927\u8fdb\u7a0b\u6570\u8c03\u5230\u4e86400\u3002\u6211\u60f3\u8bf7\u6559\u4e00\u4e0b\uff0cOracle\u670d\u52a1\u5668\u662f\u4e0d\u662f\u4e3a\u6bcf\u4e00\u4e2a\u5ba2\u6237\u7aef\u5728\u670d\u52a1\u5668\u5355\u72ec\u5f00\u4e00\u4e2a\u8fdb\u7a0b\uff1f\u4e00\u53f0\u670d\u52a1\u5668\u80fd\u591f\u8054\u63a5\u7684\u5ba2\u6237\u7aef\u6570\u91cf\u76f8\u5bf9\u4e8e\u5185\u5b58\u7684\u5927\u5c0f\u5728\u7406\u8bba\u4e0a\u662f\u4e0d\u662f\u6709\u4e2a\u53c2\u8003\u7684\u7ecf\u9a8c\u503c\uff1f\u6709\u7684\u8bdd\u5927\u6982\u662f\u591a\u5c11\uff1f
\u89e3\u7b54\uff1a
1.Oracle\u670d\u52a1\u5668\u53ef\u4ee5\u5206\u4e3a\u4e13\u7528\u670d\u52a1\u5668\u548c\u5171\u4eab\u670d\u52a1\u5668\u4e24\u79cd\u3002\u4e13\u7528\u670d\u52a1\u5668\u4e3a\u6bcf\u4e2a\u5ba2\u6237\u7aef\u8fdb\u7a0b\u5f00\u542f\u4e00\u4e2a\u670d\u52a1\u5668\u7aef\u8fdb\u7a0b\uff1b\u5171\u4eab\u670d\u52a1\u5668\u5219\u5f00\u542f\u6570\u4e2a\u670d\u52a1\u5668\u7aef\u8fdb\u7a0b\uff0c\u4e3a\u6240\u6709\u7684\u5ba2\u6237\u7aef\u7a0b\u5e8f\u670d\u52a1\uff1b
\u4e00\u822c\u6765\u8bf4\uff0c\u91c7\u7528\u4e13\u7528\u670d\u52a1\u5668\u7684\u8bdd\uff0c\u4f60\u53ef\u4ee5\u6309\u7167\u6bcf\u4e2a\u5e76\u53d1\u8fde\u63a5\u6570\u9700\u89812m\u5185\u5b58\u6765\u7b80\u5355\u8ba1\u7b97\u3002512M\u5185\u5b58\u76f8\u5bf9\u8fde\u63a5\u6570\u8f83\u591a\uff0c\u5904\u7406\u91cf\u8f83\u5927\u7684\u7cfb\u7edf\u662f\u4e0d\u592a\u591f\u7684\u3002Oracle9i \u5b89\u88c5\u5c31\u63a8\u8350512m\u5185\u5b58\u4e86\u3002
Oracle\u7684\u8bbe\u8ba1\u601d\u8def\u662f\u5047\u8bbe\u673a\u5668\u5177\u6709\u65e0\u9650\u80fd\u529b\uff0c\u5728\u8fc7\u53bb\u4e0d\u600e\u4e48\u6837\uff0c\u56e0\u4e3a\u673a\u5668\u6027\u80fd\u5dee\uff0c\u4f46\u662f\u968f\u7740\u6280\u672f\u7684\u53d1\u5c55\uff0c\u673a\u5668\u7684\u80fd\u529b\u500d\u589e\uff0c\u800c\u4e14\u4ee3\u4ef7\u4e5f\u5927\u5927\u964d\u4f4e\uff0c\u82b1\u5f88\u5c11\u7684\u94b1\u5c31\u53ef\u4ee5\u4e70\u5230\u5f88\u597d\u7684\u673a\u5668\u4e86\uff0c\u73b0\u5728\u770b\u6765\uff0c\u8fd9\u79cd\u5f00\u53d1\u601d\u8def\u662f\u6781\u5176\u6210\u529f\u7684\u3002
2.\u5171\u4eab\u670d\u52a1\u5e76\u4e0d\u610f\u5473\u7740\u4e0d\u5360\u7528\u5185\u5b58\uff0c\u53ea\u662f\u91c7\u7528\u5171\u4eab\u6c60\u6a21\u5f0f\uff0c\u5c06\u8fde\u63a5\u6570\u636e\u5e93\u4f46\u6682\u65f6\u6ca1\u6709\u6570\u636e\u4f5c\u7684\u7528\u6237\u8fdb\u7a0b\u6302\u8d77\uff0c\u82e5\u5e76\u53d1\u7528\u6237\u6570\u91cf\u591a\u800c\u4e14\u9891\u7e41\u65f6\uff0c\u4f1a\u964d\u4f4e\u7cfb\u7edf\u6027\u80fd\u3002
\u53e6Oracle\u6570\u636e\u5e93\u4f7f\u7528\u5185\u5b58\u6700\u591a\u7684\u5e94\u8be5\u662fSGA\u533a\uff0c\u591a\u6570\u914d\u7f6e\u5408\u7406\u7684\u7cfb\u7edf\u4e2dSGA\u533a\u4f1a\u5360\u5230\u7cfb\u7edf\u5185\u5b58\u76841\/3\u751a\u81f31\/2\u4ee5\u4e0a\uff0c\u4e0d\u5408\u7406\u7684SGA\u533a\u914d\u7f6e\u4f1a\u6781\u5927\u5730\u5f71\u54cd\u6570\u636e\u5e93\u6027\u80fd\u3002\u81f3\u4e8eSGA\u533a\u5927\u5c0f\u548c\u5212\u5206\u4e0e\u5e94\u7528\u7cfb\u7edf\u7684\u6570\u636e\u91cf\u3001\u5ba2\u6237\u7aef\u6570\u91cf\u3001\u6570\u636e\u5904\u7406\u548c\u7a0b\u5e8f\u4ee3\u7801\u7b49\u76f8\u5173\u3002
\u6839\u636e\u6211\u4ece\u4e8b\u6570\u636e\u5e93\u5de5\u4f5c\u7684\u7ecf\u9a8c\uff0c2G\u5185\u5b58\u5e94\u8be5\u662f\u9700\u8981\u7684\uff0c\u800c\u4e14\u8d35\u5355\u4f4d\u7684\u6570\u636e\u5e93\u5f88\u53ef\u80fd\u9700\u8981\u4f18\u5316\u3002
3.\u6211\u89c9\u5f97\u5927\u5bb6\u5ffd\u7565\u4e86\u4e00\u70b9\uff1a\u7cfb\u7edf\u8d1f\u8f7d\u4e0d\u4ec5\u4e0e\u7528\u6237\u6570\u6709\u5173\uff0c\u66f4\u591a\u7684\u4e0e\u4ea4\u6613\u91cf\u76f8\u5173\u3002
\u6570\u636e\u5e93\u4e2d\u6ce8\u518c\u7528\u6237\u8868\u53ef\u80fd\u8fbe\u5230\u51e0\u5343\u4e07\u6761\uff0c\u5728\u521b\u5efa\u65f6\u6ce8\u610f\u4e9b\u4ec0\u4e48\u8bbe\u7f6e
\u5bf9\u8d85\u7ea7\u5927\u8868\uff0c\u9996\u5148\u8981\u6ce8\u610f\u7684\u662f\u5b58\u50a8\u53c2\u6570\u7684\u8bbe\u5b9a\uff0c\u4f30\u8ba1\u4e00\u4e0b\u884c\u6570\u636e\u91cf\uff0c\u5bf9\u8868\u6700\u7ec8\u7684\u5b58\u50a8\u7a7a\u95f4\u8981\u6c42\u5927\u81f4\u4f30\u7b97\u4ee5\u4e0b\uff0c\u5efa\u8868\u65f6\u8bbe\u5b9a\u597d\uff08next_extent\u548cmax_extents\u53c2\u6570\uff0c\u4ee5\u514d\u6700\u540e\u8868\u8d85\u8fc7max_extents\u800c\u65e0\u6cd5\u6269\u5c55)\uff0cpct_increase\u53c2\u6570\u4e00\u5b9a\u8981\u8bbe\u5b9a\u4e3a0\uff0c\u5426\u5219\u4ee5\u540enext_extent\u4f1a\u5448\u51e0\u4f55\u7ea7\u6570\u589e\u957f\u3002
\u5982\u679c\u8be5\u8868\u6570\u636e\u53d8\u5316\uff08\u589e\u52a0\u3001\u5220\u9664\u3001\u4fee\u6539\uff09\u9891\u7e41\uff0c\u9700\u8981\u8bbe\u5b9a PCT_FREE\u548cPCT_USED\u53c2\u6570\uff08\u53c2\u6570\u5b9a\u4e49\u548c\u7528\u6cd5\u8bf7\u67e5\u627e\u8d44\u6599\uff09\uff1b\u5982\u679c\u7a7a\u95f4\u8db3\u591f\u7684\u8bdd\uff0c\u6700\u597d\u5728\u5b57\u6bb5\u5b9a\u4e49\u4e2d\u4e0d\u4f7f\u7528VARCHAR2\u6570\u636e\u7c7b\u578b\uff0c\u5f53\u524d\u6ca1\u6709\u6570\u636e\u4e5f\u8ba9\u6570\u636e\u5e93\u9884\u7559\u51fa\u7a7a\u95f4\uff0c\u51cf\u5c11\u4fee\u6539\u6570\u636e\u5236\u9020\u7684\u6570\u636e\u788e\u7247\u3002
\u5bf9\u8d85\u7ea7\u5927\u8868\u7684\u68c0\u7d22\u3001*** \u4f5c\uff0c\u4e3b\u8981\u9760\u7d22\u5f15\uff0c\u5982\u4f55\u5efa\u597d\u7d22\u5f15\u3001\u7528\u597d\u7d22\u5f15\u662f\u7cfb\u7edf\u5f00\u53d1\u4eba\u5458\u7684\u804c\u8d23\u3002\u8d85\u7ea7\u5927\u8868\u7684\u68c0\u7d22\u9996\u5148\u5e94\u8be5\u4e0e\u4e3b\u8868\u5206\u5728\u4e0d\u540c\u7684\u8868\u7a7a\u95f4\uff08\u6700\u597d\u662f\u4e0d\u540c\u7684\u5b58\u50a8\u4ecb\u8d28\uff09\uff0c\u5176\u6b21\u8d85\u7ea7\u5927\u8868\u7684\u68c0\u7d22\u4e5f\u4f1a\u5360\u5f88\u5927\u7684\u7a7a\u95f4\uff0c\u68c0\u7d22\u7684\u5b58\u50a8\u53c2\u6570\u4e5f\u662f\u8981\u8bbe\u5b9a\u597d\u7684\u3002
\u5bf9\u8d85\u7ea7\u5927\u8868\u800c\u8a00\uff0c\u4e00\u70b9\u70b9\u7ed3\u6784\u8bbe\u8ba1\u7684\u4e0d\u5408\u7406\uff0c\u751a\u81f3\u4e00\u53e5\u7cdf\u7cd5\u7684\u7a0b\u5e8f\u4ee3\u7801\u5c31\u53ef\u80fd\u4f7f\u6574\u4e2a\u7cfb\u7edf\u7684\u6027\u80fd\u8ba9\u4eba\u65e0\u6cd5\u5fcd\u53d7\u3002\u6709\u4e9b\u539f\u5219\u8981\u8bb0\u4f4f\uff1a\u5728\u8d85\u7ea7\u5927\u8868\u4e0a\uff0c\u4e0d\u8981\u5b58\u5728\u4e0e\u5176\u4ed6\u6570\u636e\u8868\u7684\u7ea6\u675f\u5173\u7cfb\uff0c\u7ea6\u675f\u5173\u7cfb\u53ef\u4ee5\u901a\u8fc7\u7a0b\u5e8f\u4ee3\u7801\u5b9e\u73b0\uff1b\u5bf9\u8d85\u7ea7\u5927\u8868\uff0c\u4e0d\u8981\u968f\u610f\u4e0e\u5176\u4ed6\u6570\u636e\u8868\u8fdb\u884c\u5173\u8054\uff0c\u9664\u975e\u901a\u8fc7\u4e3b\u952e\uff08\u81f3\u5c11\u662f\u7d22\u5f15\u5217\uff09\u5173\u8054\u4e14where\u6761\u4ef6\u80fd\u4f7f\u7528\u5230\u7d22\u5f15\uff1b
\u5982\u679c\u4f60\u7528\u5230\u4e86ORACLE 8\uff0c\u5bf9\u8d85\u7ea7\u5927\u8868\u8fdb\u884c\u5206\u533a\u662f\u975e\u5e38\u6709\u4ef7\u503c\u7684\u3002
\u91cd\u88c5Oracle\u670d\u52a1\u5668\u540e\uff0c\u6062\u590d\u4ee5\u524d\u7684\u6570\u636e\u7cfb\u7edf\u73af\u5883
1\u3001\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 2000 Server\uff0c\u673a\u5668\u5185\u5b58128M
2\u3001\u6570\u636e\u5e93\uff1a\u3000Oracle 8i R2 (8.1.6) for NT \u4f01\u4e1a\u7248
3\u3001\u5b89\u88c5\u8def\u5f84\uff1aC:\\ORACLE
\u8bf4\u660e\uff1a
\u6062\u590d\u7684\u524d\u63d0\u662f\u8981\u4fdd\u7559\u4ee5\u4e0b\u5168\u90e8\u6587\u4ef6\uff1a
\u521d\u59cb\u5316\u53c2\u6570\u6587\u4ef6INIT.ORA
\u6240\u6709\u6570\u636e\u6587\u4ef6
\u6240\u6709\u91cd\u505a\u65e5\u5fd7\u6587\u4ef6\uff08\u8054\u673a\u65e5\u5fd7\u3001\u5f52\u6863\u65e5\u5fd7\uff09
\u6240\u6709\u63a7\u5236\u6587\u4ef6
internal\u5bc6\u7801\u6587\u4ef6
\u6b65\u9aa4\uff1a
1\u3001\u91cd\u65b0\u5b89\u88c5\u6570\u636e\u5e93\u65f6\uff0c\u521b\u5efa\u548c\u539f\u6709\u6570\u636e\u5e93\u76f8\u540c\u7684\u540d\u5b57
2\u3001shutdown
3\u3001\u505c\u6389NT\u4e0a\u6240\u6709Oracle\u670d\u52a1\uff0c\u5220\u9664\u65b0\u5efa\u6570\u636e\u5e93\u4e2d\u7684\u6240\u6709\u65b0\u5efa\u6587\u4ef6\uff08\u548c\u4ee5\u4e0a\u90a3\u4e9b\u7c7b\u4f3c\u7684\u6587\u4ef6\uff09
4\u3001\u5c06\u6240\u6709\u4ee5\u4e0a\u6587\u4ef6\u62f7\u8d1d\u56de\u539f\u76ee\u5f55
5\u3001startup
\u65e5\u6587\u7cfb\u7edf\u6539\u6210\u82f1\u6587\u7684\u529e\u6cd5
\u5728\u6ce8\u518c\u8868\u4e2d\u6539\u4e00\u4e2a\u952e\u503c\u3002
\u5177\u4f53\u5982\u4e0b\uff1a\u628aHKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> HOME0 -> NLS_LANG \u7684\u5065\u503c\u6539\u6210 AMERICAN_AMERICA.WE8ISO8859P1\uff0c\u7136\u540e\u5c31\u6b63\u5e38\u4e86\u3002
\u65e5\u671f\u4e71\u7801
Oracle Server\u7684\u8bbe\u7f6e\u5982\u4e0b
NLS_CHARACTERSET WE8ISO8859P1
NLS_LANGUAGE AMERICAN
NLS_NCHAR_CHARACTERSET AL16UTF16
\u673a\u5668\u4e0a\u7684\u6ce8\u518c\u8868
NLS_LANGUAGE AMERICAN_AMERICA.WE8ISO8859P1
\u95ee\u9898\uff1a
Java\u7a0b\u5e8f\u4f20\u65e5\u671f\u5230Oracle\u7684function\u91cc,\u7ecf\u8fc7lower(to_char(xsched_date,'DY'))\u51fd\u6570\u540e\uff0c\u65e5\u671f\u53d8\u6210\u4e86\u4e71\u7801\u3002\u8bf7\u95ee\uff1a
1. \u6211\u7684\u5b57\u7b26\u96c6\u5e94\u5f53\u600e\u6837\u8bbe\u7f6e\u5462\uff1f
2. server\u7684 NLS_CHARACTERSET \u548c NLS_NCHAR_CHARACTERSET \u4e0d\u4e00\u6837\uff0c\u6ca1\u5173\u7cfb\u5427\uff1fNLS_NCHAR_CHARACTERSET \u662f\u4ec0\u4e48\u610f\u601d?
\u89e3\u7b54\uff1a
1 \u5148\u67e5\u770b\u6709\u5173\u5b57\u7b26\u96c6\u7684\u4fe1\u606f
SQL>col value$ format a40
SQL> select * from nls_database_parameters;
SQL> select * from V$NLS_PARAMETERS;
2 \u67e5\u5f97\u7684\u4e3b\u8981\u5bf9\u5e94client\u7aef\u7684\u663e\u793a
SQL> select * from sys.props$ WHERE NAME='NLS_LANGUAGE';
\/\/\u53ef\u4ee5\u628a'AMERICAN' \u6539\u4e3a'SIMPLIFIED CHINESE ',\u4e0d\u8fc7\u8fd9\u4e2a\u4e8e\u672c\u95ee\u9898\u65e0\u5173
3\u4fee\u6539\u5b57\u7b26\u96c6
SQL> select * from sys.props$ WHERE NAME='NLS_CHARACTERSET';
\/\/\u628a\u4f60\u673a\u5668\u4e0a\u7684WE8ISO8859P1\u6539\u4e3a
SQL>UPDATE sys.PROPS$ SET VALUE$='ZHS16GBK' WHERE NAME='NLS_CHARACTERSET';
SQL>commit;
4 NLS_NCHAR_CHARACTERSET AL16UTF16 \u5176\u4e2d\u7684UTF16\u4e3aZHS16GBK\u7684\u5b50\u96c6,\u53ef\u663e\u793a\u5927\u591a\u6570\u6c49\u5b57\u3002
\u66f4\u6539\u5b57\u7b26\u96c6
\u6700\u597d\u4e0d\u8981\u4fee\u6539 props$\u8868\uff0c\u53ef\u80fd\u4f1a\u5f15\u8d77\u4e0d\u6b63\u5e38\u7684\u5de5\u4f5c\u3002
\u5982\u679c\u662f\u5ba2\u6237\u7aef \uff0c\u4fee\u6539\u6ce8\u518c\u8868\u5373\u53ef\uff1b
\u670d\u52a1\u5668\u7aef \"alter database character set \u5b57\u7b26\u96c6\"\u5373\u53ef
Oracle\u5ba2\u6237\u7aef\u6253\u5305\u5b89\u88c5\u95ee\u9898
\u6211\u7684\u7a0b\u5e8f\u662fC\/S\u67b6\u6784\u7684\uff0c\u6240\u4ee5\u5ba2\u6237\u7aef\u7535\u8111\u90fd\u8981\u5b89\u88c5ORACLE\u7684\u5ba2\u6237\u7aef\u7a0b\u5e8f\uff0c\u4e0d\u77e5\u9053\u6709\u6ca1\u6709\u529e\u6cd5\uff0c\u5c06ORACLE\u7684\u5ba2\u6237\u7aef\u5b89\u88c5\u7a0b\u5e8f\u6253\u5305\u8fdb\u6211\u7684\u5b89\u88c5\u7a0b\u5e8f\uff0c\u8fdb\u884c\u81ea\u52a8\u5b89\u88c5\u3002
\u89e3\u7b54\uff1a
1.\u5176\u5b9eORACLE\u7684\u5b89\u88c5\u5f88\u7b80\u5355\uff0c\u4f60\u5148\u5b89\u88c5\u4e00\u5957\u5ba2\u6237\u7aef\uff0c\u7136\u540e\u628a\u8fd9\u4e9b\u6587\u4ef6\u6253\u5305\uff08\u4eceORACLE_HOME\u5f00\u59cb\u5168\u90e8\u53d6\u51fa\uff09\uff0c\u628a\u6ce8\u518c\u8868\u4e2d\u7684ORACLE\u90e8\u5206\u5bfc\u51fa\u3002\u7136\u540e\u81ea\u5df1\u7f16\u5199\u4e00\u4e2a\u5b89\u88c5\u7a0b\u5e8f\uff0c\u628a\u8fd9\u4e9b\u6587\u4ef6\u6309\u7167\u67d0\u4e2a\u8def\u5f84\u62f7\u8d1d\uff08\u4e0d\u8981\u4fee\u6539\u76f8\u5bf9\u8def\u5f84\uff09\uff0c\u5982\u679c\u4f60\u5b89\u88c5\u7684ORACLE_HOME\u6539\u53d8\u4e86\uff0c\u5c31\u4fee\u6539REG\u4e2d\u7684ORACLE_hone\u53c2\u6570\uff0c\u7136\u540e\u5c06REG\u6587\u4ef6\u88c5\u5165\u3002\u8fd9\u4e9b\u90fd\u53ef\u4ee5\u901a\u8fc7\u7f16\u5199\u7a0b\u5e8f\u6765\u5b9e\u73b0\u3002
2.\u5b9e\u9645\u4e0aOracle\u9a71\u52a8\u5fae\u8f6f\u4e5f\u6709\uff0c\u4e3b\u8981\u5c31\u7f3a\u90a3\u4e2a\u7f51\u7edc\u670d\u52a1\u540d\uff0c\u7528Filemon.exe\u8f6f\u4ef6\u8ddf\u8e2a\u4e00\u4e0b\uff0c\u770b\u770b\u8981\u7528\u5230\u4e9b\u4ec0\u4e48\u4e1c\u897f\u3002
\u65e0\u6cd5\u786e\u5b9a\u4e3b\u673aIP\u9519\u8bef
\u95ee\u9898\uff1a
Win2003+Oracle 9iR2
\u5b89\u88c5\u7684\u65f6\u5019\u544a\u8bc9\u6211\u65e0\u6cd5\u786e\u5b9a\u4e3b\u673a\u7684IP\uff0c\u5ffd\u7565\u540e\u53c8\u62a5\u4e86\u51e0\u6b21\uff0c\u6700\u540e\u8fd8\u662f\u4e0d\u80fd\u5b89\u88c5
\u89e3\u7b54\uff1a\u4fee\u6539hosts\u6587\u4ef6\u3002\u786e\u8ba4nslookup\u547d\u4ee4\u53ef\u4ee5\u6b63\u786e\u6267\u884c
\u6ca1\u6709\u57df\u540d\u65f6\u8bbe\u7f6eOracle9i\u4e2d\u5168\u5c40\u6570\u636e\u5e93\u540d
set globle_name=false
\u53cc\u7f51\u5361\u8fde\u63a5\u5916\u7f51\u95ee\u9898
\u95ee\u9898\uff1a
\u670d\u52a1\u5668\u53cc\u7f51\u5361,\u4e00\u4e2a\u5185\u90e8\u7528,\u4e00\u4e2a\u901a\u5916\u7f51,\u88c5ORACLE8I,\u5ba2\u6237\u7aef\u8fde\u63a5\u670d\u52a1\u5668,\u5f53\u628a\u5916\u7f51\u7f51\u7ebf\u62d4\u6389,\u8fde\u63a5\u6b63\u5e38,\u628a\u5916\u7f51\u7f51\u7ebf\u63d2\u4e0a,\u8fde\u4e0d\u4e0a\u3002
\u89e3\u7b54\uff1a\u628a\u5185\u90e8\u7f51\u7684\u7f51\u5173\u53bb\u6389\uff0c\u518d\u5728\u4e0a\u9762\u52a0\u4e00\u4e2aNETBEUI\u534f\u8bae\u8fd9\u6837\u5c31\u53ef\u4ee5\u4e86\u3002
Oracle9i\u6570\u636e\u5e93\u7684\u4f01\u4e1a\u7248\u548c\u6807\u51c6\u7248\u7684\u533a\u522b
Oracle9i\u6570\u636e\u5e93\u7684\u4f01\u4e1a\u7248\u548c\u6807\u51c6\u7248\u6700\u4e3b\u8981\u7684\u533a\u522b\u5728\u4e8e\u4f01\u4e1a\u7248\u6709\u66f4\u5f3a\u5927\u7684\u5e76\u884c\u548c\u5206\u5e03\u5f0f\u5904\u7406\u80fd\u529b\uff0c\u6807\u51c6\u7248\u662f\u4e13\u4e3a\u5f00\u53d1\u3001\u90e8\u7f72\u548c\u7ba1\u7406\u90e8\u95e8\u7ea7 Internet \u5e94\u7528\u7a0b\u5e8f\u800c\u8bbe\u8ba1\u7684\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u662f\u7528\u4e8e\u4f20\u7edf\u7684\u90e8\u95e8\u7ea7\u5e94\u7528\u7a0b\u5e8f\u7684\u4e00\u6d41\u6570\u636e\u5e93\u3002\u800c\u5e94\u7528\u8d85\u51fa\u90e8\u95e8\u7ea7\u6807\u51c6\u6216\u8bbf\u95ee\u6570\u636e\u5e93\u7684\u4eba\u8f83\u591a\u65f6\uff0c\u5219\u5e94\u5f53\u9009\u7528\u4f01\u4e1a\u7248\u3002
\u6807\u51c6\u7248\u5305\u542b\u4e0b\u5217\u7ec4\u4ef6\uff1a Jserver Enterprise Edition
InterMedia
Enterprise Manager
Workflow Standard Edition
Standard Management Pack
Object Option
Networking kit
Object for OLE
Distributed Option
64 bit Option
ODBC Driver
Sql*Plus
OCI
\u4f01\u4e1a\u7248\u5305\u62ec\u6807\u51c6\u7248\u4e2d\u6240\u6709\u7ec4\u4ef6\uff0c\u5e76\u4e14\u8fd8\u542b\u6709\u4e0b\u5217\u989d\u5916\u7684\u7ec4\u4ef6\uff1a
Jserver Enterprise Edition
InterMedia
Object Option
Networking kit
Object for OLE
Advance Replication Option
Distributed Option
Parallel Query Option
SQL*Plus
VIR
Workflow Enterprise Edition
Advanced backup & recovery
Connection Pool
64 bit Option
ODBC Driver
OCI
Enterprise Manager
Enterprise Backup Utility
\u53e6\u8bf7\u53c2\u8003http:\/\/www.Oracle.com.cn\/cgi-bin\/topic_show.cgi?id=117&h=1&bpg=13&age=0
Oracle\u4e0eIIS\u5730\u5740\u51b2\u7a81
\u95ee\u9898\uff1a
\u6211\u7684\u673a\u5668\u7684\u7cfb\u7edf\u76d8\u662f c \u76d8\uff0cOracle8i\u4e5f\u5b89\u88c5\u5728c\u76d8\uff0c\u4ee5\u524d\u6211\u628a\u6211\u7684\u7f51\u7ad9\u5728\u201c\u63a7\u5236\u9762\u677f----\u7ba1\u7406\u5de5\u5177\u2014\u2014Internet\u670d\u52a1\u7ba1\u7406\u5668\u201d\u4e2d\u5df2\u7ecf\u8bbe\u7f6e\u597d\u4e86IIS\u7684\u914d\u7f6e\uff0c\u6240\u4ee5\u5728\u4ee5\u524d\u4e00\u6253\u5f00http:\/\/127.0.0.1\/\u5c31\u53ef\u4ee5\u770b\u89c1\u6211\u7684\u7f51\u7ad9\uff0c\u81ea\u4ece\u5b89\u88c5\u4e86Oracle8i\u540e\uff0c\u5728\u6253\u5f00http:\/\/127.0.0.1\/\u65f6\uff0c\u663e\u793a\u7684\u662f\u5173\u4e8eOracle\u7684\u4e00\u4e2a\u9875\u9762\uff0c\u5728IIS\u4e2d\u7684\u9ed8\u8ba4WEB\u7ad9\u70b9\u5df2\u7ecf\u201c\u505c\u6b62\u201d\u4e86\uff0c\u5f53\u6211\u518d\u91cd\u65b0\u542f\u52a8\u7684\u65f6\u5019\uff0c\u8bf4\u662f\u201c\u5730\u5740\u5df2\u88ab\u4f7f\u7528\uff01\u201d\u3002\u6211\u4e0d\u77e5\u9053\u8be5\u600e\u6837\u6062\u590d\u6210\u4ee5\u524d\u7684\u60c5\u5f62\u3002
\u89e3\u7b54\uff1a\u5728\u670d\u52a1\u7ba1\u7406\u91cc\u9762\u505c\u6b62ORACLE HTTP\u670d\u52a1
\u4e00\u4e2a\u63a7\u5236\u6587\u4ef6\u88ab\u635f\u574f\uff0c\u5982\u4f55\u542f\u52a8
\u7cfb\u7edf\u73af\u5883\uff1a
1\u3001\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 2000 Server\uff0c\u673a\u5668\u5185\u5b58128M
2\u3001\u6570\u636e\u5e93\uff1aOracle 8i R2 (8.1.6) for NT \u4f01\u4e1a\u7248
3\u3001\u5b89\u88c5\u8def\u5f84\uff1aC:\\ORACLE\u9519\u8bef\u73b0\u8c61\uff1a\u56e0\u786c\u76d8\u6709\u574f\u9053\uff0c\u4e00\u4e2a\u63a7\u5236\u6587\u4ef6\u635f\u574f\u4e86\uff0c\u6216\u4eba\u5de5\u8bef\u5220\u4e00\u4e2a\u63a7\u5236\u6587\u4ef6\uff0c\u63a7\u5236\u9762\u677f\u7684Oracle\u76f8\u5173\u670d\u52a1\u53ef\u4ee5\u542f\u52a8\u6210\u529f\uff0c\u4f46\u7528SQL*Plus\u65e0\u6cd5\u8fde\u63a5\uff0c\u663e\u793a\u4ee5\u4e0b\u9519\u8bef
ORA-01034: ORACLE not available\u89e3\u51b3\u65b9\u6cd5\uff1a
C:\\>svrmgrl
svrmgrl>connect internal
svrmgrl>shutdown abort\u4fee\u6539init.ora\uff08C:\\Oracle\\admin\\oradb\\pfile\\init.ora\uff09\u6587\u4ef6\uff0c\u4f7f\u65e0\u6cd5\u4f7f\u7528\u7684\u63a7\u5236\u6587\u4ef6\u4e0d\u5728control_files\u53c2\u6570\u4e2d\u5b9a\u4e49\u4fee\u6539\u524d
control_files = (\"C:\\Oracle\\oradata\\oradb\\control01.ctl\", \"C:\\Oracle\\oradata\\oradb\\control02.ctl\",
\"C:\\Oracle\\oradata\\oradb\\control03.ctl\")
\u4fee\u6539\u540e
control_files = (\"C:\\Oracle\\oradata\\oradb\\control01.ctl\", \"C:\\Oracle\\oradata\\oradb\\control02.ctl\")svrmgrl>startup
\u6ce8\u610f\uff1a\u6700\u5c11\u8981\u6709\u4e24\u4e2a\u63a7\u5236\u6587\u4ef6\u7684\u5b58\u5728\uff0c\u5373\u4f7f\u4e00\u4e2a\u4e5f\u53ef\u4ee5\u6b63\u5e38\u5e94\u7528\u3002
\u67d0\u4e2a\u6570\u636e\u6587\u4ef6\u635f\u574f\uff0c\u5982\u4f55\u6253\u5f00\u6570\u636e\u5e93\u2014\u2014ORA-01033: ORACLE initialization or shutdown in progress\u9519\u8bef
\u7cfb\u7edf\u73af\u5883\uff1a
1\u3001\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 2000 Server\uff0c\u673a\u5668\u5185\u5b58128M
2\u3001\u6570\u636e\u5e93\uff1a\u3000Oracle 8i R2 (8.1.6) for NT \u4f01\u4e1a\u7248
3\u3001\u5b89\u88c5\u8def\u5f84\uff1aC:\\ORACLE
\u9519\u8bef\u73b0\u8c61\uff1a
\u56e0\u8bef\u64cd\u4f5c\uff0c\u6570\u636e\u5e93\u4e2d\u67d0\u4e00\u6570\u636e\u6587\u4ef6\u88ab\u8bef\u5220\uff0c
\u63a7\u5236\u9762\u677f\u7684Oracle\u76f8\u5173\u670d\u52a1\u663e\u793a\u5df2\u542f\u52a8\uff0c\u4f46\u7528SQL*Plus\u65e0\u6cd5\u8fde\u63a5\uff0c
\u663e\u793a\u4ee5\u4e0b\u9519\u8bef
ORA-01033: ORACLE initialization or shutdown in progress
\u6a21\u62df\u73b0\u8c61\uff1a
create tablespace test datafile
'c:\\test.ora' size 5M
AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
default storage (initial 128K next 1M pctincrease 0)
\/
\u5173\u95ed\u6240\u6709\u670d\u52a1stop.bat
net stop \"OracleWebAssistant0\"
net stop \"OracleOraHome81TNSListener\"
net stop \"OracleServiceORADB\"
shutdown
\u5728\u64cd\u4f5c\u7cfb\u7edf\u4e2d\u5220\u9664test.ora\u6587\u4ef6
\u91cd\u65b0\u542f\u52a8\u670d\u52a1start.bat
net start \"OracleWebAssistant0\"
net start \"OracleOraHome81TNSListener\"
net start \"OracleServiceORADB\"
\u670d\u52a1\u91ccOracleServiceORADB\u663e\u793a\u5df2\u542f\u52a8\uff0c\u4f46\u7528SQL*Plus\u65e0\u6cd5\u8fde\u63a5\uff0c
\u663e\u793aORA-01033: ORACLE initialization or shutdown in progress
\u89e3\u51b3\u65b9\u6cd5\uff1a
\u5148\u8ba9\u8be5\u6570\u636e\u6587\u4ef6\u8131\u673a,\u5c31\u53ef\u4ee5\u6253\u5f00\u6570\u636e\u5e93
C:\\>svrmgrl
svrmgrl>connect internal
svrmgrl>shutdown
svrmgrl>startup mount
--ARCHIVELOG\u6a21\u5f0f\u547d\u4ee4\uff0c\u6587\u4ef6\u540d\u8981\u5927\u5199
svrmgrl>alter database datafile 'C:\\TEST.ORA' offline;
--NOARCHIVELOG\u6a21\u5f0f\u547d\u4ee4
svrmgrl>alter database datafile 'C:\\TEST.ORA' offline drop;
svrmgrl>alter database open;
--\u67e5\u8be2\u6570\u636e\u6587\u4ef6\u8054\u3001\u8131\u673a\u72b6\u6001
SQL> select file#,name,status from v$datafile;
SQL> drop tablespace test;
\u8868\u7a7a\u95f4\u5df2\u4e22\u5f03\u3002
\u4e22\u5931\u8054\u673a\u65e5\u5fd7\u6587\u4ef6
\u5206\u4e24\u79cd\u60c5\u51b5\u5904\u7406
1\u3001\u4e22\u5931\u7684\u662f\u975e\u6d3b\u52a8\u7684\u65e5\u5fd7\u6587\u4ef6\uff1b
2\u3001\u4e22\u5931\u7684\u662f\u5f53\u524d\u6fc0\u6d3b\u7684\u65e5\u5fd7\u6587\u4ef6\u3002
\u5982\u679c\u662f\u7b2c\u4e00\u79cd\u60c5\u51b5\uff0c\u800c\u53d1\u751f\u6545\u969c\u7684\u65e5\u5fd7\u6587\u4ef6\u7ec4\u53c8\u5177\u6709\u591a\u4e2a\u6210\u5458\uff0c\u53ef\u4ee5\u5148\u5c06\u6570\u636e\u5e93shutdown\uff0c\u7136\u540e\u7528\u64cd\u4f5c\u7cfb\u7edf\u547d\u4ee4\u5c06\u635f\u574f\u65e5\u5fd7\u6587\u4ef6\u7ec4\u4e2d\u597d\u7684\u65e5\u5fd7\u6210\u5458\u6587\u4ef6\u628a\u635f\u574f\u7684\u6210\u5458\u6587\u4ef6\u8986\u76d6\uff08\u5728\u540c\u4e00\u4e2a\u65e5\u5fd7\u6210\u5458\u7ec4\u4e2d\u7684\u6240\u6709\u65e5\u5fd7\u6587\u4ef6\u7684\u5404\u4e3a\u955c\u8c61\u7684\uff09\uff0c\u5982\u679c\u5176\u7269\u7406\u4f4d\u7f6e\u4e0d\u53ef\u7528\u53ef\u5c06\u5176\u62f7\u8d1d\u5230\u65b0\u7684\u9a71\u52a8\u5668\u4e0a\uff0c\u4f7f\u7528alter database rename file \u2018xxxx' to \u2018xxxx'\u6539\u53d8\u6587\u4ef6\u4f4d\u7f6e\uff0c\u4e4b\u540e\u542f\u52a8\u6570\u636e\u5e93\uff0c\u5982\u679c\u6b63\u5e38\u9a6c\u4e0a\u8fdb\u884c\u4e00\u4e2a\u51b7\u5907\u4efd\u3002\u5982\u679c\u635f\u574f\u7684\u65e5\u5fd7\u7ec4\u4e2d\u53ea\u6709\u4e00\u4e2a\u65e5\u5fd7\u6210\u5458\uff0c\u5148mount\u4e0a\u6570\u636e\u5e93\uff0c\u5c06\u5176\u8f6c\u6362\u4e3anoarchivelog\u6a21\u5f0f\uff0c\u6267\u884calter database add logfile member \u2018xxx' to group \u2018x'\u7ed9\u76f8\u5173\u7ec4\u589e\u52a0\u4e00\u4e2a\u6210\u5458\uff0c\u518d\u6267\u884calter database drop logfile member \u2018bad_file'\u5c06\u635f\u574f\u7684\u65e5\u5fd7\u6587\u4ef6\u5220\u9664\uff0c\u7531\u4e8e\u6570\u636e\u5e93\u7684\u7ed3\u6784\u53d1\u751f\u53d8\u52a8\u9700\u8981\u5907\u4efd\u63a7\u5236\u6587\u4ef6\uff0c\u4e4b\u540e\u5c06\u6570\u636e\u5e93\u6539\u56dearchivelog\u6a21\u5f0f\uff0c\u505a\u4e00\u4e2a\u51b7\u5907\u4efd\u3002
\u5982\u679c\u4e22\u5931\u7684\u662f\u5f53\u524d\u6fc0\u6d3b\u7684\u65e5\u5fd7\u6587\u4ef6\uff0c\u6570\u636e\u5e93\u53c8\u6ca1\u6709\u955c\u50cf\u800c\u4e14\u5f53\u524d\u65e5\u5fd7\u7ec4\u4e2d\u6240\u6709\u6210\u5458\u5747\u53d8\u4e3a\u4e0d\u53ef\u7528\u3002\u9996\u5148\u5c06\u6570\u636e\u5e93shutdown abort\uff0c\u4ece\u6700\u8fd1\u7684\u4e00\u6b21\u5168\u5907\u4efd\u4e2d\u6062\u590d\u6240\u6709\u7684\u6570\u636e\u6587\u4ef6\uff0c\u5c06\u6570\u636e\u5e93\u542f\u52a8\u5230mount\u72b6\u6001\u3002\u5982\u679c\u539f\u6765\u7684\u65e5\u5fd7\u6587\u4ef6\u7269\u7406\u4f4d\u7f6e\u4e0d\u53ef\u7528\uff0c\u4f7f\u7528alter database rename file \u2018xxx' to \u2018xxx'\u6539\u53d8\u6587\u4ef6\u7684\u5b58\u653e\u4f4d\u7f6e\u3002\u7136\u540e\uff0c\u4f7f\u7528recover database until cancel\u547d\u4ee4\u6765\u6062\u590d\u6570\u636e\u5e93\uff0c\u76f4\u5230\u63d0\u793a\u6700\u540e\u4e00\u4e2a\u5f52\u6863\u65e5\u5fd7\u8fd0\u7528\u5b8c\u4e4b\u540e\uff0c\u8f93\u5165cancel\u3002\u4e4b\u540e\u7528alter database open resetlogs\u6253\u5f00\u6570\u636e\u5e93\uff0c\u5982\u679c\u6ca1\u6709\u95ee\u9898\uff0c\u7acb\u5373\u8fdb\u884c\u4e00\u4e2a\u51b7\u5907\u4efd\u3002\u6ce8\u610f\uff01\u6240\u6709\u5305\u542b\u5728\u635f\u574f\u7684redo log\u4e2d\u7684\u4fe1\u606f\u5c06\u4f1a\u4e22\u5931\uff0c\u4e5f\u5c31\u662f\u8bf4\u6570\u636e\u5e93\u5d29\u6e83\u524d\u5df2\u7ecf\u63d0\u4ea4\u7684\u6570\u636e\u6709\u53ef\u80fd\u4f1a\u4e22\u5931\u3002\u8fd9\u5bf9\u4e8e\u67d0\u4e9b\u8981\u6c42\u5f88\u9ad8\u7684\u5e94\u7528\u5c06\u4f1a\u635f\u5931\u60e8\u91cd\uff0c\u56e0\u6b64\u5e94\u5c3d\u91cf\u4f7f\u6bcf\u4e2a\u65e5\u5fd7\u7ec4\u5177\u6709\u591a\u4e2a\u65e5\u5fd7\u6210\u5458\uff0c\u5e76\u4e14\u653e\u7f6e\u5728\u4e0d\u540c\u7684\u9a71\u52a8\u5668\u4e0a\u9632\u6b62\u53d1\u751f\u4ecb\u8d28\u6545\u969c\u3002
\u9700\u8981\u5347\u7ea7\u6216\u8005\u8d2d\u4e70\u670d\u52a1\u4e86\u5417
\u95ee\u9898\uff1a
\u7ba1\u7406\u6211\u5355\u4f4d\u7684\u6570\u636e\u5e93\u670d\u52a1\u5668\uff0c\u914d\u7f6e\u662f: Compaq Alpha Es40 +512M+\u5355800Mhz CPU. \u53ea\u8dd1ORACLE\u6570\u636e\u5e93\u3002
\u56e0\u4e3a\u5bf9\u672c\u5355\u4f4d\u7684\u9700\u6c42\u5728\u7cfb\u7edf\u8bbe\u8ba1\u7684\u65f6\u5019\u4e0d\u5f88\u660e\u786e\uff0c\u4ee5\u4e0a\u914d\u7f6e\u662f\u4f9b\u8d27\u5546\u6839\u636e\u6211\u5355\u4f4d\u5f53\u65f6\u7684\u8ba1\u7b97\u673a\u5e94\u7528\u60c5\u51b5\u914d\u7f6e\u7684\uff0cCompaq\u7684\u5de5\u7a0b\u5e08\u5728\u5b89\u88c5\u7684\u65f6\u5019\u8bf4\u673a\u5668\u5f88\u597d\uff0c\u5c31\u662f\u5185\u5b58\u548cCPU\u7684\u914d\u7f6e\u5c0f\u4e86\u70b9\uff0c\u6211\u4e0d\u592a\u660e\u767d\u5f71\u54cd\u5927\u4e0d\u5927\u3002
\u6ca1\u60f3\u5230\u7684\u662f\uff0c\u4e1a\u52a1\u9700\u6c42\u7684\u589e\u957f\u5927\u5927\u8d85\u8fc7\u4e86\u5f53\u521d\u7684\u9884\u671f\uff0c\u5728\u6700\u5f00\u59cb\u7684\u65f6\u5019\u5ba2\u6237\u7aef\u7684PC\u6570\u91cf\u53ea\u6709\u4e0d\u8d85\u8fc750\u53f0\uff0c\u4e0d\u4e45\u5f88\u5feb\u5c31\u8d85\u8fc7\u4e86100\u53f0\uff0c\u6211\u628aunix\u7cfb\u7edf\u4e0b\u7684\u5355\u7528\u6237\u8fdb\u7a0b\u6570\u91cf\u8c03\u5230\u4e86200\uff0c\u5fc3\u60f3\u8fd9\u5e94\u8be5\u6ca1\u591a\u5927\u95ee\u9898\u4e86\u5427\uff0c\u7ed3\u679c\u662f\u597d\u666f\u4e0d\u957f\uff0c\u4e0d\u5230\u534a\u5e74200\u4e5f\u4e0d\u591f\u4e86\uff0c\u6211\u73b0\u5728\u628a\u6700\u5927\u8fdb\u7a0b\u6570\u8c03\u5230\u4e86400\u3002\u6211\u60f3\u8bf7\u6559\u4e00\u4e0b\uff0cOracle\u670d\u52a1\u5668\u662f\u4e0d\u662f\u4e3a\u6bcf\u4e00\u4e2a\u5ba2\u6237\u7aef\u5728\u670d\u52a1\u5668\u5355\u72ec\u5f00\u4e00\u4e2a\u8fdb\u7a0b\uff1f\u4e00\u53f0\u670d\u52a1\u5668\u80fd\u591f\u8054\u63a5\u7684\u5ba2\u6237\u7aef\u6570\u91cf\u76f8\u5bf9\u4e8e\u5185\u5b58\u7684\u5927\u5c0f\u5728\u7406\u8bba\u4e0a\u662f\u4e0d\u662f\u6709\u4e2a\u53c2\u8003\u7684\u7ecf\u9a8c\u503c\uff1f\u6709\u7684\u8bdd\u5927\u6982\u662f\u591a\u5c11\uff1f
\u89e3\u7b54\uff1a
1.Oracle\u670d\u52a1\u5668\u53ef\u4ee5\u5206\u4e3a\u4e13\u7528\u670d\u52a1\u5668\u548c\u5171\u4eab\u670d\u52a1\u5668\u4e24\u79cd\u3002\u4e13\u7528\u670d\u52a1\u5668\u4e3a\u6bcf\u4e2a\u5ba2\u6237\u7aef\u8fdb\u7a0b\u5f00\u542f\u4e00\u4e2a\u670d\u52a1\u5668\u7aef\u8fdb\u7a0b\uff1b\u5171\u4eab\u670d\u52a1\u5668\u5219\u5f00\u542f\u6570\u4e2a\u670d\u52a1\u5668\u7aef\u8fdb\u7a0b\uff0c\u4e3a\u6240\u6709\u7684\u5ba2\u6237\u7aef\u7a0b\u5e8f\u670d\u52a1\uff1b
\u4e00\u822c\u6765\u8bf4\uff0c\u91c7\u7528\u4e13\u7528\u670d\u52a1\u5668\u7684\u8bdd\uff0c\u4f60\u53ef\u4ee5\u6309\u7167\u6bcf\u4e2a\u5e76\u53d1\u8fde\u63a5\u6570\u9700\u89812m\u5185\u5b58\u6765\u7b80\u5355\u8ba1\u7b97\u3002512M\u5185\u5b58\u76f8\u5bf9\u8fde\u63a5\u6570\u8f83\u591a\uff0c\u5904\u7406\u91cf\u8f83\u5927\u7684\u7cfb\u7edf\u662f\u4e0d\u592a\u591f\u7684\u3002Oracle9i \u5b89\u88c5\u5c31\u63a8\u8350512m\u5185\u5b58\u4e86\u3002
Oracle\u7684\u8bbe\u8ba1\u601d\u8def\u662f\u5047\u8bbe\u673a\u5668\u5177\u6709\u65e0\u9650\u80fd\u529b\uff0c\u5728\u8fc7\u53bb\u4e0d\u600e\u4e48\u6837\uff0c\u56e0\u4e3a\u673a\u5668\u6027\u80fd\u5dee\uff0c\u4f46\u662f\u968f\u7740\u6280\u672f\u7684\u53d1\u5c55\uff0c\u673a\u5668\u7684\u80fd\u529b\u500d\u589e\uff0c\u800c\u4e14\u4ee3\u4ef7\u4e5f\u5927\u5927\u964d\u4f4e\uff0c\u82b1\u5f88\u5c11\u7684\u94b1\u5c31\u53ef\u4ee5\u4e70\u5230\u5f88\u597d\u7684\u673a\u5668\u4e86\uff0c\u73b0\u5728\u770b\u6765\uff0c\u8fd9\u79cd\u5f00\u53d1\u601d\u8def\u662f\u6781\u5176\u6210\u529f\u7684\u3002
2.\u5171\u4eab\u670d\u52a1\u5e76\u4e0d\u610f\u5473\u7740\u4e0d\u5360\u7528\u5185\u5b58\uff0c\u53ea\u662f\u91c7\u7528\u5171\u4eab\u6c60\u6a21\u5f0f\uff0c\u5c06\u8fde\u63a5\u6570\u636e\u5e93\u4f46\u6682\u65f6\u6ca1\u6709\u6570\u636e\u4f5c\u7684\u7528\u6237\u8fdb\u7a0b\u6302\u8d77\uff0c\u82e5\u5e76\u53d1\u7528\u6237\u6570\u91cf\u591a\u800c\u4e14\u9891\u7e41\u65f6\uff0c\u4f1a\u964d\u4f4e\u7cfb\u7edf\u6027\u80fd\u3002
\u53e6Oracle\u6570\u636e\u5e93\u4f7f\u7528\u5185\u5b58\u6700\u591a\u7684\u5e94\u8be5\u662fSGA\u533a\uff0c\u591a\u6570\u914d\u7f6e\u5408\u7406\u7684\u7cfb\u7edf\u4e2dSGA\u533a\u4f1a\u5360\u5230\u7cfb\u7edf\u5185\u5b58\u76841\/3\u751a\u81f31\/2\u4ee5\u4e0a\uff0c\u4e0d\u5408\u7406\u7684SGA\u533a\u914d\u7f6e\u4f1a\u6781\u5927\u5730\u5f71\u54cd\u6570\u636e\u5e93\u6027\u80fd\u3002\u81f3\u4e8eSGA\u533a\u5927\u5c0f\u548c\u5212\u5206\u4e0e\u5e94\u7528\u7cfb\u7edf\u7684\u6570\u636e\u91cf\u3001\u5ba2\u6237\u7aef\u6570\u91cf\u3001\u6570\u636e\u5904\u7406\u548c\u7a0b\u5e8f\u4ee3\u7801\u7b49\u76f8\u5173\u3002
\u6839\u636e\u6211\u4ece\u4e8b\u6570\u636e\u5e93\u5de5\u4f5c\u7684\u7ecf\u9a8c\uff0c2G\u5185\u5b58\u5e94\u8be5\u662f\u9700\u8981\u7684\uff0c\u800c\u4e14\u8d35\u5355\u4f4d\u7684\u6570\u636e\u5e93\u5f88\u53ef\u80fd\u9700\u8981\u4f18\u5316\u3002
3.\u6211\u89c9\u5f97\u5927\u5bb6\u5ffd\u7565\u4e86\u4e00\u70b9\uff1a\u7cfb\u7edf\u8d1f\u8f7d\u4e0d\u4ec5\u4e0e\u7528\u6237\u6570\u6709\u5173\uff0c\u66f4\u591a\u7684\u4e0e\u4ea4\u6613\u91cf\u76f8\u5173\u3002
\u6570\u636e\u5e93\u4e2d\u6ce8\u518c\u7528\u6237\u8868\u53ef\u80fd\u8fbe\u5230\u51e0\u5343\u4e07\u6761\uff0c\u5728\u521b\u5efa\u65f6\u6ce8\u610f\u4e9b\u4ec0\u4e48\u8bbe\u7f6e
\u5bf9\u8d85\u7ea7\u5927\u8868\uff0c\u9996\u5148\u8981\u6ce8\u610f\u7684\u662f\u5b58\u50a8\u53c2\u6570\u7684\u8bbe\u5b9a\uff0c\u4f30\u8ba1\u4e00\u4e0b\u884c\u6570\u636e\u91cf\uff0c\u5bf9\u8868\u6700\u7ec8\u7684\u5b58\u50a8\u7a7a\u95f4\u8981\u6c42\u5927\u81f4\u4f30\u7b97\u4ee5\u4e0b\uff0c\u5efa\u8868\u65f6\u8bbe\u5b9a\u597d\uff08next_extent\u548cmax_extents\u53c2\u6570\uff0c\u4ee5\u514d\u6700\u540e\u8868\u8d85\u8fc7max_extents\u800c\u65e0\u6cd5\u6269\u5c55)\uff0cpct_increase\u53c2\u6570\u4e00\u5b9a\u8981\u8bbe\u5b9a\u4e3a0\uff0c\u5426\u5219\u4ee5\u540enext_extent\u4f1a\u5448\u51e0\u4f55\u7ea7\u6570\u589e\u957f\u3002
\u5982\u679c\u8be5\u8868\u6570\u636e\u53d8\u5316\uff08\u589e\u52a0\u3001\u5220\u9664\u3001\u4fee\u6539\uff09\u9891\u7e41\uff0c\u9700\u8981\u8bbe\u5b9a PCT_FREE\u548cPCT_USED\u53c2\u6570\uff08\u53c2\u6570\u5b9a\u4e49\u548c\u7528\u6cd5\u8bf7\u67e5\u627e\u8d44\u6599\uff09\uff1b\u5982\u679c\u7a7a\u95f4\u8db3\u591f\u7684\u8bdd\uff0c\u6700\u597d\u5728\u5b57\u6bb5\u5b9a\u4e49\u4e2d\u4e0d\u4f7f\u7528VARCHAR2\u6570\u636e\u7c7b\u578b\uff0c\u5f53\u524d\u6ca1\u6709\u6570\u636e\u4e5f\u8ba9\u6570\u636e\u5e93\u9884\u7559\u51fa\u7a7a\u95f4\uff0c\u51cf\u5c11\u4fee\u6539\u6570\u636e\u5236\u9020\u7684\u6570\u636e\u788e\u7247\u3002
\u5bf9\u8d85\u7ea7\u5927\u8868\u7684\u68c0\u7d22\u3001*** \u4f5c\uff0c\u4e3b\u8981\u9760\u7d22\u5f15\uff0c\u5982\u4f55\u5efa\u597d\u7d22\u5f15\u3001\u7528\u597d\u7d22\u5f15\u662f\u7cfb\u7edf\u5f00\u53d1\u4eba\u5458\u7684\u804c\u8d23\u3002\u8d85\u7ea7\u5927\u8868\u7684\u68c0\u7d22\u9996\u5148\u5e94\u8be5\u4e0e\u4e3b\u8868\u5206\u5728\u4e0d\u540c\u7684\u8868\u7a7a\u95f4\uff08\u6700\u597d\u662f\u4e0d\u540c\u7684\u5b58\u50a8\u4ecb\u8d28\uff09\uff0c\u5176\u6b21\u8d85\u7ea7\u5927\u8868\u7684\u68c0\u7d22\u4e5f\u4f1a\u5360\u5f88\u5927\u7684\u7a7a\u95f4\uff0c\u68c0\u7d22\u7684\u5b58\u50a8\u53c2\u6570\u4e5f\u662f\u8981\u8bbe\u5b9a\u597d\u7684\u3002
\u5bf9\u8d85\u7ea7\u5927\u8868\u800c\u8a00\uff0c\u4e00\u70b9\u70b9\u7ed3\u6784\u8bbe\u8ba1\u7684\u4e0d\u5408\u7406\uff0c\u751a\u81f3\u4e00\u53e5\u7cdf\u7cd5\u7684\u7a0b\u5e8f\u4ee3\u7801\u5c31\u53ef\u80fd\u4f7f\u6574\u4e2a\u7cfb\u7edf\u7684\u6027\u80fd\u8ba9\u4eba\u65e0\u6cd5\u5fcd\u53d7\u3002\u6709\u4e9b\u539f\u5219\u8981\u8bb0\u4f4f\uff1a\u5728\u8d85\u7ea7\u5927\u8868\u4e0a\uff0c\u4e0d\u8981\u5b58\u5728\u4e0e\u5176\u4ed6\u6570\u636e\u8868\u7684\u7ea6\u675f\u5173\u7cfb\uff0c\u7ea6\u675f\u5173\u7cfb\u53ef\u4ee5\u901a\u8fc7\u7a0b\u5e8f\u4ee3\u7801\u5b9e\u73b0\uff1b\u5bf9\u8d85\u7ea7\u5927\u8868\uff0c\u4e0d\u8981\u968f\u610f\u4e0e\u5176\u4ed6\u6570\u636e\u8868\u8fdb\u884c\u5173\u8054\uff0c\u9664\u975e\u901a\u8fc7\u4e3b\u952e\uff08\u81f3\u5c11\u662f\u7d22\u5f15\u5217\uff09\u5173\u8054\u4e14where\u6761\u4ef6\u80fd\u4f7f\u7528\u5230\u7d22\u5f15\uff1b
\u5982\u679c\u4f60\u7528\u5230\u4e86ORACLE 8\uff0c\u5bf9\u8d85\u7ea7\u5927\u8868\u8fdb\u884c\u5206\u533a\u662f\u975e\u5e38\u6709\u4ef7\u503c\u7684\u3002
\u91cd\u88c5Oracle\u670d\u52a1\u5668\u540e\uff0c\u6062\u590d\u4ee5\u524d\u7684\u6570\u636e\u7cfb\u7edf\u73af\u5883
1\u3001\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 2000 Server\uff0c\u673a\u5668\u5185\u5b58128M
2\u3001\u6570\u636e\u5e93\uff1a\u3000Oracle 8i R2 (8.1.6) for NT \u4f01\u4e1a\u7248
3\u3001\u5b89\u88c5\u8def\u5f84\uff1aC:\\ORACLE
\u8bf4\u660e\uff1a
\u6062\u590d\u7684\u524d\u63d0\u662f\u8981\u4fdd\u7559\u4ee5\u4e0b\u5168\u90e8\u6587\u4ef6\uff1a
\u521d\u59cb\u5316\u53c2\u6570\u6587\u4ef6INIT.ORA
\u6240\u6709\u6570\u636e\u6587\u4ef6
\u6240\u6709\u91cd\u505a\u65e5\u5fd7\u6587\u4ef6\uff08\u8054\u673a\u65e5\u5fd7\u3001\u5f52\u6863\u65e5\u5fd7\uff09
\u6240\u6709\u63a7\u5236\u6587\u4ef6
internal\u5bc6\u7801\u6587\u4ef6
\u6b65\u9aa4\uff1a
1\u3001\u91cd\u65b0\u5b89\u88c5\u6570\u636e\u5e93\u65f6\uff0c\u521b\u5efa\u548c\u539f\u6709\u6570\u636e\u5e93\u76f8\u540c\u7684\u540d\u5b57
2\u3001shutdown
3\u3001\u505c\u6389NT\u4e0a\u6240\u6709Oracle\u670d\u52a1\uff0c\u5220\u9664\u65b0\u5efa\u6570\u636e\u5e93\u4e2d\u7684\u6240\u6709\u65b0\u5efa\u6587\u4ef6\uff08\u548c\u4ee5\u4e0a\u90a3\u4e9b\u7c7b\u4f3c\u7684\u6587\u4ef6\uff09
4\u3001\u5c06\u6240\u6709\u4ee5\u4e0a\u6587\u4ef6\u62f7\u8d1d\u56de\u539f\u76ee\u5f55
5\u3001startup
\u65e5\u6587\u7cfb\u7edf\u6539\u6210\u82f1\u6587\u7684\u529e\u6cd5
\u5728\u6ce8\u518c\u8868\u4e2d\u6539\u4e00\u4e2a\u952e\u503c\u3002
\u5177\u4f53\u5982\u4e0b\uff1a\u628aHKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> HOME0 -> NLS_LANG \u7684\u5065\u503c\u6539\u6210 AMERICAN_AMERICA.WE8ISO8859P1\uff0c\u7136\u540e\u5c31\u6b63\u5e38\u4e86\u3002
\n\u4e0a\u4e00\u9875<\/a>1<\/a>2<\/a>3<\/a>4<\/a>5<\/strong>6<\/a>\u4e0b\u4e00\u9875<\/a>\u9605\u8bfb\u5168\u6587<\/a>\n<\/div>","4":"
ORA-04031\uff1aunable to allocate \u2026 byters of shared memory(\"shared pool\",\"unknown object\",\"sga heap\",\"db_block_buffers\")
\u95ee\u9898\uff1a
DELL\u670d\u52a1\u5668\u88c5\u4e0d\u4e0aORACLE8.1.5\u7684\u95ee\u9898\uff0c\u51fa\u73b0\u4e0b\u9762\u7684\u9519\u8bef\u63d0\u793a\u662f\u5728\u5efa\u7acb\u6570\u636e\u5e93\u4e4b\u524d\uff0c\u7cfb\u7edf\u5148\u8981\u68c0\u67e5\u5185\u5b58\u65f6\u51fa\u73b0\u7684\uff0c
ORA-04031:unable to allocate 85141440 byters of shared memory(\"shared pool\",\"unknown object\",\"sga heap\",\"db_block_buffers\")\uff0c\u662f\u4e0d\u662f\u5185\u5b58\u4e0d\u591f\uff1f\u4f46\u5b9e\u9645\u7269\u7406\u5185\u5b58\u662f2G?\u4ec0\u4e48\u539f\u56e0\u5462\uff1f
\u89e3\u7b54\uff1a
\u5728\u5b89\u88c5\u65f6\uff0c\u628aSGA\u533a\u3001JAVA\u6c60\u7b49\u4e1c\u897f\u7684\u5185\u5b58\u914d\u5c0f\u4e00\u4e9b
ORA-01092 : Oracle instance terminated disconnection forced\u9519\u8bef
Problem:
Your Oracle Server database on OpenVMS crashes. The following errors are reported: Background process DBWR unexpectedly terminated with error 1092
ORA-1092 Oracle instance terminated
ORA-313 open failed for members of log group 'n' of thread 'n'
ORA-600 [3228] reported from a PL\/SQL script.
Explanation:
The most significant error reported here is the ORA-313 error. This error indicates a failure to open a file which indicates a problem with OpenVMS resources. When either CHANNELCNT and\/or FILLM are too small, these errors can result.
Solution:
Increase the SYSGEN parameter CHANNELCNT. This should be done by an OpenVMS system manager and requires a reboot of your OpenVMS node. For more information on SYSGEN, please review the OpenVMS documentation.
If the CHANNELCNT parameter is already large enough to allow the expected number of files to be opened, check the FILLM quota. Review two areas when you check FILLM:
1) The Oracle background processes (PMON, DBWR, LGWR etc.)
2) The SERVER side (or SHADOW) process created when you use SVRMGRL to start the database. To get an idea of the quota available, use the command: $ SHOW PROCESS \/QUOTA \/ID=<pid> Where <pid> is the OpenVMS pid of the process to be reviewed. This command displays the remaining 'Open file quota' (FILLM) for the process, as well as other available quotas.
Example:
You have 226 data files, eight REDO log files and three control files for a total of 237 files. The SYSGEN setting for CHANNELCNT is at the default of 256. During normal operation, Oracle periodically needs to open additional files. These include the INIT parameter files, the ALERT log, various DCL scripts, trace files, etc. Under these conditions, a CHANNELCNT value of 256 is too small to accommodate the number of files that Oracle\/OpenVMS needs open at the same time.
For most systems the default quotas should be adequate.
If not, please describe the infor u've encountered
ORA-00059\u9519\u8bef\u53ca\u5b57\u7b26\u96c6\u4fee\u6539
\u95ee\u9898\uff1a\u5728DBA studio\u4e2d\u4e0b\u7684\u4f8b\u7a0b\u2018\u6570\u636e\u5e93'\u81ea\u52a8\u53d8\u4e3a\u5df2\u542f\u52a8\uff0c\u65e0\u6cd5\u88c5\u8f7d\u4e5f\u65e0\u6cd5\u6253\u5f00\uff0c\u63d0\u793a\u2018ORA-00059\uff1f\uff1fLOG--FILES\uff1f\uff1f\uff1f\uff1f'\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\u5982\u679c\u4e0d\u5378\u8f7d\u91cd\u88c5\u89e3\u51b3\uff0c\u80fd\u6709\u5176\u5b83\u7684\u529e\u6cd5\u5417\uff1f
\u4e00\u822c\u6765\u8bf4ORA-00059\u591a\u51fa\u73b0maximum number of DB_FILES exceeded\u7684\u9519\u8bef,\u7531\u4e8e\u4f60\u673a\u5668\u4e0a\u7684\u5b57\u7b26\u96c6\u8bbe\u7f6e\u6709\u4e9b\u95ee\u9898,\u6240\u4ee5 \u9519\u8bef\u63d0\u793a \u53d8\u6210\u4e86??,(\u5b57\u7b26\u96c6\u8bbe\u7f6e\u4e0d\u5bf9\u7167\u6210\u7684) \u867d\u7136\u770b\u7684\u51fa\u4e8e\u95ee\u9898\u53ef\u80fd\u548cLog file\u6709\u5173,\u4f46\u4e0d\u786e\u5b9a.\u8bf7\u4fee\u6539Oracle\u7684\u5b57\u7b26\u96c6
[\u5b57\u7b26\u96c6\u4fee\u6539\u65b9\u6cd5]
SQL> desc props$
\u5217\u540d \u53ef\u7a7a\u503c\u5426 \u7c7b\u578b
------------------------------- -------- ----
NAME NOT NULL VARCHAR2(30)
VALUE$ VARCHAR2(2000)
COMMENT$ VARCHAR2(2000)
SQL> col value$ format a40
SQL> select name,value$ from props$;
NAME VALUE$
------------------------------ -------------------------
DICT.BASE 2
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY$
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS.,
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_CALENDAR GREGORIAN
NLS_RDBMS_VERSION 7.3.4.0.0
GLOBAL_DB_NAME ORACLE.WORLD
EXPORT_VIEWS_VERSION 3
\u67e5\u8be2\u523014\u8bb0\u5f55.
NLS_CHARACTERSET\u8fd9\u4e2a\u53c2\u6570\u5e94\u8be5\u662fZHS16GBK\uff0c\u5982\u4e0d\u662f\uff0c\u6539\u4e3a\u5b83\u3002
ORA-12203:TNS:unable to connect destination\u9519\u8bef
\u95ee\u9898\uff1a
\u5728Windows2000\u4e0b\u5b89\u88c58.0.5\uff0c\u9009\u62e9none\uff0c\u6ca1\u6709\u5efa\u7acb\u5b9e\u4f8b\uff0c\u4e3a\u4ec0\u4e48\u5728\u6267\u884csvrmgr30 \u65f6\u62a5\u544aOra-12203:tns:unable to connect destination!
\u89e3\u7b54\uff1a
\u56e0\u4e3a\u6ca1\u6709\u521b\u5efa\u5b9e\u4f8b\uff0c\u4e5f\u5c31\u6ca1\u6709\u73af\u5883\u53d8\u91cf\u3002\u53ef\u53c2\u8003\u201c\u624b\u5de5\u521b\u5efa\u6570\u636e\u5e93\u7684\u5168\u90e8\u811a\u672c\u548c\u8bf4\u660e\u201d\u3002
\u6ce8\u610f\u5176\u4e2d\uff1a
set ORACLE_SID=test
D:\\Oracle\\Ora81\\bin\\oradim -new -sid test -startmode manual -pfile \"D:\\Oracle\\admin\\test\\pfile\\inittest.ora\"
Ora-12571\uff1aTNS\uff1a\u5305\u5199\u5165\u7a0b\u5e8f\u5931\u8d25
\u628a\u865a\u62df\u5185\u5b58\u8bbe\u7684\u5927\u4e00\u4e9b
Ora-12705\u9519\u8bef
Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.
Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.
ORA-03113\uff1a\u901a\u4fe1\u901a\u9053\u7684\u6587\u4ef6\u7ed3\u675f
Cause:
An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the SQL*Net, two task, software. This message could occur if the shadow two-task process associated with a SQL*Net connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.
Action:
If this message occurs during a connection attempt, check the setup files for the appropriate SQL*net driver and confirm SQL*Net software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.
Explanation:
There are numerous causes of this error. It is a 'catch all' type error which means 'I cannot communicate with the Oracle shadow process'. This usually occurs when the Oracle server process has died for some reason.
ORA-12515\uff1aTNS\uff1a\u76d1\u542c\u8fdb\u7a0b\u65e0\u6cd5\u627e\u5230\u8be5\u6f14\u793a\u6587\u7a3f\u7684\u53e5\u67c4
\u89e3\u51b3\u65b9\u6848\u662f\u68c0\u67e5\u76ee\u6807\u670d\u52a1\u5668\u7f51\u7edc\u914d\u7f6e\uff0c\u5e76\u4f7f\u5176\u63a5\u53d7HTTP\u7684\u534f\u8bae\u3002\u5982\u679c\u4f60\u662f\u4f7f\u7528\u4e00\u822c\u6570\u636e\u4f7f\u7528\uff0c\u5efa\u8bae\u4f7f\u7528\u65b0\u7684\u6570\u636e\u5e93\u5b9e\u4f8b\u3002
ORA-01031\uff1ainsufficient privileges
Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.
Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.
ORA-01017\uff1ainvalid username\/password; logon denied
Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username\/password.
Action: Enter a valid username and password combination in the correct format.
\u95ee\u9898\uff1aORACLE8.1.7.0.0\u7248\u672c\uff0c\uff0c\u4e0d\u77e5\u662f\u54ea\u91cc\u7684\u95ee\u9898\uff0c\u7528internal \u548c system \u90fd\u65e0\u6cd5\u767b\u9646\uff0c\u9519\u8bef\u63d0\u793a\uff1aORA1031 \u3001ORA1017
\u89e3\u7b54\uff1a\u8fd8\u6709\u6ca1\u6709\u5176\u4ed6DBA\u8eab\u4efd\u7684\u7528\u6237\uff0c\u5982\u679c\u6709\uff0c\u6700\u597d\u767b\u9646\u8fdb\u53bb\uff0c\u7136\u540ealter user system identified by YOURPASSWORD; \u4f60\u7684\u7cfb\u7edf\u5bc6\u7801\u88ab\u4eba\u4fee\u6539\u4e86
ORA-03121\uff1a\u6ca1\u8fde\u63a5\u63a5\u53e3\u9a71\u52a8\u7a0b\u5e8f
Cause: This message occurs usually because the Net8 driver is not loaded into memory or there is a mismatch of the version of the driver. A user program linked with an obsolete library may also cause this message. Only programs provided by Oracle Corporation should use this interface.
Action: If the message occurred during use of a program provided by Oracle Corporation, contact Oracle Support Services. If a user program caused the message, relink the program with current versions of the Oracle libraries.
ORA-12638\uff1a\u51ed\u8bc1\u68c0\u7d22\u5931\u8d25
\u95ee\u9898\uff1a
2000ad server SP2 \u5177\u57df\u7f51\uff0c\u5728\u7f51\u7edc\u8fde\u63a5\u7684\u60c5\u51b5\u4e0b\u6309\u88c5ORACLE8I\uff0c\u5230\u521b\u5efa\u6570\u636e\u5e93\uff0c\u521d\u59cb\u5316\u6570\u636e\u5e93\u65f6\uff0c\u63d0\u793a\u201cORA-12638 \u51ed\u8bc1\u68c0\u7d22\u5931\u8d25\u201d\uff0c\u88c5\u4e86\u51e0\u6b21\u90fd\u662f\u8fd9\u6837
\u89e3\u7b54\uff1a
\u51ed\u8bc1\u68c0\u7d22\u5931\u8d25\u7684\u9519\u8bef\u4e00\u822c\u90fd\u4e0e\u7f51\u7edc\u7528\u6237\u96c6\u6210\u6709\u5173\uff0cORACLE\u4e2d\u5bf9\u4e8e\u8fd9\u4e2a\u95ee\u9898\u7684\u7ba1\u7406\u662f\u5728SQLNET.ORA\u6587\u4ef6\u7684SQLNET.AUTHENTICATION_SERVICES\u8fdb\u884c\u63a7\u5236\u7684\uff0c\u9ed8\u8ba4\u5b89\u88c5\u90fd\u662fSQLNET.AUTHENTICATION_SERVICES= (NTS)\u8868\u793a\u5b89\u88c5ORACLE\u7684\u7528\u6237\u662f\u901a\u8fc7\u64cd\u4f5c\u7cfb\u7edf\u7684\u96c6\u6210\u8ba4\u8bc1\u63a7\u5236\u7684\uff0c\u6240\u4ee5\uff0c\u6211\u4eec\u53ea\u8981\u628a\u8fd9\u4e2a\u53c2\u6570\u503c\u5c4f\u853d\u6389\u5c31\u884c\u4e86\u3002
\u4fee\u6539\\Oracle\\Ora81\\network\\ADMIN\u76ee\u5f55\u4e0bSQLNET.ORA\u6587\u4ef6\u7684SQLNET.AUTHENTICATION_SERVICES= (NTS)\u4e3a# SQLNET.AUTHENTICATION_SERVICES= (NTS)
ORA-00604: error occurred at recursive SQL level 2
Cause: An error occurred while processing a recursive SQL statement (a statement applyingto internal dictionary tables).
Action: If the situation described in the next error on the stack can be corrected, do
so; otherwise contact Oracle Customer Support.
ORA-04030 out of process memory when trying to allocate string bytes (string,string)
Cause: Operating system process private memory has been exhausted.
Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.
ORA-04031\uff1aunable to allocate string bytes of shared memory(\"string\",\"string\",\"string\",\"string\")
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package topin large packages, reduce your use of shared memory, or increase the amount ofavailable shared memory by increasing the value of the initialization parametersSHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is out of memory,increase the initialization parameter LARGE_POOL_SIZE.
ORA-01555\uff1asnapshot too old: rollback segment number 9 with name \"USER_RS5\" too small
\u95ee\u9898\uff1a\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u6267\u884c\u7684\u6570\u636e\u5927\u6982\u6709100\u4e07\u6761\uff0c\u5728\u6267\u884c\u5230\u51e0\u5341\u4e07\u6761\u7684\u65f6\u5019\uff0c\u9047\u5230\u4e86\u5982\u4e0a\u5f02\u5e38\u3002
\u89e3\u7b54\uff1a\u539f\u56e0\u6709\u4e24\u4e2a\u65b9\u9762\uff1a
1\u3001\u7531\u4e8e\u4f60\u7684\u8fd9\u4e2a\u64cd\u4f5c\u6267\u884c\u7684\u65f6\u95f4\u592a\u957f\uff0c\u5bfc\u81f4SNAP SHOT\u5931\u6548\uff08\u592a\u8001\u4e86\uff09\uff0c\u5bfc\u81f4\u4f60\u7684\u64cd\u4f5c\u5931\u8d25\uff1b
2\u3001\u4f60\u7684RBS\u592a\u5c0f\uff0c\u65e0\u6cd5\u5bb9\u7eb3\u90a3\u4e48\u591a\u7684\u64cd\u4f5c\u3002
\u5904\u7406\u65b9\u6cd5\uff1a
1\u3001\u52a0\u5927\u56de\u6eda\u6bb5\u7684\u5927\u5c0f\uff08\u589e\u52a0RBS\u8868\u7a7a\u95f4\uff0c\u4fee\u6539\u56de\u6eda\u6bb5\u7684\u53c2\u6570\u7b49\uff09
2\u3001\u4f60\u8fd9\u79cd\u7f16\u7a0b\u65b9\u6cd5\u6709\u95ee\u9898\uff0c\u5982\u679c\u7b2c\u4e00\u4e2a\u65b9\u6cd5\u4e0d\u80fd\u89e3\u51b3\u95ee\u9898\uff0c\u8bf4\u660e\u662f\u56e0\u4e3a\u6267\u884c\u65f6\u95f4\u8fc7\u957f\uff0cSNAPSHOT\u5931\u6548\uff0c\u9700\u8981\u4f60\u8c03\u6574\u4e00\u4e0b\u7a0b\u5e8f\u3002\u662f\u4e0d\u662f\u5148\u628a100\u4e07\u8bb0\u5f55\u8bfb\u5230\u5185\u5b58\u91cc\uff08\u5185\u5b58\u4e0d\u591f\uff0c\u53ef\u4ee5\u91c7\u7528\u6587\u4ef6\u4f5c\u4e3a\u7f13\u51b2\uff09\uff0c\u7136\u540e\u518d\u505a\u5904\u7406\u3002\u4e5f\u53ef\u4ee5\u91c7\u7528\u5206\u6bb5\u5904\u7406\u7684\u65b9\u6cd5\uff0c\u4e00\u6b21\u5904\u740610\u4e07\u6761\u3002
ORA-01589\uff1amust use RESETLOGS or NORESETLOGS option for database open
\u95ee\u9898\uff1a\u5728startup \u4e4b\u540e\u51fa\u73b0\u9519\u8bef\u63d0\u793a
\u89e3\u7b54\uff1a
Cause: Either incomplete or backup control file recovery has been performed. After these types of recovery you must specify either the RESETLOGS option or the NORESETLOGS option to open your database.
Action: Specify the appropriate option.
\u4f60\u7684\u6570\u636e\u5e93\u4ee5\u524d\u505a\u8fc7Media Recovery\uff0c\u7528OPEN DATABASE RESETLOGS\u6216OPEN DATABASE NORESETLOGS\u6253\u5f00\u6570\u636e\u5e93\u5c31\u53ef\u4ee5\u4e86\u3002
ORA-01017\uff1ainvalid username\/password; logon denied
Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username\/password.
Action: Enter a valid username and password combination in the correct format.
\u7f3a\u7701\u5bc6\u7801
8i\uff1a
scott\/tiger
internal\/change_on_install
system\/manager
sys\/oralce(\u5bc6\u7801\u4e5f\u53ef\u80fd\u662fmanager\u6216change_on_install)
9i\uff1a
scott\/tiger
sys\/change_on_install
OEM\u7684\u7528\u6237\u540d\/\u5bc6\u7801\uff1asysman\/oem_temp
\u91cd\u8bbesystem\u7528\u6237\u7684\u5bc6\u7801
\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u65b9\u6cd5\u767b\u9646
sqlplus \/nolog
conn \/ as sysdba
alter user system identifed by '123'
Oracle\u7684\u5bc6\u7801\u6587\u4ef6
8i\u4e00\u822c\u4f4d\u4e8e$ORACLE_HOME\/PRODUCT\/8.1.6\/DBS\/ORAPWD_[SID].ORA
\u5982\u4f55\u6fc0\u6d3b\u7528\u6237
8i\uff1a\u5728DBA Studio\u91cc\u9762\uff0c\u6709\u201c\u7528\u6237\u201d--\u7136\u540e\u627e\u5230\u7528\u6237\u540d--->\u7136\u540e\u9009\u4e2d\u201c\u672a\u9501\u5b9a\u201d\u5c31\u53ef\u4ee5\u4e86
Oracle\u7684\u521d\u59cb\u5316\u6587\u4ef6
8i\uff1a\u5b89\u88c5\u65f6\u8bbe\u5b9a\u7684ORACLEHOME\u7684\u76ee\u5f55\u4e0b\u4f1a\u6709\uff1aadmin\u3001oradata\u548cora81\u4e09\u4e2a\u76ee\u5f55\uff0c\u5176\u4e2d\u5728admin\u76ee\u5f55\u4e0b\u7684\u4f60\u5b89\u88c5\u7684\u6570\u636e\u5e93\u76ee\u5f55\u4e0b\u7684Prfile\u4e0b\u7684init.ora\u5c31\u662f\u3002
9i\uff1a\u5728\u539f\u6765\u7684\u76ee\u5f55\u4e0b\u770b\u4e0d\u5230init\u6587\u4ef6\u4e86\u3002\u4e0d\u8fc7\u4f60\u53ef\u4ee5\u8fd9\u6837\uff1a
create pfile from spfile;
\u8fd9\u6837\u5c31\u53ef\u4ee5\u770b\u5230init\u7684\u6587\u4ef6\u4e86\uff0c\u56e0\u4e3a9i\u91cc\u9762\u7684\u521d\u59cb\u5316\u6587\u4ef6\u6709\u70b9\u53d8\u5316\u3002
Oracle \u6570\u636e\u5e93\u81ea\u5e26\u6570\u636e\u7684\u751f\u6210\u811a\u672c
\\ORACLE_HOME\\rdbms\\admin\\SCOTT.SQL
ORA-04031\uff1aunable to allocate \u2026 byters of shared memory(\"shared pool\",\"unknown object\",\"sga heap\",\"db_block_buffers\")
\u95ee\u9898\uff1a
DELL\u670d\u52a1\u5668\u88c5\u4e0d\u4e0aORACLE8.1.5\u7684\u95ee\u9898\uff0c\u51fa\u73b0\u4e0b\u9762\u7684\u9519\u8bef\u63d0\u793a\u662f\u5728\u5efa\u7acb\u6570\u636e\u5e93\u4e4b\u524d\uff0c\u7cfb\u7edf\u5148\u8981\u68c0\u67e5\u5185\u5b58\u65f6\u51fa\u73b0\u7684\uff0c
ORA-04031:unable to allocate 85141440 byters of shared memory(\"shared pool\",\"unknown object\",\"sga heap\",\"db_block_buffers\")\uff0c\u662f\u4e0d\u662f\u5185\u5b58\u4e0d\u591f\uff1f\u4f46\u5b9e\u9645\u7269\u7406\u5185\u5b58\u662f2G?\u4ec0\u4e48\u539f\u56e0\u5462\uff1f
\u89e3\u7b54\uff1a
\u5728\u5b89\u88c5\u65f6\uff0c\u628aSGA\u533a\u3001JAVA\u6c60\u7b49\u4e1c\u897f\u7684\u5185\u5b58\u914d\u5c0f\u4e00\u4e9b
ORA-01092 : Oracle instance terminated disconnection forced\u9519\u8bef
Problem:
Your Oracle Server database on OpenVMS crashes. The following errors are reported: Background process DBWR unexpectedly terminated with error 1092
ORA-1092 Oracle instance terminated
ORA-313 open failed for members of log group 'n' of thread 'n'
ORA-600 [3228] reported from a PL\/SQL script.
Explanation:
The most significant error reported here is the ORA-313 error. This error indicates a failure to open a file which indicates a problem with OpenVMS resources. When either CHANNELCNT and\/or FILLM are too small, these errors can result.
Solution:
Increase the SYSGEN parameter CHANNELCNT. This should be done by an OpenVMS system manager and requires a reboot of your OpenVMS node. For more information on SYSGEN, please review the OpenVMS documentation.
If the CHANNELCNT parameter is already large enough to allow the expected number of files to be opened, check the FILLM quota. Review two areas when you check FILLM:
1) The Oracle background processes (PMON, DBWR, LGWR etc.)
2) The SERVER side (or SHADOW) process created when you use SVRMGRL to start the database. To get an idea of the quota available, use the command: $ SHOW PROCESS \/QUOTA \/ID=<pid> Where <pid> is the OpenVMS pid of the process to be reviewed. This command displays the remaining 'Open file quota' (FILLM) for the process, as well as other available quotas.
Example:
You have 226 data files, eight REDO log files and three control files for a total of 237 files. The SYSGEN setting for CHANNELCNT is at the default of 256. During normal operation, Oracle periodically needs to open additional files. These include the INIT parameter files, the ALERT log, various DCL scripts, trace files, etc. Under these conditions, a CHANNELCNT value of 256 is too small to accommodate the number of files that Oracle\/OpenVMS needs open at the same time.
For most systems the default quotas should be adequate.
If not, please describe the infor u've encountered
ORA-00059\u9519\u8bef\u53ca\u5b57\u7b26\u96c6\u4fee\u6539
\u95ee\u9898\uff1a\u5728DBA studio\u4e2d\u4e0b\u7684\u4f8b\u7a0b\u2018\u6570\u636e\u5e93'\u81ea\u52a8\u53d8\u4e3a\u5df2\u542f\u52a8\uff0c\u65e0\u6cd5\u88c5\u8f7d\u4e5f\u65e0\u6cd5\u6253\u5f00\uff0c\u63d0\u793a\u2018ORA-00059\uff1f\uff1fLOG--FILES\uff1f\uff1f\uff1f\uff1f'\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\u5982\u679c\u4e0d\u5378\u8f7d\u91cd\u88c5\u89e3\u51b3\uff0c\u80fd\u6709\u5176\u5b83\u7684\u529e\u6cd5\u5417\uff1f
\u4e00\u822c\u6765\u8bf4ORA-00059\u591a\u51fa\u73b0maximum number of DB_FILES exceeded\u7684\u9519\u8bef,\u7531\u4e8e\u4f60\u673a\u5668\u4e0a\u7684\u5b57\u7b26\u96c6\u8bbe\u7f6e\u6709\u4e9b\u95ee\u9898,\u6240\u4ee5 \u9519\u8bef\u63d0\u793a \u53d8\u6210\u4e86??,(\u5b57\u7b26\u96c6\u8bbe\u7f6e\u4e0d\u5bf9\u7167\u6210\u7684) \u867d\u7136\u770b\u7684\u51fa\u4e8e\u95ee\u9898\u53ef\u80fd\u548cLog file\u6709\u5173,\u4f46\u4e0d\u786e\u5b9a.\u8bf7\u4fee\u6539Oracle\u7684\u5b57\u7b26\u96c6
[\u5b57\u7b26\u96c6\u4fee\u6539\u65b9\u6cd5]
SQL> desc props$
\u5217\u540d \u53ef\u7a7a\u503c\u5426 \u7c7b\u578b
------------------------------- -------- ----
NAME NOT NULL VARCHAR2(30)
VALUE$ VARCHAR2(2000)
COMMENT$ VARCHAR2(2000)
SQL> col value$ format a40
SQL> select name,value$ from props$;
NAME VALUE$
------------------------------ -------------------------
DICT.BASE 2
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY$
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS.,
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_CALENDAR GREGORIAN
NLS_RDBMS_VERSION 7.3.4.0.0
GLOBAL_DB_NAME ORACLE.WORLD
EXPORT_VIEWS_VERSION 3
\u67e5\u8be2\u523014\u8bb0\u5f55.
NLS_CHARACTERSET\u8fd9\u4e2a\u53c2\u6570\u5e94\u8be5\u662fZHS16GBK\uff0c\u5982\u4e0d\u662f\uff0c\u6539\u4e3a\u5b83\u3002
ORA-12203:TNS:unable to connect destination\u9519\u8bef
\u95ee\u9898\uff1a
\u5728Windows2000\u4e0b\u5b89\u88c58.0.5\uff0c\u9009\u62e9none\uff0c\u6ca1\u6709\u5efa\u7acb\u5b9e\u4f8b\uff0c\u4e3a\u4ec0\u4e48\u5728\u6267\u884csvrmgr30 \u65f6\u62a5\u544aOra-12203:tns:unable to connect destination!
\u89e3\u7b54\uff1a
\u56e0\u4e3a\u6ca1\u6709\u521b\u5efa\u5b9e\u4f8b\uff0c\u4e5f\u5c31\u6ca1\u6709\u73af\u5883\u53d8\u91cf\u3002\u53ef\u53c2\u8003\u201c\u624b\u5de5\u521b\u5efa\u6570\u636e\u5e93\u7684\u5168\u90e8\u811a\u672c\u548c\u8bf4\u660e\u201d\u3002
\u6ce8\u610f\u5176\u4e2d\uff1a
set ORACLE_SID=test
D:\\Oracle\\Ora81\\bin\\oradim -new -sid test -startmode manual -pfile \"D:\\Oracle\\admin\\test\\pfile\\inittest.ora\"
Ora-12571\uff1aTNS\uff1a\u5305\u5199\u5165\u7a0b\u5e8f\u5931\u8d25
\u628a\u865a\u62df\u5185\u5b58\u8bbe\u7684\u5927\u4e00\u4e9b
Ora-12705\u9519\u8bef
Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.
Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.
ORA-03113\uff1a\u901a\u4fe1\u901a\u9053\u7684\u6587\u4ef6\u7ed3\u675f
Cause:
An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the SQL*Net, two task, software. This message could occur if the shadow two-task process associated with a SQL*Net connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.
Action:
If this message occurs during a connection attempt, check the setup files for the appropriate SQL*net driver and confirm SQL*Net software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.
Explanation:
There are numerous causes of this error. It is a 'catch all' type error which means 'I cannot communicate with the Oracle shadow process'. This usually occurs when the Oracle server process has died for some reason.
ORA-12515\uff1aTNS\uff1a\u76d1\u542c\u8fdb\u7a0b\u65e0\u6cd5\u627e\u5230\u8be5\u6f14\u793a\u6587\u7a3f\u7684\u53e5\u67c4
\u89e3\u51b3\u65b9\u6848\u662f\u68c0\u67e5\u76ee\u6807\u670d\u52a1\u5668\u7f51\u7edc\u914d\u7f6e\uff0c\u5e76\u4f7f\u5176\u63a5\u53d7HTTP\u7684\u534f\u8bae\u3002\u5982\u679c\u4f60\u662f\u4f7f\u7528\u4e00\u822c\u6570\u636e\u4f7f\u7528\uff0c\u5efa\u8bae\u4f7f\u7528\u65b0\u7684\u6570\u636e\u5e93\u5b9e\u4f8b\u3002
ORA-01031\uff1ainsufficient privileges
Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.
Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.
ORA-01017\uff1ainvalid username\/password; logon denied
Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username\/password.
Action: Enter a valid username and password combination in the correct format.
\u95ee\u9898\uff1aORACLE8.1.7.0.0\u7248\u672c\uff0c\uff0c\u4e0d\u77e5\u662f\u54ea\u91cc\u7684\u95ee\u9898\uff0c\u7528internal \u548c system \u90fd\u65e0\u6cd5\u767b\u9646\uff0c\u9519\u8bef\u63d0\u793a\uff1aORA1031 \u3001ORA1017
\u89e3\u7b54\uff1a\u8fd8\u6709\u6ca1\u6709\u5176\u4ed6DBA\u8eab\u4efd\u7684\u7528\u6237\uff0c\u5982\u679c\u6709\uff0c\u6700\u597d\u767b\u9646\u8fdb\u53bb\uff0c\u7136\u540ealter user system identified by YOURPASSWORD; \u4f60\u7684\u7cfb\u7edf\u5bc6\u7801\u88ab\u4eba\u4fee\u6539\u4e86
ORA-03121\uff1a\u6ca1\u8fde\u63a5\u63a5\u53e3\u9a71\u52a8\u7a0b\u5e8f
Cause: This message occurs usually because the Net8 driver is not loaded into memory or there is a mismatch of the version of the driver. A user program linked with an obsolete library may also cause this message. Only programs provided by Oracle Corporation should use this interface.
Action: If the message occurred during use of a program provided by Oracle Corporation, contact Oracle Support Services. If a user program caused the message, relink the program with current versions of the Oracle libraries.
ORA-12638\uff1a\u51ed\u8bc1\u68c0\u7d22\u5931\u8d25
\u95ee\u9898\uff1a
2000ad server SP2 \u5177\u57df\u7f51\uff0c\u5728\u7f51\u7edc\u8fde\u63a5\u7684\u60c5\u51b5\u4e0b\u6309\u88c5ORACLE8I\uff0c\u5230\u521b\u5efa\u6570\u636e\u5e93\uff0c\u521d\u59cb\u5316\u6570\u636e\u5e93\u65f6\uff0c\u63d0\u793a\u201cORA-12638 \u51ed\u8bc1\u68c0\u7d22\u5931\u8d25\u201d\uff0c\u88c5\u4e86\u51e0\u6b21\u90fd\u662f\u8fd9\u6837
\u89e3\u7b54\uff1a
\u51ed\u8bc1\u68c0\u7d22\u5931\u8d25\u7684\u9519\u8bef\u4e00\u822c\u90fd\u4e0e\u7f51\u7edc\u7528\u6237\u96c6\u6210\u6709\u5173\uff0cORACLE\u4e2d\u5bf9\u4e8e\u8fd9\u4e2a\u95ee\u9898\u7684\u7ba1\u7406\u662f\u5728SQLNET.ORA\u6587\u4ef6\u7684SQLNET.AUTHENTICATION_SERVICES\u8fdb\u884c\u63a7\u5236\u7684\uff0c\u9ed8\u8ba4\u5b89\u88c5\u90fd\u662fSQLNET.AUTHENTICATION_SERVICES= (NTS)\u8868\u793a\u5b89\u88c5ORACLE\u7684\u7528\u6237\u662f\u901a\u8fc7\u64cd\u4f5c\u7cfb\u7edf\u7684\u96c6\u6210\u8ba4\u8bc1\u63a7\u5236\u7684\uff0c\u6240\u4ee5\uff0c\u6211\u4eec\u53ea\u8981\u628a\u8fd9\u4e2a\u53c2\u6570\u503c\u5c4f\u853d\u6389\u5c31\u884c\u4e86\u3002
\u4fee\u6539\\Oracle\\Ora81\\network\\ADMIN\u76ee\u5f55\u4e0bSQLNET.ORA\u6587\u4ef6\u7684SQLNET.AUTHENTICATION_SERVICES= (NTS)\u4e3a# SQLNET.AUTHENTICATION_SERVICES= (NTS)
ORA-00604: error occurred at recursive SQL level 2
Cause: An error occurred while processing a recursive SQL statement (a statement applyingto internal dictionary tables).
Action: If the situation described in the next error on the stack can be corrected, do
so; otherwise contact Oracle Customer Support.
ORA-04030 out of process memory when trying to allocate string bytes (string,string)
Cause: Operating system process private memory has been exhausted.
Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.
ORA-04031\uff1aunable to allocate string bytes of shared memory(\"string\",\"string\",\"string\",\"string\")
Cause: More shared memory is needed than was allocated in the shared pool.
Action: If the shared pool is out of memory, either use the DBMS_SHARED_POOL package topin large packages, reduce your use of shared memory, or increase the amount ofavailable shared memory by increasing the value of the initialization parametersSHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is out of memory,increase the initialization parameter LARGE_POOL_SIZE.
ORA-01555\uff1asnapshot too old: rollback segment number 9 with name \"USER_RS5\" too small
\u95ee\u9898\uff1a\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u6267\u884c\u7684\u6570\u636e\u5927\u6982\u6709100\u4e07\u6761\uff0c\u5728\u6267\u884c\u5230\u51e0\u5341\u4e07\u6761\u7684\u65f6\u5019\uff0c\u9047\u5230\u4e86\u5982\u4e0a\u5f02\u5e38\u3002
\u89e3\u7b54\uff1a\u539f\u56e0\u6709\u4e24\u4e2a\u65b9\u9762\uff1a
1\u3001\u7531\u4e8e\u4f60\u7684\u8fd9\u4e2a\u64cd\u4f5c\u6267\u884c\u7684\u65f6\u95f4\u592a\u957f\uff0c\u5bfc\u81f4SNAP SHOT\u5931\u6548\uff08\u592a\u8001\u4e86\uff09\uff0c\u5bfc\u81f4\u4f60\u7684\u64cd\u4f5c\u5931\u8d25\uff1b
2\u3001\u4f60\u7684RBS\u592a\u5c0f\uff0c\u65e0\u6cd5\u5bb9\u7eb3\u90a3\u4e48\u591a\u7684\u64cd\u4f5c\u3002
\u5904\u7406\u65b9\u6cd5\uff1a
1\u3001\u52a0\u5927\u56de\u6eda\u6bb5\u7684\u5927\u5c0f\uff08\u589e\u52a0RBS\u8868\u7a7a\u95f4\uff0c\u4fee\u6539\u56de\u6eda\u6bb5\u7684\u53c2\u6570\u7b49\uff09
2\u3001\u4f60\u8fd9\u79cd\u7f16\u7a0b\u65b9\u6cd5\u6709\u95ee\u9898\uff0c\u5982\u679c\u7b2c\u4e00\u4e2a\u65b9\u6cd5\u4e0d\u80fd\u89e3\u51b3\u95ee\u9898\uff0c\u8bf4\u660e\u662f\u56e0\u4e3a\u6267\u884c\u65f6\u95f4\u8fc7\u957f\uff0cSNAPSHOT\u5931\u6548\uff0c\u9700\u8981\u4f60\u8c03\u6574\u4e00\u4e0b\u7a0b\u5e8f\u3002\u662f\u4e0d\u662f\u5148\u628a100\u4e07\u8bb0\u5f55\u8bfb\u5230\u5185\u5b58\u91cc\uff08\u5185\u5b58\u4e0d\u591f\uff0c\u53ef\u4ee5\u91c7\u7528\u6587\u4ef6\u4f5c\u4e3a\u7f13\u51b2\uff09\uff0c\u7136\u540e\u518d\u505a\u5904\u7406\u3002\u4e5f\u53ef\u4ee5\u91c7\u7528\u5206\u6bb5\u5904\u7406\u7684\u65b9\u6cd5\uff0c\u4e00\u6b21\u5904\u740610\u4e07\u6761\u3002
ORA-01589\uff1amust use RESETLOGS or NORESETLOGS option for database open
\u95ee\u9898\uff1a\u5728startup \u4e4b\u540e\u51fa\u73b0\u9519\u8bef\u63d0\u793a
\u89e3\u7b54\uff1a
Cause: Either incomplete or backup control file recovery has been performed. After these types of recovery you must specify either the RESETLOGS option or the NORESETLOGS option to open your database.
Action: Specify the appropriate option.
\u4f60\u7684\u6570\u636e\u5e93\u4ee5\u524d\u505a\u8fc7Media Recovery\uff0c\u7528OPEN DATABASE RESETLOGS\u6216OPEN DATABASE NORESETLOGS\u6253\u5f00\u6570\u636e\u5e93\u5c31\u53ef\u4ee5\u4e86\u3002
ORA-01017\uff1ainvalid username\/password; logon denied
Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username\/password.
Action: Enter a valid username and password combination in the correct format.
\u7f3a\u7701\u5bc6\u7801
8i\uff1a
scott\/tiger
internal\/change_on_install
system\/manager
sys\/oralce(\u5bc6\u7801\u4e5f\u53ef\u80fd\u662fmanager\u6216change_on_install)
9i\uff1a
scott\/tiger
sys\/change_on_install
OEM\u7684\u7528\u6237\u540d\/\u5bc6\u7801\uff1asysman\/oem_temp
\u91cd\u8bbesystem\u7528\u6237\u7684\u5bc6\u7801
\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u65b9\u6cd5\u767b\u9646
sqlplus \/nolog
conn \/ as sysdba
alter user system identifed by '123'
Oracle\u7684\u5bc6\u7801\u6587\u4ef6
8i\u4e00\u822c\u4f4d\u4e8e$ORACLE_HOME\/PRODUCT\/8.1.6\/DBS\/ORAPWD_[SID].ORA
\u5982\u4f55\u6fc0\u6d3b\u7528\u6237
8i\uff1a\u5728DBA Studio\u91cc\u9762\uff0c\u6709\u201c\u7528\u6237\u201d--\u7136\u540e\u627e\u5230\u7528\u6237\u540d--->\u7136\u540e\u9009\u4e2d\u201c\u672a\u9501\u5b9a\u201d\u5c31\u53ef\u4ee5\u4e86
Oracle\u7684\u521d\u59cb\u5316\u6587\u4ef6
8i\uff1a\u5b89\u88c5\u65f6\u8bbe\u5b9a\u7684ORACLEHOME\u7684\u76ee\u5f55\u4e0b\u4f1a\u6709\uff1aadmin\u3001oradata\u548cora81\u4e09\u4e2a\u76ee\u5f55\uff0c\u5176\u4e2d\u5728admin\u76ee\u5f55\u4e0b\u7684\u4f60\u5b89\u88c5\u7684\u6570\u636e\u5e93\u76ee\u5f55\u4e0b\u7684Prfile\u4e0b\u7684init.ora\u5c31\u662f\u3002
9i\uff1a\u5728\u539f\u6765\u7684\u76ee\u5f55\u4e0b\u770b\u4e0d\u5230init\u6587\u4ef6\u4e86\u3002\u4e0d\u8fc7\u4f60\u53ef\u4ee5\u8fd9\u6837\uff1a
create pfile from spfile;
\u8fd9\u6837\u5c31\u53ef\u4ee5\u770b\u5230init\u7684\u6587\u4ef6\u4e86\uff0c\u56e0\u4e3a9i\u91cc\u9762\u7684\u521d\u59cb\u5316\u6587\u4ef6\u6709\u70b9\u53d8\u5316\u3002
Oracle \u6570\u636e\u5e93\u81ea\u5e26\u6570\u636e\u7684\u751f\u6210\u811a\u672c
\\ORACLE_HOME\\rdbms\\admin\\SCOTT.SQL
\n\u4e0a\u4e00\u9875<\/a>1<\/a>2<\/a>3<\/a>4<\/strong>5<\/a>6<\/a>\u4e0b\u4e00\u9875<\/a>\u9605\u8bfb\u5168\u6587<\/a>\n<\/div>","6":"
Oracle 9i AS\u5b89\u88c5\u9519\u8bef
\u89e3\u51b3\uff1a\u6309\u7167\u5b83\u7684\u63d0\u793a\u7f16\u8f91host\u6587\u4ef6\uff0c\u52a0\u4e0a127.0.0.1 localhost #localhost
spfile \u548c pfile\u5f02\u540c
spfile\uff0c\u670d\u52a1\u5668\u53c2\u6570\u6587\u4ef6\u662f\u5728Oracle9i\u53ca\u66f4\u9ad8\u7248\u672c\u4e2d\u4e00\u4e2a\u65b0\u7279\u6027\u3002\u5176\u4f7fOracle9i\u53ef\u4ee5\u66f4\u6539\u5927\u591a\u6570\u8fc7\u53bb\u5728\u4f7f\u7528\u6570\u636e\u5e93\u8054\u673a\u548c\u7528\u6237\u65f6\u4e0d\u80fd\u52a8\u6001\u66f4\u6539\u7684\u521d\u59cb\u5316\u53c2\u6570\u3002\u6b64\u5916\uff0c\u670d\u52a1\u5668\u53c2\u6570\u6587\u4ef6\u4f7fOracle9i\u80fd\u8bb0\u4f4f\u4f1a\u8bdd\u4e4b\u95f4\u52a8\u6001\u66f4\u6539\u8fc7\u7684\u521d\u59cb\u5316\u53c2\u6570\u7684\u8bbe\u7f6e\u3002
pfile\uff0c\u76f8\u5f53\u4e0eOracle8i\u53ca\u4ee5\u524d\u7248\u672c\u7684Init.ora\u3002
\u53ef\u4ee5\u6839\u636epfile\u5efa\u7acbspfile\uff1a\u5982\uff1acreate spfile from pfile \uff1d\u2018\u8def\u5f84\/init.ora'
\u6570\u636e\u5e93\u5347\u7ea7\u9519\u8bef\u2014\u2014\u4e0d\u76f8\u5173\u7684\u5b57\u7b26\u96c6
\u6570\u636e\u5e93\u4eceOracle8.0.5\u5347\u7ea7\u52308.1.5\uff0c\u5907\u4efd\u6570\u636e\u6062\u590d\u65f6\u51fa\u73b0\u9519\u8bef\u3002\u9519\u8bef\u63d0\u793a\uff1a\u4e0d\u76f8\u5173\u7684\u5b57\u7b26\u96c6\uff08805\u5230820\uff09
1\u3001\u91cd\u5efaOracle 8i\u6570\u636e\u5e93\uff0c\u5efa\u5e93\u65f6\u6307\u5b9a\u540c\u4e00\u5b57\u7b26\u96c6\uff0c\u518d\u79fb\u690d\uff1b \u67e5\u770b\u539f\u6570\u636e\u5e93\u5b57\u7b26\u96c6\uff0c select * from nls_database_parameters
2\u3001\u8bbe\u7f6e\u539f\u6570\u636e\u5e93Oracle 805 \u7684\u73af\u5883\u53d8\u91cfNLS_LANG\u4e0eora 8i\u6570\u636e\u5e93\u4e00\u81f4\uff0c\u6267\u884cexport\u65f6\u53ef\u4ee5\u8f6c\u6362\u5b57\u7b26\u96c6\u3002
3\u3001exp \u4e0e imp \u6700\u597d\u90fd\u4f7f\u7528Oracle 816 \u5e26\u7684\uff0c\u4e0d\u8981\u7528Oracle 805 \u7684exp \u5bfc\u51fa\u7684dmp \u6587\u4ef6\uff0c\u53c8\u7528Oracle 816 \u7684 imp \u6765\u5bfc\u3002
\u542f\u52a8 iSQL*Plus
\u8981\u542f\u52a8 iSQL*Plus\uff0c\u8bf7\u6267\u884c\u4ee5\u4e0b\u6b65\u9aa4\uff1a
\u8fde\u63a5\u5230 Internet \u6216 Intranet\uff0c\u7136\u540e\u542f\u52a8 Web \u6d4f\u89c8\u5668\u3002\u5728 Web \u6d4f\u89c8\u5668\u7684\u201c\u4f4d\u7f6e\u201d\u5b57\u6bb5\u6216\u201c\u5730\u5740\u201d\u5b57\u6bb5\u4e2d\uff0c\u8f93\u5165 Oracle9i HTTP Server URL\uff0c\u5e76\u63a5\u7740\u8f93\u5165 isqlplus\u3002iSQL*Plus URL \u5982\u4e0b\u6240\u793a\uff1ahttp:\/\/machine_name.domain:7777\/isqlplus
\u5982\u679c\u60a8\u4e0d\u77e5\u9053 Oracle9i HTTP Server URL\uff0c\u8bf7\u5411\u7cfb\u7edf\u7ba1\u7406\u5458\u54a8\u8be2\u3002
\u6309 Enter \u952e\u5c06\u8f6c\u5230\u8be5 URL\u3002Web \u6d4f\u89c8\u5668\u4e2d\u5c06\u663e\u793a iSQL*Plus\u201c\u767b\u5f55\u201d\u5c4f\u5e55\u3002
\u5728\u201c\u7528\u6237\u540d\u201d\u5b57\u6bb5\u548c\u201c\u53e3\u4ee4\u201d\u5b57\u6bb5\u4e2d\uff0c\u8f93\u5165 Oracle9i \u7528\u6237\u540d\u548c\u53e3\u4ee4\u3002\u5982\u679c\u60a8\u4e0d\u77e5\u9053 Oracle9i \u7528\u6237\u540d\u548c\u53e3\u4ee4\uff0c\u8bf7\u5411\u6570\u636e\u5e93\u7ba1\u7406\u5458\u54a8\u8be2\u3002
\u5c06\u201c\u8fde\u63a5\u6807\u8bc6\u7b26\u201d\u5b57\u6bb5\u4fdd\u7559\u4e3a\u7a7a\u53ef\u4ee5\u8fde\u63a5\u5230\u9ed8\u8ba4\u6570\u636e\u5e93\u3002\u8f93\u5165 Oracle Net \u6570\u636e\u5e93\u522b\u540d\u65f6\uff0c\u53ef\u4ee5\u8fde\u63a5\u5230\u9ed8\u8ba4\u6570\u636e\u5e93\u4ee5\u5916\u7684\u5176\u4ed6\u6570\u636e\u5e93\u3002\u5982\u679c\u5df2\u914d\u7f6e\u4e86\u9650\u5236\u7684\u6570\u636e\u5e93\u8bbf\u95ee\uff0c\u201c\u8fde\u63a5\u6807\u8bc6\u7b26\u201d\u5b57\u6bb5\u5c31\u4f1a\u53d8\u6210\u53ef\u4f9b\u9009\u62e9\u7684\u53ef\u7528\u6570\u636e\u5e93\u7684\u4e0b\u62c9\u5217\u8868\u3002
\u5355\u51fb\u201c\u767b\u5f55\u201d\uff0c\u8fde\u63a5\u5230\u76f8\u5173\u6570\u636e\u5e93\u3002Web \u6d4f\u89c8\u5668\u4e0a\u5c06\u4f1a\u663e\u793a iSQL*Plus\u201c\u5de5\u4f5c\u5c4f\u5e55\u201d\u3002
\u6b64\u65f6\uff0c\u60a8\u53ef\u4ee5\u5728\u201c\u5de5\u4f5c\u5c4f\u5e55\u201d\u7684\u8f93\u5165\u533a\u57df\u4e2d\u8f93\u5165\u5e76\u6267\u884c SQL\u3001PL\/SQL \u548c SQL*Plus \u8bed\u53e5\u548c\u547d\u4ee4\u3002
Oracle 816\u4e2d\u542f\u52a8Enterprise Manager
\u7cfb\u7edf\u73af\u5883\uff1a
1\u3001\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 2000
2\u3001\u6570\u636e\u5e93\uff1a\u3000Oracle 8i R2 (8.1.6) for NT \u4f01\u4e1a\u7248
3\u3001\u5b89\u88c5\u8def\u5f84\uff1aC:\\ORACLE
\u9519\u8bef\u73b0\u8c61\uff1a
\u9ed8\u8ba4\u5b89\u88c5\u5b8cOracle 816 for NT\u540e\uff0c\u60f3\u4f7f\u7528Oracle816 for NT\u7684OEM\u5de5\u5177\u6765\u7ba1\u7406\u6570\u636e\u5e93\uff0c\u5f00\u59cb\u2192\u7a0b\u5e8f\u2192Oracle - OraHome81\u2192Enterprise Manager\u2192Console\u3002\u8fd9\u65f6\u7cfb\u7edf\u51fa\u73b0\u4ee5\u4e0b\u753b\u9762\u4e00\uff1a
\u70b9\u51fb\u201c\u786e\u5b9a\u201d\uff0c\u51fa\u73b0\u753b\u9762\u4e8c\u3001\u4e09\u3002
\u5728\u201c\u6dfb\u52a0\u7ba1\u7406\u670d\u52a1\u5668\u201d\u680f\u4e0a\u8f93\u5165\u672c\u673aIP\u5730\u5740\uff0c\u5982\uff1a192.1.1.1\uff0c\u70b9\u51fb\u201c\u786e\u5b9a\u201d\uff0c\u51fa\u73b0\u753b\u9762\u56db\u3002
\u753b\u9762\u663e\u793a\u51fa\u7684oradb\u5c31\u4f7f\u672c\u673a\u540d\u79f0\uff0c\u70b9\u51fb\u201c\u786e\u5b9a\u201d\uff0c\u51fa\u73b0\u753b\u9762\u4e94\uff0c\u8fdb\u884c\u201cOracle Enterprise Manager \u767b\u5f55\u201d\u3002
\u8f93\u5165\u53e3\u4ee4\/\u5bc6\u7801\uff1asystem\/manager\uff0c\u70b9\u51fb\u201c\u786e\u5b9a\u201d\uff0c\u51fa\u73b0\u753b\u9762\u516d\uff0c\u51fa\u73b0\u4ee5\u4e0b\u9519\u8bef\u63d0\u793a\u3002
VTK-1000 : Unable to connect to the management server oradb. Please vertify that you have entered the correct host name nd the status of the Oracle Managerment Server.\u89e3\u51b3\u65b9\u6cd5\uff1a
1\u3001\u4f7f\u7528Enterprise Manager\u914d\u7f6e\u8f85\u52a9\u5de5\u5177
\u5f00\u59cb\u2192\u7a0b\u5e8f\u2192Oracle - OraHome81\u2192Enterprise Manager\u2192Configuration Assistant
a\u3001\u4f7f\u7528Configuration Assistant\u5de5\u5177\u6765\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u8d44\u6599\u6863\u6848\u5e93\uff0c\u5982\u56fe\u4e03\u3002
\u5355\u51fb\u201c\u4e0b\u4e00\u6b65\u201d\uff0c\u51fa\u73b0\u753b\u9762\u516b\u3002
b\u3001 \u5148\u767b\u5f55 \u7528\u6237\u540d\uff1asystem\uff0c\u5bc6\u7801\uff1amanager\uff0c\u670d\u52a1\uff1aoradb\uff0c\u6ce8\uff1a\u8f93\u5165\u7684\u7528\u6237\u5fc5\u987b\u5177\u6709DBA\u6743\u9650\uff0c\u5355\u51fb\u201c\u4e0b\u4e00\u6b65\u201d\uff0c\u51fa\u73b0\u753b\u9762\u4e5d\u3002\uff089i\u4e3asysman\/oem_temp\uff09
c\u3001\u518d\u521b\u5efa\u62e5\u6709\u6b64\u8d44\u6599\u6863\u6848\u5e93\u7684\u7528\u6237\uff0c\u7cfb\u7edf\u9ed8\u8ba4\u53d6\u673a\u5668\u540d\uff0c\u8fd9\u91cc\u6211\u4eec\u8bbe\u7528\u6237\u540d\u4e3a\uff1atest\uff0c\u5bc6\u7801\uff1atest,\u8f93\u5165\u4e24\u904d\u53e3\u4ee4\uff0c\u5355\u51fb\u201c\u4e0b\u4e00\u6b65\u201d\uff0c\u51fa\u73b0\u753b\u9762\u5341\u3002
d\u3001\u56e0\u4e3a\u8f93\u5165\u7684\u662f\u4e00\u4e2a\u65b0\u7528\u6237\uff0c\u7cfb\u7edf\u8981\u6c42\u6307\u5b9a\u7528\u6237\u8868\u7a7a\u95f4\uff0c\u672c\u4f8b\u4f7f\u7528\u7cfb\u7edf\u63a8\u8350\uff0c
\u5355\u51fb\u201c\u4e0b\u4e00\u6b65\u201d\uff0c\u7cfb\u7edf\u6b63\u5728\u521b\u5efaOEM_REPOSITORY\u8868\u7a7a\u95f4\uff0c\u521b\u5efa\u5b8c\u6bd5\u540e\u51fa\u73b0\u753b\u9762\u5341\u4e00\u3002
e\u3001\u7cfb\u7edf\u663e\u793a\u201c\u521b\u5efa\u8d44\u6599\u6863\u6848\u5e93\u6982\u8981\u201d\uff0c\u5355\u51fb\u201c\u5b8c\u6210\u201d\uff0c\u663e\u793a\u201c\u914d\u7f6e\u8f85\u52a9\u5de5\u5177\u8fdb\u5ea6\u201d\uff0c\u5982\u56fe\u5341\u4e8c\u3002
\u5355\u51fb\u201c\u663e\u793a\u8be6\u7ec6\u8d44\u6599\u201d\uff0c\u53ef\u4ee5\u770b\u5230\u7cfb\u7edf\u6b63\u5728\u521b\u5efa\u5404\u79cd\u5bf9\u8c61\u7684\u63d0\u793a\u3002
\u7cfb\u7edf\u5904\u7406\u5b8c\u6210\uff0c\u5355\u51fb\u201c\u5173\u95ed\u201d\uff0c\u5982\u56fe\u5341\u4e09\u3002
2\u3001 \u542f\u52a8OracleOraHome81ManagementServer\u670d\u52a1\uff1a\u5f00\u59cb\u2192\u8bbe\u7f6e\u2192\u63a7\u5236\u9762\u7248\u2192\u7ba1\u7406\u5de5\u5177\u2192\u670d\u52a1\uff0c\u5982\u56fe\u5341\u56db\uff0c\u627e\u5230Oracle\u76f8\u5173\u670d\u52a1\u7684\u4f4d\u7f6e\u3002
\u5355\u51fb\u201c\u542f\u52a8\u201d\uff0c\u5982\u56fe\u5341\u4e94\uff0c\u5982\u679c\u4e0a\u4e00\u6b65\u6ca1\u6709\u521b\u5efa\u8d44\u6599\u6863\u6848\u5e93\uff0c\u5219\u4f1a\u542f\u52a8\u5931\u8d25\u3002
\u628aOracleOraHome81ManagementServer\u670d\u52a1\u8bbe\u7f6e\u6210\u81ea\u52a8\u542f\u52a8\u65b9\u5f0f\u3002
3\u3001 \u91cd\u65b0\u8fdb\u884cOracle Enterprise Manager \u767b\u5f55\uff1a\u5f00\u59cb\u2192\u7a0b\u5e8f\u2192Oracle - OraHome81\u2192Enterprise Manager\u2192Console
Oracle Enterprise Manager \u7684\u9ed8\u8ba4\u7ba1\u7406\u5458\u662f sysman\/oem_temp\uff0c\u7cfb\u7edf\u7ba1\u7406\u5458\u5e94\u8be5\u9a6c\u4e0a\u66f4\u6539\u53e3\u4ee4\u3002
\u5982\u56fe\u5341\u516d\uff0c\u4e0d\u8981\u5728\u7ba1\u7406\u5458\u4e00\u680f\u76f4\u63a5\u5199sysman\/oem_temp\uff0c\u800c\u662f\u5206\u522b\u8f93\u5165\u201c\u7528\u6237\u540d\/\u5bc6\u7801\u201d\u3002
\u5355\u51fb\u201c\u786e\u5b9a\u201d\uff0c\u51fa\u73b0\u56fe\u5341\u4e03\uff0c\u5b89\u5168\u8b66\u544a\uff0c\u8981\u6c42\u4f60\u7acb\u5373\u66f4\u6539sysman\u7684\u53e3\u4ee4\u3002
\u672c\u4f8b\u8f93\u5165\u4e24\u904dmanager\u4f5c\u4e3a\u53e3\u4ee4\uff0c\u8f93\u5165\u5b8c\u53e3\u4ee4\u540e\uff0c\u5355\u51fb\u201c\u66f4\u6539\u201d\uff0c\u7cfb\u7edf\u6b63\u5f0f\u8c03\u51fa\u201cOracle Enterprise Manager \u63a7\u5236\u53f0 SYSMAN@oradb\u201d\u7684\u753b\u9762\u3002
\u5907\u4efd\u548c\u6062\u590d\u6570\u636e\u5e93\u7684\u65f6\u5019\u542f\u52a8OMS\u65f6\u603b\u662f\u63d0\u793aVTD\u2014\u20140057\u8fde\u63a5\u8d44\u6599\u6863\u6848\u5e93\u65f6\u51fa\u9519Oracle sysman emSDK client ons client NoDomainException
1.run \"emca\" to create a \"repository\" for oem
2.agentctl start
oemctl start oms
$ORACLE_HOME\/network\/snmp\/peer\/start_peer -a
3.oemapp dbastudio <= initial account\/password=sysman\/oem_temp
\u6570\u636e\u5e93\u7684\u521b\u5efa\u811a\u672c
\u7cfb\u7edf\u73af\u5883\uff1a
1\u3001\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 2000 Server\uff0c\u673a\u5668\u5185\u5b58128M
2\u3001\u6570\u636e\u5e93\uff1a\u3000Oracle 8i R2 (8.1.6) for NT \u4f01\u4e1a\u7248
3\u3001\u5b89\u88c5\u8def\u5f84\uff1aD:\\ORACLE
\u5efa\u5e93\u6b65\u9aa4\uff1a
1\u3001\u624b\u5de5\u521b\u5efa\u76f8\u5173\u76ee\u5f55
D:\\Oracle\\admin\\test
D:\\Oracle\\admin\\test\\adhoc
D:\\Oracle\\admin\\test\\bdump
D:\\Oracle\\admin\\test\\cdump
D:\\Oracle\\admin\\test\\create
D:\\Oracle\\admin\\test\\exp
D:\\Oracle\\admin\\test\\pfile
D:\\Oracle\\admin\\test\\udump
D:\\Oracle\\oradata\\test
D:\\Oracle\\oradata\\test\\archive
2\u3001\u624b\u5de5\u521b\u5efa\u521d\u59cb\u5316\u542f\u52a8\u53c2\u6570\u6587\u4ef6\uff1aD:\\Oracle\\admin\\test\\pfile\\inittest.ora\uff0c\u5185\u5bb9\uff1a
3\u3001\u624b\u5de5\u521b\u5efaD:\\Oracle\\Ora81\\DATABASE\\inittest.ora\u6587\u4ef6\uff0c
\u5185\u5bb9\uff1aIFILE='D:\\Oracle\\admin\\test\\pfile\\inittest.ora'
4\u3001\u4f7f\u7528orapwd.exe\u547d\u4ee4\uff0c\u521b\u5efaD:\\Oracle\\Ora81\\DATABASE\\PWDtest.ora
\u547d\u4ee4\uff1aD:\\Oracle\\Ora81\\bin\\orapwd file=D:\\Oracle\\Ora81\\DATABASE\\PWDtest.ora password=ORACLE entries=5
5\u3001\u901a\u8fc7oradim.exe\u547d\u4ee4\uff0c\u5728\u670d\u52a1\u91cc\u751f\u6210\u4e00\u4e2a\u65b0\u7684\u5b9e\u4f8b\u7ba1\u7406\u670d\u52a1\uff0c\u542f\u52a8\u65b9\u5f0f\u4e3a\u624b\u5de5
set ORACLE_SID=test
D:\\Oracle\\Ora81\\bin\\oradim -new -sid test -startmode manual -pfile \"D:\\Oracle\\admin\\test\\pfile\\inittest.ora\"
6\u3001\u751f\u6210\u5404\u79cd\u6570\u636e\u5e93\u5bf9\u8c61D:\\>svrmgrl
--\u521b\u5efa\u6570\u636e\u5e93
connect INTERNAL\/Oracle
startup nomount pfile=\"D:\\Oracle\\admin\\test\\pfile\\inittest.ora\"
CREATE DATABASE test
LOGFILE 'D:\\Oracle\\oradata\\test\\redo01.log' SIZE 2048K,'D:\\Oracle\\oradata\\test\\redo02.log' SIZE 2048K, 'D:\\Oracle\\oradata\\test\\redo03.log' SIZE 2048K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'D:\\Oracle\\oradata\\test\\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET ZHS16GBK;
\u63a7\u5236\u6587\u4ef6\u3001\u65e5\u5fd7\u6587\u4ef6\u5728\u4e0a\u9762\u8bed\u53e5\u6267\u884c\u65f6\u751f\u6210
connect INTERNAL\/Oracle
--\u4fee\u6539\u7cfb\u7edf\u8868\u7a7a\u95f4
ALTER TABLESPACE SYSTEM DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 50);
ALTER TABLESPACE SYSTEM MINIMUM EXTENT 64K;
--\u521b\u5efa\u56de\u6eda\u8868\u7a7a\u95f4
CREATE TABLESPACE RBS DATAFILE 'D:\\Oracle\\oradata\\test\\rbs01.dbf' SIZE 256M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE(INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);
--\u521b\u5efa\u7528\u6237\u8868\u7a7a\u95f4
CREATE TABLESPACE USERS DATAFILE 'D:\\Oracle\\oradata\\test\\users01.dbf' SIZE 128M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);
--\u521b\u5efa\u4e34\u65f6\u8868\u7a7a\u95f4
CREATE TABLESPACE TEMP DATAFILE 'D:\\Oracle\\oradata\\test\\temp01.dbf' SIZE 32M REUSE
AUTOEXTEND ON NEXT 640K
MINIMUM EXTENT 64K
DEFAULT STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) TEMPORARY;
--\u521b\u5efa\u5de5\u5177\u8868\u7a7a\u95f4
CREATE TABLESPACE TOOLS DATAFILE 'D:\\Oracle\\oradata\\test\\tools01.dbf' SIZE 64M REUSE
AUTOEXTEND ON NEXT 320K
MINIMUM EXTENT 32K
DEFAULT STORAGE ( INITIAL 32K NEXT 32K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);
--\u521b\u5efa\u7d22\u5f15\u8868\u7a7a\u95f4
CREATE TABLESPACE INDX DATAFILE 'D:\\Oracle\\oradata\\test\\indx01.dbf' SIZE 32M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);
--\u521b\u5efa\u56de\u6eda\u6bb5
CREATE PUBLIC ROLLBACK SEGMENT RBS0 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS1 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS2 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS3 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS4 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS5 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS6 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS7 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS8 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS9 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS10 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS11 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS12 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS13 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS14 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS15 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS16 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS17 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS18 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS19 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS20 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS21 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS22 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS23 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS24 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
--\u4f7f\u56de\u6eda\u6bb5\u5728\u7ebf
ALTER ROLLBACK SEGMENT \"RBS0\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS1\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS2\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS3\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS4\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS5\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS6\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS7\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS8\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS9\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS10\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS11\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS12\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS13\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS14\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS15\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS16\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS17\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS18\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS19\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS20\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS21\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS22\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS23\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS24\" ONLINE;
--\u4fee\u6539sys\u7528\u6237\u7684\u4e34\u65f6\u8868\u7a7a\u95f4\u4e3aTEMP
alter user sys temporary tablespace TEMP;
--\u521b\u5efa\u6570\u636e\u5b57\u5178\u8868
@D:\\Oracle\\Ora81\\Rdbms\\admin\\catalog.sql;
@D:\\Oracle\\Ora81\\Rdbms\\admin\\catexp7.sql
@D:\\Oracle\\Ora81\\Rdbms\\admin\\catproc.sql
@D:\\Oracle\\Ora81\\Rdbms\\admin\\caths.sql
connect system\/manager
@D:\\Oracle\\Ora81\\sqlplus\\admin\\pupbld.sql
connect internal\/Oracle
@D:\\Oracle\\Ora81\\Rdbms\\admin\\catrep.sql
exit
--\u751f\u6210SQL*Plus\u5e2e\u52a9\u7cfb\u7edf
sqlplus SYSTEM\/manager
@D:\\Oracle\\Ora81\\sqlplus\\admin\\help\\helpbld.sql helpus.sql
exit
--\u4fee\u6539system\u7528\u6237\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u4e34\u65f6\u8868\u7a7a\u95f4
svrmgrl
connect internal\/Oracle
alter user system default tablespace TOOLS;
alter user system temporary tablespace TEMP;
exit
7\u3001\u5c06test\u5b9e\u4f8b\u542f\u52a8\u670d\u52a1\u8bbe\u7f6e\u6210\u81ea\u52a8\u542f\u52a8\u65b9\u5f0f
D:\\Oracle\\Ora81\\bin\\oradim -edit -sid test -startmode auto
\u542f\u52a8ARCHIVELOG\u6a21\u5f0f
C:\\>svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
\u7248\u6743\u6240\u6709 (c) 1997\uff0c1999\uff0cOracle Corporation\u3002\u4fdd\u7559\u6240\u6709\u6743\u5229\u3002
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SVRMGR> connect internal
\u8fde\u63a5\u6210\u529f
SVRMGR>shutdown
\u5df2\u5173\u95ed\u6570\u636e\u5e93\u3002
\u5df2\u5378\u4e0b\u6570\u636e\u5e93\u3002
\u5df2\u5173\u95ed ORACLE \u5b9e\u4f8b\u3002
SVRMGR> startup mount
\u5df2\u542f\u52a8 ORACLE \u5b9e\u4f8b\u3002
\u7cfb\u7edf\u5168\u5c40\u533a\u57df\u5408\u8ba1\u6709 57124108\u4e2a\u5b57\u8282
Fixed Size 70924\u4e2a\u5b57\u8282
Variable Size 40198144\u4e2a\u5b57\u8282
Database Buffers 16777216\u4e2a\u5b57\u8282
Redo Buffers 77824\u4e2a\u5b57\u8282
\u5df2\u88c5\u5165\u6570\u636e\u5e93\u3002
SVRMGR> alter database archivelog;
\u8bed\u53e5\u5df2\u5904\u7406\u3002
SVRMGR> archive log start
\u8bed\u53e5\u5df2\u5904\u7406\u3002
SVRMGR> alter database open;
\u8bed\u53e5\u5df2\u5904\u7406\u3002
SVRMGR> alter system switch logfile; --\u5f3a\u5236\u7cfb\u7edf\u8fdb\u884c\u65e5\u5fd7\u5207\u6362\uff0c\u53ef\u9a6c\u4e0a\u89c2\u5bdf\u5230\u5f52\u6863\u65e5\u5fd7\u7684\u4ea7\u751f
\u8bed\u53e5\u5df2\u5904\u7406\u3002
SVRMGR> exit
\u670d\u52a1\u5668\u7ba1\u7406\u7a0b\u5e8f\u7ed3\u675f\u3002
\u4fee\u6539\u6570\u636e\u5e93\u53c2\u6570\u6587\u4ef6c:\\Oracle\\admin\\oradb\\pfile\\init.ora\uff0c
\u53d6\u6d88\u4ee5\u4e0b\u8bed\u53e5\u7684#\u6ce8\u91ca
log_archive_start = true
log_archive_dest_1 = \"location=C:\\Oracle\\oradata\\oradb\\archive\"
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
\u5173\u95ed\u6570\u636e\u5e93\uff0c\u91cd\u65b0\u542f\u52a8
\u67e5\u770bC:\\Oracle\\oradata\\oradb\\archive\u76ee\u5f55\u4e0b\uff0c\u53ef\u4ee5\u770b\u5230\u7c7b\u4f3cORADBT001S01201.ARC\u7684\u6587\u4ef6\uff0c\u8bf4\u660e\u5f52\u6863\u6210\u529f
PLUS:Oracle9i\u4e2d\u9700\u8981\u6267\u884c\u7684\u90e8\u5206
SQL> alter system set log_archive_dest_1 =\"location=E:\\Oracle\\oradata\\test\\archive\" scope = spfile;
SQL> alter system set log_archive_start = true scope = spfile;
\u8865\u5145\u4e00\u4e9b\u6982\u5ff5
\u89e3\u91cainit.ora\u53c2\u6570\u6587\u4ef6\u4e2d\u5173\u4e8e\u5f52\u6863\u91cd\u505a\u65e5\u5fd7\u53c2\u6570\u9879\u7684\u542b\u4e49
\u5f52\u6863\u6a21\u5f0f\u662f\u81ea\u52a8\u8fd8\u662f\u624b\u5de5\uff0ctrue\u4e3a\u81ea\u52a8\uff0cfalse\u4e3a\u624b\u5de5
log_archive_start = true
\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u6240\u4fdd\u5b58\u7684\u8def\u5f84
log_archive_dest_1 = \"location=C:\\Oracle\\oradata\\oradb\\archive\"
\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u7684\u547d\u540d\u65b9\u6cd5
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
\u5f52\u6863\u547d\u4ee4\uff1a
\u542f\u52a8\u81ea\u52a8\u5f52\u6863\u6a21\u5f0f\uff0c\u7cfb\u7edf\u91cd\u8d77\u540e\uff0c\u5c06\u6309init.ora\u4e2d\u7684\u53c2\u6570log_archive_start\u7684\u503c\u8bbe\u7f6e\u5f52\u6863\u65b9\u5f0f
SVRMGR> archive log start
\u542f\u52a8\u624b\u5de5\u5f52\u6863\u6a21\u5f0f
SVRMGR> archive log stop
\u67e5\u770b\u5f52\u6863\u4fe1\u606f\uff1a\u91cd\u505a\u65e5\u5fd7\u662f\u5426\u5f52\u6863\u65b9\u5f0f\u3001\u662f\u81ea\u52a8\u5f52\u6863\u8fd8\u662f\u624b\u5de5\u5f52\u6863\u3001\u5f52\u6863\u8def\u5f84\u3001\u6700\u65e7\u7684\u8054\u673a\u65e5\u5fd7\u5faa\u5e8f\u53f7
SVRMGR> archive log list
\u5f52\u6863\u4e00\u4e2a\u5df2\u6ee1\uff0c\u4f46\u6ca1\u6709\u5f52\u6863\u7684\u8054\u673a\u91cd\u505a\u65e5\u5fd7
SVRMGR> archive log next
\u5f52\u6863\u6240\u6709\u5df2\u6ee1\uff0c\u4f46\u6ca1\u6709\u5f52\u6863\u7684\u8054\u673a\u91cd\u505a\u65e5\u5fd7
SVRMGR> archive log all
\u6ce8\u610f\uff1a\u4e00\u4e2a\u4e8b\u52a1\u5373\u4f7f\u4e0d\u88ab\u63d0\u4ea4\uff0c\u4e5f\u4f1a\u88ab\u5199\u5165\u5230\u91cd\u505a\u65e5\u5fd7\u4e2d\u3002
SYS\u4e0b\u7684\u7a0b\u5e8f\u5305\u548c\u7a0b\u5e8f\u5305\u4f53\u4ec5STANDARD\u5305\u4f53\u53ef\u4ee5\u7f16\u8bd1\u4e3avalid
\u95ee\u9898\uff1a\u6211\u7684sys\u4e0b\u7684\u7a0b\u5e8f\u5305\u548c\u7a0b\u5e8f\u5305\u4f53\u90fd\u662finvalid.\u4f46\u662fSTANDARD\u5305\u4f53\u53ef\u4ee5\u7f16\u8bd1\u4e3avalid.\u5176\u4ed6\u7a0b\u5e8f\u5305\u90fd\u662finvalid. \u7f16\u8bd1\u65f6\u63d0\u793a\uff1a
VBO-4553\uff1aPL\/SQL \u7a0b\u5e8f\u5305\u7f16\u8bd1\u662f\u4e0d\u3002\u6709\u5173\u8be6\u7ec6\u4fe1\u606f\uff0c\u8bf7\u6309\u8be5\u5c5e\u6027\u9875\u4e0a\u7684\u663e\u793a\u9519\u8bef\u3002ORA-06554:????? PL\/SQL ???? DBMS_STANDARD
SQLPLUS\u8fde\u63a5\u65f6\u63d0\u793a\uff1aERROR:ORA-06554: package DBMS_STANDARD must be created before using PL\/SQL
Error accessing package DBMS_APPLICATION_INFO
ERROR:ORA-06554: package DBMS_STANDARD must be created before using PL\/SQL
\u89e3\u7b54\uff1a
\u7528$ORACLE_HOME\/RDBMS\/ADMIN\u4e0b\u9762\u7684\u76f8\u5173\u6587\u4ef6\u91cd\u65b0\u521b\u5efa\u4e00\u4e0b\u8fd9\u4e9b\u5305\u3002
SYSDBA\u767b\u9646\u8fd0\u884c
$ORACLE_HOME\/RDBMS\/ADMIN\/CATALOG.SQL
$ORACLE_HOME\/RDBMS\/ADMIN\/CATPROC.SQL
\u5982\u4f55\u5b9e\u73b0\uff1a\u63d2\u5165\u6570\u636e\u5230\u6570\u636e\u5e93A\u4e2d\u7684\u8868TPROCESS\uff0c\u6570\u636e\u5e93\u81ea\u52a8\u66f4\u65b0\u5230\u6570\u636e\u5e93B\u4e2d\u7684\u8868TLOG\uff1f
1. at db1
chk tnsnames.ora
CONNECT_STRING_DB2 = ...
tnsping CONNECT_STING_DB2
sql> create public database link DB2 using 'CONNECT_STING_DB2';
2. at db2
chk tnsnames.ora
CONNECT_STRING_DB1 = ...
tnsping CONNECT_STING_DB1
sql> create public database link DB1 using 'CONNECT_STING_DB1';
3. at db1
sql> create trigger ... after insert ...
insert into USER.TABLE@DB2 ... <<== using database link !!!
:NEW.column1, :NEW.column2 ...
\u4ece\u4e00\u4e2a\u5b57\u7b26\u96c6\u4e0d\u662f\u4e2d\u6587\u5b57\u7b26\u96c6\u7684\u6570\u636e\u5e93\u4e2dEXP\u6570\u636e\u5e93\uff0c\u7136\u540e\u5bfc\u5165\u5230\u4e00\u4e2a\u4e2d\u6587\u5b57\u7b26\u96c6\u7684\u6570\u636e\u5e93\u4e2d
EXP\/IMP\u662f\u4e00\u79cd\u6570\u636e\u5e93\u5230\u51fa\u5bfc\u5165\u5de5\u5177\uff0c\u4f46\u662f\u5728EXP\/IMP\u5bf9\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\u8981\u6c42\u6bd4\u8f83\u4e25\u683c\uff0c\u5982\u679cEXP\u51fa\u7684\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\u548c\u5bfc\u5165\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\u4e0d\u517c\u5bb9\u3002\u5bfc\u5165\u65e0\u6cd5\u5b8c\u6210\u3002\u6b64\u65f6\u9700\u8981\u91c7\u53d6\u4e00\u79cd\u7279\u6b8a\u7684\u65b9\u6cd5\u8fdb\u884c\u64cd\u4f5c\u3002\u7531\u4e8e\u8be5\u64cd\u4f5c\u662f\u6709\u4e00\u5b9a\u5371\u5bb3\u6027\u7684\u64cd\u4f5c\uff0c\u5728\u64cd\u4f5c\u8fc7\u7a0b\u4e2d\uff0c\u6570\u636e\u5e93\u7a81\u7136\u51fa\u73b0\u6545\u969c\u7684\u60c5\u51b5\u4e0b\uff0c\u4f1a\u5bfc\u81f4\u6570\u636e\u5e93\u53ef\u80fd\u65e0\u6cd5\u6b63\u5e38\u542f\u52a8\u3002\u56e0\u6b64\u64cd\u4f5c\u524d\u4e00\u5b9a\u8981\u5148\u5907\u4efd\u6570\u636e\u5e93\u3002
1\u3001\u5728\u539f\u6570\u636e\u5e93\u6267\u884csqlplus\uff0c\u8fde\u63a5sys\u7528\u6237\uff0c\u4fee\u6539\u5b57\u7b26\u96c6\u53c2\u6570\uff0c\u7136\u540e\u9000\u51fa\u3002
SQL> connect sys\/******;
update props$ set value$ = 'ZHS16GBK' where name = 'NLS_CHARACTERSET';
update props$ set value$ = 'ZHS16GBK' where name = 'NLS_NCHAR_CHARACTERSET';
commit;
SQL> quit;
2\u3001\u6267\u884csvrmgrl\uff0c\u5173\u95ed\u5e76\u91cd\u65b0\u5f00\u542fOracle\u6570\u636e\u5e93
SVRMGR> connect internal\/******; (\u53e3\u4ee4\u4e00\u822c\u4e3a\"Oracle\")
SVRMGR> shutdown immediate;
SVRMGR> startup mount;
SVRMGR> alter system enable restricted session;
SVRMGR> alter system set job_queue_process=0;
SVRMGR> alter database open;
SVRMGR> alter database character set ZHS16GBK;
SVRMGR> exit;
3\u3001\u4fee\u6539\u73af\u5883\u53d8\u91cfNLS_LANG
\u7531 AMERICAN_AMERICA.WE8ISO8859P1
\u8f6c\u6362\u4e3a SIMPLIFIED CHINESE_CHINA.ZHS16GBK
\u5982\u679c\u662fWINDOWS\uff0c\u7528Regedit\u4fee\u6539ORACLE\u4e0b\u7684\u952e\u503c\u3002\u5982\u679c\u662fUNIX\u7cfb\u7edf\uff0c\u4fee\u6539\u73af\u5883\u53d8\u91cf\uff1aNLS_LANG=...;export NLS_LANG
\u5982\u679c\u662fOpenVMS\uff1a\u4fee\u6539Login.com\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\uff0c\u7136\u540e\u91cd\u65b0\u6267\u884c\u4e00\u6b21Login.com
4\u3001\u6267\u884cexp\u5bfc\u51fa\u6570\u636e
5\u3001\u5c06\u73af\u5883\u53d8\u91cfNLS_LANG\u4fee\u6539\u4e3a\u539f\u6765\u7684\u503c
6\u3001\u6267\u884csqlplus\uff0c\u8fde\u63a5sys\u7528\u6237\uff0c\u6062\u590d\u5b57\u7b26\u96c6\u53c2\u6570\uff0c\u7136\u540e\u9000\u51fa\u3002
connect sys\/******; (\u53e3\u4ee4\u4e00\u822c\u4e3a\"manager\")
update props$ set value$ = 'WE8ISO8859P1' where name = 'NLS_CHARACTERSET';
update props$ set value$ = 'WE8ISO8859P1' where name = 'NLS_NCHAR_CHARACTERSET';
commit;
SQL> quit;
7\u3001\u91cd\u590d\u6b65\u9aa42\uff0c\u5173\u95ed\u5e76\u91cd\u65b0\u5f00\u542fOracle\u6570\u636e\u5e93
8\u3001\u5c06\u5bfc\u51fa\u7684dmp\u6587\u4ef6\u5bfc\u5165\u76ee\u6807\u6570\u636e\u5e93\uff08\u5b57\u7b26\u96c6\u4e3a\u4e2d\u6587\uff09
\u6210\u529f\u521b\u5efaDBLink\uff0c\u4f46\u4e0d\u80fd\u8fde\u63a5
\u95ee\u9898\uff1a
ORACLE 8.1.6 for NT\uff0c\u73b0\u5728\u9700\u8981\u8fde\u53e6\u4e00\u4e2aORACLE 8 FOR UNIX\uff0c\u5f53\u7136\u662f\u8981\u5efa\u7acbDBLINK\u3002\u4f46\u662f\u5efa\u7acb\u672c\u5730\u7f51\u7edc\u670d\u52a1\u540d\u65f6\u53ef\u4ee5\u8fde\u63a5\u4e0a\u4e86\uff0c\u6240\u5efaDBLINK\u5c31\u662f\u8fde\u63a5\u4e0d\u4e0a\uff0c\u4e3a\u4ec0\u4e48\uff1f
\u7528select <xxx> from <\u8868\u540d>@<db_link>
\u9519\u8bef\u662f\uff1aORA-02085: \u6570\u636e\u5e93\u94fe\u63a5ORA8I.US.ORACLE.COM\u4e0eORA8I\u76f8\u8fde\u7ed3\uff08ora8i \u662fDBLINK\u7684\u540d\u5b57\uff09
\u89e3\u7b54\uff1a
\u5982\u679c\u4f60\u7684\u6e90\u6570\u636e\u5e93\u7684GLOBAL_NAME\uff1dTRUE\uff0c\u90a3\u4e48\u4f60\u7684DBLINK\u7684\u540d\u5b57\u5fc5\u987b\u548c\u8fdc\u7aef\u6570\u636e\u5e93\u7684\u5168\u5c40\u540d\u4e00\u81f4\uff0c\u5426\u5219\u4f1a\u53d1\u751f2085 \u9519\u8bef\u3002
\u4f60\u53ef\u8bbe\u7f6e\u6e90\u6570\u636e\u5e93\u7684GLOBAL_NAME\uff1dFALSE\uff0c\u4e5f\u53ef\u4ee5\u5728\u521b\u5efaDBLINK\u7684\u65f6\u5019\u628aDBLINK\u7684\u540d\u79f0\u8bbe\u7f6e\u4e3a\u8fdc\u7a0b\u6570\u636e\u5e93\u7684\u5168\u5c40\u540d\u3002
How to Configure the 9i Agent with Multiple Network Cards
fact: Oracle Intelligent Agent 9.0.1
fix:
Configuring the Version 9.0.1 Agent for Use with Multiple Network Cards (NIC)(From the Oracle IA User's Guide Release 9.0.1 Part Number A88771-02):
As with version 8.1.7 of the Intelligent Agent, 9i Intelligent Agent users have three options to configure the Agent on a machine with multiple network cards.By default the Agent will bind to the primary NIC on its machine ('le0' on UNIX platforms and 'network0' on Windows NT platforms). The other two options are:
a. Ability to bind to a NIC specified by the user.\r\n
Oracle 9i AS\u5b89\u88c5\u9519\u8bef
\u89e3\u51b3\uff1a\u6309\u7167\u5b83\u7684\u63d0\u793a\u7f16\u8f91host\u6587\u4ef6\uff0c\u52a0\u4e0a127.0.0.1 localhost #localhost
spfile \u548c pfile\u5f02\u540c
spfile\uff0c\u670d\u52a1\u5668\u53c2\u6570\u6587\u4ef6\u662f\u5728Oracle9i\u53ca\u66f4\u9ad8\u7248\u672c\u4e2d\u4e00\u4e2a\u65b0\u7279\u6027\u3002\u5176\u4f7fOracle9i\u53ef\u4ee5\u66f4\u6539\u5927\u591a\u6570\u8fc7\u53bb\u5728\u4f7f\u7528\u6570\u636e\u5e93\u8054\u673a\u548c\u7528\u6237\u65f6\u4e0d\u80fd\u52a8\u6001\u66f4\u6539\u7684\u521d\u59cb\u5316\u53c2\u6570\u3002\u6b64\u5916\uff0c\u670d\u52a1\u5668\u53c2\u6570\u6587\u4ef6\u4f7fOracle9i\u80fd\u8bb0\u4f4f\u4f1a\u8bdd\u4e4b\u95f4\u52a8\u6001\u66f4\u6539\u8fc7\u7684\u521d\u59cb\u5316\u53c2\u6570\u7684\u8bbe\u7f6e\u3002
pfile\uff0c\u76f8\u5f53\u4e0eOracle8i\u53ca\u4ee5\u524d\u7248\u672c\u7684Init.ora\u3002
\u53ef\u4ee5\u6839\u636epfile\u5efa\u7acbspfile\uff1a\u5982\uff1acreate spfile from pfile \uff1d\u2018\u8def\u5f84\/init.ora'
\u6570\u636e\u5e93\u5347\u7ea7\u9519\u8bef\u2014\u2014\u4e0d\u76f8\u5173\u7684\u5b57\u7b26\u96c6
\u6570\u636e\u5e93\u4eceOracle8.0.5\u5347\u7ea7\u52308.1.5\uff0c\u5907\u4efd\u6570\u636e\u6062\u590d\u65f6\u51fa\u73b0\u9519\u8bef\u3002\u9519\u8bef\u63d0\u793a\uff1a\u4e0d\u76f8\u5173\u7684\u5b57\u7b26\u96c6\uff08805\u5230820\uff09
1\u3001\u91cd\u5efaOracle 8i\u6570\u636e\u5e93\uff0c\u5efa\u5e93\u65f6\u6307\u5b9a\u540c\u4e00\u5b57\u7b26\u96c6\uff0c\u518d\u79fb\u690d\uff1b \u67e5\u770b\u539f\u6570\u636e\u5e93\u5b57\u7b26\u96c6\uff0c select * from nls_database_parameters
2\u3001\u8bbe\u7f6e\u539f\u6570\u636e\u5e93Oracle 805 \u7684\u73af\u5883\u53d8\u91cfNLS_LANG\u4e0eora 8i\u6570\u636e\u5e93\u4e00\u81f4\uff0c\u6267\u884cexport\u65f6\u53ef\u4ee5\u8f6c\u6362\u5b57\u7b26\u96c6\u3002
3\u3001exp \u4e0e imp \u6700\u597d\u90fd\u4f7f\u7528Oracle 816 \u5e26\u7684\uff0c\u4e0d\u8981\u7528Oracle 805 \u7684exp \u5bfc\u51fa\u7684dmp \u6587\u4ef6\uff0c\u53c8\u7528Oracle 816 \u7684 imp \u6765\u5bfc\u3002
\u542f\u52a8 iSQL*Plus
\u8981\u542f\u52a8 iSQL*Plus\uff0c\u8bf7\u6267\u884c\u4ee5\u4e0b\u6b65\u9aa4\uff1a
\u8fde\u63a5\u5230 Internet \u6216 Intranet\uff0c\u7136\u540e\u542f\u52a8 Web \u6d4f\u89c8\u5668\u3002\u5728 Web \u6d4f\u89c8\u5668\u7684\u201c\u4f4d\u7f6e\u201d\u5b57\u6bb5\u6216\u201c\u5730\u5740\u201d\u5b57\u6bb5\u4e2d\uff0c\u8f93\u5165 Oracle9i HTTP Server URL\uff0c\u5e76\u63a5\u7740\u8f93\u5165 isqlplus\u3002iSQL*Plus URL \u5982\u4e0b\u6240\u793a\uff1ahttp:\/\/machine_name.domain:7777\/isqlplus
\u5982\u679c\u60a8\u4e0d\u77e5\u9053 Oracle9i HTTP Server URL\uff0c\u8bf7\u5411\u7cfb\u7edf\u7ba1\u7406\u5458\u54a8\u8be2\u3002
\u6309 Enter \u952e\u5c06\u8f6c\u5230\u8be5 URL\u3002Web \u6d4f\u89c8\u5668\u4e2d\u5c06\u663e\u793a iSQL*Plus\u201c\u767b\u5f55\u201d\u5c4f\u5e55\u3002
\u5728\u201c\u7528\u6237\u540d\u201d\u5b57\u6bb5\u548c\u201c\u53e3\u4ee4\u201d\u5b57\u6bb5\u4e2d\uff0c\u8f93\u5165 Oracle9i \u7528\u6237\u540d\u548c\u53e3\u4ee4\u3002\u5982\u679c\u60a8\u4e0d\u77e5\u9053 Oracle9i \u7528\u6237\u540d\u548c\u53e3\u4ee4\uff0c\u8bf7\u5411\u6570\u636e\u5e93\u7ba1\u7406\u5458\u54a8\u8be2\u3002
\u5c06\u201c\u8fde\u63a5\u6807\u8bc6\u7b26\u201d\u5b57\u6bb5\u4fdd\u7559\u4e3a\u7a7a\u53ef\u4ee5\u8fde\u63a5\u5230\u9ed8\u8ba4\u6570\u636e\u5e93\u3002\u8f93\u5165 Oracle Net \u6570\u636e\u5e93\u522b\u540d\u65f6\uff0c\u53ef\u4ee5\u8fde\u63a5\u5230\u9ed8\u8ba4\u6570\u636e\u5e93\u4ee5\u5916\u7684\u5176\u4ed6\u6570\u636e\u5e93\u3002\u5982\u679c\u5df2\u914d\u7f6e\u4e86\u9650\u5236\u7684\u6570\u636e\u5e93\u8bbf\u95ee\uff0c\u201c\u8fde\u63a5\u6807\u8bc6\u7b26\u201d\u5b57\u6bb5\u5c31\u4f1a\u53d8\u6210\u53ef\u4f9b\u9009\u62e9\u7684\u53ef\u7528\u6570\u636e\u5e93\u7684\u4e0b\u62c9\u5217\u8868\u3002
\u5355\u51fb\u201c\u767b\u5f55\u201d\uff0c\u8fde\u63a5\u5230\u76f8\u5173\u6570\u636e\u5e93\u3002Web \u6d4f\u89c8\u5668\u4e0a\u5c06\u4f1a\u663e\u793a iSQL*Plus\u201c\u5de5\u4f5c\u5c4f\u5e55\u201d\u3002
\u6b64\u65f6\uff0c\u60a8\u53ef\u4ee5\u5728\u201c\u5de5\u4f5c\u5c4f\u5e55\u201d\u7684\u8f93\u5165\u533a\u57df\u4e2d\u8f93\u5165\u5e76\u6267\u884c SQL\u3001PL\/SQL \u548c SQL*Plus \u8bed\u53e5\u548c\u547d\u4ee4\u3002
Oracle 816\u4e2d\u542f\u52a8Enterprise Manager
\u7cfb\u7edf\u73af\u5883\uff1a
1\u3001\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 2000
2\u3001\u6570\u636e\u5e93\uff1a\u3000Oracle 8i R2 (8.1.6) for NT \u4f01\u4e1a\u7248
3\u3001\u5b89\u88c5\u8def\u5f84\uff1aC:\\ORACLE
\u9519\u8bef\u73b0\u8c61\uff1a
\u9ed8\u8ba4\u5b89\u88c5\u5b8cOracle 816 for NT\u540e\uff0c\u60f3\u4f7f\u7528Oracle816 for NT\u7684OEM\u5de5\u5177\u6765\u7ba1\u7406\u6570\u636e\u5e93\uff0c\u5f00\u59cb\u2192\u7a0b\u5e8f\u2192Oracle - OraHome81\u2192Enterprise Manager\u2192Console\u3002\u8fd9\u65f6\u7cfb\u7edf\u51fa\u73b0\u4ee5\u4e0b\u753b\u9762\u4e00\uff1a
\u70b9\u51fb\u201c\u786e\u5b9a\u201d\uff0c\u51fa\u73b0\u753b\u9762\u4e8c\u3001\u4e09\u3002
\u5728\u201c\u6dfb\u52a0\u7ba1\u7406\u670d\u52a1\u5668\u201d\u680f\u4e0a\u8f93\u5165\u672c\u673aIP\u5730\u5740\uff0c\u5982\uff1a192.1.1.1\uff0c\u70b9\u51fb\u201c\u786e\u5b9a\u201d\uff0c\u51fa\u73b0\u753b\u9762\u56db\u3002
\u753b\u9762\u663e\u793a\u51fa\u7684oradb\u5c31\u4f7f\u672c\u673a\u540d\u79f0\uff0c\u70b9\u51fb\u201c\u786e\u5b9a\u201d\uff0c\u51fa\u73b0\u753b\u9762\u4e94\uff0c\u8fdb\u884c\u201cOracle Enterprise Manager \u767b\u5f55\u201d\u3002
\u8f93\u5165\u53e3\u4ee4\/\u5bc6\u7801\uff1asystem\/manager\uff0c\u70b9\u51fb\u201c\u786e\u5b9a\u201d\uff0c\u51fa\u73b0\u753b\u9762\u516d\uff0c\u51fa\u73b0\u4ee5\u4e0b\u9519\u8bef\u63d0\u793a\u3002
VTK-1000 : Unable to connect to the management server oradb. Please vertify that you have entered the correct host name nd the status of the Oracle Managerment Server.\u89e3\u51b3\u65b9\u6cd5\uff1a
1\u3001\u4f7f\u7528Enterprise Manager\u914d\u7f6e\u8f85\u52a9\u5de5\u5177
\u5f00\u59cb\u2192\u7a0b\u5e8f\u2192Oracle - OraHome81\u2192Enterprise Manager\u2192Configuration Assistant
a\u3001\u4f7f\u7528Configuration Assistant\u5de5\u5177\u6765\u521b\u5efa\u4e00\u4e2a\u65b0\u7684\u8d44\u6599\u6863\u6848\u5e93\uff0c\u5982\u56fe\u4e03\u3002
\u5355\u51fb\u201c\u4e0b\u4e00\u6b65\u201d\uff0c\u51fa\u73b0\u753b\u9762\u516b\u3002
b\u3001 \u5148\u767b\u5f55 \u7528\u6237\u540d\uff1asystem\uff0c\u5bc6\u7801\uff1amanager\uff0c\u670d\u52a1\uff1aoradb\uff0c\u6ce8\uff1a\u8f93\u5165\u7684\u7528\u6237\u5fc5\u987b\u5177\u6709DBA\u6743\u9650\uff0c\u5355\u51fb\u201c\u4e0b\u4e00\u6b65\u201d\uff0c\u51fa\u73b0\u753b\u9762\u4e5d\u3002\uff089i\u4e3asysman\/oem_temp\uff09
c\u3001\u518d\u521b\u5efa\u62e5\u6709\u6b64\u8d44\u6599\u6863\u6848\u5e93\u7684\u7528\u6237\uff0c\u7cfb\u7edf\u9ed8\u8ba4\u53d6\u673a\u5668\u540d\uff0c\u8fd9\u91cc\u6211\u4eec\u8bbe\u7528\u6237\u540d\u4e3a\uff1atest\uff0c\u5bc6\u7801\uff1atest,\u8f93\u5165\u4e24\u904d\u53e3\u4ee4\uff0c\u5355\u51fb\u201c\u4e0b\u4e00\u6b65\u201d\uff0c\u51fa\u73b0\u753b\u9762\u5341\u3002
d\u3001\u56e0\u4e3a\u8f93\u5165\u7684\u662f\u4e00\u4e2a\u65b0\u7528\u6237\uff0c\u7cfb\u7edf\u8981\u6c42\u6307\u5b9a\u7528\u6237\u8868\u7a7a\u95f4\uff0c\u672c\u4f8b\u4f7f\u7528\u7cfb\u7edf\u63a8\u8350\uff0c
\u5355\u51fb\u201c\u4e0b\u4e00\u6b65\u201d\uff0c\u7cfb\u7edf\u6b63\u5728\u521b\u5efaOEM_REPOSITORY\u8868\u7a7a\u95f4\uff0c\u521b\u5efa\u5b8c\u6bd5\u540e\u51fa\u73b0\u753b\u9762\u5341\u4e00\u3002
e\u3001\u7cfb\u7edf\u663e\u793a\u201c\u521b\u5efa\u8d44\u6599\u6863\u6848\u5e93\u6982\u8981\u201d\uff0c\u5355\u51fb\u201c\u5b8c\u6210\u201d\uff0c\u663e\u793a\u201c\u914d\u7f6e\u8f85\u52a9\u5de5\u5177\u8fdb\u5ea6\u201d\uff0c\u5982\u56fe\u5341\u4e8c\u3002
\u5355\u51fb\u201c\u663e\u793a\u8be6\u7ec6\u8d44\u6599\u201d\uff0c\u53ef\u4ee5\u770b\u5230\u7cfb\u7edf\u6b63\u5728\u521b\u5efa\u5404\u79cd\u5bf9\u8c61\u7684\u63d0\u793a\u3002
\u7cfb\u7edf\u5904\u7406\u5b8c\u6210\uff0c\u5355\u51fb\u201c\u5173\u95ed\u201d\uff0c\u5982\u56fe\u5341\u4e09\u3002
2\u3001 \u542f\u52a8OracleOraHome81ManagementServer\u670d\u52a1\uff1a\u5f00\u59cb\u2192\u8bbe\u7f6e\u2192\u63a7\u5236\u9762\u7248\u2192\u7ba1\u7406\u5de5\u5177\u2192\u670d\u52a1\uff0c\u5982\u56fe\u5341\u56db\uff0c\u627e\u5230Oracle\u76f8\u5173\u670d\u52a1\u7684\u4f4d\u7f6e\u3002
\u5355\u51fb\u201c\u542f\u52a8\u201d\uff0c\u5982\u56fe\u5341\u4e94\uff0c\u5982\u679c\u4e0a\u4e00\u6b65\u6ca1\u6709\u521b\u5efa\u8d44\u6599\u6863\u6848\u5e93\uff0c\u5219\u4f1a\u542f\u52a8\u5931\u8d25\u3002
\u628aOracleOraHome81ManagementServer\u670d\u52a1\u8bbe\u7f6e\u6210\u81ea\u52a8\u542f\u52a8\u65b9\u5f0f\u3002
3\u3001 \u91cd\u65b0\u8fdb\u884cOracle Enterprise Manager \u767b\u5f55\uff1a\u5f00\u59cb\u2192\u7a0b\u5e8f\u2192Oracle - OraHome81\u2192Enterprise Manager\u2192Console
Oracle Enterprise Manager \u7684\u9ed8\u8ba4\u7ba1\u7406\u5458\u662f sysman\/oem_temp\uff0c\u7cfb\u7edf\u7ba1\u7406\u5458\u5e94\u8be5\u9a6c\u4e0a\u66f4\u6539\u53e3\u4ee4\u3002
\u5982\u56fe\u5341\u516d\uff0c\u4e0d\u8981\u5728\u7ba1\u7406\u5458\u4e00\u680f\u76f4\u63a5\u5199sysman\/oem_temp\uff0c\u800c\u662f\u5206\u522b\u8f93\u5165\u201c\u7528\u6237\u540d\/\u5bc6\u7801\u201d\u3002
\u5355\u51fb\u201c\u786e\u5b9a\u201d\uff0c\u51fa\u73b0\u56fe\u5341\u4e03\uff0c\u5b89\u5168\u8b66\u544a\uff0c\u8981\u6c42\u4f60\u7acb\u5373\u66f4\u6539sysman\u7684\u53e3\u4ee4\u3002
\u672c\u4f8b\u8f93\u5165\u4e24\u904dmanager\u4f5c\u4e3a\u53e3\u4ee4\uff0c\u8f93\u5165\u5b8c\u53e3\u4ee4\u540e\uff0c\u5355\u51fb\u201c\u66f4\u6539\u201d\uff0c\u7cfb\u7edf\u6b63\u5f0f\u8c03\u51fa\u201cOracle Enterprise Manager \u63a7\u5236\u53f0 SYSMAN@oradb\u201d\u7684\u753b\u9762\u3002
\u5907\u4efd\u548c\u6062\u590d\u6570\u636e\u5e93\u7684\u65f6\u5019\u542f\u52a8OMS\u65f6\u603b\u662f\u63d0\u793aVTD\u2014\u20140057\u8fde\u63a5\u8d44\u6599\u6863\u6848\u5e93\u65f6\u51fa\u9519Oracle sysman emSDK client ons client NoDomainException
1.run \"emca\" to create a \"repository\" for oem
2.agentctl start
oemctl start oms
$ORACLE_HOME\/network\/snmp\/peer\/start_peer -a
3.oemapp dbastudio <= initial account\/password=sysman\/oem_temp
\u6570\u636e\u5e93\u7684\u521b\u5efa\u811a\u672c
\u7cfb\u7edf\u73af\u5883\uff1a
1\u3001\u64cd\u4f5c\u7cfb\u7edf\uff1aWindows 2000 Server\uff0c\u673a\u5668\u5185\u5b58128M
2\u3001\u6570\u636e\u5e93\uff1a\u3000Oracle 8i R2 (8.1.6) for NT \u4f01\u4e1a\u7248
3\u3001\u5b89\u88c5\u8def\u5f84\uff1aD:\\ORACLE
\u5efa\u5e93\u6b65\u9aa4\uff1a
1\u3001\u624b\u5de5\u521b\u5efa\u76f8\u5173\u76ee\u5f55
D:\\Oracle\\admin\\test
D:\\Oracle\\admin\\test\\adhoc
D:\\Oracle\\admin\\test\\bdump
D:\\Oracle\\admin\\test\\cdump
D:\\Oracle\\admin\\test\\create
D:\\Oracle\\admin\\test\\exp
D:\\Oracle\\admin\\test\\pfile
D:\\Oracle\\admin\\test\\udump
D:\\Oracle\\oradata\\test
D:\\Oracle\\oradata\\test\\archive
2\u3001\u624b\u5de5\u521b\u5efa\u521d\u59cb\u5316\u542f\u52a8\u53c2\u6570\u6587\u4ef6\uff1aD:\\Oracle\\admin\\test\\pfile\\inittest.ora\uff0c\u5185\u5bb9\uff1a
3\u3001\u624b\u5de5\u521b\u5efaD:\\Oracle\\Ora81\\DATABASE\\inittest.ora\u6587\u4ef6\uff0c
\u5185\u5bb9\uff1aIFILE='D:\\Oracle\\admin\\test\\pfile\\inittest.ora'
4\u3001\u4f7f\u7528orapwd.exe\u547d\u4ee4\uff0c\u521b\u5efaD:\\Oracle\\Ora81\\DATABASE\\PWDtest.ora
\u547d\u4ee4\uff1aD:\\Oracle\\Ora81\\bin\\orapwd file=D:\\Oracle\\Ora81\\DATABASE\\PWDtest.ora password=ORACLE entries=5
5\u3001\u901a\u8fc7oradim.exe\u547d\u4ee4\uff0c\u5728\u670d\u52a1\u91cc\u751f\u6210\u4e00\u4e2a\u65b0\u7684\u5b9e\u4f8b\u7ba1\u7406\u670d\u52a1\uff0c\u542f\u52a8\u65b9\u5f0f\u4e3a\u624b\u5de5
set ORACLE_SID=test
D:\\Oracle\\Ora81\\bin\\oradim -new -sid test -startmode manual -pfile \"D:\\Oracle\\admin\\test\\pfile\\inittest.ora\"
6\u3001\u751f\u6210\u5404\u79cd\u6570\u636e\u5e93\u5bf9\u8c61D:\\>svrmgrl
--\u521b\u5efa\u6570\u636e\u5e93
connect INTERNAL\/Oracle
startup nomount pfile=\"D:\\Oracle\\admin\\test\\pfile\\inittest.ora\"
CREATE DATABASE test
LOGFILE 'D:\\Oracle\\oradata\\test\\redo01.log' SIZE 2048K,'D:\\Oracle\\oradata\\test\\redo02.log' SIZE 2048K, 'D:\\Oracle\\oradata\\test\\redo03.log' SIZE 2048K
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'D:\\Oracle\\oradata\\test\\system01.dbf' SIZE 58M REUSE AUTOEXTEND ON NEXT 640K
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET ZHS16GBK;
\u63a7\u5236\u6587\u4ef6\u3001\u65e5\u5fd7\u6587\u4ef6\u5728\u4e0a\u9762\u8bed\u53e5\u6267\u884c\u65f6\u751f\u6210
connect INTERNAL\/Oracle
--\u4fee\u6539\u7cfb\u7edf\u8868\u7a7a\u95f4
ALTER TABLESPACE SYSTEM DEFAULT STORAGE ( INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 50);
ALTER TABLESPACE SYSTEM MINIMUM EXTENT 64K;
--\u521b\u5efa\u56de\u6eda\u8868\u7a7a\u95f4
CREATE TABLESPACE RBS DATAFILE 'D:\\Oracle\\oradata\\test\\rbs01.dbf' SIZE 256M REUSE
AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE(INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);
--\u521b\u5efa\u7528\u6237\u8868\u7a7a\u95f4
CREATE TABLESPACE USERS DATAFILE 'D:\\Oracle\\oradata\\test\\users01.dbf' SIZE 128M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);
--\u521b\u5efa\u4e34\u65f6\u8868\u7a7a\u95f4
CREATE TABLESPACE TEMP DATAFILE 'D:\\Oracle\\oradata\\test\\temp01.dbf' SIZE 32M REUSE
AUTOEXTEND ON NEXT 640K
MINIMUM EXTENT 64K
DEFAULT STORAGE(INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) TEMPORARY;
--\u521b\u5efa\u5de5\u5177\u8868\u7a7a\u95f4
CREATE TABLESPACE TOOLS DATAFILE 'D:\\Oracle\\oradata\\test\\tools01.dbf' SIZE 64M REUSE
AUTOEXTEND ON NEXT 320K
MINIMUM EXTENT 32K
DEFAULT STORAGE ( INITIAL 32K NEXT 32K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);
--\u521b\u5efa\u7d22\u5f15\u8868\u7a7a\u95f4
CREATE TABLESPACE INDX DATAFILE 'D:\\Oracle\\oradata\\test\\indx01.dbf' SIZE 32M REUSE
AUTOEXTEND ON NEXT 1280K
MINIMUM EXTENT 128K
DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0);
--\u521b\u5efa\u56de\u6eda\u6bb5
CREATE PUBLIC ROLLBACK SEGMENT RBS0 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS1 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS2 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS3 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS4 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS5 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS6 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS7 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS8 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS9 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS10 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS11 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS12 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS13 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS14 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS15 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS16 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS17 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS18 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS19 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS20 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS21 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS22 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS23 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
CREATE PUBLIC ROLLBACK SEGMENT RBS24 TABLESPACE RBS STORAGE ( OPTIMAL 4096K );
--\u4f7f\u56de\u6eda\u6bb5\u5728\u7ebf
ALTER ROLLBACK SEGMENT \"RBS0\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS1\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS2\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS3\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS4\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS5\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS6\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS7\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS8\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS9\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS10\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS11\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS12\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS13\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS14\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS15\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS16\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS17\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS18\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS19\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS20\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS21\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS22\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS23\" ONLINE;
ALTER ROLLBACK SEGMENT \"RBS24\" ONLINE;
--\u4fee\u6539sys\u7528\u6237\u7684\u4e34\u65f6\u8868\u7a7a\u95f4\u4e3aTEMP
alter user sys temporary tablespace TEMP;
--\u521b\u5efa\u6570\u636e\u5b57\u5178\u8868
@D:\\Oracle\\Ora81\\Rdbms\\admin\\catalog.sql;
@D:\\Oracle\\Ora81\\Rdbms\\admin\\catexp7.sql
@D:\\Oracle\\Ora81\\Rdbms\\admin\\catproc.sql
@D:\\Oracle\\Ora81\\Rdbms\\admin\\caths.sql
connect system\/manager
@D:\\Oracle\\Ora81\\sqlplus\\admin\\pupbld.sql
connect internal\/Oracle
@D:\\Oracle\\Ora81\\Rdbms\\admin\\catrep.sql
exit
--\u751f\u6210SQL*Plus\u5e2e\u52a9\u7cfb\u7edf
sqlplus SYSTEM\/manager
@D:\\Oracle\\Ora81\\sqlplus\\admin\\help\\helpbld.sql helpus.sql
exit
--\u4fee\u6539system\u7528\u6237\u9ed8\u8ba4\u8868\u7a7a\u95f4\u548c\u4e34\u65f6\u8868\u7a7a\u95f4
svrmgrl
connect internal\/Oracle
alter user system default tablespace TOOLS;
alter user system temporary tablespace TEMP;
exit
7\u3001\u5c06test\u5b9e\u4f8b\u542f\u52a8\u670d\u52a1\u8bbe\u7f6e\u6210\u81ea\u52a8\u542f\u52a8\u65b9\u5f0f
D:\\Oracle\\Ora81\\bin\\oradim -edit -sid test -startmode auto
\u542f\u52a8ARCHIVELOG\u6a21\u5f0f
C:\\>svrmgrl
Oracle Server Manager Release 3.1.6.0.0 - Production
\u7248\u6743\u6240\u6709 (c) 1997\uff0c1999\uff0cOracle Corporation\u3002\u4fdd\u7559\u6240\u6709\u6743\u5229\u3002
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SVRMGR> connect internal
\u8fde\u63a5\u6210\u529f
SVRMGR>shutdown
\u5df2\u5173\u95ed\u6570\u636e\u5e93\u3002
\u5df2\u5378\u4e0b\u6570\u636e\u5e93\u3002
\u5df2\u5173\u95ed ORACLE \u5b9e\u4f8b\u3002
SVRMGR> startup mount
\u5df2\u542f\u52a8 ORACLE \u5b9e\u4f8b\u3002
\u7cfb\u7edf\u5168\u5c40\u533a\u57df\u5408\u8ba1\u6709 57124108\u4e2a\u5b57\u8282
Fixed Size 70924\u4e2a\u5b57\u8282
Variable Size 40198144\u4e2a\u5b57\u8282
Database Buffers 16777216\u4e2a\u5b57\u8282
Redo Buffers 77824\u4e2a\u5b57\u8282
\u5df2\u88c5\u5165\u6570\u636e\u5e93\u3002
SVRMGR> alter database archivelog;
\u8bed\u53e5\u5df2\u5904\u7406\u3002
SVRMGR> archive log start
\u8bed\u53e5\u5df2\u5904\u7406\u3002
SVRMGR> alter database open;
\u8bed\u53e5\u5df2\u5904\u7406\u3002
SVRMGR> alter system switch logfile; --\u5f3a\u5236\u7cfb\u7edf\u8fdb\u884c\u65e5\u5fd7\u5207\u6362\uff0c\u53ef\u9a6c\u4e0a\u89c2\u5bdf\u5230\u5f52\u6863\u65e5\u5fd7\u7684\u4ea7\u751f
\u8bed\u53e5\u5df2\u5904\u7406\u3002
SVRMGR> exit
\u670d\u52a1\u5668\u7ba1\u7406\u7a0b\u5e8f\u7ed3\u675f\u3002
\u4fee\u6539\u6570\u636e\u5e93\u53c2\u6570\u6587\u4ef6c:\\Oracle\\admin\\oradb\\pfile\\init.ora\uff0c
\u53d6\u6d88\u4ee5\u4e0b\u8bed\u53e5\u7684#\u6ce8\u91ca
log_archive_start = true
log_archive_dest_1 = \"location=C:\\Oracle\\oradata\\oradb\\archive\"
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
\u5173\u95ed\u6570\u636e\u5e93\uff0c\u91cd\u65b0\u542f\u52a8
\u67e5\u770bC:\\Oracle\\oradata\\oradb\\archive\u76ee\u5f55\u4e0b\uff0c\u53ef\u4ee5\u770b\u5230\u7c7b\u4f3cORADBT001S01201.ARC\u7684\u6587\u4ef6\uff0c\u8bf4\u660e\u5f52\u6863\u6210\u529f
PLUS:Oracle9i\u4e2d\u9700\u8981\u6267\u884c\u7684\u90e8\u5206
SQL> alter system set log_archive_dest_1 =\"location=E:\\Oracle\\oradata\\test\\archive\" scope = spfile;
SQL> alter system set log_archive_start = true scope = spfile;
\u8865\u5145\u4e00\u4e9b\u6982\u5ff5
\u89e3\u91cainit.ora\u53c2\u6570\u6587\u4ef6\u4e2d\u5173\u4e8e\u5f52\u6863\u91cd\u505a\u65e5\u5fd7\u53c2\u6570\u9879\u7684\u542b\u4e49
\u5f52\u6863\u6a21\u5f0f\u662f\u81ea\u52a8\u8fd8\u662f\u624b\u5de5\uff0ctrue\u4e3a\u81ea\u52a8\uff0cfalse\u4e3a\u624b\u5de5
log_archive_start = true
\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u6240\u4fdd\u5b58\u7684\u8def\u5f84
log_archive_dest_1 = \"location=C:\\Oracle\\oradata\\oradb\\archive\"
\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u7684\u547d\u540d\u65b9\u6cd5
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
\u5f52\u6863\u547d\u4ee4\uff1a
\u542f\u52a8\u81ea\u52a8\u5f52\u6863\u6a21\u5f0f\uff0c\u7cfb\u7edf\u91cd\u8d77\u540e\uff0c\u5c06\u6309init.ora\u4e2d\u7684\u53c2\u6570log_archive_start\u7684\u503c\u8bbe\u7f6e\u5f52\u6863\u65b9\u5f0f
SVRMGR> archive log start
\u542f\u52a8\u624b\u5de5\u5f52\u6863\u6a21\u5f0f
SVRMGR> archive log stop
\u67e5\u770b\u5f52\u6863\u4fe1\u606f\uff1a\u91cd\u505a\u65e5\u5fd7\u662f\u5426\u5f52\u6863\u65b9\u5f0f\u3001\u662f\u81ea\u52a8\u5f52\u6863\u8fd8\u662f\u624b\u5de5\u5f52\u6863\u3001\u5f52\u6863\u8def\u5f84\u3001\u6700\u65e7\u7684\u8054\u673a\u65e5\u5fd7\u5faa\u5e8f\u53f7
SVRMGR> archive log list
\u5f52\u6863\u4e00\u4e2a\u5df2\u6ee1\uff0c\u4f46\u6ca1\u6709\u5f52\u6863\u7684\u8054\u673a\u91cd\u505a\u65e5\u5fd7
SVRMGR> archive log next
\u5f52\u6863\u6240\u6709\u5df2\u6ee1\uff0c\u4f46\u6ca1\u6709\u5f52\u6863\u7684\u8054\u673a\u91cd\u505a\u65e5\u5fd7
SVRMGR> archive log all
\u6ce8\u610f\uff1a\u4e00\u4e2a\u4e8b\u52a1\u5373\u4f7f\u4e0d\u88ab\u63d0\u4ea4\uff0c\u4e5f\u4f1a\u88ab\u5199\u5165\u5230\u91cd\u505a\u65e5\u5fd7\u4e2d\u3002
SYS\u4e0b\u7684\u7a0b\u5e8f\u5305\u548c\u7a0b\u5e8f\u5305\u4f53\u4ec5STANDARD\u5305\u4f53\u53ef\u4ee5\u7f16\u8bd1\u4e3avalid
\u95ee\u9898\uff1a\u6211\u7684sys\u4e0b\u7684\u7a0b\u5e8f\u5305\u548c\u7a0b\u5e8f\u5305\u4f53\u90fd\u662finvalid.\u4f46\u662fSTANDARD\u5305\u4f53\u53ef\u4ee5\u7f16\u8bd1\u4e3avalid.\u5176\u4ed6\u7a0b\u5e8f\u5305\u90fd\u662finvalid. \u7f16\u8bd1\u65f6\u63d0\u793a\uff1a
VBO-4553\uff1aPL\/SQL \u7a0b\u5e8f\u5305\u7f16\u8bd1\u662f\u4e0d\u3002\u6709\u5173\u8be6\u7ec6\u4fe1\u606f\uff0c\u8bf7\u6309\u8be5\u5c5e\u6027\u9875\u4e0a\u7684\u663e\u793a\u9519\u8bef\u3002ORA-06554:????? PL\/SQL ???? DBMS_STANDARD
SQLPLUS\u8fde\u63a5\u65f6\u63d0\u793a\uff1aERROR:ORA-06554: package DBMS_STANDARD must be created before using PL\/SQL
Error accessing package DBMS_APPLICATION_INFO
ERROR:ORA-06554: package DBMS_STANDARD must be created before using PL\/SQL
\u89e3\u7b54\uff1a
\u7528$ORACLE_HOME\/RDBMS\/ADMIN\u4e0b\u9762\u7684\u76f8\u5173\u6587\u4ef6\u91cd\u65b0\u521b\u5efa\u4e00\u4e0b\u8fd9\u4e9b\u5305\u3002
SYSDBA\u767b\u9646\u8fd0\u884c
$ORACLE_HOME\/RDBMS\/ADMIN\/CATALOG.SQL
$ORACLE_HOME\/RDBMS\/ADMIN\/CATPROC.SQL
\u5982\u4f55\u5b9e\u73b0\uff1a\u63d2\u5165\u6570\u636e\u5230\u6570\u636e\u5e93A\u4e2d\u7684\u8868TPROCESS\uff0c\u6570\u636e\u5e93\u81ea\u52a8\u66f4\u65b0\u5230\u6570\u636e\u5e93B\u4e2d\u7684\u8868TLOG\uff1f
1. at db1
chk tnsnames.ora
CONNECT_STRING_DB2 = ...
tnsping CONNECT_STING_DB2
sql> create public database link DB2 using 'CONNECT_STING_DB2';
2. at db2
chk tnsnames.ora
CONNECT_STRING_DB1 = ...
tnsping CONNECT_STING_DB1
sql> create public database link DB1 using 'CONNECT_STING_DB1';
3. at db1
sql> create trigger ... after insert ...
insert into USER.TABLE@DB2 ... <<== using database link !!!
:NEW.column1, :NEW.column2 ...
\u4ece\u4e00\u4e2a\u5b57\u7b26\u96c6\u4e0d\u662f\u4e2d\u6587\u5b57\u7b26\u96c6\u7684\u6570\u636e\u5e93\u4e2dEXP\u6570\u636e\u5e93\uff0c\u7136\u540e\u5bfc\u5165\u5230\u4e00\u4e2a\u4e2d\u6587\u5b57\u7b26\u96c6\u7684\u6570\u636e\u5e93\u4e2d
EXP\/IMP\u662f\u4e00\u79cd\u6570\u636e\u5e93\u5230\u51fa\u5bfc\u5165\u5de5\u5177\uff0c\u4f46\u662f\u5728EXP\/IMP\u5bf9\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\u8981\u6c42\u6bd4\u8f83\u4e25\u683c\uff0c\u5982\u679cEXP\u51fa\u7684\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\u548c\u5bfc\u5165\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\u4e0d\u517c\u5bb9\u3002\u5bfc\u5165\u65e0\u6cd5\u5b8c\u6210\u3002\u6b64\u65f6\u9700\u8981\u91c7\u53d6\u4e00\u79cd\u7279\u6b8a\u7684\u65b9\u6cd5\u8fdb\u884c\u64cd\u4f5c\u3002\u7531\u4e8e\u8be5\u64cd\u4f5c\u662f\u6709\u4e00\u5b9a\u5371\u5bb3\u6027\u7684\u64cd\u4f5c\uff0c\u5728\u64cd\u4f5c\u8fc7\u7a0b\u4e2d\uff0c\u6570\u636e\u5e93\u7a81\u7136\u51fa\u73b0\u6545\u969c\u7684\u60c5\u51b5\u4e0b\uff0c\u4f1a\u5bfc\u81f4\u6570\u636e\u5e93\u53ef\u80fd\u65e0\u6cd5\u6b63\u5e38\u542f\u52a8\u3002\u56e0\u6b64\u64cd\u4f5c\u524d\u4e00\u5b9a\u8981\u5148\u5907\u4efd\u6570\u636e\u5e93\u3002
1\u3001\u5728\u539f\u6570\u636e\u5e93\u6267\u884csqlplus\uff0c\u8fde\u63a5sys\u7528\u6237\uff0c\u4fee\u6539\u5b57\u7b26\u96c6\u53c2\u6570\uff0c\u7136\u540e\u9000\u51fa\u3002
SQL> connect sys\/******;
update props$ set value$ = 'ZHS16GBK' where name = 'NLS_CHARACTERSET';
update props$ set value$ = 'ZHS16GBK' where name = 'NLS_NCHAR_CHARACTERSET';
commit;
SQL> quit;
2\u3001\u6267\u884csvrmgrl\uff0c\u5173\u95ed\u5e76\u91cd\u65b0\u5f00\u542fOracle\u6570\u636e\u5e93
SVRMGR> connect internal\/******; (\u53e3\u4ee4\u4e00\u822c\u4e3a\"Oracle\")
SVRMGR> shutdown immediate;
SVRMGR> startup mount;
SVRMGR> alter system enable restricted session;
SVRMGR> alter system set job_queue_process=0;
SVRMGR> alter database open;
SVRMGR> alter database character set ZHS16GBK;
SVRMGR> exit;
3\u3001\u4fee\u6539\u73af\u5883\u53d8\u91cfNLS_LANG
\u7531 AMERICAN_AMERICA.WE8ISO8859P1
\u8f6c\u6362\u4e3a SIMPLIFIED CHINESE_CHINA.ZHS16GBK
\u5982\u679c\u662fWINDOWS\uff0c\u7528Regedit\u4fee\u6539ORACLE\u4e0b\u7684\u952e\u503c\u3002\u5982\u679c\u662fUNIX\u7cfb\u7edf\uff0c\u4fee\u6539\u73af\u5883\u53d8\u91cf\uff1aNLS_LANG=...;export NLS_LANG
\u5982\u679c\u662fOpenVMS\uff1a\u4fee\u6539Login.com\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e\uff0c\u7136\u540e\u91cd\u65b0\u6267\u884c\u4e00\u6b21Login.com
4\u3001\u6267\u884cexp\u5bfc\u51fa\u6570\u636e
5\u3001\u5c06\u73af\u5883\u53d8\u91cfNLS_LANG\u4fee\u6539\u4e3a\u539f\u6765\u7684\u503c
6\u3001\u6267\u884csqlplus\uff0c\u8fde\u63a5sys\u7528\u6237\uff0c\u6062\u590d\u5b57\u7b26\u96c6\u53c2\u6570\uff0c\u7136\u540e\u9000\u51fa\u3002
connect sys\/******; (\u53e3\u4ee4\u4e00\u822c\u4e3a\"manager\")
update props$ set value$ = 'WE8ISO8859P1' where name = 'NLS_CHARACTERSET';
update props$ set value$ = 'WE8ISO8859P1' where name = 'NLS_NCHAR_CHARACTERSET';
commit;
SQL> quit;
7\u3001\u91cd\u590d\u6b65\u9aa42\uff0c\u5173\u95ed\u5e76\u91cd\u65b0\u5f00\u542fOracle\u6570\u636e\u5e93
8\u3001\u5c06\u5bfc\u51fa\u7684dmp\u6587\u4ef6\u5bfc\u5165\u76ee\u6807\u6570\u636e\u5e93\uff08\u5b57\u7b26\u96c6\u4e3a\u4e2d\u6587\uff09
\u6210\u529f\u521b\u5efaDBLink\uff0c\u4f46\u4e0d\u80fd\u8fde\u63a5
\u95ee\u9898\uff1a
ORACLE 8.1.6 for NT\uff0c\u73b0\u5728\u9700\u8981\u8fde\u53e6\u4e00\u4e2aORACLE 8 FOR UNIX\uff0c\u5f53\u7136\u662f\u8981\u5efa\u7acbDBLINK\u3002\u4f46\u662f\u5efa\u7acb\u672c\u5730\u7f51\u7edc\u670d\u52a1\u540d\u65f6\u53ef\u4ee5\u8fde\u63a5\u4e0a\u4e86\uff0c\u6240\u5efaDBLINK\u5c31\u662f\u8fde\u63a5\u4e0d\u4e0a\uff0c\u4e3a\u4ec0\u4e48\uff1f
\u7528select <xxx> from <\u8868\u540d>@<db_link>
\u9519\u8bef\u662f\uff1aORA-02085: \u6570\u636e\u5e93\u94fe\u63a5ORA8I.US.ORACLE.COM\u4e0eORA8I\u76f8\u8fde\u7ed3\uff08ora8i \u662fDBLINK\u7684\u540d\u5b57\uff09
\u89e3\u7b54\uff1a
\u5982\u679c\u4f60\u7684\u6e90\u6570\u636e\u5e93\u7684GLOBAL_NAME\uff1dTRUE\uff0c\u90a3\u4e48\u4f60\u7684DBLINK\u7684\u540d\u5b57\u5fc5\u987b\u548c\u8fdc\u7aef\u6570\u636e\u5e93\u7684\u5168\u5c40\u540d\u4e00\u81f4\uff0c\u5426\u5219\u4f1a\u53d1\u751f2085 \u9519\u8bef\u3002
\u4f60\u53ef\u8bbe\u7f6e\u6e90\u6570\u636e\u5e93\u7684GLOBAL_NAME\uff1dFALSE\uff0c\u4e5f\u53ef\u4ee5\u5728\u521b\u5efaDBLINK\u7684\u65f6\u5019\u628aDBLINK\u7684\u540d\u79f0\u8bbe\u7f6e\u4e3a\u8fdc\u7a0b\u6570\u636e\u5e93\u7684\u5168\u5c40\u540d\u3002
How to Configure the 9i Agent with Multiple Network Cards
fact: Oracle Intelligent Agent 9.0.1
fix:
Configuring the Version 9.0.1 Agent for Use with Multiple Network Cards (NIC)(From the Oracle IA User's Guide Release 9.0.1 Part Number A88771-02):
As with version 8.1.7 of the Intelligent Agent, 9i Intelligent Agent users have three options to configure the Agent on a machine with multiple network cards.By default the Agent will bind to the primary NIC on its machine ('le0' on UNIX platforms and 'network0' on Windows NT platforms). The other two options are:
a. Ability to bind to a NIC specified by the user.\r\n
\n\u4e0a\u4e00\u9875<\/a>1<\/a>2<\/a>3<\/a>4<\/a>5<\/a>6<\/strong>\u9605\u8bfb\u5168\u6587<\/a>\n<\/div>","3":"
\u5728\u5355\u673a\u4e0a\u5b89\u88c5805\uff0cOracleTNSListener80\u4e0d\u80fd\u542f\u52a8
\u95ee\u9898\uff1a
\u6211\u5728win2000\u4e0b\u5b89\u88c5\u4e86ORACLE805,\u6709\u7f51\u5361\uff0c\u4f46\u662f\u6ca1\u6709\u6ca1\u6709\u8fde\u7f51\u3002
\u89e3\u7b54\uff1a
1.805\u5fc5\u987b\u8054\u7f51\uff0c\u8bbe\u7f6eMicrosoft loopback\u6216\u4f7f\u7528816\u3002\u76f4\u63a5\u628aListener\u7684\u4fa6\u542c\u5730\u5740\u8bbe\u5230127.0.0.1\u4e0a\u8bd5\u8bd5\u770b\u3002
2.\u628a(PROTOCOL=ipc \u548csnmp)\u7684\u914d\u7f6e\u5220\u9664\uff0c\u6211\u662f\u5728win98\u4e0b\u88c5\u7684804\uff0c
listener.ora\u914d\u7f6e\u5982\u4e0b\uff1a
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 192.168.1.4)
(Port = 1521)
)
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
#\u88ab\u6ce8\u91ca (ADDRESS =
# (PROTOCOL = SPX)
# (Service = y_lsnr)
# )
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = y)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
\u8fd0\u884c\u6b63\u5e38\u3002
ORA-12516 TNS:\u76d1\u542c\u7a0b\u5e8f\u65e0\u6cd5\u627e\u5230\u5339\u914d\u7684\u4fe1\u606f\u6808\u7684\u53ef\u7528\u53e5\u67c4\u9519\u8bef
\u5148\u6253\u5f00 TNSNAMES.ORA \u8fd9\u4e2a\u6587\u4ef6, (\u4f4d\u4e8e \/\/OraHome1\/network\/admin\/tnsnames.ora) \uff0c\u786e\u5b9a(INSTANCE_NAME=) \u548c INITsid.ORA \u6587\u4ef6\u4e2d\u7684 \u5b9e\u4f8b\u540d(\u6267\u884c\u9879\u6b21) \u5339\u914d
ORA-12154 TNS\u4e0d\u80fd\u89e3\u6790\u670d\u52a1\u540d
\u4f7f\u7528Oracle\u7684\u7f51\u7edc\u914d\u7f6e\u52a9\u624b\u201cnet configration assistant\u201d\u5220\u9664\u6240\u6709\u7684\u7f51\u7edc\u7684\u914d\u7f6e\uff08\u4e3b\u8981\u662f\u76d1\u542c\u7a0b\u5e8f\u7684\u914d\u7f6e\u548c\u672c\u5730\u7f51\u7edc\u670d\u52a1\u540d\u7684\u914d\u7f6e\uff09\uff0c\u7136\u540e\u91cd\u65b0\u914d\u7f6e\u3002\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u547d\u4ee4\u5bdf\u770b\u662f\u5426\u4f60\u7684\u6570\u636e\u5e93\u670d\u52a1\u5668\u5df2\u7ecf\u542f\u52a8\uff08\u5728 *** \u4f5c\u7cfb\u7edf\u4e2d\u7684\u201c\u670d\u52a1\u201d\u4e2d\u663e\u793a\u4e3a\u542f\u52a8\uff0c\u4f46\u4f60\u7684\u6570\u636e\u5e93\u5e76\u4e0d\u4e00\u5b9a\u542f\u52a8\u4e86\u3002\u5728MS-Dos\u63d0\u793a\u7b26\u4e0b\u8f93\u5165\uff1a
C:\\svrmgrl
SVRMGR:>connect to internal
\u5bc6\u7801\uff1a<\u8f93\u5165\u4f60\u7684\u5bc6\u7801\uff0c\u5982\u679c\u4e0d\u77e5\u9053\uff0c\u8f93\u5165ORACLE\u8bd5\u8bd5>
\u5982\u679c\u8fde\u63a5\u6210\u529f\uff0c\u6267\u884chelp\u53ef\u4ee5\u5bdf\u770b\u547d\u4ee4\u3002
SVRMGR>startup
\u5982\u679c\u63d0\u793a\u4f60\u7684\u6570\u636e\u5e93\u5df2\u7ecf\u542f\u52a8\uff0c\u5219\u6267\u884c\u201cstop\u201d\u505c\u6b62\u6570\u636e\u5e93\uff0c\u7136\u540e\u518d\u6267\u884c\u201cstartup\u201d\u542f\u52a8\u3002
\u65e0\u6cd5\u542f\u52a8\u5b9e\u4f8b\u670d\u52a1
\u63a7\u5236\u9762\u677f-->\u7ba1\u7406\u5de5\u5177-->\u670d\u52a1\u4e0b\u9762\u7684\u67e5\u770bOracleServiceTest\u670d\u52a1\u6709\u6ca1\u6709\u542f\u52a8\uff0c\u5982\u679c\u6ca1\u6709\u542f\u52a8\u5219\u542f\u52a8\u3002\u5982\u679c\u542f\u52a8\u65f6\u5019\u62a5\u627e\u4e0d\u5230\u8def\u5f84\uff0c\u5219\u67e5\u770b\u6ce8\u518c\u8868HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\OracleServiceTest\u9879\u5e76\u8bbe\u7f6e ImagePath>D:\\Oracle\\Ora92\\BIN\\Oracle.exe test\uff08\u4f60\u7684\u5b89\u88c5\u76ee\u5f55\uff0c\u53c2\u6570\u4e3a\u4f60\u7684\u670d\u52a1\u540d\uff09\u4ee5\u4e0a\u4e24\u5219\u90fd\u53ef\u80fd\u662f\u7531\u4e8e\u8fd0\u884c\u4e86\u6ce8\u518c\u8868\u8f6f\u4ef6\u9020\u6210\uff0c\u6bd4\u5982\u4f18\u5316\u5927\u5e08\u4e4b\u7c7b\uff0c\u6211\u4e2a\u4eba\u7684\u89e3\u51b3\u529e\u6cd5\u662f\u5728\u626b\u63cf\u6ce8\u518c\u8868\u7684\u65f6\u5019\u7565\u8fc7HKEY_LOCAL_MACHINE\u3002
\u5728Windows\u5e73\u53f0\u4e0a\uff0c\u5b89\u88c5Oracle\u540e\u4ea7\u751f\u5982\u4e0b\u670d\u52a1
OracleMTSRecoveryService
OracleOraHome92Agent
OracleOraHome92HTTPServer
OracleOraHome92TNSListener
OracleServiceTest\u2014\u2014\u4ee5\u4e0a\u4e3a\u7f3a\u7701\u914d\u7f6e\u4e3a\u81ea\u52a8\u542f\u52a8\u7684
OracleOraHome92ClientCache
OracleOraHome92PagingServer
OracleOraHome92SNMPPeerEncapsulator
OracleOraHome92SNMPPeerMasterAgent
\u8bbe\u7f6e\u81ea\u52a8\u542f\u52a8\u6570\u636e\u5e93
\u53ef\u901a\u8fc7\u4fee\u6539\u6ce8\u518c\u8868\u6765\u5b9e\u73b0\uff1a
hkey_local_machine->software->microsoft->windows->currentversion->run->\u6dfb\u52a0\u4e00\u4e2a\u952e\u503cOraclestart->\u5176\u503c\u4e3a:c:\\Oracle\\ora81\\bin\\oradim.exe -startup -sid \u6570\u636e\u5e93\u522b\u540d -usepwd Oracle -starttype inst
\u5728\u542f\u52a8ORACLE\u670d\u52a1\u65f6\u65e0\u6cd5\u542f\u52a8\u2018OracleOracleAgent'
\u95ee\u9898\uff1a\u63d0\u793a\u9519\u8bef\u5982\u4e0b\uff1a\u201c\u5728\u672c\u5730\u8ba1\u7b97\u673a\u65e0\u6cd5\u542f\u52a8OracleOracleAgent\u670d\u52a1\u3002\u9519\u8bef\uff1a3221356559\u201d
\u539f\u56e0\uff1a
The Intelligent Agent stores all jobs and event requests in a series of queue files in the network\/agent directory. Upon startup, the Agent compares the actual hostname of the server to the hostname stored in the queue files. If the hostname of the server changes, the Agent will not recognize the queue files and will consider them corrupt. Then, the Agent will not start.
\u89e3\u7b54\uff1a
1. Remove the services.ora and all \"q\" files (*.q) from the $Oracle_Home\\network\\agent directory
2. Re-start the Intelligent Agent.
\u6280\u5de7\uff1a
This fix should be done with the understanding that any jobs or events registered against that Agent will be lost. Any active jobs or registered events against this agent should be removed from OEM console before deleting the agent's *.q files.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist\u9519\u8bef
\u95ee\u9898\uff1a
\u521a\u521a\u88c5\u4e0aOracle8.1.7\u4ee5\u540e\uff08\u5b89\u88c5\u8fc7\u7a0b\u975e\u5e38\u6b63\u5e38\uff09\uff0c\u8fd0\u884c\u4ee5\u4e0b\u64cd\u4f5c\uff0c\u4e00\u5207\u6b63\u5e38\u3002
C:\\>sqlplus system\/manager
SQL*Plus: Release 8.1.7.0.0 - Production on \u661f\u671f\u56db 11\u6708 13 20:01:20 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
\u8fde\u63a5\u5230:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL>
\u4f46\u662f\u53ea\u8981\u91cd\u542f\u7535\u8111\uff0c\u518d\u8fd0\u884c\u540c\u6837\u64cd\u4f5c\uff0c\u5c31\u4f1a\u51fa\u73b0\u5982\u4e0b\u7684\u95ee\u9898\uff1a
C:\\>sqlplus system\/manager
SQL*Plus: Release 8.1.7.0.0 - Production on \u661f\u671f\u56db 11\u6708 13 19:28:25 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR\uff1a
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
\u6b64\u65f6\u67e5\u770bOracle\u8fdb\u7a0b\uff0c\u6240\u5360\u7528\u5185\u5b58\u4e0d\u523010m\u3002
\u4f46\u662f\u53ea\u8981\u6267\u884c\u5b8cDatabase Configuration Assistant--\u3009\u66f4\u6539\u6570\u636e\u5e93\u8bbe\u7f6e\u540e\uff0c
\u518d\u6b21\u6267\u884c\u5982\u4e0a\u64cd\u4f5c\uff0c\u5c31\u80fd\u6b63\u5e38\u8fd0\u884c\uff1a
\u6b64\u65f6Oracle\u8fdb\u7a0b\u5360\u7528\u5185\u5b58\u63a5\u8fd1100m\uff0c\u5e94\u8be5\u6bd4\u8f83\u6b63\u5e38\u3002
\u4f46\u662f\u53ea\u8981\u91cd\u65b0\u542f\u52a8\uff0c\u5c31\u4f1a\u4f9d\u7136\u51fa\u73b0
ERROR\uff1a
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
\u8fd9\u79cd\u9519\u8bef\uff0c\u53ea\u80fd\u7528Database Configuration Assistant\u66f4\u6539\u6570\u636e\u5e93\u8bbe\u7f6e\u540e\u624d\u80fd\u4f7f\u7528\uff0c\u91cd\u542f\u540e\u95ee\u9898\u4f9d\u65e7\u3002\u8ba9\u6211\u767e\u601d\u4e0d\u5f97\u5176\u89e3\u3002
\u89e3\u7b54\uff1a
\u6570\u636e\u5e93\u5b9e\u4f8b\u6ca1\u968f\u8ba1\u7b97\u673a\u542f\u52a8\u3002
1.\u6570\u636e\u5e93\u542f\u52a8\u53c2\u6570\u4e2d\u662f\u5426\u6709\u975ePUBLIC\u56de\u6eda\u6bb5! \u8981\u662f\u6709\u7684\u8bdd\u5c31\u5148\u5c4f\u853d\u6389,\u7b49\u521b\u5efa\u5b8c\u56de\u6eda\u6bb5\u540e\u91cd\u65b0\u6253\u5f00,\u5e94\u8be5\u5c31\u6ca1\u6709\u95ee\u9898\u4e86\u3002\u5f53\u65f6\u5728ORACLE 7\u4e0b\u6210\u529f\u3002\u5f53\u65f6\u6211\u7528\u539f\u6709\u7684\u6570\u636e\u5e93\u914d\u7f6e\u53c2\u6570(*.ORA)\u6587\u4ef6\u521b\u5efa\u4ee5\u540e\u5c31\u51fa\u73b0\u4e86\u4e0a\u9762\u7684\u95ee\u9898\u3002
2.\u5efa\u8bae\u6b64\u65f6\u624b\u52a8\u542f\u52a8\u670d\u52a1\uff0c\u89c2\u5bdf\u5982\u679c\u51fa\u73b0\u7f3a\u5c11\u8def\u5f84\u7684\u63d0\u793a\uff0c\u53ef\u4ee5\u53c2\u7167\u4e0a\u6587\u8bbe\u5b9a\u76f8\u5173\u8def\u5f84\u3002
ORA-12500: TNS: \u76d1\u542c\u7a0b\u5e8f\u65e0\u6cd5\u542f\u52a8\u4e13\u7528\u670d\u52a1\u5668\u8fdb\u7a0b
1.lsnrctl status
2.lsnrctl start
3.sqlplus \/nolog
4.connect \/ as sysdba
5.startup nomount
6.alter database open
\u9010\u6b65\u5206\u89e3\u67e5\u627e\u95ee\u9898\u3002
\u6709\u53ef\u80fd\u662flistener.ora\u6587\u4ef6\u88ab\u7834\u574f\u4e86\uff0c\u9047\u5230\u8fc7\u7c7b\u4f3c\u7684\u95ee\u9898\uff0c\u91cd\u65b0\u914d\u7f6elistener.ora\u5c31\u53ef\u4ee5\u4e86\u3002
\u5728\u5355\u673a\u4e0a\u5b89\u88c5805\uff0cOracleTNSListener80\u4e0d\u80fd\u542f\u52a8
\u95ee\u9898\uff1a
\u6211\u5728win2000\u4e0b\u5b89\u88c5\u4e86ORACLE805,\u6709\u7f51\u5361\uff0c\u4f46\u662f\u6ca1\u6709\u6ca1\u6709\u8fde\u7f51\u3002
\u89e3\u7b54\uff1a
1.805\u5fc5\u987b\u8054\u7f51\uff0c\u8bbe\u7f6eMicrosoft loopback\u6216\u4f7f\u7528816\u3002\u76f4\u63a5\u628aListener\u7684\u4fa6\u542c\u5730\u5740\u8bbe\u5230127.0.0.1\u4e0a\u8bd5\u8bd5\u770b\u3002
2.\u628a(PROTOCOL=ipc \u548csnmp)\u7684\u914d\u7f6e\u5220\u9664\uff0c\u6211\u662f\u5728win98\u4e0b\u88c5\u7684804\uff0c
listener.ora\u914d\u7f6e\u5982\u4e0b\uff1a
LISTENER =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 192.168.1.4)
(Port = 1521)
)
(ADDRESS =
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
#\u88ab\u6ce8\u91ca (ADDRESS =
# (PROTOCOL = SPX)
# (Service = y_lsnr)
# )
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = y)
(SID_NAME = ORCL)
)
(SID_DESC =
(SID_NAME = extproc)
(PROGRAM=extproc)
)
)
\u8fd0\u884c\u6b63\u5e38\u3002
ORA-12516 TNS:\u76d1\u542c\u7a0b\u5e8f\u65e0\u6cd5\u627e\u5230\u5339\u914d\u7684\u4fe1\u606f\u6808\u7684\u53ef\u7528\u53e5\u67c4\u9519\u8bef
\u5148\u6253\u5f00 TNSNAMES.ORA \u8fd9\u4e2a\u6587\u4ef6, (\u4f4d\u4e8e \/\/OraHome1\/network\/admin\/tnsnames.ora) \uff0c\u786e\u5b9a(INSTANCE_NAME=) \u548c INITsid.ORA \u6587\u4ef6\u4e2d\u7684 \u5b9e\u4f8b\u540d(\u6267\u884c\u9879\u6b21) \u5339\u914d
ORA-12154 TNS\u4e0d\u80fd\u89e3\u6790\u670d\u52a1\u540d
\u4f7f\u7528Oracle\u7684\u7f51\u7edc\u914d\u7f6e\u52a9\u624b\u201cnet configration assistant\u201d\u5220\u9664\u6240\u6709\u7684\u7f51\u7edc\u7684\u914d\u7f6e\uff08\u4e3b\u8981\u662f\u76d1\u542c\u7a0b\u5e8f\u7684\u914d\u7f6e\u548c\u672c\u5730\u7f51\u7edc\u670d\u52a1\u540d\u7684\u914d\u7f6e\uff09\uff0c\u7136\u540e\u91cd\u65b0\u914d\u7f6e\u3002\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u547d\u4ee4\u5bdf\u770b\u662f\u5426\u4f60\u7684\u6570\u636e\u5e93\u670d\u52a1\u5668\u5df2\u7ecf\u542f\u52a8\uff08\u5728 *** \u4f5c\u7cfb\u7edf\u4e2d\u7684\u201c\u670d\u52a1\u201d\u4e2d\u663e\u793a\u4e3a\u542f\u52a8\uff0c\u4f46\u4f60\u7684\u6570\u636e\u5e93\u5e76\u4e0d\u4e00\u5b9a\u542f\u52a8\u4e86\u3002\u5728MS-Dos\u63d0\u793a\u7b26\u4e0b\u8f93\u5165\uff1a
C:\\svrmgrl
SVRMGR:>connect to internal
\u5bc6\u7801\uff1a<\u8f93\u5165\u4f60\u7684\u5bc6\u7801\uff0c\u5982\u679c\u4e0d\u77e5\u9053\uff0c\u8f93\u5165ORACLE\u8bd5\u8bd5>
\u5982\u679c\u8fde\u63a5\u6210\u529f\uff0c\u6267\u884chelp\u53ef\u4ee5\u5bdf\u770b\u547d\u4ee4\u3002
SVRMGR>startup
\u5982\u679c\u63d0\u793a\u4f60\u7684\u6570\u636e\u5e93\u5df2\u7ecf\u542f\u52a8\uff0c\u5219\u6267\u884c\u201cstop\u201d\u505c\u6b62\u6570\u636e\u5e93\uff0c\u7136\u540e\u518d\u6267\u884c\u201cstartup\u201d\u542f\u52a8\u3002
\u65e0\u6cd5\u542f\u52a8\u5b9e\u4f8b\u670d\u52a1
\u63a7\u5236\u9762\u677f-->\u7ba1\u7406\u5de5\u5177-->\u670d\u52a1\u4e0b\u9762\u7684\u67e5\u770bOracleServiceTest\u670d\u52a1\u6709\u6ca1\u6709\u542f\u52a8\uff0c\u5982\u679c\u6ca1\u6709\u542f\u52a8\u5219\u542f\u52a8\u3002\u5982\u679c\u542f\u52a8\u65f6\u5019\u62a5\u627e\u4e0d\u5230\u8def\u5f84\uff0c\u5219\u67e5\u770b\u6ce8\u518c\u8868HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\OracleServiceTest\u9879\u5e76\u8bbe\u7f6e ImagePath>D:\\Oracle\\Ora92\\BIN\\Oracle.exe test\uff08\u4f60\u7684\u5b89\u88c5\u76ee\u5f55\uff0c\u53c2\u6570\u4e3a\u4f60\u7684\u670d\u52a1\u540d\uff09\u4ee5\u4e0a\u4e24\u5219\u90fd\u53ef\u80fd\u662f\u7531\u4e8e\u8fd0\u884c\u4e86\u6ce8\u518c\u8868\u8f6f\u4ef6\u9020\u6210\uff0c\u6bd4\u5982\u4f18\u5316\u5927\u5e08\u4e4b\u7c7b\uff0c\u6211\u4e2a\u4eba\u7684\u89e3\u51b3\u529e\u6cd5\u662f\u5728\u626b\u63cf\u6ce8\u518c\u8868\u7684\u65f6\u5019\u7565\u8fc7HKEY_LOCAL_MACHINE\u3002
\u5728Windows\u5e73\u53f0\u4e0a\uff0c\u5b89\u88c5Oracle\u540e\u4ea7\u751f\u5982\u4e0b\u670d\u52a1
OracleMTSRecoveryService
OracleOraHome92Agent
OracleOraHome92HTTPServer
OracleOraHome92TNSListener
OracleServiceTest\u2014\u2014\u4ee5\u4e0a\u4e3a\u7f3a\u7701\u914d\u7f6e\u4e3a\u81ea\u52a8\u542f\u52a8\u7684
OracleOraHome92ClientCache
OracleOraHome92PagingServer
OracleOraHome92SNMPPeerEncapsulator
OracleOraHome92SNMPPeerMasterAgent
\u8bbe\u7f6e\u81ea\u52a8\u542f\u52a8\u6570\u636e\u5e93
\u53ef\u901a\u8fc7\u4fee\u6539\u6ce8\u518c\u8868\u6765\u5b9e\u73b0\uff1a
hkey_local_machine->software->microsoft->windows->currentversion->run->\u6dfb\u52a0\u4e00\u4e2a\u952e\u503cOraclestart->\u5176\u503c\u4e3a:c:\\Oracle\\ora81\\bin\\oradim.exe -startup -sid \u6570\u636e\u5e93\u522b\u540d -usepwd Oracle -starttype inst
\u5728\u542f\u52a8ORACLE\u670d\u52a1\u65f6\u65e0\u6cd5\u542f\u52a8\u2018OracleOracleAgent'
\u95ee\u9898\uff1a\u63d0\u793a\u9519\u8bef\u5982\u4e0b\uff1a\u201c\u5728\u672c\u5730\u8ba1\u7b97\u673a\u65e0\u6cd5\u542f\u52a8OracleOracleAgent\u670d\u52a1\u3002\u9519\u8bef\uff1a3221356559\u201d
\u539f\u56e0\uff1a
The Intelligent Agent stores all jobs and event requests in a series of queue files in the network\/agent directory. Upon startup, the Agent compares the actual hostname of the server to the hostname stored in the queue files. If the hostname of the server changes, the Agent will not recognize the queue files and will consider them corrupt. Then, the Agent will not start.
\u89e3\u7b54\uff1a
1. Remove the services.ora and all \"q\" files (*.q) from the $Oracle_Home\\network\\agent directory
2. Re-start the Intelligent Agent.
\u6280\u5de7\uff1a
This fix should be done with the understanding that any jobs or events registered against that Agent will be lost. Any active jobs or registered events against this agent should be removed from OEM console before deleting the agent's *.q files.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist\u9519\u8bef
\u95ee\u9898\uff1a
\u521a\u521a\u88c5\u4e0aOracle8.1.7\u4ee5\u540e\uff08\u5b89\u88c5\u8fc7\u7a0b\u975e\u5e38\u6b63\u5e38\uff09\uff0c\u8fd0\u884c\u4ee5\u4e0b\u64cd\u4f5c\uff0c\u4e00\u5207\u6b63\u5e38\u3002
C:\\>sqlplus system\/manager
SQL*Plus: Release 8.1.7.0.0 - Production on \u661f\u671f\u56db 11\u6708 13 20:01:20 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
\u8fde\u63a5\u5230:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL>
\u4f46\u662f\u53ea\u8981\u91cd\u542f\u7535\u8111\uff0c\u518d\u8fd0\u884c\u540c\u6837\u64cd\u4f5c\uff0c\u5c31\u4f1a\u51fa\u73b0\u5982\u4e0b\u7684\u95ee\u9898\uff1a
C:\\>sqlplus system\/manager
SQL*Plus: Release 8.1.7.0.0 - Production on \u661f\u671f\u56db 11\u6708 13 19:28:25 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR\uff1a
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
\u6b64\u65f6\u67e5\u770bOracle\u8fdb\u7a0b\uff0c\u6240\u5360\u7528\u5185\u5b58\u4e0d\u523010m\u3002
\u4f46\u662f\u53ea\u8981\u6267\u884c\u5b8cDatabase Configuration Assistant--\u3009\u66f4\u6539\u6570\u636e\u5e93\u8bbe\u7f6e\u540e\uff0c
\u518d\u6b21\u6267\u884c\u5982\u4e0a\u64cd\u4f5c\uff0c\u5c31\u80fd\u6b63\u5e38\u8fd0\u884c\uff1a
\u6b64\u65f6Oracle\u8fdb\u7a0b\u5360\u7528\u5185\u5b58\u63a5\u8fd1100m\uff0c\u5e94\u8be5\u6bd4\u8f83\u6b63\u5e38\u3002
\u4f46\u662f\u53ea\u8981\u91cd\u65b0\u542f\u52a8\uff0c\u5c31\u4f1a\u4f9d\u7136\u51fa\u73b0
ERROR\uff1a
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
\u8fd9\u79cd\u9519\u8bef\uff0c\u53ea\u80fd\u7528Database Configuration Assistant\u66f4\u6539\u6570\u636e\u5e93\u8bbe\u7f6e\u540e\u624d\u80fd\u4f7f\u7528\uff0c\u91cd\u542f\u540e\u95ee\u9898\u4f9d\u65e7\u3002\u8ba9\u6211\u767e\u601d\u4e0d\u5f97\u5176\u89e3\u3002
\u89e3\u7b54\uff1a
\u6570\u636e\u5e93\u5b9e\u4f8b\u6ca1\u968f\u8ba1\u7b97\u673a\u542f\u52a8\u3002
1.\u6570\u636e\u5e93\u542f\u52a8\u53c2\u6570\u4e2d\u662f\u5426\u6709\u975ePUBLIC\u56de\u6eda\u6bb5! \u8981\u662f\u6709\u7684\u8bdd\u5c31\u5148\u5c4f\u853d\u6389,\u7b49\u521b\u5efa\u5b8c\u56de\u6eda\u6bb5\u540e\u91cd\u65b0\u6253\u5f00,\u5e94\u8be5\u5c31\u6ca1\u6709\u95ee\u9898\u4e86\u3002\u5f53\u65f6\u5728ORACLE 7\u4e0b\u6210\u529f\u3002\u5f53\u65f6\u6211\u7528\u539f\u6709\u7684\u6570\u636e\u5e93\u914d\u7f6e\u53c2\u6570(*.ORA)\u6587\u4ef6\u521b\u5efa\u4ee5\u540e\u5c31\u51fa\u73b0\u4e86\u4e0a\u9762\u7684\u95ee\u9898\u3002
2.\u5efa\u8bae\u6b64\u65f6\u624b\u52a8\u542f\u52a8\u670d\u52a1\uff0c\u89c2\u5bdf\u5982\u679c\u51fa\u73b0\u7f3a\u5c11\u8def\u5f84\u7684\u63d0\u793a\uff0c\u53ef\u4ee5\u53c2\u7167\u4e0a\u6587\u8bbe\u5b9a\u76f8\u5173\u8def\u5f84\u3002
ORA-12500: TNS: \u76d1\u542c\u7a0b\u5e8f\u65e0\u6cd5\u542f\u52a8\u4e13\u7528\u670d\u52a1\u5668\u8fdb\u7a0b
1.lsnrctl status
2.lsnrctl start
3.sqlplus \/nolog
4.connect \/ as sysdba
5.startup nomount
6.alter database open
\u9010\u6b65\u5206\u89e3\u67e5\u627e\u95ee\u9898\u3002
\u6709\u53ef\u80fd\u662flistener.ora\u6587\u4ef6\u88ab\u7834\u574f\u4e86\uff0c\u9047\u5230\u8fc7\u7c7b\u4f3c\u7684\u95ee\u9898\uff0c\u91cd\u65b0\u914d\u7f6elistener.ora\u5c31\u53ef\u4ee5\u4e86\u3002