Blake, When you open a command line window (aka DOS session I like to call them), remember to issue the following statement before you try to use sqlplus:
Set oracle_sid=put_your_SID_here e.g. set oracle_sid=ORCL sqlplus Then connect internal if you can. I like to try something like select name from v$database to see if the database is really up. If it is, you will get the database name; if not... Oracle will tell you. You then probably should do a shutdown abort followed by startup (specify the pfile if Oracle doesn't know how to find it). After rebooting, wait a couple of minutes before logging in. Oracle sometimes takes a while to get up and running on Windows NT 4, I strongly suspect it's the same on Windows2000, since that is just NT 5 anyway. You can always r-click on the bottom bar, where the minimized applications appear. Select Task Manager, and look at the Performance tab to see if the memory has been allocated for your Oracle instance. If you have more than one instance, you will need to set oracle_sid=xxx before using the tools, or you need to specify a connect string (e.g. sqlplus [EMAIL PROTECTED]) The Oracle Agent is a separate issue, that can be started using lsnrctl dbsnmp_start. To check if it is up, try lsnrctl dbsnmp_status Re. the Oracle Agent, it could be that the dbsnmp user does not yet exist in your new database, if it doesn't, to create it you need to run catsnmp.sql which is located in /oracle/ora81/rdbms/admin/. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -----Original Message----- Sent: Monday, April 01, 2002 4:08 PM To: Multiple recipients of list ORACLE-L Subject: Oracle on NT << File: Card for Blake Wilson >> I have the good fortune? of creating two new databases on two Windows 2000 servers. I am familiar with Oracle on Solaris, but have no clue about Windows 2000. I have installed Oracle release 8.1.7 and have upgraded it to release 8.1.7.3. As part of the install I created the demo database on both servers. All seemed fine. I then created scripts to create a second database on one of the servers. I have not run these scripts yet. I now cannot connect to the demo database using sqlplus. I got an error message (I forgot to write down the error number) saying that my NLS parameter was not set or invalid. In HK_LOCAL_MACHINE the parameter is set to: NLS_LANG:AMERICAN_AMERICA.WE8ISO8859P1. I could connect to this database from my other server. In my wisdom? I decided to reboot the server and see what happens. Now I get the message on startup: Could not start ORACLEORAHOME81AGENT service on local computer error 3221356553. I cannot start the service manually. I cannot connect to the demo database from either server. I get the message ORA-01033: ORACLE initialization or shutdown in progress. I assume this has to do with the oracle agent service not starting. What should my NLS parameter be? What can I do to start the oracle agent service? Should there be a ORA_NLS33 parameter in the settings? Thank you for any help. Blake Wilson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
