最近系統(tǒng)啟動(dòng)時(shí)，收到了ORA-00119以及ORA-00132的錯(cuò)誤，該錯(cuò)誤實(shí)際上跟LISTENER有關(guān)，通常的處理辦法是將spfile轉(zhuǎn)儲(chǔ)為pfile然后從pfile啟動(dòng)
并生成新的spfile，不過該操作方式代價(jià)太高，需要重新啟動(dòng)數(shù)據(jù)庫(kù)。另一種方式則是直接修改tnsnames.ora中的服務(wù)名，使之與監(jiān)聽器中的listener名字保持一致，具體參考下面的細(xì)節(jié)。
一.錯(cuò)誤提示
SQL> startup nomount;
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ODBP'
二、分析錯(cuò)誤
1.查看錯(cuò)誤號(hào)對(duì)應(yīng)的具體描述
[Oracle@odbp admin]$ oerr ora 00132
00132, 00000, "syntax error or unresolved network name '%s'"
// *Cause: Listener address has syntax error or cannot be resolved.
// *Action: If a network name is specified, check that it corresponds
// to an entry in TNSNAMES.ORA or other address repository
// as configured for your system. Make sure that the entry
// is syntactically correct.
描述信息中給出了listener.ora中網(wǎng)絡(luò)名是否與tnsnames.ora相一致，需要檢查
2.查看監(jiān)聽
[Oracle@odbp admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER_ODBP =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = odbp.oradb.com)
(Oracle_HOME = /u01/app/oracle/10g)
(SID_NAME = odbp)
)
LISTENER_ODBP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = odbp.oradb.com)(PORT = 1521))
3.查看tnsnames.ora
[Oracle@odbp admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/tnsnames.ora
ODBP =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.192.11)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = odbp.oradb.com)
EXTPROC_CONNECTION_DATA =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(SID = PLSExtProc)
(PRESENTATION = RO)
由上面的listener.ora與tnsnames.ora可知
listener.ora中的監(jiān)聽名與tnsnames.ora中的服務(wù)名不一致
三、解決方法
1.修改tnsnames.ora中的服務(wù)名為L(zhǎng)ISTENER_ODBP，然后重新啟動(dòng)數(shù)據(jù)庫(kù)即可
2.可以將spfile(無pfile情況下)轉(zhuǎn)儲(chǔ)為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動(dòng)數(shù)據(jù)庫(kù)后重新生成spfile
可以采用下面的方法來轉(zhuǎn)儲(chǔ)，如下
[Oracle@odbp dbs]$ ls --沒有pfile
hc_odbp.dat initdw.ora init.ora lkODBP orapwodbp spfileodbp.ora
[Oracle@odbp dbs]$ strings spfileodbp.ora > initodbp.ora
[Oracle@odbp dbs]$ cat initodbp.ora
odbp.__db_cache_size=130023424
odbp.__java_pool_size=33554432
odbp.__large_pool_size=4194304
odbp.__shared_pool_size=113246208
odbp.__streams_pool_size=0
*.audit_file_dest='/u01/app/ *.background_dump_dest='/u01/app/ *.compatible='10.2.0.4.0' *.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.czbl888.cn】 一.錯(cuò)誤提示 SQL> startup nomount; ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_ODBP' 二、分析錯(cuò)誤 1.查看錯(cuò)誤號(hào)對(duì)應(yīng)的具體描述 [Oracle@odbp admin]$ oerr ora 00132 00132, 00000, "syntax error or unresolved network name '%s'" // *Cause: Listener address has syntax error or cannot be resolved. // *Action: If a network name is specified, check that it corresponds // to an entry in TNSNAMES.ORA or other address repository // as configured for your system. Make sure that the entry // is syntactically correct. 描述信息中給出了listener.ora中網(wǎng)絡(luò)名是否與tnsnames.ora相一致，需要檢查 2.查看監(jiān)聽 [Oracle@odbp admin]$ more listener.ora # listener.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER_ODBP = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = odbp.oradb.com) (Oracle_HOME = /u01/app/oracle/10g) (SID_NAME = odbp) ) ) LISTENER_ODBP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = odbp.oradb.com)(PORT = 1521)) ) 3.查看tnsnames.ora [Oracle@odbp admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ODBP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.192.11)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = odbp.oradb.com) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 由上面的listener.ora與tnsnames.ora可知 listener.ora中的監(jiān)聽名與tnsnames.ora中的服務(wù)名不一致 三、解決方法 1.修改tnsnames.ora中的服務(wù)名為L(zhǎng)ISTENER_ODBP，然后重新啟動(dòng)數(shù)據(jù)庫(kù)即可 2.可以將spfile(無pfile情況下)轉(zhuǎn)儲(chǔ)為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動(dòng)數(shù)據(jù)庫(kù)后重新生成spfile 可以采用下面的方法來轉(zhuǎn)儲(chǔ)，如下 [Oracle@odbp dbs]$ ls --沒有pfile hc_odbp.dat initdw.ora init.ora lkODBP orapwodbp spfileodbp.ora [Oracle@odbp dbs]$ strings spfileodbp.ora > initodbp.ora [Oracle@odbp dbs]$ cat initodbp.ora odbp.__db_cache_size=130023424 odbp.__java_pool_size=33554432 odbp.__large_pool_size=4194304 odbp.__shared_pool_size=113246208 odbp.__streams_pool_size=0 *.audit_file_dest='/u01/app/ *.background_dump_dest='/u01/app/ *.compatible='10.2.0.4.0' *.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
*.background_dump_dest='/u01/app/ *.compatible='10.2.0.4.0' *.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.czbl888.cn】 一.錯(cuò)誤提示 SQL> startup nomount; ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_ODBP' 二、分析錯(cuò)誤 1.查看錯(cuò)誤號(hào)對(duì)應(yīng)的具體描述 [Oracle@odbp admin]$ oerr ora 00132 00132, 00000, "syntax error or unresolved network name '%s'" // *Cause: Listener address has syntax error or cannot be resolved. // *Action: If a network name is specified, check that it corresponds // to an entry in TNSNAMES.ORA or other address repository // as configured for your system. Make sure that the entry // is syntactically correct. 描述信息中給出了listener.ora中網(wǎng)絡(luò)名是否與tnsnames.ora相一致，需要檢查 2.查看監(jiān)聽 [Oracle@odbp admin]$ more listener.ora # listener.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER_ODBP = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = odbp.oradb.com) (Oracle_HOME = /u01/app/oracle/10g) (SID_NAME = odbp) ) ) LISTENER_ODBP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = odbp.oradb.com)(PORT = 1521)) ) 3.查看tnsnames.ora [Oracle@odbp admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ODBP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.192.11)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = odbp.oradb.com) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 由上面的listener.ora與tnsnames.ora可知 listener.ora中的監(jiān)聽名與tnsnames.ora中的服務(wù)名不一致 三、解決方法 1.修改tnsnames.ora中的服務(wù)名為L(zhǎng)ISTENER_ODBP，然后重新啟動(dòng)數(shù)據(jù)庫(kù)即可 2.可以將spfile(無pfile情況下)轉(zhuǎn)儲(chǔ)為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動(dòng)數(shù)據(jù)庫(kù)后重新生成spfile 可以采用下面的方法來轉(zhuǎn)儲(chǔ)，如下 [Oracle@odbp dbs]$ ls --沒有pfile hc_odbp.dat initdw.ora init.ora lkODBP orapwodbp spfileodbp.ora [Oracle@odbp dbs]$ strings spfileodbp.ora > initodbp.ora [Oracle@odbp dbs]$ cat initodbp.ora odbp.__db_cache_size=130023424 odbp.__java_pool_size=33554432 odbp.__large_pool_size=4194304 odbp.__shared_pool_size=113246208 odbp.__streams_pool_size=0 *.audit_file_dest='/u01/app/ *.background_dump_dest='/u01/app/ *.compatible='10.2.0.4.0' *.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
*.compatible='10.2.0.4.0'
*.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.czbl888.cn】 一.錯(cuò)誤提示 SQL> startup nomount; ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_ODBP' 二、分析錯(cuò)誤 1.查看錯(cuò)誤號(hào)對(duì)應(yīng)的具體描述 [Oracle@odbp admin]$ oerr ora 00132 00132, 00000, "syntax error or unresolved network name '%s'" // *Cause: Listener address has syntax error or cannot be resolved. // *Action: If a network name is specified, check that it corresponds // to an entry in TNSNAMES.ORA or other address repository // as configured for your system. Make sure that the entry // is syntactically correct. 描述信息中給出了listener.ora中網(wǎng)絡(luò)名是否與tnsnames.ora相一致，需要檢查 2.查看監(jiān)聽 [Oracle@odbp admin]$ more listener.ora # listener.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER_ODBP = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = odbp.oradb.com) (Oracle_HOME = /u01/app/oracle/10g) (SID_NAME = odbp) ) ) LISTENER_ODBP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = odbp.oradb.com)(PORT = 1521)) ) 3.查看tnsnames.ora [Oracle@odbp admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ODBP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.192.11)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = odbp.oradb.com) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 由上面的listener.ora與tnsnames.ora可知 listener.ora中的監(jiān)聽名與tnsnames.ora中的服務(wù)名不一致 三、解決方法 1.修改tnsnames.ora中的服務(wù)名為L(zhǎng)ISTENER_ODBP，然后重新啟動(dòng)數(shù)據(jù)庫(kù)即可 2.可以將spfile(無pfile情況下)轉(zhuǎn)儲(chǔ)為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動(dòng)數(shù)據(jù)庫(kù)后重新生成spfile 可以采用下面的方法來轉(zhuǎn)儲(chǔ)，如下 [Oracle@odbp dbs]$ ls --沒有pfile hc_odbp.dat initdw.ora init.ora lkODBP orapwodbp spfileodbp.ora [Oracle@odbp dbs]$ strings spfileodbp.ora > initodbp.ora [Oracle@odbp dbs]$ cat initodbp.ora odbp.__db_cache_size=130023424 odbp.__java_pool_size=33554432 odbp.__large_pool_size=4194304 odbp.__shared_pool_size=113246208 odbp.__streams_pool_size=0 *.audit_file_dest='/u01/app/ *.background_dump_dest='/u01/app/ *.compatible='10.2.0.4.0' *.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
*.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.czbl888.cn】 一.錯(cuò)誤提示 SQL> startup nomount; ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_ODBP' 二、分析錯(cuò)誤 1.查看錯(cuò)誤號(hào)對(duì)應(yīng)的具體描述 [Oracle@odbp admin]$ oerr ora 00132 00132, 00000, "syntax error or unresolved network name '%s'" // *Cause: Listener address has syntax error or cannot be resolved. // *Action: If a network name is specified, check that it corresponds // to an entry in TNSNAMES.ORA or other address repository // as configured for your system. Make sure that the entry // is syntactically correct. 描述信息中給出了listener.ora中網(wǎng)絡(luò)名是否與tnsnames.ora相一致，需要檢查 2.查看監(jiān)聽 [Oracle@odbp admin]$ more listener.ora # listener.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER_ODBP = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = odbp.oradb.com) (Oracle_HOME = /u01/app/oracle/10g) (SID_NAME = odbp) ) ) LISTENER_ODBP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = odbp.oradb.com)(PORT = 1521)) ) 3.查看tnsnames.ora [Oracle@odbp admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ODBP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.192.11)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = odbp.oradb.com) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 由上面的listener.ora與tnsnames.ora可知 listener.ora中的監(jiān)聽名與tnsnames.ora中的服務(wù)名不一致 三、解決方法 1.修改tnsnames.ora中的服務(wù)名為L(zhǎng)ISTENER_ODBP，然后重新啟動(dòng)數(shù)據(jù)庫(kù)即可 2.可以將spfile(無pfile情況下)轉(zhuǎn)儲(chǔ)為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動(dòng)數(shù)據(jù)庫(kù)后重新生成spfile 可以采用下面的方法來轉(zhuǎn)儲(chǔ)，如下 [Oracle@odbp dbs]$ ls --沒有pfile hc_odbp.dat initdw.ora init.ora lkODBP orapwodbp spfileodbp.ora [Oracle@odbp dbs]$ strings spfileodbp.ora > initodbp.ora [Oracle@odbp dbs]$ cat initodbp.ora odbp.__db_cache_size=130023424 odbp.__java_pool_size=33554432 odbp.__large_pool_size=4194304 odbp.__shared_pool_size=113246208 odbp.__streams_pool_size=0 *.audit_file_dest='/u01/app/ *.background_dump_dest='/u01/app/ *.compatible='10.2.0.4.0' *.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
*.db_block_size=8192
*.db_domain='oradb.com'
*.db_file_multiblock_read_count=16
*.db_name='odbp'
*.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.czbl888.cn】 一.錯(cuò)誤提示 SQL> startup nomount; ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_ODBP' 二、分析錯(cuò)誤 1.查看錯(cuò)誤號(hào)對(duì)應(yīng)的具體描述 [Oracle@odbp admin]$ oerr ora 00132 00132, 00000, "syntax error or unresolved network name '%s'" // *Cause: Listener address has syntax error or cannot be resolved. // *Action: If a network name is specified, check that it corresponds // to an entry in TNSNAMES.ORA or other address repository // as configured for your system. Make sure that the entry // is syntactically correct. 描述信息中給出了listener.ora中網(wǎng)絡(luò)名是否與tnsnames.ora相一致，需要檢查 2.查看監(jiān)聽 [Oracle@odbp admin]$ more listener.ora # listener.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER_ODBP = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = odbp.oradb.com) (Oracle_HOME = /u01/app/oracle/10g) (SID_NAME = odbp) ) ) LISTENER_ODBP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = odbp.oradb.com)(PORT = 1521)) ) 3.查看tnsnames.ora [Oracle@odbp admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ODBP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.192.11)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = odbp.oradb.com) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 由上面的listener.ora與tnsnames.ora可知 listener.ora中的監(jiān)聽名與tnsnames.ora中的服務(wù)名不一致 三、解決方法 1.修改tnsnames.ora中的服務(wù)名為L(zhǎng)ISTENER_ODBP，然后重新啟動(dòng)數(shù)據(jù)庫(kù)即可 2.可以將spfile(無pfile情況下)轉(zhuǎn)儲(chǔ)為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動(dòng)數(shù)據(jù)庫(kù)后重新生成spfile 可以采用下面的方法來轉(zhuǎn)儲(chǔ)，如下 [Oracle@odbp dbs]$ ls --沒有pfile hc_odbp.dat initdw.ora init.ora lkODBP orapwodbp spfileodbp.ora [Oracle@odbp dbs]$ strings spfileodbp.ora > initodbp.ora [Oracle@odbp dbs]$ cat initodbp.ora odbp.__db_cache_size=130023424 odbp.__java_pool_size=33554432 odbp.__large_pool_size=4194304 odbp.__shared_pool_size=113246208 odbp.__streams_pool_size=0 *.audit_file_dest='/u01/app/ *.background_dump_dest='/u01/app/ *.compatible='10.2.0.4.0' *.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)'
*.job_queue_processes=10
*.local_listener='LISTENER_ODBP' --將改行注釋掉或置空
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.czbl888.cn】 一.錯(cuò)誤提示 SQL> startup nomount; ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_ODBP' 二、分析錯(cuò)誤 1.查看錯(cuò)誤號(hào)對(duì)應(yīng)的具體描述 [Oracle@odbp admin]$ oerr ora 00132 00132, 00000, "syntax error or unresolved network name '%s'" // *Cause: Listener address has syntax error or cannot be resolved. // *Action: If a network name is specified, check that it corresponds // to an entry in TNSNAMES.ORA or other address repository // as configured for your system. Make sure that the entry // is syntactically correct. 描述信息中給出了listener.ora中網(wǎng)絡(luò)名是否與tnsnames.ora相一致，需要檢查 2.查看監(jiān)聽 [Oracle@odbp admin]$ more listener.ora # listener.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER_ODBP = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = odbp.oradb.com) (Oracle_HOME = /u01/app/oracle/10g) (SID_NAME = odbp) ) ) LISTENER_ODBP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = odbp.oradb.com)(PORT = 1521)) ) 3.查看tnsnames.ora [Oracle@odbp admin]$ more tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/Oracle/10g/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ODBP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.192.11)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = odbp.oradb.com) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) 由上面的listener.ora與tnsnames.ora可知 listener.ora中的監(jiān)聽名與tnsnames.ora中的服務(wù)名不一致 三、解決方法 1.修改tnsnames.ora中的服務(wù)名為L(zhǎng)ISTENER_ODBP，然后重新啟動(dòng)數(shù)據(jù)庫(kù)即可 2.可以將spfile(無pfile情況下)轉(zhuǎn)儲(chǔ)為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動(dòng)數(shù)據(jù)庫(kù)后重新生成spfile 可以采用下面的方法來轉(zhuǎn)儲(chǔ)，如下 [Oracle@odbp dbs]$ ls --沒有pfile hc_odbp.dat initdw.ora init.ora lkODBP orapwodbp spfileodbp.ora [Oracle@odbp dbs]$ strings spfileodbp.ora > initodbp.ora [Oracle@odbp dbs]$ cat initodbp.ora odbp.__db_cache_size=130023424 odbp.__java_pool_size=33554432 odbp.__large_pool_size=4194304 odbp.__shared_pool_size=113246208 odbp.__streams_pool_size=0 *.audit_file_dest='/u01/app/ *.background_dump_dest='/u01/app/ *.compatible='10.2.0.4.0' *.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.czbl888.cn】
Oracle instance started.
Total System Global Area 285212672 bytes
Fixed Size 1267068 bytes
Variable Size 150997636 bytes
Database Buffers 130023424 bytes
Redo Buffers 2924544 bytes
SQL> create spfile from pfile;
File created.
SQL> startup force;
Database mounted.
Database opened.
*.audit_file_dest='/u01/app/ *.background_dump_dest='/u01/app/ *.compatible='10.2.0.4.0' *.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
*.background_dump_dest='/u01/app/ *.compatible='10.2.0.4.0' *.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
*.control_files='/u01/app/ *.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
*.core_dump_dest='/u01/app/ *.db_block_size=8192 *.db_domain='oradb.com' *.db_file_multiblock_read_count=16 *.db_name='odbp' *.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
*.db_recovery_file_dest='/u01/app/ *.db_recovery_file_dest_size=2147483648 *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)' *.job_queue_processes=10 *.local_listener='LISTENER_ODBP' --將改行注釋掉或置空 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile='EXCLUSIVE' *.sga_target=285212672 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
*.user_dump_dest='/u01/app/ SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】--> 服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
SQL> startup nomount pfile='/u01/app/ Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes SQL> create spfile from pfile; File created. SQL> startup force; Oracle instance started. Total System Global Area 285212672 bytes Fixed Size 1267068 bytes Variable Size 150997636 bytes Database Buffers 130023424 bytes Redo Buffers 2924544 bytes Database mounted. Database opened.本文出自：億恩科技【www.enidc.com】-->
服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]
0371-601359007*24小時(shí)客服服務(wù)熱線
0371-60135900
京公網(wǎng)安備41019702002023號(hào)
香港服務(wù)器租用
美國(guó)服務(wù)器租用
電信骨干機(jī)房
聯(lián)通骨干機(jī)房
