TNS Protocol adapter error while starting Oracle SQL*Plus

Question

Whenever I try to login into SQL*Plus (11g Standar Edition Win 64) I get an error related to some connection error.

I try to login as sys as sysdba and provide the password.

All the services are started. I'm on Windows 7.

Any help would be appreciated.

enter image description here

possible duplicate of [Oracle Protocol Adapter Error](http://stackoverflow.com/questions/6173492/oracle-protocol-adapter-error) — Sathyajith Bhat, Jan 09 '12 at 04:35

score 12 · Answer 1 · edited Jan 10 '12 at 11:50

12

Try

sqlplus sys/<your password>@<your SID> as sysdba

edited Jan 10 '12 at 11:50

Jon Egerton

40,401
11
97
129

answered Jan 10 '12 at 11:46

Sivadas Melazhi

121
2

score 9 · Answer 2 · answered Oct 06 '12 at 05:11

Ensure the OracleService is running. I keep running into this error, but when I go into Services, find OracleServiceXE and manually start it, the problem is resolved. I have it set to start automatically, but sometimes it just seems to stop on its own; at least, I can't find anything I am doing to stop it.

score 4 · Answer 3 · answered Jan 09 '14 at 04:08

4

Use this command, in command prompt

sqlplus userName/password@host/serviceName

answered Jan 09 '14 at 04:08

Roshan

177
2
9

John Doyle · Answer 4 · 2012-01-09T04:31:35.823

4

Try typing all of this on the command line:

sqlplus / as sysdba

As what you are doing is starting sqlplus and then using sys as sysdba as the user-name which is incorrect as that is not a valid user. By using the above command Oracle is using your system login credentials to access the db. Also, I would confirm that the sqlplus executable you are running is the correct one by checking your path - ensure it is in the bin of the server installation directories.

edited Jan 09 '12 at 04:31

answered Jan 09 '12 at 03:06

John Doyle

7,475
5
33
40

Do you get the same error if you use `tnsping `? What do you see if you use `lsnrctl status`? (Ignore my initial suggestion that using `sys as sysdba` is incorrect, it _is_ acceptable, your error is something else.) – John Doyle Jan 09 '12 at 14:45

score 3 · Answer 5 · answered Sep 30 '15 at 08:14

You are getting ORA-12560: TNS:protocol adaptor error becuase you didn't start the Oracle database.

You can start Oracle database like this. From START-> select Oracle Database 11g Express Edition( 11g or what ever your database type.you can find this from All Programs). Then inside this folder there is a DB icon with green color spot. It is the Start Service icon.Click it.Then it will take some seconds and start the service.

After getting the above message,again try to connect through the SQL plus command line by giving user name and password.

score 2 · Answer 6 · answered Jan 10 '12 at 12:04

2

Enter SQL*Plus with:

sqlplus /nolog

And then:

connect sys@<SID> AS sysdba

answered Jan 10 '12 at 12:04

Benoit

76,634
23
210
236

score 1 · Answer 7 · edited Jul 20 '17 at 19:20

1

Go to Start --> Run--> type " services.msc"

Select the OracleService name, Right Click, Start.

Wait for a while and then your service will start. Then go to your sql command line window and try to connect to your user. I hope you can do that now.

edited Jul 20 '17 at 19:20

Community

1
1

answered Jun 24 '14 at 20:49

Bikash Karmokar

43
1
7

score 0 · Answer 8 · answered Apr 13 '13 at 16:59

0

You might have set oracle not to start automatically. Goto Start and search for Services. Scroll down and look for OracleServiceORCL (or OracleServiceSID). Double click and change startup type to automatic if it is set as manual.

answered Apr 13 '13 at 16:59

CodeDevotion

307
2
16

access_granted · Answer 9 · 2017-12-13T03:47:06.457

0

Another possibility (esp. with multiple Oracle homes)

set ORACLE_SID=$SID

sqlplus /nolog

conn / as sysdba;

edited Dec 13 '17 at 03:47

answered Dec 13 '17 at 03:36

access_granted

1,807
20
25

score 0 · Answer 10 · answered Dec 28 '18 at 17:40

The major issue might be the oracle database itself may not have started. So, you need to manually go via

run command -> services.msc

check for OracleXEService surely, it may be disabled

right click go to properties-> set it to Automatic and press Ok. Then just right click again and start.

This will start your database making you to connect to it

Finally, In sqlplus command line,

connect as sysdba

enter username as admin

then press enter, you'll be connected

score 0 · Answer 11 · answered May 17 '20 at 03:55

0

Make sure your oracle services are running automatically. Just press Win+R. Type services.msc in textbox then press O to find oracle services.

In your PC name might be like OracleserviceXYZ. Right click on highlighted services.

answered May 17 '20 at 03:55

Abhi

73
2
9

TNS Protocol adapter error while starting Oracle SQL*Plus

11 Answers11

Linked