Help - Search - Members - Calendar
Full Version: oracle 10G listener stops automatically
Oracle DBA Forums > Oracle > Oracle Forum
Venugopalan
Dear All

We have installed Oracle 10G in windows 2003 server.
Oracle is working fine when oracle services are running in local system account, when we change the option “Log On As” from local system account to an domain id the oracle listener stops automatically.

I tried the below mentioned options,
    We created a new listener it did not worked
    we are able to connect the db through command prompt but not through SQL plus or TOAD
    When we add the domain id to the local administrator group the oracle is working fine. But we cannot have the domain id in local administrator group since GPO will automatically remove the domain id from local administrator group


Please help me.

Best regards,
Venugopalan N
SteveC
The thought of checking the documentation may have escaped you when you installed "the oracle," but the obvious answer is to create a local user with group membership in ora_dba.

http://download.oracle.com/docs/cd/B19306_...en.htm#NTQRF120

http://dba-oracle.com/googlesearchsite_pro...8&q=ora_dba
burleson
Hi Venugopalan,

Windows 203 is obselete and probably not supported . . .

>> We created a new listener it did not worked

"Not worked" is NOT an acceptable answer!

What errors do you see in the listener log file nd alert log file?

It shound like you have not been trained in Oracle.

If so, you need this pronto:

http://www.rampant-books.com/book_0501_eas...e_jumpstart.htm

******************************************
>> we are able to connect the db through command prompt but not through SQL plus

Aha! That's a good clue!

Try invoking sqlplus from the os command line, like this:

c:\app\oracle\bin\sqlplus fred@flintstone@mysid

Then try it without the service name:

c:\app\oracle\bin\sqlplus fred@flintstone@mysid

**************************************************
Follow these steps carefully and it will show you your problem, which is likely in your tnsnames.ora file:

http://www.dba-oracle.com/t_troubleshootin...vity_errors.htm

You also need to verify that the Oracle services are all running:

http://www.dba-oracle.com/t_check_verify_w...ws_services.htm

Good Luck!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.