RE: sysdba

  • From: "Zelli, Brian" <Brian.Zelli@xxxxxxxxxxxxxxx>
  • To: "Ruel, Chris" <Chris.Ruel@xxxxxxx>, "oracle-l (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 4 Feb 2015 17:51:36 +0000

Ok, once I created the password file, everything worked as it should.....thx 
guys.

Brian


From: Ruel, Chris [mailto:Chris.Ruel@xxxxxxx]
Sent: Wednesday, February 04, 2015 11:55 AM
To: Zelli, Brian; oracle-l (oracle-l@xxxxxxxxxxxxx)
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@xxxxxxx<mailto:cruel@xxxxxxx> * Desk:317.759.2172 * Cell 317.523.8482

From: Zelli, Brian [mailto:Brian.Zelli@xxxxxxxxxxxxxxx]
Sent: Wednesday, February 04, 2015 11:50 AM
To: Ruel, Chris; oracle-l 
(oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>)
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@xxxxxxx<mailto:cruel@xxxxxxx> * Desk:317.759.2172 * Cell 317.523.8482

From: Zelli, Brian [mailto:Brian.Zelli@xxxxxxxxxxxxxxx]
Sent: Wednesday, February 04, 2015 11:16 AM
To: Ruel, Chris; oracle-l 
(oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>)
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@xxxxxxx]
Sent: Wednesday, February 04, 2015 10:04 AM
To: Zelli, Brian; oracle-l 
(oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>)
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@xxxxxxx<mailto:cruel@xxxxxxx> * Desk:317.759.2172 * Cell 317.523.8482

From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Zelli, Brian
Sent: Wednesday, February 04, 2015 9:56 AM
To: oracle-l (oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>)
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.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2015