é®é¢æè¿°ï¼æ以åé»è®¤ç ORACLE_SID æ¯orcl ï¼ç°å¨ææ³åæ°æ®åæ¥ï¼ å¿
é¡»çæä¸åç ORACLE_SID ï¼ä»¥ä¾¿åºåå¼æ¥ã
ç°å¨ä»
éè¦ç®åçå 个æ¥éª¤å°±å¯ä»¥ä¿®æ¹å¥½ORACLE_SIDï¼
1.é¦å
shutdown immediate ï¼æ³¨æä¸è¦shutdown abortï¼
2.ä¿®æ¹oracleç¨æ·çç¯å¢åé ï¼ ï½/.bash_prfile
[oracle@oracle ~]$ vi .bash_profile
æ export ORACLE_SID=orcl è¿ä¸è¡ç orcl æ¹ä¸º ä½ æ³æ¹çå称ï¼æ该为 export ORACLE_SID=morcl
ç¶åä¿å并éåºï¼
3.ä¿®æ¹ /etc/oratab æ件 ï¼ å¨æ件çæåä¸è¡ å° orcl æ¹ä¸º morcl
morcl:/u01/app/oracle/product/10.2.0:N
4. æ¥ä¸æ¥å°±åºè¯¥ä¿®æ¹ oracle ç®å½éè¾¹çæ件 cd /$ORACLE_HOME/dbs æææå
å« orcl çæ件å ï¼ä¿®æ¹ä¸º å
å« morcl çæ件å
mv hc_orcl.dat hc_morcl.dat
mv lkORCL lkMORCL
mv spfileorcl.ora spfilemorcl.ora
mv orapworcl orapwmorcl
5.é建å£ä»¤æ件 æçç¨æ·åå¯ç 为ï¼oracle@oracle
[oracle@oracle dbs]$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle entries=5 force=y
5. æ£æ¥ORACLE_SID æ¯å¦çæ echo $ORACLE_SID å¦æ为çæï¼ åå¯ä»¥éå¯ æºå ï¼è®© ORACLE_SIDçæ
ãã[oracle@oracle dbs]$ echo $ORACLE_SID
ããmorcl
ãã[oracle@oracle dbs]$
ãã6.确认oracle_sidãä¿®æ¹å¥½äºå°±å¯å¯å¨æ°æ®åºäºï¼ç¶æ们æç®ä»¥å¾
å§ï¼ï¼ï¼ï¼ï¼ï¼ï¼
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL>
7.确认oracleãdatabase å
é¨å·²ç»SID å·²ç»ä¿®æ¹
SQL>
SQL> select instance from V$thread;
INSTANCE
--------------------------------------------------------------------------------
morcl
SQL>
ãã
ok 大ååæ ï¼
温馨提示:答案为网友推荐,仅供参考