Re: SYSDBA account

From: <mjain_at_my-dejanews.com>
Date: Tue, 03 Nov 1998 03:16:02 GMT
Message-ID: <71lshi$knd$1@nnrp1.dejanews.com>

Hi,

Here are the steps you need to follow:-

SHUTDOWN THE DATABASE INSTANCE LIKE YOU NORMALLY WOULD DO.
CHANGE INIT PARAMETER REMOTE_LOGIN_PASSWORD_FILE. # Changed from shared to exclusive to handle sysoper and sysdba remote_login_passwordfile = exclusive
CREATE THE NEW PASSOWRD FILE ON SERVER USING ORACLE PASSOWRD UTILITY

C:\ORANT\BIN>ORAPWD73.EXE FILE=C:\ORANT\DATABASE\PWDE40.ORA PASSWORD=MYPASSWORD ENTRIES=30

4. INVOKE SERVER MANAGER ON DATABASE SERVER
5. CONNECT SYS/SYSPASSWORD AS SYSDBA   STARTUP THE INSTANCE AND DATABASE
6. GRANT SYSDBA PRIVILEGE TO REMOTESYSDBAUSER

SVRMGR> GRANT SYSDBA TO REMOTESYSDBAUSER;Statement processed. 7. VERIFY USING V$PWFILE_USERS VIEW TO MAKE SURE THAT THE REMOTESYSDBAUSER HAS NOW GOT DESIRED PRIVILEGES. 8. DISCONNECT 9. GO TO REMOTE CLIENT AND RETRY WHAT YOU WERE TRYING EARLIER. I AM PRETTY SURE THIS WILL WORK.. IF IN PROBLEM REFER : SERVER ADMINISTRATOR'S GUIDE. HOPE THIS HELPS, Manoj Jain
Oracle Certfied professional - OCP DBA
Chauncey Certified Oracle7 DBA

In article <b7r%1.15970$h45.10999934_at_news.rdc1.az.home.com>, "Kevin P. Fleming" <kfleming_at_access-laserpress.com> wrote:
> Fair warning: CONNECT INTERNAL is documented as going away as of Oracle 8.1,
> so I wouldn't be training anyone new on how to use it...
>
> Van Messner wrote in message ...
> >Hello:
> >
> > I'm not sure what you mean by a sysdba account. User SYSTEM is a dba,
> >user SYS is god. If you use Svrmgr and connect internal you can startup
> and
> >shutdown your database. With the enterprise edition you also got
> enterprise
> >manager. You can use that or statements in Svrmgr to create a user and
> >grant him many possible roles and permissions including the DBA role. Hope
> >this helps.
> >
> >Van
> >
> >
> >rosek_at_my-dejanews.com wrote in message <71l8on$qd2$1_at_nnrp1.dejanews.com>...
> >>I am using Oracle 8 Enterprise Edition. I dont seem to have a SYSDBA
> >account
> >>or SYSDBA role which I need to start up and shut down the database.
> >>
> >>Are these suppose to be created when you install ?
> >>If so what is SYSDBAs default password?
> >>Is there a script I must run to create this user ?
> >>
> >>How can I create a SYSDBA user with priviledges to shutdown and start
> >>database?
> >>
> >>If someone can point me to the prpoer oracle docs or provide a soltuion
> >would
> >>be a bonus.
> >>
> >>Thanks :)
> >>
> >>-----------== Posted via Deja News, The Discussion Network ==----------
> >>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 02 1998 - 21:16:02 CST