Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005

    Exclamation Unanswered: Error while trying to retrieve text for error ORA-12154

    Hi to all,

    When i try to execute sumple query with ASP.NET I receive this error:
    Error while trying to retrieve text for error ORA-12154

    [OracleException: Error while trying to retrieve text for error ORA-12154
    System.Data.OracleClient.DBObjectPool.GetObject(Ob ject owningObject, Boolean& isInTransaction) +207
    System.Data.OracleClient.OracleConnectionPoolManag er.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) +165
    System.Data.OracleClient.OracleConnection.OpenInte rnal(OracleConnectionString parsedConnectionString, Object transact) +600
    System.Data.OracleClient.OracleConnection.Open() +32
    Simple1.WebForm1.ReadMyData(String myConnString) in c:\inetpub\wwwroot\simple1\simple1.aspx.cs:72
    Simple1.WebForm1.btnAccept_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\simple1\simple1.aspx.cs:130
    System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
    System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +57
    System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18
    System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
    System.Web.UI.Page.ProcessRequestMain() +1277

  2. #2
    Join Date
    Sep 2003
    Virginia, USA
    ORA-12154 generally indicates a problem with your Oracle Net configuration files (files tnsnames.ora and sqlnet.ora) or your LDAP server if you are using that in lieu of Oracle Net.

    Generally, start with file $ORACLE_HOME/rdbms/admin/sqlnet.ora. This file has the line SQLNET.DIRECTORY_PATH. If this is set to TNSNAMES then you are using Local Naming and you need to ensure certain things are set corredtly in files sqlnet.ora and tnsnames.ora. All of the below tips assume you are using Local Naming.

    Next, in the same file sqlnet.ora, look at the parameter NAMES.DEFAULT_DOMAIN. Write down the value. When Oracle created the file it probably put your network domain name, which most people don't want. Again, just make a note at this point.

    Next, edit file tnsnames.ora and you should see an entry that starts with the format SID.DOMAIN = .... When you try to connect to a database named ORCL, for example, the value of DEFAULT_DOMAIN is appended to the database name. If the value of NAMES.DEAFAULT_DOMAIN = ACME.COM, then your tnsnames.ora file needs a block that starts ORCL.ACME.COM = ....

    Therefore, all you may need to do is edit file tnsnames.ora to ensure each block starts with the correct SID.DOMAIN.

    Note: the domain mentioned above has nothing to do with your database init.ora parameter DB_DOMAIN. That is used in the CONNECT_DATA clause of the tnsnames entries, but not in the alias part of the entry (line 1 of each block in tnsnames.ora is called the "alias".)

    Author, Oracle Database 10g: From Nuts to Soup

Posting Permissions

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