Security :: User Unable To Login After Password Reset

Dec 14, 2011

We have a production database on 11.2.0.2 version. The application user was prompted to change the password after his password expired.

USERID NTIMESTAMP# ACTION# RETURNCODE
------------------------------ --------------------------------------------------------------------------- ---------- ----------
M500796 13-DEC-11 06.11.06.065209 PM 100 28001

After changing the password he is not able to logon. The aud$ table does not show any occurrence of 1017, therefore it is not a question of Invalid password.

LVV> show parameter SEC_CASE_SENSITIVE_LOGON

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE

View 2 Replies


ADVERTISEMENT

User Unable To Login Even After Password Reset

Nov 27, 2012

10.2.0.3 on Linux

I reset a user password and the user is unable to login as you can see below

[oracle@testdb 10.2.0]$ sqlplus sys/manager as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 27 16:20:21 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> alter user sysman identified by oracle;

User altered.

SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning, OLAP and Data Mining options

[oracle@testdb 10.2.0]$ sqlplus sysman/oracle

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 27 16:20:32 2012

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

ERROR: ORA-01017: invalid username/password; logon denied

User unable to login even after password reset

View 4 Replies View Related

XE :: Unable To Login With Logon As OPS$-user To Get SAPSR3 Password?

Jun 18, 2013

my listener getting started and database also up

but gives error

Connecting as SAPSR3/<pwd>@ECC on connection 0 (nls_hdl 0)

Logon as OPS$-user to get SAPSR3's password

If can share screen shots are some link so i can go aehad

what is the default password for SYSTEM

View 1 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 :: 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

Security :: Set Exclusive To Remote Login Password?

Nov 28, 2011

i create password file in oracle 10g now i want to Set the EXCLUSIVE to REMOTE_LOGIN_PASSWORD initialization parameter. so what should i do.

View 5 Replies View Related

Security :: User Locked / Track User Who Hit Wrong Password

Dec 21, 2010

We have the database user called c88888 and is locked yesterday. I came to this with the following query.

select * from dba_users where username like 'C88888';

Due to invalid password the user was locked. Can we track who hit the database with the wrong password?

View 5 Replies View Related

Security :: User Password Expired?

Nov 11, 2011

i am using a oracle server. And all my users password has been expired, is there any way to recover those users without failing my data.

View 19 Replies View Related

Security :: Create User With Non Expiring Password

Jul 7, 2011

I want to create oracle user with non expiring password or i want to create one oracle user and set the password as non expiring.

View 9 Replies View Related

Security :: How To Generate User And Password Manually

Aug 27, 2012

i forget my system password and i can't login to my database,and its not letting me in as sys/manager as sysdba...how to generate new user and password....

View 13 Replies View Related

Security :: How To Get User Login / Logout Information For Past 30 Days

Feb 3, 2012

I just want to know the user login / log out information for the past 31days. how can i get that?

View 11 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

Server Administration :: Can't Install SQLT - User Unable To Login

Jan 3, 2012

From metalink: Note 215187.1...Im trying to install SQLT. The installation process ask for:

Specify optional Connect Identifier (as per Oracle Net)
Include "@" symbol, ie. @PROD
If not applicable, enter nothing and hit the "Enter" key

I have tried with SID (@TESTDB) and SERVICE NAME (@TESTDB.mydomain.local) and leaving it blank, nothing works. I cant connect as SQLTXPLAIN.

View 5 Replies View Related

Reset Sys Password With Passwordfile Set To Shared?

Aug 29, 2012

Just trying to figure out a way to reset a lost sys password.The Customer has a database that were configured by the application provider.They were however kicked out and did not leave any kind of documentation behind

they also configured the passwordfile to disable OS (oracle) user to login to the DB.Is it possible to change the password file with orapwd to set a new password for the sys user?I some how recall that it can only be done if the passwordfile is set to exclusive and not as in this case set to shared.

View 3 Replies View Related

Expired Account Need To Open Without Password Reset?

Aug 14, 2013

Account XYZ has expired and we don't know the password of account xyz and don't want reset the password also. How can open account XYZ without change the password?

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

JDeveloper, Java & XML :: Reset Expired Password On Database?

Jan 2, 2013

I'm trying to write short program to reset password on databases. I'm trying to use OCINewPassword property with following

