The same Instant Client ZIP file occupies 463.956 KB on disk. "Waste hundreds of megs"? No kidding! Instant Client (10.2.0.1.0) needs 498 MB.
"Install everything"? Oracle Universal Installer suggests several options, such as Instant Client, Runtime, and - oh, guess what? - Custom installation which enables you to choose individual components to install. Quote: Did you ever get frustrated when you want to connect with your oracle database, but you have to install everything from oracle client software cd and waste for hundreds megs only to get connect with your database? No major objections, but one: the first sentence: I read contents of the page you suggested. "Run From Server"="res:US,prodmsg:US,script:US,dll:US" "ORACLE_GROUP_NAME"="Oracle - DEFAULT_HOME1" Now open your client and access the database."inst_loc"="C:\\Program Files\\Oracle\\Inventory"
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname or ipaddress)(PORT = portnum)) Now open the “tnsnames.ora” and enter database configuration information. If Variable Value already exists then append a semi-colon to the list and update the new path, then Click OK.Ģ. Open the Control Panel –> click, System (Classic View) –> select, Advanced tab –>click, Environment Variables –> click, New (User variables) –> enter Variable Name as “TNS_ADMIN” and Variable Value as the location path of file “tnsnames.ora”, which comes in C:/oracle….Networ/Admin, now click, New (System variables) –> enter Variable Name as “Path” and Variable Value as the Oracle client folder path. How to setup up the environment variables We need to configure the client.įor that first set up the TNS_ADMIN environment variable and later confure the tnsnames.ora.ġ. Unzip the files to your Oracle installation folder. The latest version is Version 11.2.0.3.0, select the Instant Client Package – Basic Lite: Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only). The required software link is “Instant Client for Microsoft Windows (圆4)”. Solution: Download and install Client from given link. The error clearly says an 64-bit Oracle client need to be installed properly inorder to access the database. This error occurs when we try to connect an Oracle database, through a Client like Toad for Oracle etc.
You need at least one 64-bit client properly configured.
0 kommentar(er)
