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 <[EMAIL PROTECTED]>
@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 [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
<< 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
