Home » RDBMS Server » Server Administration » Error 119 and ERROR 130 (Centos 6.2 - Oracle 11gr2)
Error 119 and ERROR 130 [message #581461] Sun, 07 April 2013 17:21 Go to next message
rafael9br
Messages: 10
Registered: April 2013
Location: brasil
Junior Member
Hello,

I installed Oracle 11g r2 using this website : cezaralmeidajr.blogspot.com.br/2012/04/oracle-11g-r2-no-centos-62
After install I reboot the virtual machine, connect in SSH, but i have the problem in start Oracle

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

Please help me.

############
My tnsnames.ora
############

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.rcs.local)(PORT = 1521)) scope=memory;
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)



############
My listener.ora
############

# listener.ora Network Configuration File: /ora/app/oracle/product/11.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.rcs.local)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /ora/app/oracle



############
My init.ora:
############
db_recovery_file_dest=/ora/app/oracle/flash_recovery_area
db_recovery_file_dest_size=4039114752

###########################################
# Miscellaneous
###########################################
compatible=11.2.0.0.0
diagnostic_dest=/ora/app/oracle
memory_target=421527552

###########################################
# Processes and Sessions
###########################################
processes=150

###########################################
# Security and Auditing
###########################################
audit_file_dest=/ora/app/oracle/admin/orcl/adump
audit_trail=db
remote_login_passwordfile=EXCLUSIVE

###########################################
# Shared Server
###########################################
dispatchers="(PROTOCOL=TCP) (SERVICE=orasidXDB)"

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1




