RE: Oracle on Windows question

From: Reimer, John J. <>
Date: Wed, 11 Feb 2009 15:12:22 -0500
Message-ID: <0142190D495B2740886EBBA05A92425F0B4EE42C_at_fa0099.findlay.tire.cooperintra.ctb>

We do have oraenv_SID.bat files, but we do not set LOCAL. We ended up connecting _at_tnsentry and doing a shutdown and startup. Now we can connect to the database by with just the ORACLE_SID set. The database bounce seemed to clear up the error.  

Thanks to all

From: M Rafiq [] Sent: Wednesday, February 11, 2009 2:22 PM To: Reimer, John J.; oracle list
Subject: RE: Oracle on Windows question

If you set LOCAL and it works fine then don't worry about other parameters.  

set LOCAL=xxxx
sqlplus " / as sysdba"  

If it is connected without any issues or asking your password, you are good with it.  

shutdown immediate;

I don't think you should have any issues. In worst case scenario you can use Database service to stop and start for bouncing database. Most of the time we just set LOCAL instead of setting ORACLE_SID.  

I will suggest to make an oraenv_SID.bat file and put all suggested 3 settings there and run it before using sqlplus " / as sysdba"  


Subject: RE: Oracle on Windows question
Date: Wed, 11 Feb 2009 11:25:27 -0500

If I set the LOCAL environment variable to the tns alias, then I connect fine. Isn't that the same as using the "connect user_at_tnsentry" syntax?  

I can connect fine when going through sqlnet, but just using ORACLE_SID to make the connection does not work. There is nothing unusual in the alert log. The listener log only shows when connections are made through sqlnet. Nothing shows there when the direct connections fail.  

We are planning on bouncing the database, but we are concerned that we will not be able to bring it back up (or even shut it down cleanly) since we can't connect as we usually do to perform those tasks.  

From: M Rafiq [] Sent: Wednesday, February 11, 2009 10:37 AM To: Reimer, John J.; oracle list
Subject: RE: Oracle on Windows question

Please try to set all three parameters and try again.  

set LOCAL= (check alis in tnsnames.ora file) set ORACLE_HOME=  

It appears to be permission issue as well while try to writing to listener.log file. Is the same user id starting other databases as well?  


Subject: Oracle on Windows question
Date: Tue, 10 Feb 2009 16:42:05 -0500

We have a problem connecting to a database that we have not seen before, and I am wondering if any else has encountered it. OS: Windows2003 32-bit
Database Version:
Only one Oracle Home on the box
There are six databases running on this server. We can connect to five of them just fine.
When setting ORACLE_SID to the problem SID, and trying "Connect sys as sysdba" we get
"ORA-12546: TNS:permission denied"
When we do "Connect sys_at_sidname as sysdba" it connects fine. Why would one database have a problem when the others all work?

Windows Live(tm): Keep your life in sync. See how it works. < _022009>

Windows Live(tm): E-mail. Chat. Share. Get more ways to connect. Check it out.
< 2009>

Received on Wed Feb 11 2009 - 14:12:22 CST

Original text of this message