This content has been marked as final. Show 5 replies
I find that when I log in to the Windows Server and open a command prompt and after I set the DB tier env using the SID_Host.cmd I am not log able to login to Sql*Plus using / as sysdba. But without setting the DB Tier env I am able to login using / as sysdba. The issue is caused by the env variable LOCAL=<SID>. I am still trying to find out why this is happening only on one server.
Can you please check if you are able to connect to database as below
sqlplus apps/<pass>@SID if no then problem is with your listener. When you are trying to connect to database without giving SID it is not taking listener path and it is allowing you to connect as you are trying to connect from same server where database is running.
I find that there is no issue with the adcrobj.cmd & adcrobj.sql scripts.
The issue is that the database fails with "insufficient privileges" when it tries to connect as " / as sysdba".
If I remove the LOCAL=PROD from the DB Tier env file then i can make connection as " / as sysdba". This is the issue.