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