Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Unanswered: Connection Problem in Form6i for Win95 and SCO Unix/Oracle 7.1.6

    We have no client server environment but UNIX environment.
    We are storing Form 3.0 application as well as Oracle 7.1.6 database on SCO Unix 5.0.0 server machine. And we are running Form 3.0 application on dump terminals with help of terminal emulation program.

    Now we wish to migrate Form 3.0 application to Forms 6i. Hence we purchased Oracle IDS and loaded forms 6i on windows 95/98 clients.

    Intially we faced the problem of ping with unix server. We resolved it using tnsnames.ora file modification and starting the listener. Now listener has started and tnsping80 response is OK.

    Problem :
    Now when we run the forms 6i designer or sqlplus or any other application, it asks for username,password,connect-string. After giving all these, as scott,tiger,test (service-name), it gives error - ora-06413, connection not open.

    Please suggest any solution. We are using OS Authentication method.

  2. #2
    Join Date
    Jan 2002
    Location
    italy
    Posts
    39
    Hi:

    You may want to trace the client connection with level 16 (admin) and look at the resulting sqlnet trace file.

    There is an issue in regarding reserved characters used to identify the client computer: If you have this characters in the host name, username, program name these charaters can 'break' the establishment of the connection.

    Reserve symbols are:

    ( ) = \ " ' #

    let me know if this was your case...

    regards,
    astropp
    astropp

  3. #3
    Join Date
    Feb 2002
    Posts
    2
    Dear Mr.astropp

    I could not find the trc file in client machine. Any way, we give the parameter like this :

    username : scott
    pass : tiger
    conn_stg : erp

    erp is our service name, which is pinging and giving OK with server. There is no special characters as metioned by you.

    regards,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •