URGENT/ora-01005 when trying to connect to the database from the application
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: URGENT/ora-01005 when trying to connect to the database from the application

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    Database 7.3.4 run on unix, Oracle client 9i.

    after the network admin install Oracle ADI, the users couldn't connect to the database anymore through the application, if I used SQLPLUS to connect, it connect ok. For sure, it's ORacle ADI problem b/c we have another machine which run 9i wihtout ADI and the application works fine. Below is the errors message when I log into the database from the application.
    I got the ORA-01005: null password given; logon denied.



    I search on metalink and I got the below advise:

    Modify the sqlnet.ora parameter, names.directory_path, to contain the values &
    quot;tnsnames, onames" instead of, "onames, tnsnames".
    Make sure the tnsnames.ora contains the same entries needed for ADI as the
    Oracle Names server.


    Does the above advise applicable with your problem??? Anyone face this problem before???

    Thanks






  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    ADI probably uses a different version of the client software. Make sure the appropriate tnsnames.ora and sqlnet.ora files are correct.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Moving to Apps DBA...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Sep 2002
    Posts
    42
    This kind of error we got before

    The scenario was the
    1)shared memory segment created while the database startup(SGA) didn't have permissions properly .Actually it was created with different userid than oracle owner.

    2)the above thing is due to the file permission
    $ORACLE_HOME/bin/oracle has got changed
    ideally the permission should be 6751


    In above situations we got ORA-1005

    make sure that your application uses proper listener etc..
    request should come thru listener etc...


    GOOD LUCK


    In GOD I find everything

  5. #5
    Join Date
    Dec 2001
    Location
    Atlanta
    Posts
    175
    ashley75,

    I experienced similar problem with ADI few weeks ago. What version of Oracle ADI did you install? Are they able to connect to Oracle Apps through ADI? Check its compatibility with your Oracle Apps. You may need to install the latest ADI version or apply ADI patch to fix the problem.

    C. K.
    Oracle SysDBA 11i
    _______________________________
    In all you're doing, seek divine wisdom


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