Cannot able to connect the oracle database

[yogeshyl]

How can i use the oracle database on a local / single pc . what are the settings required in tnsnames.ora?

Where should i store the database on my local computer, ie. c drive / d drive?

How i shall give path of the database in tnsnames.ora file.

Yogesh

[debasisdas]

Kindly post the exact error message eith error number that you are getting .

[smashzone]

How can i use the oracle database on a local / single pc . what are the settings required in tnsnames.ora?


I'm not sure what you want to do, but if you install oracle database on your pc, there are no settings required in your tnsnames.ora file, oracle will configure this automatically during installation.

Where should i store the database on my local computer, ie. c drive / d drive?


Well, it doesn't matter where you install oracle, that is entirely up to you.

How i shall give path of the database in tnsnames.ora file.
What do you mean about path, please be specific

Cheers
Smashzone

[smashzone]

Just a follow up, if you want to coonect to a database in windows (and this depends which oracle version you are using), make sure that you have your ORACL_SID environment variable set. And from the command line, simply issue the following:

sqlplus /nolog

conn /as sysdba


Hope this helps
Cheers
Smashzone