Hi All,
I tried installing a prebuilt Oracle Linux VM on Windows 7 host. It had a Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 installed.
I also installed sql developer in the vm but unable to connect to the db server.
lsnrctl services show the connection is refused
/lsnrctl services
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-JUN-2015 22:09:35
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Message 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 not found; No message file for product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
TNS-00511: Message 511 not found; No message file for product=network, facility=TNS
Linux Error: 111: Connection refused
./lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-JUN-2015 22:01:15
Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS
Unable to connect to oracle database on the linux vm
-
noteirak
- Site Moderator
- Posts: 5231
- Joined: 13. Jan 2012, 11:14
- Primary OS: Debian other
- VBox Version: OSE Debian
- Guest OSses: Debian, Win 2k8, Win 7
- Contact:
Re: Unable to connect to oracle database on the linux vm
Why do you think this has anything to do with VirtualBox?
The error is clear: the connection is refused by the DB server : port is not open, or firewalled, or you got the wrong IP.
The error is clear: the connection is refused by the DB server : port is not open, or firewalled, or you got the wrong IP.
Hyperbox - Virtual Infrastructure Manager - https://apps.kamax.lu/hyperbox/
Manage your VirtualBox infrastructure the free way!
Manage your VirtualBox infrastructure the free way!
-
scottgus1
- Site Moderator
- Posts: 20945
- Joined: 30. Dec 2009, 20:14
- Primary OS: MS Windows 10
- VBox Version: VirtualBox+Oracle ExtPack
- Guest OSses: Windows, Linux
Re: Unable to connect to oracle database on the linux vm
We probably need to find out if the failing command is being run on the host or on the guest, and if on the host, has the Virtualbox network been set up correctly.
Re: Unable to connect to oracle database on the linux vm
Hi Scottgus1,
I am unable to connect from both the host and the guest. However, not an issue with connectivity from host to guest as i have bridged adapter network settings in the network settings and don't think any issue with the virtual box as such.
I think it is to do with the DB configurations within the Oracle Linux VM (guest os) which i am unable to resolve. i found a link to this forum for a similar question in another forum and wondering if anyone had resolved this issue
regards,
BCS
I am unable to connect from both the host and the guest. However, not an issue with connectivity from host to guest as i have bridged adapter network settings in the network settings and don't think any issue with the virtual box as such.
I think it is to do with the DB configurations within the Oracle Linux VM (guest os) which i am unable to resolve. i found a link to this forum for a similar question in another forum and wondering if anyone had resolved this issue
regards,
BCS
-
scottgus1
- Site Moderator
- Posts: 20945
- Joined: 30. Dec 2009, 20:14
- Primary OS: MS Windows 10
- VBox Version: VirtualBox+Oracle ExtPack
- Guest OSses: Windows, Linux
Re: Unable to connect to oracle database on the linux vm
OK, sounds like Virtualbox is doing its job then. If you can ping the guest and the host from each other, transfer files, etc., then the network is good. You'll need to hunt up a forum for that guest OS or the database it has inside it to get the database working.