Re: AW: Urgent SYSDBA

My tnsnames.ora file has no problem

I can connect from two other system to this server and from this server as well

sqlplus system/manager_at_orcl

works fine.

Problem comes with connectin as sysdba.

One more quyestion
Do I have to do something extra after installing the oracle from setup.exe. I installed and created the database from this only and did nothing else. Are there some extra tasks that I have to perform. In UNIX I would never had problems since last 5 years, this bloody NT??

Any thoughts, please

Thanks much

Mukesh

• Schoen Volker <v.schoen_at_inplan.de> wrote:
  > in sqlplus try this:
  >
  > sql> connect sys/oracle@<service name> as sysdba (it
  > does not work)
  >
  > You have to setup tnsnames.ora with a service name
  > to your instance.
  >
  > regards
  >
  > Volker Schön
  > E-Mail: mailto:v.schoen_at_inplan.de
  > http://www.inplan.de
  >
  >
  >
  > -----Ursprüngliche Nachricht-----
  > Von: Thapliyal, Deepak [mailto:DThapliyal_at_ea.com]
  > Gesendet: Freitag, 11. August 2000 00:36
  > An: Multiple recipients of list ORACLE-L
  > Betreff: RE: Urgent SYSDBA
  >
  >
  > i think you can start connecting as internal via
  > sql*plus and completely
  > augment the svrmgrl functionality using the same
  > only from 8i(8.1.X) onwards
  > ...
  >
  > hth
  > deepak
  >
  > -----Original Message-----
  > Sent: Thursday, August 10, 2000 2:35 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > Hello experts
  >
  > I am in problem here. I installed 8.0.5 on NT4 with
  > servicepack 6a and its ok. I am able to create the
  > database and install the sqlnet alises. I edited
  > the
  > initSID.ora file and put following:
  > REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
  >
  > then I did following
  > orapwd80 -file=pwdfl password=oracle entries=10
  >
  > then I did following
  > created sys and system user account with ora_dba
  > group
  > in NT.
  >
  > Now I have password for sys,system and internal
  >
  > I granted the system the sysdba .
  >
  > Now problem
  >
  > if I do
  > svrmgr30 > connect sys/oracle as sysdba (it works)
  > svrmgr30 > connect system/oracle as sysdba (it
  > works)
  > svrmgr30 > connect internal/oracle as sysdba (it
  > works)
  >
  > but when I do following at sqlplus prompt
  > sql> connect sys/oracle as sysdba (it does not work)
  > errors out with ORA-01031 insufficient privileges
  >
  > Also it does not work for system and internal as
  > well
  > at sqlplus prompt.
  >
  >
  > Please help, whats wrong why it does not work at sql
  > prompt
  >
  > Many thanks
  >
  >
  > MCG
  >
  >
  > __________________________________________________
  > Do You Yahoo!?
  > Kick off your party with Yahoo! Invites.
  > http://invites.yahoo.com/
  > --
  > Author: Mukesh Ghildiyal
  > INET: mcgoracle_at_yahoo.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
  > 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).
  > --
  > Author: Thapliyal, Deepak
  > INET: DThapliyal_at_ea.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
  > 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).
  > --
  > Author: Schoen Volker
  > INET: v.schoen_at_inplan.de
  >
  > 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