Question

Urgent Help: web-Forms 6i don't work after Upgrading the db from 8i to 10g

Database, Oracle, DB2, SQL, Windows, Oracle administration, Architecture/Design, Backup & recovery, Installation, Migration, Performance/Tuning, Security, Data/Application Integration, Oracle Business Applications, Oracle Database Versions, Oracle 10g, Oracle 8i, Oracle development, Java/J2EE, PHP, Tech support

Hi,
We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B.
The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C.

When launching the web-Forms we get this error: 1034-ORACLE not available ORA-27101:shared memory realm does not exist SVR4 Error: 2: No such file or directory. After providing the connection parameters the same error comes up.

The sqlplus is running fine on the Forms 6i machine against this 10g db. The db is up and running and we have Forms 4.5 that are running against the 10g db almost fine for 2 days already.

the tnsnames.ora file is using the alias for the db, all the SIDs are lower case, so we tried to "cover" properly the environment settings.

Please, help. We don't have an Oracle DBA and the db was upgraded by consultants that didn't reply to our questions yet.

Couldn't find any hardcoded info that is pointing to the host C.
Please, advice.

Thank you.

If you can, start up the old 8i database and see if the application connects to it. That way you'll at least know if something is still looking for the old one or if the error is caused by a misconfiguration with the new one.