Re: Oracle on Windoze

From: <Reginald.W.Bailey_at_jpmorgan.com>
Date: Fri, 1 Oct 2004 14:09:03 -0500
Message-ID: <OFB7B0E2E5.0E40DF04-ON86256F20.005F96F8@NY.JPMORGAN.COM>

You need to ensure that the userid that you are logged in as is in the ORA_DBA group (or whatever group was chosen). This group is the equivalent of the DBA group in Unix.

RWB Reginald W. Bailey
Your Friendly Neighborhood DBA
IBM Global Services
JPMC Account - DCI GTI Database Management 713-216-7703 (Office) 281-798-5474 (Mobile) e-mail: reginald.w.bailey_at_jpmorgan.com baileyre_at_us.ibm.com

                                                                                                                                                  
                      sol beach                                                                                                                   
                      <sol.beach_at_gmail.c        To:       oracle-l_at_freelists.org                                                                  
                      om>                       cc:                                                                                               
                      Sent by:                  Subject:  Oracle on Windoze                                                                       
                      oracle-l-bounce_at_fr                                                                                                          
                      eelists.org                                                                                                                 
                                                                                                                                                  
                                                                                                                                                  
                      10/01/2004 11:39                                                                                                            
                      AM                                                                                                                          
                      Please respond to                                                                                                           
                      sol.beach

I'm a *nix command line type DBA who has next to no experience directly supporting
Oracle on Windoze.
I get logged onto the DB server system as "administrator" & this account supposedly
was used to install Oracle.
However when I open up a command window & invoke SQL*PLUS and then / as sysdba
The error message reports I have insufficient privileges.

How do I get into this DB as "SYS"?
--

http://www.freelists.org/webpage/oracle-l

This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of J.P. Morgan Chase & Co., its subsidiaries and affiliates.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 01 2004 - 14:10:50 CDT