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