DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: oracle9i on Winxp need to regenerate the oracle configuration file.error- ORA-12154.

  1. #1
    Join Date
    Aug 2004
    Location
    sunnyvale,CA
    Posts
    4

    oracle9i on Winxp need to regenerate the oracle configuration file.error- ORA-12154.

    Hi,
    I'm a new user to Oracle. when I tried to execute my code in ASP I got an error and after googleing I found that I need to regenerate the oracle configuration files to fix the error.

    The follwing is the error I got

    Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
    [Oracle][ODBC][Ora]Error while trying to retrieve text for error ORA-12154


    My operating system is Winxp and Oracle version is 9i.

    any one plz tell me the procedure to regenerate the congiguration files.and I request U for U'r suggessions to fix the above error.

    Thanks in advance,
    Rajesh.

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    On the client - edit your tnsnames.ora located in $ORACLE_HOME/network/admin.
    Add/edit an entry that points to right sid, port and machine.

    If you don't know how - post your listener.ora file located in the same directory (on the database server).

  3. #3
    Join Date
    Aug 2004
    Location
    sunnyvale,CA
    Posts
    4
    Hi,
    Thanks for U'r reply.Already I edited my TNSNAMES.ORA file.I am pasting the file below.
    # TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    shop =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname )(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = shop)
    )
    )

    RAJ =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = raj)
    )
    )



    INST1_HTTP =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVER = SHARED)
    (SERVICE_NAME = MODOSE)
    (PRESENTATION = http://HRService)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    I'm able to connect to Oracle through SQL+
    The test for DSN is also successful.
    I'm able to run the TNSLSNR (ORACLEHOME/network/admin/bin/tnslsnr)successfully.
    but when I try to run the tnsping file, then the problem occurs.I searched in google about the error.I found the solution that I need to regenerate the configuratio files to fix it itseems.

    And I didn't get your second suggession "post listener".can U plz tell me the way how to do that?

    my system is not connected to any LAN.so I think my system itself works as a SERVER as well as the client I think.


    Thanks,
    Rajesh.
    Last edited by orcle_beginer; 08-06-2004 at 05:38 PM.

  4. #4
    Join Date
    Oct 2002
    Posts
    807
    Plug in the ipaddress of your database server (in your case - it is your local machine) in place of hostname. host=123.450.0.000. Your listener.ora should be located in the same directory that your tnsnames.ora file sits. (If the database is indeed running locally).

    What's the sid that you're connecting to - raj or shop? What are you trying to tnsping? Where does your DSN point to?

  5. #5
    Join Date
    Aug 2004
    Location
    sunnyvale,CA
    Posts
    4
    I tried by replacing the host name with the ip address.but the error is the same as before.listener.ora and tnsnames.ora are in the same directory(oraclehome/network/admin/).I have created two databases, shop and Raj.I'm able to connect to oracle through SQL+ the database "shop". and the SID is also the same(shop) for the database shop.

Posting Permissions

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


Click Here to Expand Forum to Full Width