Vivekk.Arora wrote:what exactly are you trying to do above?
I have raised a question in OTN yesterday "https://forums.oracle.com/forums/message.jspa?messageID=10798738#10798738" but stil i am not able to get the connection working..
I need some more clarifications in it. can some one suggest
SQL> alter user hr Vivek@310628 unlock;
i have followed the instructions provide:
in alter user command ,as suggested i am altering the user hr(which is provided by default) and Vivek@310628 is the password i have use during i have made a database using the tool...
I know i am wrong somehere but not getting where i am...
can you please tell me like ,if i have to create a new db using "Database configuration assistant" tool and then connect to that db using"sql developer " what are the steps involved.
You really should learn how to Read The Fine Manual yourself instead of relying on others to do so for you
[oracle@localhost ~]$ sqlplus SQL*Plus: Release 188.8.131.52.0 Production on Thu Jan 17 20:54:51 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to: Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> alter user hr identified by hr account unlock; User altered. SQL> connect hr/hr Connected. SQL>
Vivek@310628 is the password i have useYou should not be using the "@" character in a password. Oracle doesn't prevent you from assigning such a password but when you attempt to connect with the username-password combination, Oracle interprets the "@" as a connection-string indicator for another database.
Vivekk.Arora wrote:And we want to help. but the best help is that which leads you to a greater degree of self reliance. And you could have answered your question yourself (greater self-reliance) had you simply looked up the syntax of the ALTER USER command.
Thank you for your kind reply......i was just taking help ......