Oracle-L: RE: Oracle on NT

From: <tday6_at_csc.com>
Date: Tue, 02 Apr 2002 06:43:24 -0800
Message-ID: <F001.00438B75.20020402064324@fatcity.com>

I think that he has a much more serious problem than setting the SID. If I understand the situation the Oracle Service (the instance) is not starting because the ORACLE_HOME parameter in the registry is messed up (probably as part of the upgrade).

Try clicking START, PROGRAMS, ORACLE FOR WIN2K (or something like that), and see if you have 'Oracle Home Selector'. After you set the ORACLE_HOME, click START, PROGRAMS, ACCESSORIES (or ADMINISTRATIVE TOOLS - I forget which {MS changed it in Win2K}) and SERVICES. Scroll down until you see the ORACLE..... services and start the automatic start ones that haven't started.

If the ORACLE_HOME is still messed up, then you'll have to dig into the registry. Look under HKEY_LOCAL_MACHINE, SOFTWARE, ORACLE, ALL_HOMES. There should be a parameter called HOME_COUNTER that will tell you how many ORACLE_HOMES are set up on your machine. Further branches will be IDn where 0 is the first Oracle home, 1 is the second, etc. Under those are parameters NAME and PATH. Find the one with the NAME "DEFAULT_HOME" and set it's PATH to what you want the ORACLE_HOME to be (maybe something like "C:\ORACLE\ORACLE8I" {include the quotes}).

Then scroll down to ORACLE_HOMES. Under that will be folders named ORACLEn, again where 0 is the first Oracle Home, 1 is the second, etc. Here the parameter ORACLE_HOME should be the path, ie., what you set PATH to be above. One of the folders should have the parameter ORACLE_HOME_NAME set to "DEFAULT_HOME". This is the one that you want to set the ORACLE_HOME to your chosen Oracle Home. It can also have a SHARED_ORACLE_HOME parameter that you should set to your Oracle Home.

Then reboot the machine for the registry changes to take effect and see if the services have started.

You can check out the NSL_LANGUAGE parameters while you're there but my experience is that that's a bogus error message. Oracle can't find the correct Oracle Home, tries to send you an error message, realizes that it doesn't have the NSL_LANGUAGE parameter set, and settles for sending you an error message to that effect.

BTW - save a copy of your registry before you try this!!! From the Registry Editor (regedit) click on 'registry' and 'export registry file' to save a copy. To change registry values right click on the parameter name. You'll get a little pop-up. Click 'Modify' and you'll get a little edit window to edit the value.

Good luck - HTH

                                                                                           
                    "Boivin,                                                               
                    Patrice J"           To:     Multiple recipients of list ORACLE-L      
                    <BoivinP             <ORACLE-L_at_fatcity.com>                            
                    @mar.dfo-mpo.        cc:                                               
                    gc.ca>               Subject:     RE: Oracle on NT                     
                    Sent by: root                                                          
                                                                                           
                                                                                           
                    04/01/2002                                                             
                    07:08 PM                                                               
                    Please                                                                 
                    respond to                                                             
                    ORACLE-L

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 system/manager_at_orcl.myhost)

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: boivinp_at_mar.dfo-mpo.gc.ca

-----Original Message-----
Sent: Monday, April 01, 2002 4:08 PM To: Multiple recipients of list ORACLE-L

<< 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: BoivinP_at_mar.dfo-mpo.gc.ca

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: ListGuru_at_fatcity.com (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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: tday6_at_csc.com

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