Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Finding Port number using Oracle Profile options

edited Jan 14, 2014 3:07AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered
Hi,

ERP =
  (DESCRIPTION =
    (ADDRESS =
      (PROTOCOL = CC)
      (HOST = erp.com)
      (PORT = 1520)
    )
    (CONNECT_DATA =
      (SID = ERP)
    )
  )


I would like to login database with database username & password but don't have TNS entries in my client machine.I am able to find out host & SID from oracle application using profile options but not able to find out port number. How can I find out the port number from oracle application.

Regards,

Madhu

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center