Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with oracle 8i and 9i

441238Apr 6 2005 — edited Apr 6 2005

Hi all,

I'm currently working with Oracle database 8i and forms 6i and I need to work also with oracle database ans foms 9i. I succeded the installation of Oracle 9i and I can connect to database9i.

My problem is that I couldn't no more connect to oracle8i. when I try to open an sql*plus8.0 session with user_name:system and pwd=manager, I'm getting the following error message :
"ORA-12560: TNS - Protocol Adapter Error".

also when I enter a value for the hostString=my_service_name (which is detailed in tnsnames.ora), I get another error message:
"ORA-01034:oracle not available
ORA-27101:shared memory realm does not exist".

can someone help me to solve this problem in order to connect to both oracle8i and 9i database.

I will be very Thankfull.
Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on May 4 2005

Added on Apr 6 2005

#general-database-discussions

15 comments

471 views