what port is isqlplus using

Posted on 2004-11-09
Medium Priority
Last Modified: 2011-10-03
1,)   I am using Oracle 9i client on windows 2000, trying to connect to a 9i Oracle instance on a Solaris 9 box.  I have started apache and get the Apache screen when typing in the hostname in IE.  How do I find what port that isqlplus is using.  On my 10g instance on a 2003 server, I use:


and it connects fine.  I have tried port 7779 and 7783, from searching around in the archives.  I have searched for a isqlplus.ini file on the solaris box and did not find one.  The isqlplus.conf did not have any info on the port, neither did the ORACLE_HOME/sqlplus/logs/isqlplus/log.xml.

Question by:theoradically
  • 3

Author Comment

ID: 12561068
I have found that my windows Oracle 10g install configured isqlplus automatically for me.  On my Solaris Oracle 9i install, I was able to start /usr/Apache/bin/apachectl as root, but could not start Oracle/Apache as user oracle.  The only message that came back was httpd not started.  error_log only referred me to a non-existant jserv log.  I finally found /oracle/product/9.2.0/Apache/Jserv/logs/mod_jserv.log which included an error entry like this:

wrapper.env.copy: environment variable not found for DISPLAY

as sson as I set my DISPLAY variable, the Oracle/Apache server started with success.
Now, the isqlplus.conf says to copy the configuration into the oracle_apache.conf but when I use that as the configuration file, it comes back with a

apachectl: test: argument expected

So, I am making progress with this.  Oracle information searches are so poor.  100s of forum requests all asking for similar info, but no responses.  Good Oracle troubleshooting docs are hard to come by.  You know what I mean.  Making progress though, I figure the default ports will work as soon as I get a correct apache configuration file.

Author Comment

ID: 12561219
After copying the isqlplus.conf into the httpd.conf and starting oracle/apache with that config file, I was able to log into isqlplus successfully, using:


THIS QUESTION CAN BE CLOSED.  I still have a question open on specific information on isqlplus security vulnerabilities.

Author Comment

ID: 12796796
As I submitted on 11/11, no DBAs responded to my request, so this issue can be CLOSED.

Accepted Solution

modulo earned 0 total points
ID: 12808479
PAQed with points refunded (250)

Community Support Moderator

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
What we learned in Webroot's webinar on multi-vector protection.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question