Home » SQL & PL/SQL » Client Tools » Pasword reset
Pasword reset [message #306245] Thu, 13 March 2008 07:26 Go to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Oracle version.
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE	9.2.0.8.0	Production
TNS for Linux: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production


I have set the password like test@123 while connecting the SQL Plus it is not connecting to DB because user/test@123@hostname here there is 2 @ coming that is why.

Can you please advice how can i change the password.

Also i can connect SQL developer Tool.

Thanx & Reds
Thangam.
Re: Pasword reset [message #306246 is a reply to message #306245] Thu, 13 March 2008 07:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to enclose your password between ":
connect user/"test@123"@hostname

You can always change it using "password" command.

Regards
Michel
Re: Pasword reset [message #306247 is a reply to message #306246] Thu, 13 March 2008 07:38 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Hi Michel,

Good Day,

As per your advice i have connected like that but i got the below ERROR. Can you please.

SQL> conn dthangad/"jillu@55"@fcdb426_mpldev1
ERROR:
ORA-12154: TNS:could not resolve service name


Warning: You are no longer connected to ORACLE.



Re: Pasword reset [message #306253 is a reply to message #306247] Thu, 13 March 2008 07:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve the connect identifier specified
 *Cause:  A connection to a database or other service was requested using
 a connect identifier, and the connect identifier specified could not
 be resolved into a connect descriptor using one of the naming methods
 configured. For example, if the type of connect identifier used was a
 net service name then the net service name could not be found in a
 naming method repository, or the repository could not be
 located or reached.
 *Action:
   - If you are using local naming (TNSNAMES.ORA file):
      - Make sure that "TNSNAMES" is listed as one of the values of the
        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA)
      - Verify that a TNSNAMES.ORA file exists and is in the proper
        directory and is accessible.
      - Check that the net service name used as the connect identifier
        exists in the TNSNAMES.ORA file.
      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
        file.  Look for unmatched parentheses or stray characters. Errors
        in a TNSNAMES.ORA file may make it unusable.
   - If you are using directory naming:
      - Verify that "LDAP" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Verify that the LDAP directory server is up and that it is
        accessible.
      - Verify that the net service name or database name used as the
        connect identifier is configured in the directory.
      - Verify that the default context being used is correct by
        specifying a fully qualified net service name or a full LDAP DN
        as the connect identifier
   - If you are using easy connect naming:
      - Verify that "EZCONNECT" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Make sure the host, port and service name specified
        are correct.
      - Try enclosing the connect identifier in quote marks.

   See the Oracle Net Services Administrators Guide or the Oracle
   operating system specific guide for more information on naming.

Regards
Michel
Re: Pasword reset [message #306262 is a reply to message #306253] Thu, 13 March 2008 08:46 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Michel,

i have using local TNSNAME.ORA file only.

SQL> conn meilvs_app/1601_ilvsd@fcdb426_mpldev1
Connected.
SQL> 
SQL> conn dthangad/"jillu@55'@fcdb426_mpldev1
ERROR:
ORA-12154: TNS:could not resolve service name


Warning: You are no longer connected to ORACLE.
SQL> 


Same host but some others user names are working fine.

Thanx & Reds
Thanga.
Re: Pasword reset [message #306265 is a reply to message #306262] Thu, 13 March 2008 09:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check your quotes, one is double the other one is single.

Regards
Michel
Re: Pasword reset [message #306281 is a reply to message #306265] Thu, 13 March 2008 09:44 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Sorry if double quotes also same error.

SQL> conn meilvs_app/1601_ilvsd@fcdb426_mpldev1
Connected.
SQL> 
SQL> conn dthangad/"jillu@55"@fcdb426_mpldev1
ERROR:
ORA-12154: TNS:could not resolve service name


Warning: You are no longer connected to ORACLE.
SQL> 



Thanx & Reds
Thanga.
Re: Pasword reset [message #306283 is a reply to message #306281] Thu, 13 March 2008 09:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know what is the problem in your case but it does not come from the password:
SQL> create user t identified by "a@b";

User created.

SQL> grant create session to t;

Grant succeeded.

SQL> connect t/"a@b"
Connected.
SQL> connect t/"a@b"@mika
Connected.

Regards
Michel
Re: Pasword reset [message #306292 is a reply to message #306283] Thu, 13 March 2008 10:13 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
If it solves your immediate problem, you could also just change the password to something without a "@", with

ALTER USER dthangad IDENTIFIED BY new_pass


with a user that has DBA privileges.
Re: Pasword reset [message #306299 is a reply to message #306292] Thu, 13 March 2008 10:43 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Hi Thomas,

I don't have DBA privileges, just i am one of the user.

Thanx & Reds
Thanga,
Re: Pasword reset [message #306350 is a reply to message #306299] Thu, 13 March 2008 17:02 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Then ask your DBA to do it for you.
Re: Password reset [message #306638 is a reply to message #306350] Sat, 15 March 2008 05:00 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Hi Littlefoot ,

Your right, while i am going to my DBA they allocating the Ticket and money for that. Before going to them is there anyway to change my password.

My DBA's are ready to change the password only thing is i don't want to give money to them that is why i am asking here.

Can you please.

Thanx & Reds
Thangam.

Re: Password reset [message #306643 is a reply to message #306638] Sat, 15 March 2008 06:24 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Alternatively if you are connecting from unix try setting TWO_TASK variable from the shell prompt and try connecting to your userid and password. I am not sure what's the equivalent in windows. Once successful in your connection you can change your password.

Regards

Raj

[Updated on: Sat, 15 March 2008 06:36]

Report message to a moderator

Re: Password reset [message #306647 is a reply to message #306638] Sat, 15 March 2008 07:09 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
What happens if you connect without giving your password and wait for the password-prompt?
Re: Password reset [message #306704 is a reply to message #306638] Sun, 16 March 2008 01:14 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
iamdurai wrote on Sat, 15 March 2008 11:00
DBA (are) allocating the Ticket and money for that. My DBA's are ready to change the password only thing is i don't want to give money to them

Whoa! So they earn salary directly from employees? I hope not! But, if you have to pay for password resetting, is it legal? Do DBA pay taxes for this kind of extra money?

OK, I admit: I may be awkward or (even more likely) I didn't quite understand what you mean by "paying" this kind of a service. I just can't believe that someone might ask you to pay something that a person who types with 10 fingers needs pure 10 seconds in order to change your password. This is trivia ... doesn't require any skills, just privileges (true, not everyone is granted such privileges!) to be eable to
ALTER USER this_user IDENTIFIED BY its_new_password;
It's been three (3!!!) days now as you can't work because of "invalid" password. Unbelieveable!
Unnamed Cape Canaveral source
We are terribly sorry, but Endeavour can not take off because captain doesn't have any pocket money to change launching password
Re: Password reset [message #307038 is a reply to message #306704] Mon, 17 March 2008 12:00 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Hi Littlefoot,

Quote:


I am not joking or kidding what I said is real believe me why because if i need to reset my password that kind of situation I need to raise the DBA ticket it is going to be assign the DBA team once we are going to the DBA team they ducting our project cost.

Basically I am working in production support also my PM asking me a questions like why we need to go for DBA we will try like that.

I can connect via SQL developer whereas I can't connect through SQL PLUS.

Can you please help me.

Thanks in advance.






Thanx & Reds
Thangam

[Updated on: Mon, 17 March 2008 12:35] by Moderator

Report message to a moderator

Re: Password reset [message #307041 is a reply to message #307038] Mon, 17 March 2008 12:16 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Quote:

I can connect via SQL developer whereas I can't connect through SQL PLUS.



Can't you change the password in SQL developer then?
Re: Password reset [message #307070 is a reply to message #306647] Mon, 17 March 2008 15:12 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Frank wrote on Sat, 15 March 2008 13:09
What happens if you connect without giving your password and wait for the password-prompt?

Re: Password reset [message #307250 is a reply to message #307070] Tue, 18 March 2008 04:33 Go to previous messageGo to next message
iamdurai
Messages: 96
Registered: April 2007
Location: Chennai
Member

Hi Frank,

It is working fine.

Thanks a lot.


Thanx & Reds
Thangam.
Re: Pasword reset [message #311794 is a reply to message #306253] Sun, 06 April 2008 21:37 Go to previous messageGo to next message
gouthami1970
Messages: 2
Registered: April 2008
Location: Atlanta
Junior Member
hi,
Connecting as a sysdba.
i.e
sql> conn / as sysdba
enter the passward if any
sql>
alter user username identified by give newpassword

then the password changes

no conn with old username and new password


gouthami
Re: Pasword reset [message #311823 is a reply to message #311794] Mon, 07 April 2008 00:38 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
... which was already given as an advice about 10 or so posts back.
Previous Topic: /nolog
Next Topic: Toad Road Map
Goto Forum:
  


Current Time: Sun Dec 11 06:05:29 CST 2016

Total time taken to generate the page: 0.14562 seconds