you have to download oracle instantclient from here
choose that supported for your platform & your database.
like, Instant Client for Microsoft Windows (32-bit)
==> Version 11.2.0.1.0
====> instantclient-basic-win32-11.2.0.1.0.zip
When you downloaded zip file to your computer already, extract to your path
like, c:\instantclient_11_2
Then right client at My Computer ==> Advanced ==> Environment Variables
At Environment Variables window click new at user variable ( if you want to add for this user only) or system variable ( if you want all users on this computer use )
add
ORACLE_HOME=c:\instantclient_11_2
TNS_ADMIN=c:\instantclient_11_2
NLS_LANG=AMERICAN_AMERICA.TH8TISASCII
Then, Create text file tnsnames.ora at c:\instantclient_11_2 with your connection string to use your database
like,
TESTDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = TESTDB)
)
)
That all!
==TaTsHuYa==
4 comments:
Thanks so much for this.
I spent the better part of all day today trying to configure pl/sql developer and your blog post got me through it.
Thank you! This saved me!
Thank you, it worked.
well done bro. was a great post spent more then 30 hours to solve this problem at last your suggestion came in and finally all okay.
Post a Comment