1ãæ£æ¥åæ¥çæ°æ®åºå®ä¾å
$ echo $ORACLE_SID
orcl
$ sqlplus / as sysdba
> select instance from v$thread;
INSTANCE
orcl
2ãå
³éæ°æ®åº
> shutdown immediate;
> exit;
3ãä¿®æ¹oracleç¨æ·çORACLE_SIDç¯å¢åéï¼å¦ç±orclä¿®æ¹ä¸ºexoaidc
$ vi /home/oracle/.bash_profile
export ORACLE_SID=exoaidc
$ source /home/oracle/.bash_profile
4ãä¿®æ¹/etc/oratabæ件ï¼å°sidåç±orclä¿®æ¹ä¸ºlinux
$ vi /etc/oratab
exoa:/u01/app/oracle/11.2/db_1:Y
5ãè¿å
¥å°$ORACLE_HOME/dbsç®å½
å°æææ件åä¸å
å«åæ¥çsidçä¿®æ¹ä¸ºå¯¹åºçæ°sidç
$ cd $ORACLE_HOME/dbs
$ mv hc_zf.dat hc_exoa.dat
$ mv lkZF lkexoa
$ mv orapwzf orapwexoa
$ mv spfilezf.ora spfileexoa.ora
6ãé建å£ä»¤æ件
å 为å£ä»¤æ件æ¹ååä¸è½å¨æ°å®ä¾ä¸ä½¿ç¨ï¼æ以é建
$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=123456 entries=5 force=y
7ãå¯å¨æ°æ®åº
$ sqlplus / as sysdba
> startup
8ãæ£æ¥æ°æ®åºå®ä¾å
éè¿å¦ä¸è¯å¥æ£æ¥æ°æ®åºå®ä¾åï¼åç°å®ä¾åå·²ç»ç±orclåæexoa
> select instance from v$thread;
INSTANCE
exoa
æ¥ä¸æ¥è¦ä¿®æ¹çå¬å¨ï¼å 为修æ¹äºsidï¼ä½æ¯çå¬å¨æ¤æ¶è¿æ¯é
ç½®åæ¥çorclçsid
ä¿®æ¹$ORACLE_HOME\network\admin\listener.oraæ件
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = ORCL)
)
)
æORCLæ¹æexoaå³å¯
温馨提示:答案为网友推荐,仅供参考