Ora-00119 error handling

Today, we are doing experiments to help identify machines and use them at will.Hostname sourceCommand to change the linux host name and then start the database to report the following error:
[Oracle @ source dbs] $ sqlplus/as sysdba

SQL * Plus: Release 11.2.0.2.0 Production on Sat Aug 24 20:11:43 2013

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS = (PROTOCOL = TCP) (HOST = source) (PORT = 1521 ))'

 

The pfile file is generated with this error. You have to remove the LOCAL_LISTENER parameter and start the database. The pfile to be opened does not contain the LOCAL_LISTERER parameter. This is strange.

The parameter file is as follows:
[Oracle @ source dbs] $ vi initCRM. ora

CRM. _ pga_aggregate_target = 503316480
CRM. _ db_cache_size = 268435456
CRM. _ java_pool_size = 16777216
CRM. _ large_pool_size = 16777216
CRM. _ oracle_base = '/oracle/app' # ORACLE_BASE set from environment
CRM. _ pga_aggregate_target = 503316480
CRM. _ sga_target = 754974720
CRM. _ shared_io_pool_size = 0
CRM. _ shared_pool_size = 402653184
CRM. _ streams_pool_size = 33554432
*. Audit_file_dest = '/oracle/app/admin/CRM/adump'
*. Audit_trail = 'db'
*. Compatible = '11. 2.0.0.0'
*. Control_files = '/oracle/CRM2/control01.ctl', '/oracle/CRM2/control02.ctl' # Restore Controlfile
*. Db_block_size = 8192
*. Db_cache_size = 218103808
*. Db_domain =''
*. Db_name = 'crm'
*. Diagnostic_dest = '/oracle/app'
*. Dispatchers = '(PROTOCOL = TCP) (SERVICE = CRMXDB )'
*. Log_archive_dest_1 = 'location =/oracle/archive'
*. Log_archive_dest_2 =''
*. Log_archive_format = '% t _ % s _ % r. dbf'
*. Memory_target = 1258291200
*. Open_cursors = 300
*. Processses = 150
*. Remote_login_passwordfile = 'clusive'
*. Undo_retention = 1200
*. Undo_tablespace = 'undotbs3'

 

Then, an error occurs when you use the pfile parameter to start the instance.
SQL> startup nomount pfile = '/oracle/app/db1/dbs/initCRM. ora ';
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS = (PROTOCOL = TCP) (HOST = source) (PORT = 1521 ))'

 

So I thought about it carefully. Since the host name is changed, this error occurs. Check whether/etc/hosts/is faulty. Check whether the hosts file is faulty.
[Oracle @ source dbs] $ cat/etc/hosts
# Do not remove the following line, or various programs
# That require network functionality will fail.
127.0.0.1 oracle localhost. localdomain localhost
: 1 localhost6.localdomain6 localhost6

 

The changed hosts file is as follows:

Root @ oracle ~] # Cat/etc/hosts
# Do not remove the following line, or various programs
# That require network functionality will fail.
127.0.0.1 source localhost. localdomain localhost

After the change, the database is started normally, as shown below:
[Root @ oracle ~] # Su-oracle
[Oracle @ source ~] $ Sqlplus/as sysdba

SQL * Plus: Release 11.2.0.2.0 Production on Sat Aug 24 20:17:45 2013

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1252663296 bytes
Fixed Size 2226072 bytes
Variable Size 973080680 bytes
Database Buffers 268435456 bytes
Redo Buffers 8921088 bytes
Database mounted.
Database opened.

 

This article is from the "myblog" blog, please be sure to keep this source http://jiujian.blog.51cto.com/444665/1282048