Re: Error 119 and ERROR 130 [message #581462 is a reply to message #581461] Sun, 07 April 2013 18:08 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

BTW, only V11.2.0.3 works with Centos V6

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

the parameter file (& not init.ora) contains a bad entry

do as below

cd /ora/app/oracle/product/11.2.0/dbs/
ls -ltr

COPY the results then PASTE all back here.

[Updated on: Sun, 07 April 2013 18:10]

Report message to a moderator

Re: Error 119 and ERROR 130 [message #581463 is a reply to message #581462] Sun, 07 April 2013 18:29 Go to previous messageGo to next message
rafael9br
Messages: 10
Registered: April 2013
Location: brasil
Junior Member
[oracle@localhost ~]$ cd /ora/app/oracle/product/11.2.0/dbs/
[oracle@localhost dbs]$ ls -ltr
total 32
-rw-r--r--. 1 oracle oracle 2851 May 15  2009 init.ora
drwx------. 2 oracle oracle 4096 Mar 25 15:52 peshm_orcl_0
-rw-r-----. 1 oracle oracle   24 Mar 25 15:55 lkORCL
-rw-r-----. 1 oracle oracle 1536 Mar 25 16:03 orapworasid
-rw-r--r--. 1 oracle oracle  930 Mar 26 19:24 initorasid.ora
drwx------. 2 oracle oracle 4096 Mar 26 19:27 peshm__0
-rw-r-----. 1 oracle oracle 2560 Mar 26 19:32 spfileorasid.ora
-rw-rw----. 1 oracle oracle 1544 Mar 26 21:05 hc_orasid.dat
Re: Error 119 and ERROR 130 [message #581464 is a reply to message #581463] Sun, 07 April 2013 18:33 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
cat /ora/app/oracle/product/11.2.0/dbs/initorasid.ora

post results from command above
Re: Error 119 and ERROR 130 [message #581465 is a reply to message #581464] Sun, 07 April 2013 18:39 Go to previous messageGo to next message
rafael9br
Messages: 10
Registered: April 2013
Location: brasil
Junior Member
[oracle@localhost dbs]$ cat /ora/app/oracle/product/11.2.0/dbs/initorasid.ora
orasid.__db_cache_size=146800640
orasid.__java_pool_size=4194304
orasid.__large_pool_size=4194304
orasid.__oracle_base='/ora/app/oracle'#ORACLE_BASE set from environment
orasid.__pga_aggregate_target=146800640
orasid.__sga_target=276824064
orasid.__shared_io_pool_size=0
orasid.__shared_pool_size=109051904
orasid.__streams_pool_size=4194304
*.audit_file_dest='/ora/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/ora/app/oracle/oradata/orcl/control01.ctl','/ora/app/oracle/flash_recovery_area/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='/ora/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/ora/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orasidXDB)'
*.memory_target=421527552
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
Re: Error 119 and ERROR 130 [message #581466 is a reply to message #581465] Sun, 07 April 2013 18:44 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
>ORA-00119: invalid specification for system parameter LOCAL_LISTENER
problem is with LOCAL_LISTENER parameter & it appears to only now exist within spfileorasid.ora file.

so do as below
sqlplus
/ as sysdba
create pfile from spfile;
!vi /ora/app/oracle/product/11.2.0/dbs/initorasid.ora
# remove line containing LOCAL_LISTENER & save the changed pfile
create spfile from pfile;
startup
Re: Error 119 and ERROR 130 [message #581467 is a reply to message #581466] Sun, 07 April 2013 19:07 Go to previous messageGo to next message
rafael9br
Messages: 10
Registered: April 2013
Location: brasil
Junior Member
Don't exists this parameter in: /ora/app/oracle/product/11.2.0/dbs/initorasid.ora
Re: Error 119 and ERROR 130 [message #581468 is a reply to message #581467] Sun, 07 April 2013 19:11 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
sqlplus
/ as sysdba
startup pfile='/ora/app/oracle/product/11.2.0/dbs/initorasid.ora'

COPY the results from above then PASTE all back here
Re: Error 119 and ERROR 130 [message #581469 is a reply to message #581468] Sun, 07 April 2013 19:14 Go to previous messageGo to next message
rafael9br
Messages: 10
Registered: April 2013
Location: brasil
Junior Member
SQL> startup pfile='/ora/app/oracle/product/11.2.0/dbs/initorasid.ora'
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.rcs.local)(PORT=1521))'
Re: Error 119 and ERROR 130 [message #581471 is a reply to message #581469] Sun, 07 April 2013 19:25 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
>*.db_name='orcl'

I give up since what you post is totally inconsistent.
Re: Error 119 and ERROR 130 [message #581472 is a reply to message #581471] Sun, 07 April 2013 19:37 Go to previous messageGo to next message
rafael9br
Messages: 10
Registered: April 2013
Location: brasil
Junior Member
I coleted the information requested.
Sorry.
My first installation the Oracle.

If you want to allow a connection via SSH for you check. If yes, private menssaging.
Thank's.
Re: Error 119 and ERROR 130 [message #581474 is a reply to message #581472] Sun, 07 April 2013 19:58 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
sqlplus
/ as sysdba
startup pfile='/ora/app/oracle/product/11.2.0/dbs/init.ora'

COPY the results from above then PASTE all back here
Re: Error 119 and ERROR 130 [message #581497 is a reply to message #581474] Mon, 08 April 2013 05:58 Go to previous messageGo to next message
rafael9br
Messages: 10
Registered: April 2013
Location: brasil
Junior Member
SQL> startup pfile='/ora/app/oracle/product/11.2.0/dbs/init.ora'
ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
ORA-48140: the specified ADR Base directory does not exist [/ora/app/oracle/product/11.2.0/dbs/<ORACLE_BASE>]
ORA-48187: specified directory does not exist
Linux Error: 2: No such file or directory
Additional information: 1


More information in /ora/app/oracle/product/11.2.0/dbs/

spfile.orasid
                                                                             £  \£X0                                                                                                                                                                                                                                                                                                                                                                                                                                        orasid.__db_cache_size=146800640
orasid.__java_pool_size=4194304
orasid.__large_pool_size=4194304
orasid.__oracle_base='/ora/app/oracle'#ORACLE_BASE set from environment
orasid.__pga_aggregate_target=146800640
orasid.__sga_target=276824064
orasid.__shared_io_pool_size=0
orasid.__shared_pool_size=109051904
orasid.__streams_pool_size=4194304
*.audit_file_dest='/ora/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/ora/app/oracle/oradata/orcl/control01.ctl','/ora/app/oracle/flash_recovery_area/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='/ora/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/ora/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orasidXDB)'
*.memory_target=421527552
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'



init.ora

# 
# $Header: rdbms/admin/init.ora /main/23 2009/05/15 13:35:38 ysarig Exp $ 
# 
# Copyright (c) 1991, 1997, 1998 by Oracle Corporation
# NAME
#   init.ora
# FUNCTION
# NOTES
# MODIFIED
#     ysarig     05/14/09  - Updating compatible to 11.2
#     ysarig     08/13/07  - Fixing the sample for 11g
#     atsukerm   08/06/98 -  fix for 8.1.
#     hpiao      06/05/97 -  fix for 803
#     glavash    05/12/97 -  add oracle_trace_enable comment
#     hpiao      04/22/97 -  remove ifile=, events=, etc.
#     alingelb   09/19/94 -  remove vms-specific stuff
#     dpawson    07/07/93 -  add more comments regarded archive start
#     maporter   10/29/92 -  Add vms_sga_use_gblpagfile=TRUE 
#     jloaiza    03/07/92 -  change ALPHA to BETA 
#     danderso   02/26/92 -  change db_block_cache_protect to _db_block_cache_p
#     ghallmar   02/03/92 -  db_directory -> db_domain 
#     maporter   01/12/92 -  merge changes from branch 1.8.308.1 
#     maporter   12/21/91 -  bug 76493: Add control_files parameter 
#     wbridge    12/03/91 -  use of %c in archive format is discouraged 
#     ghallmar   12/02/91 -  add global_names=true, db_directory=us.acme.com 
#     thayes     11/27/91 -  Change default for cache_clone 
#     jloaiza    08/13/91 -         merge changes from branch 1.7.100.1 
#     jloaiza    07/31/91 -         add debug stuff 
#     rlim       04/29/91 -         removal of char_is_varchar2 
#   Bridge     03/12/91 - log_allocation no longer exists
#   Wijaya     02/05/91 - remove obsolete parameters
#
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation to help you start by providing
# a starting point to customize your RDBMS installation for your site. 
# 
# NOTE: The values that are used in this file are only intended to be used
# as a starting point. You may want to adjust/tune those values to your
# specific hardware and needs. You may also consider using Database
# Configuration Assistant tool (DBCA) to create INIT file and to size your
# initial set of tablespaces based on the user input.
###############################################################################

# Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
# install time)

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/flash_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300 
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'
                         


initorasid.ora
orasid.__db_cache_size=146800640
orasid.__java_pool_size=4194304
orasid.__large_pool_size=4194304
orasid.__oracle_base='/ora/app/oracle'#ORACLE_BASE set from environment
orasid.__pga_aggregate_target=146800640
orasid.__sga_target=276824064
orasid.__shared_io_pool_size=0
orasid.__shared_pool_size=109051904
orasid.__streams_pool_size=4194304
*.audit_file_dest='/ora/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/ora/app/oracle/oradata/orcl/control01.ctl','/ora/app/oracle/flash_recovery_area/orcl/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='/ora/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='/ora/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orasidXDB)'
*.memory_target=421527552
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'

[Updated on: Mon, 08 April 2013 06:10]

Report message to a moderator

Re: Error 119 and ERROR 130 [message #581502 is a reply to message #581497] Mon, 08 April 2013 06:56 Go to previous messageGo to next message
Michel Cadot
Messages: 59198
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
diagnostic_dest='<ORACLE_BASE>'


This is not a valid value.
Use a valid pfile to start your instance.

Regards
Michel
Re: Error 119 and ERROR 130 [message #581509 is a reply to message #581502] Mon, 08 April 2013 07:32 Go to previous messageGo to next message
rafael9br
Messages: 10
Registered: April 2013
Location: brasil
Junior Member
I changed "init.ora" and alter all <ORACLE_BASE> for "/ora/app/oracle/" and I changed to memory_target=1GB" for "memory_target=500M"

But started this problem again:

SQL> startup pfile='/ora/app/oracle/product/11.2.0/dbs/init.ora'
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=orcl.rcs.local)(PORT=1521))'
Re: Error 119 and ERROR 130 [message #581512 is a reply to message #581509] Mon, 08 April 2013 08:10 Go to previous messageGo to next message
Michel Cadot
Messages: 59198
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post result of:
grep -i LOCAL_LISTENER /ora/app/oracle/product/11.2.0/dbs/init.ora
grep -i ifile /ora/app/oracle/product/11.2.0/dbs/init.ora

Regards
Michel
Re: Error 119 and ERROR 130 [message #581514 is a reply to message #581512] Mon, 08 April 2013 08:16 Go to previous messageGo to next message
rafael9br
Messages: 10
Registered: April 2013
Location: brasil
Junior Member
Results follows:

[oracle@orcl ~]$ grep -i LOCAL_LISTENER /ora/app/oracle/product/11.2.0/dbs/init.ora


[oracle@orcl ~]$ grep -i ifile /ora/app/oracle/product/11.2.0/dbs/init.ora
#     hpiao      04/22/97 -  remove ifile=, events=, etc.
Re: Error 119 and ERROR 130 [message #581521 is a reply to message #581514] Mon, 08 April 2013 09:36 Go to previous messageGo to next message
Michel Cadot
Messages: 59198
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to add a local_listener line that fits your environment.

Regards
Michel
Re: Error 119 and ERROR 130 [message #581522 is a reply to message #581521] Mon, 08 April 2013 09:41 Go to previous messageGo to next message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
>You have to add a local_listener line that fits your environment.
or eliminate it completely, since it is NOT required to start or use Oracle DB
Re: Error 119 and ERROR 130 [message #581524 is a reply to message #581522] Mon, 08 April 2013 09:46 Go to previous messageGo to next message
rafael9br
Messages: 10
Registered: April 2013
Location: brasil
Junior Member
Where i remove or add? ...pfile?
Re: Error 119 and ERROR 130 [message #581532 is a reply to message #581524] Mon, 08 April 2013 11:08 Go to previous message
Michel Cadot
Messages: 59198
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the file that you use to start the instance/database.

Regards
Michel
Previous Topic: Automatic Memory Management
Next Topic: Spliting table partition without making the primary key index UNUSABLE
Goto Forum:
  


Current Time: Tue Sep 23 12:03:00 CDT 2014

Total time taken to generate the page: 0.12856 seconds