Oracle Database Discussions

Hello,

This is with respect to the two issues I am encountering in Oracle. Kindly somebody help with these issues as it is urgent.


PLEASE GO THROUGH EACH AND EVERY POINT BEFORE ARRIVING AT A CONCLUSION

1. With the Post Oracle database installation
2. Oracle forms connectivity to the Oracle database (FORMS WAS INSTALLED PRIOR TO ORACLE INSTALLATION)

I will start with the 1st issue (Post Oracle database installation)

Steps A01
----------
1. I unistalled an existing version 8.1.7 using the steps mentioned in the following link (http://www.oracle-base.com/articles/misc/ManualOracleUninstall.php)
2. I chose typical installation (default, all the rest of installation methods were default)
3. Gave SID as ORCL_DB
4. Created database by installation
5. connected to SYS using default password - no problem
6. Created another user usr01 and granted necessary privileges Was able to logon to the database using usr01. No problem

But if I do a restart of the machine and then I am encountering an error ORA-27101: shared memory realm does not exist after which I am unable to connect to the database.

##### (PLEASE NOTE THAT I AM ABLE TO CONNECT TO ORACLE FOR THE FIRST TIME WITHOUT ANY PROBLEMS. THE ERROR IS THROWN IF WE REBOOT THE MACHINE AND TRY TO CONNECT TO ORACLE) ###


The steps I tried to troubleshoot this
--------------------------------------
a. Checked the oracle network admin directory. All the config files are there (TNSNAMES.ORA, SQLNET.ORA, LISTNER.ORA)
b. did a tnsping
c:\tnsping ORCL_DB
NO PROBLEM WITH THAT. GETTING OK FOR THE PING
c. Checked the oracle registries.
Could find all these entries have the correct value:
ORACLE_HOME - C:\ORACLE
ORACLE_SID - ORCL_DB
ORACLE_BASE - c:\oracle

There were no extra slash or extra character with the registry entries.

Now the the post forms installation scenario

Steps A02 (FORMS WAS INSTALLED PRIOR TO ORACLE INSTALLATION)
------------------------------------------------------------
1. Installed forms (directory c:\orant)


Steps A03
---------
1. Copied the contents tnsnames.ora file entries from oracle\network\admin directory to the orant\net80\admin\tnsnames.ora file
2. Tried to connect to oracle forms (user : usr01, database : ORCL_DB).

Got error : ORA-12154: TNS:could not resolve service name

3. Created an environment variable : tns_admin with value c:/oracle/network/admin. Tried to connect again
Now getting another error : unable to connect to the destination : ora-12203 (unable to connect to destination)


I have installed forms and oracle in separate directories. Can somebody help to resolve these issues?

Thanks in advance
Chanaya