Home » Other » General » invalid specification for system parameter LOCAL_LISTENER (Oracle dB 12c, oracle linux 7)
| invalid specification for system parameter LOCAL_LISTENER [message #656289] |
Sun, 02 October 2016 03:50  |
 |
Janning
Messages: 43
Registered: April 2016
|
Member |
|
|
Hi,
Let me start by saying, I'm not really a beginner at all this, but by no means an expert. I have Oracle 12c enterprise set up on a Oracle Enterprise Linux ver 7 box.
This has always worked fine, start Linux, from a terminal window
[oracle@oradev ~]$ sqlplus /nologSQL> conn SYS as SYSDBA
Enter password: xxxxx
startup
lsnrctl start
All was well. I have this running on VMware® Workstation 12 Pro, 12.5.0 build-4352439. I recently updated VMware...now when I get to
startup I get:
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=oradev.attlocal.net)(PORT=1522))'
SQL>
I believe my host name in oracle Linux (which is on VM ware, so maybe is in VM ware setting, this all started after updating VM ware)
is not the same, somehow is in my listener.ora ? It looks ok below to me, but as I said, I'm not expert level
I've taken many notes and screen shots, which can be seen at
http://www.aanning.com/ajissues/oracle_startup_faq/
Please advise?
James
|
|
|
|
|
|
|
|
| Re: invalid specification for system parameter LOCAL_LISTENER [message #656292 is a reply to message #656291] |
Sun, 02 October 2016 06:10  |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Quote:Is this to address a possible corrupt SPRILE? No. It is to remove the parameter that you have set incorrectly.
Quote:I don't know how to create a pfile from the spfile..then you use the to create the file it came from? You need to look up the command CREATE SPFILE...from PFILE... It is in the docs. Or take a basic DBA course.
Quote:I'm new to this You said "I'm not really a beginner at all this" 
Quote:From what I googled Ill need the database running Where do you read that rubbish? If you don't believe me, you could just try it, you know.
--update: mis-read something, corrected
[Updated on: Sun, 02 October 2016 06:13] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: invalid specification for system parameter LOCAL_LISTENER [message #656296 is a reply to message #656295] |
Sun, 02 October 2016 06:31 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Janning wrote on Sun, 02 October 2016 12:20 The spfile is created using the CREATE SPFILE statement; this requires connecting as SYSDBA.
Connect system/manager as sysdba;
CREATE SPFILE FROM PFILE;
The three hits in google, I came up with...say the above, ill continue looking for an alternative method So you've found the answer three times with Google, as well as being told by me and MC, and you still don't believe it? This is why DBAs hate some developers! Those developers who just won't believe what they are told.
|
|
|
|
|
|
|
|
|
|
| Re: invalid specification for system parameter LOCAL_LISTENER [message #656301 is a reply to message #656300] |
Sun, 02 October 2016 07:13 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
The idea of this bulletin board is to help people develop their skills, not to spoonfeed answers. However, I see from your topic on OTN that you have been stuck on this for a while, and we do have a guideline to provide complete answers if people are in a hurry on a production issue. So here you are:C:\Users\john>
C:\Users\john>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 2 13:09:49 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
orclz> create pfile='c:\tmp\initorclz.ora' from spfile='%ORACLE_HOME%\database\spfileorclz.ora';
File created.
orclz>exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
C:\Users\john>dir /tmp/init*
Parameter format not correct - "mp".
C:\Users\john>
C:\Users\john>dir \tmp\init*
Volume in drive C is OS
Volume Serial Number is 4454-E531
Directory of C:\tmp
02/10/2016 13:10 1,173 initorclz.ora
1 File(s) 1,173 bytes
0 Dir(s) 142,348,374,016 bytes free
C:\Users\john>[Updated on: Sun, 02 October 2016 07:16] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: invalid specification for system parameter LOCAL_LISTENER [message #656306 is a reply to message #656305] |
Sun, 02 October 2016 10:35 |
John Watson
Messages: 8962
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Janning wrote on Sun, 02 October 2016 14:25Ok, it did start up..I see a new file initorcl.ora, which does have:
*.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=oradev.attlocal.net)(PORT=1522))'
I shutdown, and tried using just "startup" as I had for months, I get the same old error, so I'm lost here
Quote:Create a pfile from the spfile, edit it to remove the local_listener parameter, re-create the spfile from the modified pfile, startup the instance. Take it from there.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: invalid specification for system parameter LOCAL_LISTENER [message #656337 is a reply to message #656336] |
Mon, 03 October 2016 09:50 |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Janning wrote on Mon, 03 October 2016 13:22I can not ping it from a terminal window....no
Did you can not ping from what to what?
As John suggestion, you might review your hosts file in /etc/hosts. If you have got a root account, you can edit this file, if you have not, you probably review it by typing "$ more /etc/hosts". This is very simply. Otherwise you have not any idea to go to fix it.
Write some tips on your notepad file.
1.Your Linux OS hostname? Check by typing "$ hostname". Does the VM server use IPv6? Does the VM server use loopback 127.0.0.1? Does the VM can resolve the hostname?
2.Your Virtualization Engine Application (VEA)? Oracle Virtual, VMWare, NetApp, ..etc? Check and confirm it. Does it bring Bridge Connection or use physical NIC (Network Interface Card). If one of VEA used physical NIC, did the System Admin configure or by pass MAC Address by VEA network utility? In general case, the System Admin use -Bridge Connection to configure for Developer deploying.
3.Your Linux OS configuration with SELinux? Check by typing "$ more /etc/selinux"
4.Your Linux OS configuration with firewall? Check by typing "$ service iptables status"
5.Your result when testing by "$ tnsping your_alias_tnsnames_of_Oracle_database". Verify the alias by "$ cat $ORACLE_HOME/network/admin/tnsnames.ora".
6.If you use jdbc*thin to connect directly to your Oracle Database, verify it by using SQL*Developer utility.
7.Your listener.ora is configured by "oradev.attlocal.net", the hostname "oradev.attlocal.net" can be resolved by checking "ping oradev.attlocal.net"?
Hope this help.
TaT
[Updated on: Mon, 03 October 2016 09:53] Report message to a moderator |
|
|
|
| Re: invalid specification for system parameter LOCAL_LISTENER [message #656338 is a reply to message #656337] |
Mon, 03 October 2016 10:24 |
|
Janning
Messages: 43
Registered: April 2016
|
Member |
|
|
1.Your Linux OS hostname? Check by typing "$ hostname"
my host name is oradev
2.Your Virtualization Engine Application (VEA)? Oracle Virtual, VMWare, NetApp, ..etc? Check and confirm it.
Does it bring Bridge Connection or use physical NIC (Network Interface Card).
If one of VEA used physical NIC, did the System Admin configure or by pass MAC Address by
VEA network utility? In general case, the System Admin use -Bridge Connection
to configure for Developer deploying.
Im VMWare Workstation...All my issues began when I updated the VM workstation
I have a feeling my issues is right here, in the VM NIC connection or the Linux NIC
The below shows the VM workstation is a bridged connection:
http://www.aanning.com/ajissues/oracle_startup_faq/VMWare_network_readd.jpg
The literal VM where oracle is on oracle linux 7.2
The NIC is as shown in jpgs NIC1, NIC2, NIC3 and NIC4.jpg
http://www.aanning.com/ajissues/oracle_startup_faq/
3.Your Linux OS configuration with SELinux? Check by typing "$ more /etc/selinux"
[oracle@oradev ~]$ more /etc/selinux
*** /etc/selinux: directory ***
4.Your Linux OS configuration with firewall? Check by typing "$ service iptables status"
The firewall should be off
[oracle@oradev ~]$ service iptables status
Redirecting to /bin/systemctl status iptables.service
● iptables.service
Loaded: not-found (Reason: No such file or directory)
Active: inactive (dead)
5.Your result when testing by "$ tnsping your_alias_tnsnames_of_Oracle_database".
Verify the alias by "$ cat $ORACLE_HOME/network/admin/tnsnames.ora".
tnsping oradev.attlocal.net
Used parameter files:
/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora
TNS-03505: Failed to resolve name
cat $ORACLE_HOME/network/admin/tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oradev.attlocal.net)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.attlocal.net)
)
)
6.If you use jdbc*thin to connect directly to your Oracle Database, verify it by using SQL*Developer utility.
Dont have this installed
7.Your listener.ora is configured by "oradev.attlocal.net", the hostname "oradev.attlocal.net" can be resolved
by checking "ping oradev.attlocal.net"?
[oracle@oradev ~]$ ping oradev.attlocal.net
ping: unknown host oradev.attlocal.net
[oracle@oradev ~]$
|
|
|
|
|
|
|
|
|
|
| Re: invalid specification for system parameter LOCAL_LISTENER [message #656360 is a reply to message #656346] |
Mon, 03 October 2016 22:54 |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Janning wrote on Mon, 03 October 2016 18:24I thought "unknown host oradev.attlocal.net" .....is the problem? and that is what I am trying to correct.
This is what I have used for 9 months w no issues.
Yes, it's the problem, exactly. The hostname is simply, name of host, such as my name, your name. Our name are identified by ID card, and the name of the host is identified by /etc/hosts. You did not define the hostname, you did not call it from anywhere.
More simple, imaging, you have plan to have got a weekend in fishing camp, when you go to the camp manager, you must take your ID to the manager who has known about you 9 months later.
Add the line as below:
$ vi /etc/hosts
# Internet host table
#
::1 localhost
127.0.0.1 localhost loghost
# Primary IPs
xx.xx.xx.xx oradev.attlocal.net
In which, replace xx.xx.xx.xx with real IP. How to define real IP? Type: "# ifconfig -a"
Quote:
What else is odd, is in my router, this box was seen as "oradev"....now, it only see it as its IP address (for port forwarding)
"The box was seen", well, if I am not wrong, the VM is named as oradev.attlocal.net, it's belonged to VM management.
[Updated on: Mon, 03 October 2016 23:15] Report message to a moderator |
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Dec 27 05:29:05 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
