This content has been marked as final. Show 5 replies
Thanks for your reply, damorgan.
damorgan wrote:No, I didn't. However, few months ego I did install Oracle 11gXE on my another VPS (also not doing any changes in kernel) and DB is working fine.
Did you read and follow the installation instructions including changes to the Linux kernel before performing the install?
Post a copy of the file etc/hosts
::1 localhost ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters 127.0.0.1 localhost.localdomain localhost # Auto-generated hostname. Please do not remove this comment. 184.108.40.206 jackk_fx
Edited by: JackK on Jan 13, 2013 8:13 AM
I can connect to DB like this:
PHP5 can also connect to my DB.
$ sqlplus / as sysdba SQL*Plus: Release 220.127.116.11.0 Production on N Sty 13 09:14:40 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 18.104.22.168.0 - 64bit Production SQL>
I'm not able to connect remotely to this DB via SQL*Developer, however. The error message is:
I think this is because of not working listener. I don't know that to do to make him work.
Status : Failure -Test failed: Błąd we-wy: The Network Adapter could not establish the connection
After reinstalling DB again and configuring (commented few lines in /etc/init.d oracle-xe) the listener can start.
But I still cannot connect remotely to DB.
$ whoami oracle $ lsnrctl status LSNRCTL for Linux: Version 22.214.171.124.0 - Production on 13-STY-2013 09:31:18 Copyright (c) 1991, 2011, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 126.96.36.199.0 - Production Start Date 12-STY-2013 22:27:38 Uptime 0 days 11 hr. 3 min. 40 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service XE Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora Listener Log File /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/vz11/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vz11.vihost.pl)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "XE" has 1 instance(s). Instance "XE", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
$ env SHELL=/bin/bash TERM=xterm SSH_CLIENT=<cutted IP> 41807 22 NLS_LANG=POLISH_POLAND.AL32UTF8 SSH_TTY=/dev/pts/2 USER=oracle ORACLE_SID=XE PATH=/u01/app/oracle/product/11.2.0/xe/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games MAIL=/var/mail/oracle PWD=/u01/app/oracle LANG=pl_PL.UTF-8 HOME=/u01/app/oracle SHLVL=2 LOGNAME=oracle SSH_CONNECTION=<cutted IP> 41807 <cutted IP> 22 ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe _=/usr/bin/env OLDPWD=/root
Edited by: JackK on Jan 13, 2013 10:44 AM
oracle@vz11:~$ sqlplus sygnalyfx SQL*Plus: Release 188.8.131.52.0 Production on N Sty 13 11:42:59 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 11g Express Edition Release 184.108.40.206.0 - 64bit Production SQL> exit Disconnected from Oracle Database 11g Express Edition Release 220.127.116.11.0 - 64bit Production oracle@vz11:~$ sqlplus sygnalyfx@localhost:1521/XE SQL*Plus: Release 18.104.22.168.0 Production on N Sty 13 11:43:29 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. ERROR: ORA-12541: TNS:no listener Enter user-name:
# listener.ora Network Configuration File: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = XE) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) (ADDRESS = (PROTOCOL = TCP)(HOST = vz11.vihost.pl)(PORT = 1521)) ) ) DEFAULT_SERVICE_LISTENER = (XE)
Help me, please... I need to be able to connect remotely.
# tnsnames.ora Network Configuration File: XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = vz11.vihost.pl)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )
It does, but in name only. In other words, I don't think you can set your listener HOST= to an IPv6 address, but if its an IPv6 hostname, it can work. But the IPv6 address needs to be in /etc/hosts. Also see MOS note ID 362956.1 for info regarding 10g and 11g IPv6 support.
XE supported IPV6.
There are a couple things probably not quite correct with the networking setup. Looks like the interface has no IPv4 address, but in /etc/hosts:
And for the instant client try (@host:port/service_name) ...
# Auto-generated hostname. Please do not remove this comment. 22.214.171.124 jackk_fx
That isn't going to work, since /etc/hosts has localhost for an alias to the IPv6 loopback address. The localhost /etc/hosts should point to 127.0.0.1, the IPv4 loopback. But if IPv4 is not configured on the interface, that would be a broken NIC setup anyway. Try:
sqlplus sygnalyfx@localhost:1521/XE ... ORA-12541: TNS:no listener
And lastly, have you checked the firewall? Port 1521 has to be open to allow remote database connections, also port 8080 if Apex needs to be accessed remotely. A tnsping from any remote client will return different results, if the listener is running and the firewall port(s) are open it should return an "OK (<n> MSec)".
sqlplus firstname.lastname@example.org:1521/XE ... ? also try the tnsnames.ora alias: sqlplus sygnalyfx@xe ... ?
Usually for a blocked port, tnsping might return "TNS-12547: TNS:lost contact". From the database host, tnsping should work since tcp traffic won't be going through the firewall port.