Connecting to Oracle Database from Unix?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • starlight849
    New Member
    • Jun 2009
    • 82

    Connecting to Oracle Database from Unix?

    Hi and thanks for checking out my post.
    My problem is connecting to a remote oracle database from my unix machine. The remote database is on the network and I typicaly connect to it using an alias, username and password.

    In the past I have connected to the database using sqldeveloper. The connection type is TNS and the network alias is abc123(for example)I also supply my username and password.

    I have also connected to the database using vb.net over the network with no problem by simply providing the same network alias (abc123), password and username.

    I have been banging my head against the wall trying to make this connection in a shell script for three days. If anyone could point me in the right direction I would certainly appreciate it.
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    To connect with shell use sqlplus client
    Code:
    sqlplus user/login@alias

    Comment

    Working...