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???
ADI probably uses a different version of the client software. Make sure the appropriate tnsnames.ora and sqlnet.ora files are correct.
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...
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.
Oracle SysDBA 11i
In all you're doing, seek divine wisdom