Home » RDBMS Server » Server Administration » urgent help!!!
urgent help!!! [message #52123] Wed, 03 July 2002 13:05 Go to next message
emme
Messages: 13
Registered: July 2002
Junior Member
I have oracle server and client.(ORACLE 8.0 FOR WINDOWS NT).but i only know the host string.No body knows the user name and password.Just giving some assumed user name and password.If i use that assumed user name and password,I am getting error:

ORA-12224: TNS:no listener

My question is,
Is there is any way i can retrive the user name and password?

Please somebody help me

Report message to a moderator

Re: urgent help!!! [message #52132 is a reply to message #52123] Thu, 04 July 2002 02:02 Go to previous messageGo to next message
santosh
Messages: 85
Registered: October 2000
Member
Try using general users like scott/tiger

Or u can use system/manager and then run query select username,password from dba_users.Passwords will be in encrypted format but u can do -->alter user (user name) identified by (new password)

Santosh

Report message to a moderator

Re: urgent help!!! [message #118660 is a reply to message #52123] Fri, 06 May 2005 14:26 Go to previous messageGo to next message
David Shenoda
Messages: 4
Registered: July 2004
Junior Member
Hello:
I have a web application that requires user's login UID/PWD. The table DBA_USERS has the login info UID/PWD that we need, but the PWD is in Hex or Encrypted. How can I compare the user's PWD entered through the web app with the Encrypted PWD at the DBA_USERS table?

Can anyone help me please

Thanks;

[Updated on: Fri, 06 May 2005 14:27]

Report message to a moderator

Re: urgent help!!! [message #118683 is a reply to message #118660] Fri, 06 May 2005 19:07 Go to previous messageGo to next message
KumarD
Messages: 8
Registered: March 2005
Location: india
Junior Member
Hi,

The problem for you is to connect the database....but what i have seen in your issue is at your side the Listener process is not up...if this is the case even you supply the correct username and password u may not connect to the database...

so go the server machine and start ur listener then checkout whether u can connect or not.....if it is not connected then post the error message

Regards

D.Dilip

Report message to a moderator

Re: urgent help!!! [message #118712 is a reply to message #52123] Sat, 07 May 2005 03:59 Go to previous messageGo to next message
tycoonajayverma
Messages: 17
Registered: May 2005
Location: b'lore
Junior Member
Hi

1. u need to check that on server the listener is working or not. if working.
2. at the client check ur tnsname.ora file that file has the xxx.world in it alonge with service name ur using on the server.
3. if nothing u know all this stuff.. do one thing copy ur server tnsname.ora file edit it and use it...
4. for the user u can use the scott/tiger,system/manager,sys/change_on_install.
5. after u get access to the database with system and sys u can change the password for any user as u need with
alter user <username> identified by <passwd>;

Thanks

Report message to a moderator

Re: urgent help!!! [message #118744 is a reply to message #118660] Sat, 07 May 2005 14:52 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Re: urgent help!!! Sat, 07 May 2005 00:56
David Shenoda
Hello:
I have a web application that requires user's login UID/PWD. The table DBA_USERS has the login info UID/PWD that we need, but the PWD is in Hex or Encrypted. How can I compare the user's PWD entered through the web app with the Encrypted PWD at the DBA_USERS table?

Can anyone help me please

Thanks;

[Updated on: Sat, 07 May 2005 00:57]

DBA_USERS shows you all Oracle users. These may/may not be your application users.

Also when u connect to Oracle using any of these Oracle users (as displayed by DBA_USERS), from your web application, the connection will fail if the uid/pwd is incorrect. U will get error in connection itself.

If the application users are not oracle users and u want authentication to happen via Oracle only, in that case one way is to store the uid/pwd in one separate table and use this table for authentication purpose.

Report message to a moderator

Previous Topic: ideal sessions
Next Topic: Apache error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 04:27:29 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.