| Error 119 and ERROR 130 [message #581461] |
Sun, 07 April 2013 17:21  |
 |
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  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
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 #581497 is a reply to message #581474] |
Mon, 08 April 2013 05:58 |
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
