Results 1 to 3 of 3

Thread: oracle port

  1. #1
    Join Date
    Jan 2004
    Munich, Germany

    Unanswered: oracle port

    Hi everyone,

    I am going crazy with Oracle. I created a database using the Oracle Database configuration Assistant and it created the database just fine. However, I cannot connect to it using the Enterprise Manager Console because I do not know the port number for this database. I recreated the database but I found that at no point during the creation it tells me the port number. Now I do not know how to find this out. Please help!



  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2004
    If you need a port to connect to Oracle, then you certainly need to configure a LISTENER, which is not done by the install. To do this, you should run "netca" ("Net configuration assistant"), located at $ORACLE_HOME/bin/netca in UNIX (it should be something like this in Windows, and you must have a shortcut in your "Start" menu). Choose "Configure a listener" (or something like this), then "Add a listener" ... go on ... and it will ask for the port on which the listener is gonna listen (1521 by default). Once the listener is configured, quit netca, and retry your connection from Enterprise Manager. Now it should work. If the Oracle server is on another machine, you should also configure your "tnsnames.ora" file, which can be done either "by hand" or with "Net Manager" ($ORACLE_HOME/bin/netmgr, "Local->service name resolution" menu or something like this).

    I hope that will help.
    Last edited by RBARAER; 08-10-04 at 13:47.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts