Change Root / Oracle Password In Rac

Mar 16, 2012

I need know the impact in my oracle database 10g R2, if i change root/oracle passwords in my Oracle RAC environment, my database using ASM and the nodes is in Red Hat 4.7.

View 1 Replies


ADVERTISEMENT

Data Guard :: Change Non-SYS Password On Oracle 11g Environment?

Jul 26, 2012

how to change non - SYS oracle users' password in data guard envirnment. We all know that for SYS password change in data guard. DBA has to change in primary database by either "alter user SYS identified by xxxx" or create password file with orapwd.

Then scp password file to standby database. However, if I want to change SYSTEM or DBSNMP passwords, I change on primary with " alter user ....." SQL, then new passwords will be login dictionary. But this new SYSTEM pqssword will be shipped with redo log to standby and SYSTEM password on standby will be updated? I need technical answer on this question

View 7 Replies View Related

SQL & PL/SQL :: Change Password Without Using ALTER Statement?

Aug 9, 2010

Requirement: I need to create a Function to allow users to change their own password when they are logging in to an application. Also, I would prefer to not use the ALTER command.

View 12 Replies View Related

Security :: Logminer And Password Change?

Oct 15, 2010

Is it possible to track the password changes made by some user using the logminer with the archived logs?

View 1 Replies View Related

Forms :: Change Password On Welcome Form

Nov 23, 2010

I am calling a form whose name is welcome from the menu module. Now there is a button "change password" on the welcome form and I want that when I call the welcome form automatically the change password button should be pressed and which in turn calls a new window for resetting of password.

I am calling the welcome form by using go_form('welcome');I tried this coding in the menu module.

go_form('welcome');
GO_ITEM('APP_VERSION.RESET_PASSWORD');
show_reset_password;
-----------------------------------
PROCEDURE show_reset_password IS
[code]....

View 2 Replies View Related

Unable To Connect OE Once Change Sys Password

Jan 7, 2013

some days ago we chaged sys,system and sysman password using SQL console. ORACLE 10.2.0.1.0 Now Backups and SQL console loggins are ok but we cant connect OEM console having: insufficient privileges, logging as sys / as sysdba

we reload (start / stop) oem console service and now the OM page is unable to be desplayed having (when starts finished no error messages was found):

The webpage cannot be found

or

Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.

but all is OK !!The DB SO is linux unbrekeable.

View 2 Replies View Related

SQL & PL/SQL :: How To Change User Password In Stored Procedure

Sep 9, 2010

OBJECTIVE: To allow a user to change their own password after logging into an application.

BACKGROUND: I have a stored procedure where I pass the userid, old password, and new password. The stored procedure contains the following ALTER statement:

EXECUTE IMMEDIATE 'ALTER USER :uid
IDENTIFIED BY :npwd REPLACE :opwd'
USING IN v_user_id, v_new_pwd, v_old_pwd;

where v_user_id, v_new_pwd, and v_old_pwd are the arguments passed to the stored procedure.

FACTS:
(1) The procedure compiles fine;
(2) During execution, SQLCODE returns "0" (i.e. zero);
(3) My userid does have permission to change my password and execute the stored procedure;
(4) At the time I call the stored procedure, I am successfully logged into the application with my userid and old password.

PROBLEM: When I try to login with the new password I get the following error: "ORA-01017 invalid username/password; logon denied".

View 12 Replies View Related

SQL & PL/SQL :: Using EXECUTE IMMEDIATE For DDL Command In Procedure For Password Change?

Nov 6, 2011

I have a procedure in this procedure i use.

EXECUTE IMMEDIATE 'alter user '||use||' identified by '||modp ||' replace '||oldp;

but when i execute it show insufficient privilages but i create for this procedure as public.and grant execute facility to the user.

View 6 Replies View Related

Security :: User Unable To Change Password With Command

Aug 23, 2010

We have enable the alter log for audit purpose so the password will be display in the log which is not security. I try to use "password" to change password but very user got the error below.

SQL> password
Changing password for RUDEE
Old password:
New password:
Retype new password:
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-20014: -6502 ORA-06502: PL/SQL: numeric or value error
ORA-06512: at line 27

Password unchanged

View 17 Replies View Related

Security :: ORA-20007 - Change User Account Password

Jul 16, 2011

When i try to change the user account password, i get following error.

alter user bala
identified by Ju4hlsd2;

ERROR at line 1:
ORA-20178: ORA-20176: ORA-28003: password verification for the specified password failed
ORA-20007: Password cannot consist of sequences of 3+ characters from the userid

how to set the password based on the error.

View 5 Replies View Related

Unable To Change Password In SQLPLUS After Trigger Added

Aug 17, 2012

One of my Customer had followed the document applied pertaining to mitigate against vulnerability CVE-2012-3132.

New Document Mitigation steps for CVE-2012-3132 [ID 1482694.1]

This was applied to a database and it stopped the 'password' command from succeeding in SQLPLUS. Once the trigger was disabled, it worked fine.

ORA-00604: error occurred at recursive SQL level 1
ORA-06531: Reference to uninitialized collection
ORA-06512: at "SYS.NAME_SECURITY", line 165
ORA-06512: at line 2

Why is this behavior seen? By the way, he was able to change the password using TOAD. Only sqlplus is the issue.

View 2 Replies View Related

Application Express :: Place Change Password Link Next To Page Logout?

Oct 17, 2012

I want to place change password link at the upper right of the page where logout link is..

i m using apex 4.1

View 2 Replies View Related

Access Oracle Database From Root User?

Dec 18, 2012

i have an linux instance running oracle 11g as oracle OS user. i am able to connect the DB from clients.

i need to access this DB from OS root user. what should i do.

View 7 Replies View Related

RAC & Failsafe :: Root.sh Fails On Oracle Cluster Installation?

Sep 7, 2011

I am installaing oracle RAC 11.2.0.1. After I installed the grid infrastructure, when I ran root.sh, I got below errors;

ASM failed to start. Check /d1/app/grid/cfgtoollogs/asmca/asmca-1109068AM4612.log for details.

Configuration of ASM failed, see logs for details
Did not succssfully configure and start ASM
CRS-2500: Cannot stop resource 'ora.crsd' as it is not running

[Code]....

View 9 Replies View Related

How To Know Password (Exact Password Not Hascode) Of All Users As A Sysdba

May 28, 2008

How to know the password(Exact password not hascode) of all users as a sysdba in Oracle 9i or 10g.How to convert hashcode password to Actual password.

View 1 Replies View Related

SQL & PL/SQL :: Create Procedure That Will Send In Customer ID / Password And New Password

May 14, 2011

I am trying to create a procedure that will send in the customer id, password and new password. The procedure will say if it has been updated or not. this is the code i have.

--Patty Carson
--Assignment 3 Question 3
--Description: Allows the user to change a password for a customer
CREATE or REPLACE procedure ChgPwd
(custid OUT number, password OUT VARCHAR2, newpassword IN VARCHAR2)
AS
[code]...

View 15 Replies View Related

Security :: Create Password File / Don't Know Password Of Sys User

Jun 5, 2012

I want to know what if any person don't know the password of SYS, can he create password file, becauase i dont know the password of sys users, generally login with '/ as sysdba',

View 4 Replies View Related

Running Root.sh More Than Once

Aug 10, 2007

I am trying to correct NMO NOT SETUID-ROOT (UNIX-ONLY) error. On production database (9..7). Googlng this error - it says to run root.sh as root. should this be run in /usr/local/bin. which is the default location.

I don't believe that there would be any problems - but would like some confirmation -to be safe.

View 5 Replies View Related

Sqlplus Only Runs As Root?

Jul 18, 2013

I'm having issues with users logging into Oracle. I installed it on Ubuntu 12.04 running Oracle 11.2 XE. If i am root, i can run sqlplus just fine and log in. But when I use a regular user account and run sqlplus, it will just stay blank. No error messages or any feedback. I echo $ORACLE_HOME and echo $ORACLE_SID and they come back exactly as they do under the root account. My path is set up just like root has it.

It almost seems like a permission issue but even when i try sqlplus /nolog it stays blank.

[URL]

View 1 Replies View Related

Oracle 9i Default Username And Password

Sep 14, 2003

I Just got Oracle 9i installed. But can not login . What are the Default username and password for "Oracle9i Discoverer Administrator" and other Developers Suite apps?

Also What URL should i type to access the "iSQL *PLUS" through my browser, so that i can execute my SQL statements.

View 3 Replies View Related

Forms :: Password Decryption With Oracle 9i

Jul 21, 2010

I am facing password decryption problem with my oracle forms 9i version. (forms 9i , d/b-oracle10g, application server 10g)..My current db is in oracle9i (windows server), it is migrated to oracle 10g in unix server. (dont have more details about server).

In my application "loginscreen.fmb" is fetching the p/w from security_table (here p/w stores in encrypted format) and decrypt at form level. If both are matching, then only it allows the user to proceed further.But when it is decrypting p/w from the forms(internally calling the decryption function from d/b), junk data is displaying (i put debug mesage and found this ).

when forms connected to the d/b if that is in unix server, decryption functionality will not work? I did same decryption using the same key from sql*plus, it is giving correct values. What is the diff between decryption from forms and sql*plus ( both case it is calling the same function that is stored in the d/b).

View 4 Replies View Related

Security :: Oracle Password Encryption

Oct 10, 2011

While searching for password encryption I came across these statements.

1.Password Encryption While Connecting. This protection is always in force, by default. Passwords are always automatically and transparently encrypted during network (client/server and server/server) connections, using a modified DES (Data Encryption Standard) or 3DES algorithm, before sending them across the network.

Confirm whether by default oracle encrypts the password before sending it to the database across the network even when the clear text password is used for connecting from a jdbc client.

View 1 Replies View Related

Find Root Cause Why Database Unresponsive

Apr 30, 2013

We have a 2 node RAC runing on 11.2.0.2 and last night the database was totally un-responsive. when i checked the ADDM I noticed the following:

Waiting for event "cursor: pin S wait on X" in wait class "Concurrency" accounted for 98% of the database time spent in processing the SQL statement with SQL_ID "4b2epo0eaqol9".I am wondering what option do i have here? i am looking to do the following:

1) find the root cause why the database was un-responsive

2) ADDM is listing the query, what options do we have further?

View 2 Replies View Related

Deny Root / Admin Access To DB?

Apr 25, 2012

I am studying a way to block the access from the root(UNIX) or admin(WIN) users to the database.

Are there some way to block the access by the superusers?

View 3 Replies View Related

RAC & Failsafe :: Root.sh Failed On 11gr2?

Mar 4, 2011

I am installing 11gr2 11.2.0.2 grid infrastructure software. while running root.sh on node1 it got failed.

Start of resource "ora.crsd" failed
CRS-2672: Attempting to start 'ora.crsd' on 'rac1'
CRS-5017: The resource action "ora.crsd start" encountered the following error:
Start action for daemon aborted
CRS-2674: Start of 'ora.crsd' on 'rac1' failed
CRS-2679: Attempting to clean 'ora.crsd' on 'rac1'
CRS-2681: Clean of 'ora.crsd' on 'rac1' succeeded
CRS-4000: Command Start failed, or completed with errors.
Clusterware exclusive mode start of Clusterware Ready Services failed at /u01/app/11.2.0/grid/crs/install/crsconfig_lib.pm line 6475.
/u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install /u01/app/11.2.0/grid/crs/install/rootcrs.pl execution failed

View 2 Replies View Related

Server Administration :: Su - (to Orauser) Root On None?

Sep 17, 2012

how can I suppress that su: (to orauser) root on none is filling my message.log up.

View -1 Replies View Related

Reset Password - Oracle 9i Developer Database?

Aug 27, 2007

I have an Oracle 9i developer database on my Windows workstation. I havent used it in a couple weeks and forgot my Sysdba login password. how I can reset it or get into the database?

View 6 Replies View Related

Windows :: How To Get Password Post Installation Of Oracle

Jul 1, 2011

I have installed Oracle 10g on Windows 7 64 bit today by own from the following link with data.

[URL]

1. At the start of my installation

Global Database Name : oracl
Password : my own password

2. At last i got the message "The installation of Oracle Database 10g was successful."

I have tried logon with

User Name as scott with tiger with Host String as oracl
User Name as scott with tiger
User Name as system with manager with Host String as oracl
User Name as system with manager

But i am unable to login to SQL.

Note: In between installation, i have not set any password.

View 7 Replies View Related

Security :: Create Password File In Oracle 10g?

Nov 28, 2011

I want to create password file in Oracle 10g, setp to create password file.

View 5 Replies View Related

RAC & Failsafe :: Running Root.sh Script On Second Node

Jun 15, 2011

during installtion of Oracle RAC 11g r1 on Linux using VMware server, all the pre cluster installation was successful, and root.sh on node 1 was successful too, but whenever I run the root.sh script on the second node I get error message "Failure at final check of oracle CRS stack. 10"

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved