Re: urgent -Svrmgrl

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Tue, 12 Dec 2000 08:33:47 -0600
Message-Id: <10708.124314@fatcity.com>

--------------9CE1083DEA344FEA1CACD64B
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Check the $ORACLE_HOME/rdbms/log directory. If it fills up, no new files can be created.
Oracle tries to create an audit file every time some tries to login to svrmgrl.

Terry

Suganya wrote:

> Hi
> remote_login_passwordfile = none
> I have logged in the dba group only where the oracle 8i is
> installed. And also I am not trying from
> the remote_database_connectstring.But that orapwd is also not working
> for me.
> Please suggest me how to resolve from this problem.
>
> Thank and Regards
> 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
>> >>
>> >> If it fills up, no ehttp://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).
>> >

--------------9CE1083DEA344FEA1CACD64B
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_HOME/rdbms/log directory.  If it fills up, no new files can be created.
 Oracle tries to create an audit file every time some tries to login to svrmgrl.

<p>Terry
<p>Suganya wrote:
<blockquote TYPE=CITE>Hi
<br>&nbsp;&nbsp; remote_login_passwordfile = none
<br>&nbsp;&nbsp; I have logged in the dba group only where the oracle 8i

is installed. And also I am not trying from the remote_database_connectstring.But that orapwd is also not working for me.

<br>Please suggest me how to resolve from this problem.
<p>Thank and Regards
<br>Suganya
<br>&nbsp;
<br>&nbsp;
<p>Srinivas Pulla wrote:
<blockquote TYPE=CITE>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>

<p>Let me know if you require more help.
<p>Srinivas
<p>Suganya wrote:
<blockquote TYPE=CITE>Hi all
<br>&nbsp;&nbsp;&nbsp; In the <font color="#3333FF">svrmgrl</font> suddenly

it 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>&lt;BACKUP>
<p>Cheers,
<p>Earl
<p>On Fri, 08 Dec 2000 07:51:36
<br>&nbsp;Kevin Kostyszyn wrote:
<br>>RE: shutdown for backup : pro's and con'sPersonally, we do a shutdown
<br>>immediate.&nbsp; 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

<br>>not come up.&nbsp; I would go with the shutdown immediate.
<br>>
<br>>Kevin Kostyszyn
<br>>DBA, Dulcian, Inc
<br>>&nbsp; -----Original Message-----
<br>>&nbsp; From: root_at_fatcity.com [<a href="mailto:root_at_fatcity.com">mailto:root_at_fatcity.com</a>]On

Behalf Of Koivu, Lisa

<br>>&nbsp; Sent: Friday, December 08, 2000 8:26 AM
<br>>&nbsp; To: Multiple recipients of list ORACLE-L
<br>>&nbsp; Subject: RE: shutdown for backup : pro's and con's
<br>>
<br>>
<br>>&nbsp; Hi Pat,
<br>>
<br>>&nbsp; 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.&nbsp; I haven't had any problems.&nbsp;

Think about it -
 >If you startup and shutdown nice after a shutdown abort, the database has a

<br>>chance to clean itself up.
<br>>
<br>>&nbsp; HTH
<br>>
<br>>&nbsp; Lisa Rutland Koivu
<br>>&nbsp; Oracle Database Administrator
<br>>&nbsp; Qode.com
<br>>&nbsp; 4850 North State Road 7
<br>>&nbsp; Suite G104
<br>>&nbsp; Fort Lauderdale, FL&nbsp; 33319
<br>>
<br>>&nbsp; V: 954.484.3191, x174
<br>>&nbsp; F: 954.484.2933
<br>>&nbsp; C: 954.658.5849
<br>>&nbsp; <a href="http://www.qode.com">http://www.qode.com</a>
<br>>
<br>>&nbsp; "The information contained herein does not express the opinion

or position

<br>>of Qode.com and cannot be attributed to or made binding upon Qode.com."
<br>>
<br>>
<br>>
<br>>&nbsp; -----Original Message-----
<br>>&nbsp; From: Pat Howe - Contractor [<a href="mailto:pat.howe_at_Terabeam.com">mailto:pat.howe_at_Terabeam.com</a>]
<br>>&nbsp; Sent: Thursday, December 07, 2000 10:34 PM
<br>>&nbsp; To: Multiple recipients of list ORACLE-L
<br>>&nbsp; Subject: shutdown for backup : pro's and con's
<br>>
<br>>
<br>>
<br>>
<br>>&nbsp; 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 ?

<br>>
<br>>&nbsp; SHUTDOWN ABORT
<br>>&nbsp; STARTUP RESTRICT
<br>>&nbsp; SHUTDOWN NORMAL
<br>>&nbsp; &lt;BACKUP>
<br>>
<br>>&nbsp; or
<br>>
<br>>&nbsp; SHUTDOWN IMMEDIATE
<br>>&nbsp; &lt;BACKUP>
<br>>
<br>>&nbsp; I have seen both widely used.
<br>>&nbsp; I have always stayed away from the ABORT option because I am

uneasy about

<br>>&nbsp; taking any database down this way (hard).
<br>>&nbsp; I am looking for a dialog on the pro's and con's of each approach.
<br>>&nbsp; ie: Any horror stories about taking down with the ABORT option

<br>>
<br>>&nbsp; --
<br>>&nbsp; Please see the official ORACLE-L FAQ: <a href="http://www.orafaq.com">http://www.orafaq.com</a>
<br>>&nbsp; --
<br>>&nbsp; Author: Pat Howe - Contractor
<br>>&nbsp;&nbsp;&nbsp; INET: pat.howe_at_Terabeam.com
<br>>
<br>>&nbsp; Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;

FAX: (858) 538-5051
 >  San Diego, California        -- Public Internet access / Mailing Lists

<br>>&nbsp; --------------------------------------------------------------------

>  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

<br>>&nbsp; also send the HELP command for other information (like subscribing).
<br>>
<br>>
<p>Great Gift Idea!&nbsp; FREE cell phone, internet ready at Lycos Marketplace
<br>&nbsp;<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>&nbsp; INET: theoracledba_at_lycos.com
<p>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp;

FAX: (858) 538-5051
 San Diego, California        -- Public Internet access / Mailing Lists

<br>--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in Received on Tue Dec 12 2000 - 08:33:47 CST