Results 1 to 2 of 2

Thread: Err=12505

  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unanswered: Err=12505

    I have recently installed Oracle 9 and am trying to connect to it using my Java code. I have done this many times before when connecting to Oracle 8 on other boxes.

    My java code looks like:

    String dbDriver = "oracle.jdbc.driver.OracleDriver";
    String dbServer = "jdbcracle:thin:@192.168.1.70:1521racle.domain.bluespark.com";
    String username = "meds";
    String password = "meds";
    ...
    con = DriverManager.getConnection(dbServer, username, password);

    I tested the above on another sid on another boxe and it worked fine.

    Using the SID above I get the following error:
    java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=1 2505)(ERROR_STACK=(ERR
    OR=(CODE=12505)(EMFI=4))))

    If I use this SID: jdbcracle:thin:@192.168.1.70:1521racle
    I get this error: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []


    My tnsnames.ora looks like this:
    # TNSNAMES.ORA Network Configuration File: E:\Oracle\Ora9\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    INST1_HTTP.DOMAIN.BLUESPARK.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.70)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    EXTPROC_CONNECTION_DATA.DOMAIN.BLUESPARK.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ORACLE.DOMAIN.BLUESPARK.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.70)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = oracle.neal.bluespark)
    )
    )

    My listener.ora looks like this:
    # LISTENER.ORA Network Configuration File: E:\Oracle\Ora9\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.70)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = E:\Oracle\Ora9)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = oracle.neal.bluespark)
    (ORACLE_HOME = E:\Oracle\Ora9)
    (SID_NAME = oracle)
    )
    )

    I can connect to the meds tablespace no proble using SQLPlus with:
    username: meds
    password: meds
    host: oracle


    Any help would be greatly appreciated.
    Thanks,
    Neal

  2. #2
    Join Date
    Nov 2003
    Posts
    4

    Re: Err=12505

    I figured it out. I needed the new version of the driver. SID is "oracle" in my case and everythign is now working fine.



    Originally posted by nealw
    I have recently installed Oracle 9 and am trying to connect to it using my Java code. I have done this many times before when connecting to Oracle 8 on other boxes.

    My java code looks like:

    String dbDriver = "oracle.jdbc.driver.OracleDriver";
    String dbServer = "jdbcracle:thin:@192.168.1.70:1521racle.domain.bluespark.com";
    String username = "meds";
    String password = "meds";
    ...
    con = DriverManager.getConnection(dbServer, username, password);

    I tested the above on another sid on another boxe and it worked fine.

    Using the SID above I get the following error:
    java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=1 2505)(ERROR_STACK=(ERR
    OR=(CODE=12505)(EMFI=4))))

    If I use this SID: jdbcracle:thin:@192.168.1.70:1521racle
    I get this error: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []


    My tnsnames.ora looks like this:
    # TNSNAMES.ORA Network Configuration File: E:\Oracle\Ora9\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    INST1_HTTP.DOMAIN.BLUESPARK.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.70)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    EXTPROC_CONNECTION_DATA.DOMAIN.BLUESPARK.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ORACLE.DOMAIN.BLUESPARK.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.70)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = oracle.neal.bluespark)
    )
    )

    My listener.ora looks like this:
    # LISTENER.ORA Network Configuration File: E:\Oracle\Ora9\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.70)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = E:\Oracle\Ora9)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = oracle.neal.bluespark)
    (ORACLE_HOME = E:\Oracle\Ora9)
    (SID_NAME = oracle)
    )
    )

    I can connect to the meds tablespace no proble using SQLPlus with:
    username: meds
    password: meds
    host: oracle


    Any help would be greatly appreciated.
    Thanks,
    Neal

Posting Permissions

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