| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Svrmgrl
--------------A4F7D53FC9A4B1AF1E013CA7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Hi
Thanks for ur effort.
I want to know how to give the orapwd command
for an example
orapwd file=orapwgldb password=gldb
In the above command orapwgldb will be the password file
whereas gldb is the password for sys or internal.
If I want to mention both how to give it.
Please let me know the syntax with examle
Thanks in advance
suganya
Srinivas Pulla wrote:
> check the ORACLE_SID, and the OS user you have logged in as, if the OS
> user you have logged is in the dba group(OS) then it shouldn't prompt
> you for a password for the Internal user, also checkout if you are
> trying to administer a remote database or your ORACLE_SID is set to a
> different one than the one you are connecting to, and trying to
> connect as "connect internal_at_Remote_database_connectstring" in this
> case it will even prompt you for a password, then you need to check
> out the REMOTE_LOGIN_PASSWORDFILE parameter in the initsid.ora file.
>
> Here is the syntax for changing the password for Internal.
>
> $ $ORACLE_HOME/bin/orapwd file=<filename> password=<password>
> entries=<max_users>
>
> Let me know if you require more help.
>
> Srinivas
>
> Suganya wrote:
>
>> Hi all
>> In the svrmgrl suddenly it is asking for internal password.
>> I used the same thing without password. How we can disable the
>> password and also tell me how to change the password
>> using orapwd command in unix system
>> Thanx and Regards
>> suganya
>>
>> The Oracle DBA wrote:
>>
>> > One vote for:
>> >
>> > SHUTDOWN immediate
>> > STARTUP RESTRICT
>> > (practive backup of control file)
>> > SHUTDOWN NORMAL
>> > <BACKUP>
>> >
>> > Cheers,
>> >
>> > Earl
>> >
>> > On Fri, 08 Dec 2000 07:51:36
>> > Kevin Kostyszyn wrote:
>> > >RE: shutdown for backup : pro's and con'sPersonally, we do a
>> > shutdown
>> > >immediate. As far as I know, if you don't do it this way and then
>> > say try
>> > >to bring the database up on another machine with using the same
>> > name and the
>> > >datafiles and init file, the redo logs will be corrupt and the
>> > database will
>> > >not come up. I would go with the shutdown immediate.
>> > >
>> > >Kevin Kostyszyn
>> > >DBA, Dulcian, Inc
>> > > -----Original Message-----
>> > > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
>> > Koivu, Lisa
>> > > Sent: Friday, December 08, 2000 8:26 AM
>> > > To: Multiple recipients of list ORACLE-L
>> > > Subject: RE: shutdown for backup : pro's and con's
>> > >
>> > >
>> > > Hi Pat,
>> > >
>> > > I have to use SHUTDOWN ABORT/STARTUP RESTRICT/SHUTDOWN
>> > IMMEDIATE.
>> > >Otherwise our databases hang due to some refresh jobs that run
>> > continually,
>> > >and my backups never start. I haven't had any problems. Think
>> > about it -
>> > >If you startup and shutdown nice after a shutdown abort, the
>> > database has a
>> > >chance to clean itself up.
>> > >
>> > > HTH
>> > >
>> > > Lisa Rutland Koivu
>> > > Oracle Database Administrator
>> > > Qode.com
>> > > 4850 North State Road 7
>> > > Suite G104
>> > > Fort Lauderdale, FL 33319
>> > >
>> > > V: 954.484.3191, x174
>> > > F: 954.484.2933
>> > > C: 954.658.5849
>> > > http://www.qode.com
>> > >
>> > > "The information contained herein does not express the opinion
>> > or position
>> > >of Qode.com and cannot be attributed to or made binding upon
>> > Qode.com."
>> > >
>> > >
>> > >
>> > > -----Original Message-----
>> > > From: Pat Howe - Contractor [mailto:pat.howe_at_Terabeam.com]
>> > > Sent: Thursday, December 07, 2000 10:34 PM
>> > > To: Multiple recipients of list ORACLE-L
>> > > Subject: shutdown for backup : pro's and con's
>> > >
>> > >
>> > >
>> > >
>> > > I would like to be convinced one way or the other on the
>> > following issue :
>> > > What is the best way to take a database down for a cold backup ?
>> >
>> > >
>> > > SHUTDOWN ABORT
>> > > STARTUP RESTRICT
>> > > SHUTDOWN NORMAL
>> > > <BACKUP>
>> > >
>> > > or
>> > >
>> > > SHUTDOWN IMMEDIATE
>> > > <BACKUP>
>> > >
>> > > I have seen both widely used.
>> > > I have always stayed away from the ABORT option because I am
>> > uneasy about
>> > > taking any database down this way (hard).
>> > > I am looking for a dialog on the pro's and con's of each
>> > approach.
>> > > ie: Any horror stories about taking down with the ABORT option ?
>> >
>> > >
>> > > --
>> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> > > --
>> > > Author: Pat Howe - Contractor
>> > > INET: pat.howe_at_Terabeam.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).
>> > >
>> > >
>> >
>> > Great Gift Idea! FREE cell phone, internet ready at Lycos
>> > Marketplace
>> > http://www.inphonic.lycos.com/redirect.asp?referringpage=www.lycosd1
>> >
>> > --
>> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> > --
>> > Author: The Oracle DBA
>> > INET: theoracledba_at_lycos.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).
>>
--------------A4F7D53FC9A4B1AF1E013CA7 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi
<br> Thanks for ur effort. <br>I want to know how to give the orapwd command <br>for an example <br> orapwd file=orapwgldb password=gldb <p>In the above command orapwgldb will be the password file <br>whereas gldb is the password for sys or internal. <br>If I want to mention both how to give it. <br>Please let me know the syntax with examle <br>Thanks in advance <br>suganya <p>Srinivas Pulla wrote: <blockquote TYPE=CITE>check the ORACLE_SID, and the OS user you have loggedin as, if the OS user you have logged is in the dba group(OS) then it shouldn't prompt you for a password for the Internal user, also checkout if you are trying to administer a remote database or your ORACLE_SID is set to a different one than the one you are connecting to, and trying to connect as "connect internal_at_Remote_database_connectstring" in this case it will even prompt you for a password, then you need to check out the REMOTE_LOGIN_PASSWORDFILE parameter in the initsid.ora file.
<p>Let me know if you require more help. <p>Srinivas <p>Suganya wrote: <blockquote TYPE=CITE>Hi all <br> In the <font color="#3333FF">svrmgrl</font> suddenlyit is asking for internal password.
<br>I used the same thing without password. How we can disable the <br>password and also tell me how to change the password <br>using <font color="#3333FF">orapwd</font> command in unix system <br>Thanx and Regards <br>suganya <p>The Oracle DBA wrote: <blockquote TYPE=CITE>One vote for: <p>SHUTDOWN immediate <br>STARTUP RESTRICT <br>(practive backup of control file) <br>SHUTDOWN NORMAL <br><BACKUP> <p>Cheers, <p>Earl <p>On Fri, 08 Dec 2000 07:51:36 <br> Kevin Kostyszyn wrote: <br>>RE: shutdown for backup : pro's and con'sPersonally, we do a shutdown <br>>immediate. As far as I know, if you don't do it this way andthen say try
<br>>not come up. I would go with the shutdown immediate. <br>> <br>>Kevin Kostyszyn <br>>DBA, Dulcian, Inc <br>> -----Original Message----- <br>> From: root_at_fatcity.com [<a href="mailto:root_at_fatcity.com">mailto:root_at_fatcity.com</a>]OnBehalf Of Koivu, Lisa
<br>> Sent: Friday, December 08, 2000 8:26 AM <br>> To: Multiple recipients of list ORACLE-L <br>> Subject: RE: shutdown for backup : pro's and con's <br>> <br>> <br>> Hi Pat, <br>> <br>> I have to use SHUTDOWN ABORT/STARTUP RESTRICT/SHUTDOWN IMMEDIATE. <br>>Otherwise our databases hang due to some refresh jobs that run continually, <br>>and my backups never start. I haven't had any problems. Think about it -
<br>>chance to clean itself up. <br>> <br>> HTH <br>> <br>> Lisa Rutland Koivu <br>> Oracle Database Administrator <br>> Qode.com <br>> 4850 North State Road 7 <br>> Suite G104 <br>> Fort Lauderdale, FL 33319 <br>> <br>> V: 954.484.3191, x174 <br>> F: 954.484.2933 <br>> C: 954.658.5849 <br>> <a href="http://www.qode.com">http://www.qode.com</a> <br>> <br>> "The information contained herein does not express the opinionor position
<br>>of Qode.com and cannot be attributed to or made binding upon Qode.com." <br>> <br>> <br>> <br>> -----Original Message----- <br>> From: Pat Howe - Contractor [<a href="mailto:pat.howe_at_Terabeam.com">mailto:pat.howe_at_Terabeam.com</a>] <br>> Sent: Thursday, December 07, 2000 10:34 PM <br>> To: Multiple recipients of list ORACLE-L <br>> Subject: shutdown for backup : pro's and con's <br>> <br>> <br>> <br>> <br>> I would like to be convinced one way or the other on the followingissue :
<br>> <br>> SHUTDOWN ABORT <br>> STARTUP RESTRICT <br>> SHUTDOWN NORMAL <br>> <BACKUP> <br>> <br>> or <br>> <br>> SHUTDOWN IMMEDIATE <br>> <BACKUP> <br>> <br>> I have seen both widely used. <br>> I have always stayed away from the ABORT option because I amuneasy about
<br>> taking any database down this way (hard). <br>> I am looking for a dialog on the pro's and con's of each approach. <br>> ie: Any horror stories about taking down with the ABORT option?
<br>> <br>> -- <br>> Please see the official ORACLE-L FAQ: <a href="http://www.orafaq.com">http://www.orafaq.com</a> <br>> -- <br>> Author: Pat Howe - Contractor <br>> INET: pat.howe_at_Terabeam.com <br>> <br>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
<br>> --------------------------------------------------------------------<br>> To REMOVE yourself from this mailing list, send an E-Mail message <br>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
<br>> also send the HELP command for other information (like subscribing). <br>> <br>> <p>Great Gift Idea! FREE cell phone, internet ready at Lycos Marketplace <br> <a href="http://www.inphonic.lycos.com/redirect.asp?referringpage=www.lycosd1">http://www.inphonic.lycos.com/redirect.asp?referringpage=www.lycosd1</a> <br>-- <br>Please see the official ORACLE-L FAQ: <a href="http://www.orafaq.com">http://www.orafaq.com</a> <br>-- <br>Author: The Oracle DBA <br> INET: theoracledba_at_lycos.com <p>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
<br>--------------------------------------------------------------------<br>To REMOVE yourself from this mailing list, send an E-Mail message <br>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in Received on Mon Dec 11 2000 - 07:04:04 CST
 |
 |