SQL> startup nomount;
ORA-00119: invalid specificationforsystem parameter LOCAL_LISTENER
ORA-00132: syntax erroror unresolved networkname'LISTENER_ODBP'

[oracle@odbp admin]$ oerr ora00132
00132, 00000, "syntax error or unresolved network name '%s'"
// *Cause:  Listener address has syntax erroror cannot be resolved.
// *Action: If a networknameis specified, check that it corresponds
//          to an entryin TNSNAMES.ORA or other address repository
//          as configured for your system. Make sure that theentry
//          is syntactically correct.

[oracle@odbp admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/10g/network/admin/listener.ora
# Generatedby 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))
)

[oracle@odbp admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/10g/network/admin/tnsnames.ora
# Generatedby 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)
)
)

[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/oracle/admin/odbp/adump'
*.background_dump_dest='/u01/app/oracle/admin/odbp/bdump'
*.compatible='10.2.0.4.0'
*.control_files='/u01/app/oracle/oradata/odbp/control01.ctl','/u01/app/oracle/oradata/odbp/control02.ctl'
*.core_dump_dest='/u01/app/oracle/admin/odbp/cdump'
*.db_block_size=8192
*.db_domain='oradb.com'
*.db_file_multiblock_read_count=16
*.db_name='odbp'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.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/oracle/admin/odbp/udump'
SQL> startup nomount pfile='/u01/app/oracle/10g/dbs/initodbp.ora';
ORACLE instance started.
Total SystemGlobal Area  285212672 bytes
Fixed Size1267068 bytes
VariableSize150997636 bytes
Database Buffers          130023424 bytes
Redo Buffers                2924544 bytes
SQL> createspfilefrompfile;
File created.
SQL> startup force;
ORACLE instance started.
Total SystemGlobal Area  285212672 bytes
Fixed Size1267068 bytes
VariableSize150997636 bytes
Database Buffers          130023424 bytes
Redo Buffers                2924544 bytes
Database mounted.
Database opened.

--转自