LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Problem with Oracle Database

    Employee
    Posted 09-05-2012 05:57

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: sgiasemi

    Hi all,

    I am trying to connect the L.A.E with an Oracle Database.
    I have all the specifications regarding the Database and I have updated properly the tnsname.ora file.
    The connection has been established successfully using the SQL Developer program and it should work with L.A.E but I get the following error message:
    OCI Error 12154: ORA-12154: TNS:could not resolve the connect identifier specified
    Unable to attach to server 'FMS_DB': ORA-12154: TNS:could not resolve the connect identifier specified

    Do I need to make any other changes?

    node:DB_Query
    bretype:core::DB Query
    editor:sortkey=5045b95e5a691330
    output:@40fd2c7444283da6/=
    prop:DbInterface=oci
    prop:DbPassword=fmsarc1
    prop:DbService=FMS_DB
    prop:DbUser=fmsarc
    prop:SqlQuery=<<EOX
    select *
    from ARCH_CASE
    EOX
    editor:XY=90,90
    end:DB_Query

    Thank you in advance,
    sgiasemi


  • 2.  RE: Problem with Oracle Database

    Employee
    Posted 10-03-2012 11:45

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    Hmm....that is the error generally given when you run with a valid Oracle client installation but try to connect to an incorrectly configured tnsnames entry. Are you sure you have the right information in the tnsnames file and you have no typos here? Are you able to post your tnsnames.ora? Is there any odd chance you have more than one client installed, and your SQL Developer is using a different configuration? Have you tried the command line tnsping? Can you type tnsping FMS_DB?

    Cheers
    Rich


  • 3.  RE: Problem with Oracle Database

    Employee
    Posted 10-05-2012 01:56

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: sgiasemi

    Hi Rich,

    We figure out the problem with the help of support. We discovered that in my desktop I had two oracle installations, 9.2 and 10g, with conflicting settings in classpath, TNS_ADMIN, and oracle_home parameters. After unistalling and istalling again the Oracle 10g the problem was solved. I can tnsping now the database. Thank you for your response.

    Cheers,
    Sonia