public void ResetPassword(String sOldPass, String sNewPass) {
this.sCurrent = sOldPass;
this.sNewPassword = sNewPass;
Properties props;
Connection conn = null;

[code]....

View 4 Replies View Related

Application Express :: Oracle 11g XE - Retrieve Or Reset Password

Dec 12, 2012

I cannot remember my password to access an existing database in Application Express. I tried entering my password 3 times, but the system does not provide a status other than 'Invalid Login Credentials'.

I am going to assume that 3 times is limit before you have to reset the password or from what I see reinstall. When selecting reset, the system asks for an email address that was never established in the system. How can I reset my password without uninstalling and reinstalling Oracle 11g XE?

View 10 Replies View Related

Application Express :: 2 Schemas - Admin Password Reset

Feb 7, 2013

We have 2 apex schemas

APEX_030000
APEX_040200

Before executing the apxchpwd.sql, found the "alter session command" sets schema to APEX_030000. So we changed that to APEX_040200. Then we executed the sql script. It executed fine.

But now when we try to login to apex, and pressing enter after providing the username/pwd, it raises the following exception

Error Error in PLSQL code raised during plug-in processing.
ORA-06508: PL/SQL: could not find program unit being called

View 1 Replies View Related

Security :: Enhance Security Of Windows And Recover Lost / Forgotten Password?

Nov 16, 2010

Lost Windows password? Forgot Windows password? Your PC was hacked? Therefore, it is a basic step for every Windows users to enhance the security of Windows password. In the networks, it is found that a number of user's passwords are easy to guess. Only the smallest groups are the most security conscious and select passwords that are mixed lowercase and uppercase letters, numbers and punctuation to create cryptic passwords. Adopting strong password is one of the most effective ways to ensure system security. Here are several methods for you to enhance the security of your passwords in Windows 7/2000/XP/Vista and so on. You'd better remember the methods below unless you want to reset Windows password from time to time.

1. Is random password a great password?

A common myth is that totally random passwords like Ht3&e#L%5d@$B are the best passwords. This is not true. While they may be strong passwords, they are usually difficult to remember, slow to type, and sometimes vulnerable to attacks against the password generating algorithm. It is easy to create passwords that are strong but much easier to remember by using a few simple techniques. For example, consider the password "Luck-73@Better?". This password utilizes uppercase and lowercase letters, two numbers, and three symbols. The password is 15 characters long and can be memorized with very little effort. Moreover, this password can be typed very fast. The portion"Luck" and "Better" alternate between left and right-handed keys on the keyboard, improving speed, decreasing typos, and decreasing the chances of someone being able to discover your password by watching you.

2. Create the long Windows password

Although a password may eventually be discovered through some means, it is possible to create a password that cannot be cracked in any reasonable time. If a password is long enough, it will take so long or require so much processing power to crack it. That is essentially the same as being unbreakable (at least for most hackers).

3. Create the Windows password constantly?

This may be good advice for some high-risk passwords, but it is not the best policy for every user. It is frustrating for a user to have to constantly think of and remember new passwords every 30 days. It may be better to focus on stronger passwords and better user awareness rather than limiting password age. A more realistic time for the common user may be 90-120 days.

4. Write down Windows password in a proper place

Sometimes it is necessary for some users losing and forgetting complex passwords easily to write down them somewhere proper. However, it is important to educate users on how to write down passwords properly. Obviously, a sticky note on the monitor is not a good idea, but storing passwords in a safe or even a locked cabinet may be sufficient.

5. 14 characters is the optimal password length

Each character that you add to your password increases the protection. Your passwords should be 8 or more characters in length; 14 characters or longer is the Optimal Password Length. Many systems also support use of the space bar in passwords, so you can create a phrase made of many words. It is not easier to forget and lose, as well as longer than a simple password, and harder to guess.

6. Try not to use the same Windows password for all accounts

Some users always make the same passwords for every account to make it easy to remember. In that case, when any one of them lost, your other information protected by that password will be in danger as well. It is serious to use different passwords for different systems and accounts.

7. Do not use some common words that other users maybe guess

Most of users prefer to use some common words to remember easily, for example, login name, birth date, driver's license, passport number, pets' name and other words contained their personal information someone knows. In that case, your Windows system will not be safe anymore. Moreover, do remember not to use some words spelled backwards, abbreviations, sequences or repeated characters and adjacent letters, such as, asdfgh, 123456, 888888, abcdef and so on.

You can smoothly use your Windows now because the strong and powerful Windows password is created successfully, Certainly, I believe that many users lost Windows password and forgot Windows password, then you need have to reset Windows password or recover Windows password. It is a big problem for plenty of Windows users that how to reset Windows password. how to recover Windows password and they are puzzled by resetting windows password, for instance, reset Windows 7 password, recover password Windows XP, remove Windows Vista password and other operating systems after they create the password with complex letters, numbers and symbols. However, it is unnecessary to worry and it is said that things will eventually sort themselves out. There are many ways to reset forgotten Windows password, including use windows password reset disk and windows password reset software, like Super Windows Password Reset, a professional windows password reset software which could enable you to logon to Windows smoothly without reinstalling system.

View 1 Replies View Related

Server Administration :: Externally Authenticated User Login Syntax As Proxy User?

Nov 15, 2010

I created an externally authenticated user in database. And can login without password with below syntax.

SQL> connect / @TESTDB
Connected.
SQL> show user;
USER is "SCOTT"

This scott user has a proxy permission to another DBuser PROXY_USER. Previously I used to login using below syntax.

connect scott[proxy_user]/password_for_scott@TESTDB

So now, what syntax should be used for this "ExternallY Authenticated" user to login as a proxy user?

View 10 Replies View Related

Forms :: Login User From One CANVAS And Access Second As Per-user Rights?

Oct 20, 2012

- we have user id parameter.can we update the parameter(:parameter.p_userid) before firing "WHEN NEW FORM INSTANCE TRIGGER"(when new form instance trigger contain code for tree node), for login another canvas as per user rights?

- i have created a login form in one canvas.

- also tree node Hierarchy form created on another canvas. now we want to login through login screen, after login only those forms should show in tree Hierarchy which users have rights. for this purpose we want to pass the parameter of userid before connecting to tree node form through the following query

SELECT COUNT (*)
INTO v_count
FROM usersinfo
WHERE usersname = :USERBLOCK.usernames AND passwords = :USERBLOCK.passwords ;

[code]...

Every thing is working but when we click on button in login form at that time parameter.p_userid will return null. because above code is define on button click in login screen, i cannot understand where i need to define the above code .

View 1 Replies View Related

Possible To Specify Login / Password For DBLINK When Calling It?

Apr 3, 2013

I have a Oracle 91 database running on Windows 2003 with a DBLINK setup to connect to an external client. I'm looking at how i can setup a quick job that, say every 5 mins, runs a query over the DBLINK and if it returns data, then success. If it returns an error, then the DBLINK is down, moreso the external server, and then fire off an email to someone.

However, this DBLINK i think was created to be used by a specific username/password. When i try to run a query against it using SYS, i get invalid username/password error.

So is there a way i can use a DBLINK and specify the username/pwd to be used at runtime? I'm new to Oracle database..Something like 'select * from global_name@DBLINK1 as username/pwd'.

View 10 Replies View Related

PL/SQL :: User Session Has Expired And Enable User Without Changing The Password

Aug 13, 2012

User session has expired. I have to enable user without changing the password of the user.

View 1 Replies View Related

Save Password Disabled In Login Screen

Dec 6, 2011

I have Toad 9.6.1 already installed on my machine and have now installed Toad 10.6 . unfortunately the Save Passwords option on the Connection screen is disabled. how do I enable that option.

View 2 Replies View Related

Server Administration :: Can't Login By Typing Username And Password

Jul 15, 2010

I am using oracle 9i version. My problem is oracle window opens.But i can not login by typing the user name and password. while login an error is displayed as follows.

ORA-01033: ORACLE initialization or shutdown in progress.

View 8 Replies View Related

Forms :: Invalid Username / Password - Login Denied

Aug 9, 2011

I have installed oracle 10g database in my pc and it works fine. I can connect with sys or system user.

I have also installed oracle forms 10g in the same pc. But when I try to connect then it shows the message:

ORA-01017 invalid username/password; login denied

So I can not connect. I have tried to connect with sys or system user.

View 6 Replies View Related

Application Express :: Password Item Not Getting Cleared After Login?

Nov 27, 2012

I have two pages

1. Login Page  contains two items
P1_LOGINNAME - Textfield 
P1_PASSWORD - Password

2. Data entry form created using page items.  - This page is used to create new users
This page contains many items but issue with only two items.
P10_LOGINNAME - Textfield 
P10_PASSWORD - Password

These items are used for creating loginname and password for new user. When i am logging with admin user ,Chrome browser prompts for save password or not save password

1. When i am logging with save password option then
LOGINNAME and PASSWORD of Login page is reflecting on the LOGINNAME and PASSWORD of Data entry page.

so how can i clear the LOGINNAME and PASSWORD item on Data entry page after login.I have tried  to set blank to these fields after login

document.getElementById('P10_LOGINNAME').value = '';
document.getElementById('P10_PASSWORD').value = '';

// This is working in Firefox but not in chrome.APEX Version : 4.1
Database : 10g

View 6 Replies View Related

Server Administration :: Role Cannot Login - Invalid Username / Password

Oct 9, 2011

I created a role,and it can not login,why?

session1:

SQL> Create Role con_role Identified By hxl;

Role created.

SQL> Grant Connect To con_role;

Grant succeeded.

SQL> Grant Create Session To con_role;

Grant succeeded.

session2:

sql>connect con_role/hxl@myserver ORA-01017: Invalid username/password.

View 12 Replies View Related

Security :: How To Disable Sql Login

May 28, 2012

How to disable a user's sql login? To ellaborate, I want a user to login through a certain application only with his userid on database level & not through "sqlplus username@dbname".

Is it possible? If no, then what can be done to achieve below.

I have a userid which has all the update, delete privileges on it. That id needs to be configured in the application alongwith the password. So in order to avoid misuse of that id I want to block its sql access.

I am not sure whether this can be achieved or not.

View 2 Replies View Related







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