RE: 7.3.4 svrmgrl requiring password if called by root user
Thanks everyone who responded to my request. I am still unsure why svrmgrl would prompt for a password, but I was able to solve the problem by extracting my dump2 commands from the PERL script that was doing my regular backup. So now I have root's crontab call a new shell script, that first SUs to a backup user executes my PERL backup script, then finally, calls my newly created dumpall script as root. Allthough I felt my original solution was more elegant, this one actually works. We've all been there right? Thanks Again, Steve McClure -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 2:41 PM To: Multiple recipients of list ORACLE-L Subject:RE: 7.3.4 svrmgrl requiring password if called by root user Have you tried running the scripts as 'su - oracle -c script_name' from root? Or is this not possible with your current solution? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: steve mcclure [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 3:23 PM To: Multiple recipients of list ORACLE-L Subject: 7.3.4 svrmgrl requiring password if called by root user My database backup scripts are failing when run by the root user. I have just had the requirment to add a dump of all filesystems to my regular database backup routine. Upon running my modified scripts as the root user, required for the dump, I am greeted by a request for a password in response to the connect internal command. I can duplicate this by simply running svrmgrl from a prompt as the root user. Again this is for Oracle 7.3.4 on DG/UX. We are not using OS authentication, and I svrmgrl does NOT require a password for the other OS users I have tried to use. I added the root user to the dba and oper groups in hopes that might solve my problem, but was still prompted for a password. Any help with this is appreciated. Thanks, Steve McClure __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: steve mcclure INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve McClure INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 7.3.4 svrmgrl requiring password if called by root user
Are you using password files? 1) Check if some orapwSID file exists. if exists, then, internal user will always be required to authenticate in order to login. (except that 'dba' group is granted at os level. 2) Check $ORACLE_HOME/rdbms/lib/config.s file for some string like: /* 0x0008 15 */ .ascii "dba\0" The 'dba' string indicates that group DBA must be asigned to the user that will be used to connect as internal. If other string is used, then, you must use that os group as DBA role, and you must grant that group at os level. Hope it helps - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 5:23 PM My database backup scripts are failing when run by the root user. I have just had the requirment to add a dump of all filesystems to my regular database backup routine. Upon running my modified scripts as the root user, required for the dump, I am greeted by a request for a password in response to the connect internal command. I can duplicate this by simply running svrmgrl from a prompt as the root user. Again this is for Oracle 7.3.4 on DG/UX. We are not using OS authentication, and I svrmgrl does NOT require a password for the other OS users I have tried to use. I added the root user to the dba and oper groups in hopes that might solve my problem, but was still prompted for a password. Any help with this is appreciated. Thanks, Steve McClure __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: steve mcclure INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Claudio Roca INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 7.3.4 svrmgrl requiring password if called by root user
Have you tried running the scripts as 'su - oracle -c script_name' from root? Or is this not possible with your current solution? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: steve mcclure [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 3:23 PM To: Multiple recipients of list ORACLE-L Subject: 7.3.4 svrmgrl requiring password if called by root user My database backup scripts are failing when run by the root user. I have just had the requirment to add a dump of all filesystems to my regular database backup routine. Upon running my modified scripts as the root user, required for the dump, I am greeted by a request for a password in response to the connect internal command. I can duplicate this by simply running svrmgrl from a prompt as the root user. Again this is for Oracle 7.3.4 on DG/UX. We are not using OS authentication, and I svrmgrl does NOT require a password for the other OS users I have tried to use. I added the root user to the dba and oper groups in hopes that might solve my problem, but was still prompted for a password. Any help with this is appreciated. Thanks, Steve McClure __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: steve mcclure INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).