Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2011
    Posts
    5

    Unanswered: Local Installation of Oracle XE

    I'm trying to use an installation of Oracle 11 express on my computer using RazorSQL (just with offline data on my own computer), but cannot figure out how to connect to the database through RazorSQL. I believe the database is running as I was able to connect using the command line (connect system/password). I also tried creating a table and querying it through the command line and was successful in doing so. So I think that the database is working.

    With respect to razorsql, I am prompted for the following:
    login - I entered "system"
    password - I entered my password
    host/ip address - I entered "localhost"
    port - default to 1521
    service name - I tried both "OracleServiceXE" and "OracleXETNSListener"

    I get the following error:

    ERROR: An error occurred while trying to make a connection to
    the database:

    JDBC URL: jdbcracle:thin:@//localhost/OracleServiceXE

    Listener
    refused the connection with the following
    error:
    ORA-12514, TNS:listener does not currently know
    of service requested in connect descriptor
    The Connection descriptor
    used by the client was:
    //localhost/OracleServiceXE


    I know this is not a razorsql forum but I'm thinking that the problem probably lies with how I installed oracle xe or how I configured it. Could you please let me know if you have any ideas as for how to proceed?

    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    JDBC - Oracle FAQ

    >JDBC URL: jdbcracle:thin:@//localhost/OracleServiceXE

    jdbcracle:thin:[USER/PASSWORD]@[HOST][:PORT]ID
    jdbcracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE
    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
    Jul 2011
    Posts
    5
    Quote Originally Posted by anacedent View Post
    JDBC - Oracle FAQ

    >JDBC URL: jdbcracle:thin:@//localhost/OracleServiceXE

    jdbcracle:thin:[USER/PASSWORD]@[HOST][:PORT]ID
    jdbcracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE
    Thanks but I don't think I'm fully understanding. I tried changing the JDBC url to as indicated in the new error message:

    ERROR: An error occurred while trying to make a connection to
    the database:

    JDBC URL: jdbcracle:thin:[system/pass]@[localhost][:1521]/OracleServiceXE

    Io
    exception: Invalid
    connection string format, a valid format is: "//host[ort][/service_name]"

  4. #4
    Join Date
    Jul 2011
    Posts
    5
    Actually I think I did fix the format but now I'm getting the same error that I originally got in my first post.

    Using:
    jdbcracle:thin:[system/pass]@//localhost:1521/OracleServiceXE

    I get:

    ERROR: An error occurred while trying to make a connection to
    the database:

    JDBC URL: jdbcracle:thin:[system/pass]@//localhost:1521/OracleServiceXE

    Listener
    refused the connection
    with the following error:
    ORA-12514, TNS:listener does
    not currently know of service requested in connect descriptor
    The
    Connection descriptor used by the client was:
    //localhost:1521/OracleServiceXE

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I have no idea what you are doing.
    I just downloaded RazorSQL, installed it & connected to my Oracle DB.

    I do suspect that the SERVICE_NAME is just "XE"

    open a terminal window on DB Server & issue following OS commands

    lsnrctl status
    lsnrctl service

    COPY commands & results then PASTE all back here
    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.

  6. #6
    Join Date
    Jul 2011
    Posts
    5
    Quote Originally Posted by anacedent View Post
    I have no idea what you are doing.
    I just downloaded RazorSQL, installed it & connected to my Oracle DB.

    I do suspect that the SERVICE_NAME is just "XE"

    open a terminal window on DB Server & issue following OS commands

    lsnrctl status
    lsnrctl service

    COPY commands & results then PASTE all back here
    The service name was just "XE" it is working now. I never thought it would be that simple...

    Thanks

Posting Permissions

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