OraFAQ Forum: Forms » ORA-12560 ........... How could it resolve ?

Home » Developer & Programmer » Forms » ORA-12560 ........... How could it resolve ? (DATABASE 10g , FORMS 6i , FORMS 10g , WIN XP SP2)

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

ORA-12560 ........... How could it resolve ? [message #331693]

Fri, 04 July 2008 11:21

Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt

Senior Member

I installed both forms 6i , 10g ...... both work correctly , but just when I be in the beginning onto Run Time in forms 10g ... this error occur to me :-

http://img79.imageshack.us/img79/6555/ora12560dh4.png

and then I press OK and enter this information :-

http://img91.imageshack.us/img91/9980/ora12560nextstepek2.png

and when I press connect , i enter to form correct without any other problems.

I ask for help about the cause of that Problem (ORA-12560) , and also the Solution for it Question

Report message to a moderator

Re: ORA-12560 ........... How could it resolve ? [message #331698 is a reply to message #331693]

Fri, 04 July 2008 12:30

Frank
Messages: 7901
Registered: March 2000

Senior Member

First thing I can think of is that you have a different database-descriptor you default try to connect to (i.e. not orcl)

Report message to a moderator

Re: ORA-12560 ........... How could it resolve ? [message #332039 is a reply to message #331693]

Mon, 07 July 2008 05:33

debashispattanayak
Messages: 5
Registered: July 2008
Location: Bhubaneswar

Junior Member

Before running or compiling form make sure that u have loged in to the database using connect descriptor/host string (like username:SCOTT password:TIGER hoststring:ORCL)or if u are calling that form through menu then in the ON-LOGON trigger u try the followig:-

'SCOTT'||'/'||'TIGER'||'@'||'ORCL'
or
check wheather u have configured the tnsnames.ora file in the network folder for both 6i and 10g

[Updated on: Mon, 07 July 2008 05:42]

Report message to a moderator

Re: ORA-12560 ........... How could it resolve ? [message #333210 is a reply to message #331693]

Thu, 10 July 2008 18:32

Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt

Senior Member

at Form Level , ON-LOGON :-
logon('scott','Tiger@orcl');

that's all , the problem solved Smile

Report message to a moderator

Previous Topic:	Calculation without Summary Column
Next Topic:	how to use array variable

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 02:21:13 CDT 2025