0

I am using Oracle for the first time.I installed Oracle SQL*PLUS ver 8.As I had to learn this for an exam. But I am facing the following error after I enter it with the system default scott/tiger ...

"ORA-12203: TNS:unable to connect to destination"

Sorry ,if this question is already asked as I searched, but didnt get.
Thanks in advance

3
Contributors
10
Replies
11
Views
6 Years
Discussion Span
Last Post by debasisdas
0

Check if the oracle service and listener services are up and running.

Also ensure that the account is unlocked and has permission to connect to he database.

Edited by debasisdas: n/a

0

What does "Check if the oracle service and listener services are up and running." mean ???

0

there will be 2 services running in the server on which oracle is installed.

1. for oracle database service.
2. for oracle listener .

Edited by debasisdas: n/a

0

I have installed on my PC itself to learn it ,so the server what your saying is localhost for me ,so what do I do to check and make those services running .

0

I could see 4 oracle services namely :
OracleClientCache80..........Started..........Automatic
OracleServiceORCL..........Started..........Automatic
OracleStart ORCL
OracleTNSListener80..........Started..........Automatic

What should I do now ?

0

Now the services are running.

Ensure that the account is unlocked and has permission to connect to the database.

0

How do you ensure that the account is unlocked and that it has permission to connect to the database ???

I am desperate to start it so....asking so many questions
Sorry

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.