I've installed an Oracle 11g XE on a Linux Fedora machine, successfully created a user, and imported a database into it.
My ultimate goal here is to connect an existing PHP website (also residing on the machine) via OCI8 and MDB2, but I'm having problems doing that (despite the local trial noted below) - so, I'm taking things one small step at a time.
I wanted to test the connection, see if there are any problems there, before moving on to more complex solutions.
Using the Linux machine itself, I tried logging on to the Oracle database via
SQLPLUSin the command line. This works fine.
Using a Windows-based PC, via Oracle SQL developer, however, returned the following error:
Status: Failure -Test failed: IO Error: The network adapter could not establish the connection.
Which doesn't tell me much. I can ping the Linux machine from Windows, but using telnet and specifying the port (1521) returns the following error:
Could not open connection to host, on port 1521: Connection failed.
So I'm assuming something is wrong with my Oracle Setup.
What else could I check or do to resolve this?
EDIT: Additional details:
Here's what I'm using to connect to the Linux machine:
Pretty standard stuff (default port: 1521, SID: xe) so far.
I also recently installed SQL Developer on said Linux server, and tried connecting. Connection successful, no issues so far.