Home > IT Answers > CIO > Urgent Help: web-Forms 6i don't work after Up...
108108
0 pts.
 Urgent Help: web-Forms 6i don't work after Upgrading the db from 8i to 10g
Tech support, Installation, Migration, Windows, Security, Oracle, SQL, Architecture/Design, DB2, PHP, Database, Oracle administration, Performance/Tuning, Oracle Business Applications, Data/Application Integration, Oracle development, Oracle Database Versions, Java/J2EE, Backup & recovery, Oracle 10g, Oracle 8i
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.
ASKED: Oct 24, 2006  11:28 AM GMT
UPDATED: November 1, 2006  6:22:16 AM GMT
RELATED QUESTIONS
charliep
0 pts.
Answer Wiki:
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.
Last Wiki Answer Submitted:  Oct 24, 2006  3:14 PM (GMT)  by  charliep   0 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

also check if you have more than one tnsnames file on the server.

It has been a while since I used Oracle application server but there could be a registry (or some other) setting that is still pointing at another tnsnames.ora file. You did say that you are using the same database name for the new one as the old one.

charliep
 0 pts.
 

Thank you all. The problem was solved. We have several Oracle home directories .. not under the same parent directory so 1 of them still was pointing to the previous server and we missed that one (in the tnsnames.ora).

108108
 0 pts.
 

HI can you tell me the OS.This error related to Kernel parameter have you set the kernel parameters.
If you set the kernel parameter definitely it solves your problem

Regards,
Sathish.R
Oracle DBA

oracledba55
 0 pts.
 

HI can you tell me the OS.This error related to Kernel parameter have you set the kernel parameters.
If you set the kernel parameter definitely it solves your problem

Regards,
Sathish.R
Oracle DBA

oracledba55
 0 pts.