OraFAQ Forum: Forms » invalid username/password; login denied

Home » Developer & Programmer » Forms » invalid username/password; login denied (Oracle forms 10g, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

invalid username/password; login denied [message #519035]

Tue, 09 August 2011 01:35

yeahia
Messages: 22
Registered: June 2010
Location: Bangladesh

Junior Member

Hi,
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.

How can I solve this?

Yeahia

Report message to a moderator

Re: invalid username/password; login denied [message #519037 is a reply to message #519035]

Tue, 09 August 2011 01:39

ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Make sure that you are connecting to the correct TNS entry.
or make sure your password and username are correct.

If you are able to connect using sqlplus ..then those tns entries should be in client(forms or reports) tnsora file.

sriram

Report message to a moderator

Re: invalid username/password; login denied [message #519052 is a reply to message #519037]

Tue, 09 August 2011 02:33

yeahia
Messages: 22
Registered: June 2010
Location: Bangladesh

Junior Member

I have copied the tns files from database to client side, but still same problem. password and username are correct.
Yeahia

Report message to a moderator

Re: invalid username/password; login denied [message #519054 is a reply to message #519052]

Tue, 09 August 2011 02:37

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And are you able to connect with sqlplus from your client?
Did you copy the tnsnames.ora inside the forms home?
Did you connect using the tnsnames.ora entry that is something like: user/psw@tns_entry?

Regards
Michel

Report message to a moderator

Re: invalid username/password; login denied [message #519056 is a reply to message #519054]

Tue, 09 August 2011 03:04

yeahia
Messages: 22
Registered: June 2010
Location: Bangladesh

Junior Member

when i try to connect sqlplus from my client then it shows "the account is locked"
Now how can i unlock the sys or system user?
other two options you gave, i have done.
thanks.
Yeahia

Report message to a moderator

Re: invalid username/password; login denied [message #519067 is a reply to message #519056]

Tue, 09 August 2011 03:45

Michel Cadot
Messages: 68676
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Now how can i unlock the sys or system user?

SYS is NEVER locked.
You can unlock an account connecting as a DBA account and using ALTER USER ... ACCOUNT UNLOCK;
If you have no more DBA account (which is bad as you should always create at least one DBA acccount and do not use SYSTEM), you have to locally connect as SYS (connect / as sysdba) to execute the above statement.

Regard
Michel

Report message to a moderator

Re: invalid username/password; login denied [message #519070 is a reply to message #519067]

Tue, 09 August 2011 03:58

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

And don't try and connect forms to the DB as sys or system, that's not what they're there for. Create a new user to connect as.

Report message to a moderator

Previous Topic:	Graphics Builder Canvas Resizing (merged 2)
Next Topic:	Oracle Forms 10g & DB Connection Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 10 02:09:54 CDT 2024