Skip to Main Content

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!

ORA-12557: TNS:protocol adapter not loadable

Hiten SJul 15 2018 — edited Jul 16 2018

Hello Community,

I am installing Oracle 12c. After installation when I try to run sqlplus it gives me error as below.

C:\Users\hiten>sqlplus

SQL*Plus: Release 12.1.0.1.0 Production on Sun Jul 15 09:06:48 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Enter user-name: system

Enter password:

ERROR:

ORA-12557: TNS:protocol adapter not loadable

But if I try from Oracle Bin Folder it works.

C:\app\hiten\virtual\product\12.2.0\dbhome_1\bin>sqlplus

SQL*Plus: Release 12.2.0.1.0 Production on Sun Jul 15 09:18:19 2018

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Enter user-name: system

Enter password:

Last Successful login time: Wed Jul 04 2018 14:05:41 -07:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Any help what am i missed. I have added My Environment Variables are as below:

pastedImage_1.png

My Path Variables are

pastedImage_2.png

This post has been answered by unknown-7404 on Jul 15 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2018
Added on Jul 15 2018
14 comments
7,937 views