在 Linux/Windows 環境下修改 Oracle 資料庫實例名稱 (SID/DB_NAME) 屬高風險操作,需同步調整參數檔、密碼檔、環境變數、監聽註冊。本文記錄完整步驟與驗證指令。
SQL> SELECT instance_name FROM v$instance; -- orcl SQL> SHUTDOWN IMMEDIATE; $ lsnrctl stop orcl
/etc/oratab:orcl:... → bitc:...~oracle/.bash_profile:export ORACLE_SID=bitc → source .bash_profilecd $ORACLE_HOME/dbs mv hc_orcl.dat hc_bitc.dat mv lkORCL lkBITC mv orapworcl orapwbitc mv spfileorcl.ora spfilebitc.ora mv initorcl.ora initbitc.ora (若存在)
orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle entries=5 force=y
SQL> STARTUP; -- 若報 ORA-32004 (棄用參數) 僅警告,資料庫仍可開啟 SQL> SELECT instance_name FROM v$instance; -- bitc
/etc/oratab、.bash_profile,改用登錄 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ 中 ORACLE_SID 值。%ORACLE_HOME%\database\PWD.ora 。oradim -edit -sid bitc -new_sid bitc (或重建服務)。修改 listener.ora (透過 Net Manager 或手動編輯):
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = bitc)
(ORACLE_HOME = /app/oracle/product/11.2.0/dbhome_2)
(SID_NAME = bitc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.130)(PORT = 1522))
)
)
SQL> SHOW PARAMETER local_listener; -- 應為 BITC (對應 tnsnames.ora 別名) SQL> ALTER SYSTEM SET local_listener='BITC'; SQL> ALTER SYSTEM REGISTER; $ lsnrctl status -- 確認 Service "bitc" 有 1 個 instance READY
db_name 與 instance_name (RAC) 概念不同,單機通常相同。