This discussion is archived
1 2 Previous Next 17 Replies Latest reply: Dec 4, 2012 9:13 PM by Justin Cave RSS

Is there any other login utility for oracle database other than sqlplus?

karthiksingh_dba Explorer
Currently Being Moderated
Dear Legends,

I need to login remote DB writing a shell script where our DB is on a separate node, i have to test the script only with
SCHEMA USERNAME
PASSWORD
HOSTNAME
PORT NO
SID/SERVICE NAME
these details. May be am wrong to ask this question but i need to login and check the requirement.

Is there any other anyway to login without sqlplus utility?

Thanks in advance
Regards,
Karthik
  • 1. Re: Is there any other login utility for oracle database other than sqlplus?
    sb92075 Guru
    Currently Being Moderated
    karthiksingh_dba wrote:
    Dear Legends,

    I need to login remote DB writing a shell script where our DB is on a separate node, i have to test the script only with
    SCHEMA USERNAME
    PASSWORD
    HOSTNAME
    PORT NO
    SID/SERVICE NAME
    these details. May be am wrong to ask this question but i need to login and check the requirement.

    Is there any other anyway to login without sqlplus utility?

    Thanks in advance
    Regards,
    Karthik
    http://www.squirrelsql.org/

    write JAVA code using jdbc thin connector

    Handle:     karthiksingh_dba
    Status Level:     Newbie
    Registered:     May 21, 2012
    Total Posts:     88
    Total Questions:     31 (28 unresolved)

    why so MANY unanswered questions?
  • 2. Re: Is there any other login utility for oracle database other than sqlplus?
    861120 Explorer
    Currently Being Moderated
    Hi

    I could not understand, Why you not wont use the sqlplus ?

    The sqlplus works fine in this case using the tnsnames in the separete node.
  • 3. Re: Is there any other login utility for oracle database other than sqlplus?
    karthiksingh_dba Explorer
    Currently Being Moderated
    >
    http://www.squirrelsql.org/

    write JAVA code using jdbc thin connector
    Oh am very sorry am a big zero in JAVA.
    Handle:     karthiksingh_dba
    Status Level:     Newbie
    Registered:     May 21, 2012
    Total Posts:     88
    Total Questions:     31 (28 unresolved)

    why so MANY unanswered questions?
    Let me try to fix it ASAP.

    Thanks,
    Karthik
  • 4. Re: Is there any other login utility for oracle database other than sqlplus?
    karthiksingh_dba Explorer
    Currently Being Moderated
    Hi,
    I could not understand, Why you not wont use the sqlplus ?
    I have a scenario that I dont have a UNIX Box access except the TNS names.
    The sqlplus works fine in this case using the tnsnames in the separete node.
    I agree with you.

    but is there any other way to login the DB?

    Regards,
    Karthik Singh
  • 5. Re: Is there any other login utility for oracle database other than sqlplus?
    sb92075 Guru
    Currently Being Moderated
    SQL Squirrel is freeware client

    http://www.squirrelsql.org/
    bcm@bcm-laptop:~$ cat Conn.java
    import java.sql.*;
    class Conn {
      public static void main (String[] args) throws Exception
      {
       Class.forName ("oracle.jdbc.OracleDriver");
    
       Connection conn = DriverManager.getConnection
         ("jdbc:oracle:thin:@//localhost:1521/v112", "scott", "tiger");
                            // @//machineName:port/SID,   userid,  password
       try {
         Statement stmt = conn.createStatement();
         try {
           ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");
           try {
             while (rset.next())
               System.out.println (rset.getString(1));   // Print col 1
           } 
           finally {
              try { rset.close(); } catch (Exception ignore) {}
           }
         } 
         finally {
           try { stmt.close(); } catch (Exception ignore) {}
         }
       } 
       finally {
         try { conn.close(); } catch (Exception ignore) {}
       }
      }
    }
    bcm@bcm-laptop:~$ javac Conn.java
    bcm@bcm-laptop:~$ export CLASSPATH=/u01/app/oracle/product/11.2.0/dbhome_1/owb/wf/lib/ojdbc14.jar:.
    bcm@bcm-laptop:~$ java Conn
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    PL/SQL Release 11.2.0.1.0 - Production
    CORE     11.2.0.1.0     Production
    TNS for Linux: Version 11.2.0.1.0 - Production
    NLSRTL Version 11.2.0.1.0 - Production
    bcm@bcm-laptop:~$
  • 6. Re: Is there any other login utility for oracle database other than sqlplus?
    karthiksingh_dba Explorer
    Currently Being Moderated
    Hi,

    Oops am very sorry I can't able to understand this small code of java to select the version of database with it login details. For this i have to use java compiler in my machine? if so i cant do it in a client machine.

    I want to login remote db without os user account's from a SOA weblogic server but in a SOA Weblogic i think there is no oracle client so sqlplus utility will not work.

    Regards,
    Karthik
  • 7. Re: Is there any other login utility for oracle database other than sqlplus?
    EdStevens Guru
    Currently Being Moderated
    karthiksingh_dba wrote:
    Hi,
    I could not understand, Why you not wont use the sqlplus ?
    I have a scenario that I dont have a UNIX Box access except the TNS names.
    This makes no sense. What do you think UNIX has to do with tnsnames.

    There is nothing magic about sqlplus. It is just a small client app that connects to a database. The actual connection details are handled in the tns layer. When you install the oracle client software, sqlplus is just the tip of the iceberg. Anything else you find will either need exactly the same infrastructure (the rest of the oracle client software) or a jdbc driver.

    Methinks you misunderstand the role that sqlplus plays in this.

    The sqlplus works fine in this case using the tnsnames in the separete node.
    I agree with you.

    but is there any other way to login the DB?

    Regards,
    Karthik Singh
  • 8. Re: Is there any other login utility for oracle database other than sqlplus?
    EdStevens Guru
    Currently Being Moderated
    karthiksingh_dba wrote:
    Dear Legends,

    I need to login remote DB writing a shell script where our DB is on a separate node, i have to test the script only with
    SCHEMA USERNAME
    PASSWORD
    HOSTNAME
    PORT NO
    SID/SERVICE NAME
    these details. May be am wrong to ask this question but i need to login and check the requirement.

    Is there any other anyway to login without sqlplus utility?
    I don't know what you mean by "check the requirement" but it sounds like sqlplus is exactly what you need.

    Thanks in advance
    Regards,
    Karthik
  • 9. Re: Is there any other login utility for oracle database other than sqlplus?
    orafad Oracle ACE
    Currently Being Moderated
    karthiksingh_dba wrote:
    I need to login remote DB writing a shell script where our DB is on a separate node, i have to test the script only with
    "shell script"?
    SCHEMA USERNAME
    PASSWORD
    HOSTNAME
    PORT NO
    SID/SERVICE NAME
    these details. May be am wrong to ask this question but i need to login and check the requirement.
    If actual task is to verify/test connection with given details, sqlplus should be a perfect fit, even no tnsnames needed:

    sqlplus <USERNAME>@'<HOSTNAME>:<PORT NO>/<SERVICE_NAME>'

    at prompt enter: <PASSWORD>

    Ta da!


    Is there any other anyway to login without sqlplus utility?
    Why? Please explain.
  • 10. Re: Is there any other login utility for oracle database other than sqlplus?
    orafad Oracle ACE
    Currently Being Moderated
    >
    I want to login remote db without os user account's from a SOA weblogic server but in a SOA Weblogic i think there is no oracle client so sqlplus utility will not work.
    Did you search the machine for sqlplus executable?

    If not found, How about putting Instant Client with IC sqlplus on a network share, and use that from the weblogic host?

    Otherwise use the java connection test as suggested above, since weblogic server should have a jdbc client driver at least (perhaps in a lib file named ojdbc*.jar).
  • 11. Re: Is there any other login utility for oracle database other than sqlplus?
    karthiksingh_dba Explorer
    Currently Being Moderated
    I need to login remote DB writing a shell script where our DB is on a separate node, i have to test the script only with
    "shell script"?
    Yes which i can easily put in an crontab and schedule it. My logic and other sql codes are ready to work, except the login.
    SCHEMA USERNAME
    PASSWORD
    HOSTNAME
    PORT NO
    SID/SERVICE NAME
    these details. May be am wrong to ask this question but i need to login and check the requirement.
    If actual task is to verify/test connection with given details, sqlplus should be a perfect fit, even no tnsnames needed:
    Yes off course i agree, but without sqlplus utility in SOA weblogic server i need to test it.
    Is there any other anyway to login without sqlplus utility?
    Why? Please explain.
    Without a oracle client is it possible to login to DB? Because i dont have the unix box OS level user access.
  • 12. Re: Is there any other login utility for oracle database other than sqlplus?
    jgarry Guru
    Currently Being Moderated
    In some situations you can use ezconnect (google it). One way or another you need a client, whether you use sqlplus, toad, instant, some odbc thing or what-all.
  • 13. Re: Is there any other login utility for oracle database other than sqlplus?
    karthiksingh_dba Explorer
    Currently Being Moderated
    Hi,

    Thanks for your response. I understood that sqlplus is the biggest utility to login but i just need to know whether is there any other options can be used in an shell script as an alternate of sqlplus.

    Regards,
    Karthik Singh
  • 14. Re: Is there any other login utility for oracle database other than sqlplus?
    karthiksingh_dba Explorer
    Currently Being Moderated
    Hi Steve,

    After a long back am getting you, hoping you are good. I think you wont be remembering me once i got stuck in an EM issue and you are the person helped me, Thanks for the response.

    Regards,
    Karthik
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points