RE: sysdba
Date: Wed, 4 Feb 2015 17:51:36 +0000
Message-ID: <7DCF5A73984B85409A1FB7B957E590ED844E9A22_at_EXMB2WSH.roswellpark.org>
Ok, once I created the password file, everything worked as it should.....thx guys.
Brian
From: Ruel, Chris [mailto:Chris.Ruel_at_lfg.com] Sent: Wednesday, February 04, 2015 11:55 AM To: Zelli, Brian; oracle-l (oracle-l_at_freelists.org) Subject: RE: sysdba
You need to create a new password file for the instance in question: rlmdev
Log in as oracle software owner
cd $ORACLE_HOME/dbs
$ orapwd file=orapwrlmdev
Enter password for SYS:
Those files which are out there must be from other instances. You can remove them if they are no longer in use.
You should then be able to grant a user SYSDBA.
Chris..
Chris Ruel * Oracle Database Administrator * Lincoln Financial Group cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482
From: Zelli, Brian [mailto:Brian.Zelli_at_RoswellPark.org] Sent: Wednesday, February 04, 2015 11:50 AM To: Ruel, Chris; oracle-l (oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>) Subject: RE: sysdba
Let me ask:
What is your oracle instance name? (show parameter instance_name) rlmdev, which is the instance I want to do this in
Windows/Linux/Unix? HPUX
What is your oracle home? /u01/oracle11g/product/11.2.0/dbhome_1
What directory is your pw file in? /u01/oracle11g/product/11.2.0/dbhome_1/dbs
What is it called? There are 2 in there, one called orapwlimsnd and one called orapworcleg
The first one I think is for an older instance. Not sure about the second one.
Chris..
Chris Ruel * Oracle Database Administrator * Lincoln Financial Group cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482
From: Zelli, Brian [mailto:Brian.Zelli_at_RoswellPark.org] Sent: Wednesday, February 04, 2015 11:16 AM To: Ruel, Chris; oracle-l (oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>) Subject: RE: sysdba
Thx Chris. I was googling this and found that if I have:
QL> show parameter remote_login_passwordfile
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ remote_login_passwordfile string EXCLUSIVE
Does that mean I already have one for this instance? And if so, how come my grant didn't work?
Brian
From: Ruel, Chris [mailto:Chris.Ruel_at_lfg.com] Sent: Wednesday, February 04, 2015 10:04 AM To: Zelli, Brian; oracle-l (oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>) Subject: RE: sysdba
That should be all.
Create the password file with the orapwd utility as the Oracle software installation owner.
Password file must be called:
Windows: $ORACLE_HOME\database\PWD<instance_name>.ora
Linux/Unix: $ORACLE_HOME/dbs/orapw<instance_name>
Chris..
Chris Ruel * Oracle Database Administrator * Lincoln Financial Group cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian Sent: Wednesday, February 04, 2015 9:56 AM To: oracle-l (oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>) Subject: sysdba
I tried to grant a user sysbda privs and got the:
ORA-01994: GRANT failed: password file missing or disabled I understand that I have to create a passwordfile for the instance. But is that all I have to do?
Then do I issue the grant the same way?
Brian
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
Notice of Confidentiality: **This E-mail and any of its attachments may contain Lincoln National Corporation proprietary information, which is privileged, confidential, or subject to copyright belonging to the Lincoln National Corporation family of companies. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. Thank You.**
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 04 2015 - 18:51:36 CET