| 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
--------------0FD7B0F0BC54379850B1B1FB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
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).
>
--------------0FD7B0F0BC54379850B1B1FB Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
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.
<br> <br> Here is the syntax for changing the password for Internal. <p>$ $ORACLE_HOME/bin/orapwd file=<filename> password=<password>entries=<max_users>
<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 Sat Dec 09 2000 - 09:08:08 CST
 |
 |