Re: Shutdown Oracle using NT at.
From: OracleMS <lostpwds_at_hotmail.com>
Date: 19 Jul 2001 09:04:55 -0700
Message-ID: <17742ed1.0107190804.4a492dd6_at_posting.google.com>
Date: 19 Jul 2001 09:04:55 -0700
Message-ID: <17742ed1.0107190804.4a492dd6_at_posting.google.com>
You have a lot of options:
- Add the internal password to your connect string. So instead of doing connect internal shutdown immediate do (I am just giving the default password for internal as an example) connect internal/oracle shutdown immediate
- If you are not comfortable putting the password in the script, you can also do a connect internal without the password (just like on Unix). In your %ORACLE_HOME%/net80/admin, you should have a file called sqlnet.ora. It should contain this line - SQLNET.AUTHENTICATION_SERVICES= (NTS) This will allow you to connect internal on NT without a password. Since you are being asked for a password for internal, I am assuming that this line is commented out or you dont have sqlnet.ora.
- Shutdown Oracle from the NT Services. In your script, use net stop OracleServiceSID net stop OracleStartSID
Murali Sreedhar Received on Thu Jul 19 2001 - 18:04:55 CEST