remote junior developer

Tags: plsql installing Oracle Client InstallationDownload the 3 required packages (in order to connect the 11g database)1:oracle Client (Oracle clients)Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/112010-win64soft-086667-zhs.htmlDownload Win64_11gr2_client.zip Specific installation method can refer to Baidu2:pl/sql Developer 11.0Http://files.allroundautomations.com/plsqldev1106x64.exeDownload plsqldev64 bit, specific inst

PL/SQL Developer Remote connection to Oracle Database I searched many methods online. This is feasible! 1. Configure the server tnsnames. ora file. If oracle is not installed on the local machine, you can copy one (tnsnames. ora file) in the specified directory, because I have installed oracle, so directly configure this file. # Tnsnames. ora Network Configuration File: D: \ Oracle11g \ product \ 11.2.0

64-bit, use normal. (2) Install Plsql Dev. 2. Installation and Setup (1) This machine to establish a dedicated directory (will be referenced, so must be fixed directory, the proposed roadbed without space), the OCI download package decompression. (2) Create a network directory within the directory, in the network directory, create an admin directory, where the Tnsnames.ora TNS configuration file will be placed (3) Open Plsql Dev, direct Cancel Connection window into the main interface, click O

Remote connection to Oracle is troublesome. It usually takes the oracle client to be installed. You can use instantclient to easily connect to a remote Oracle database. 1. Create a Directory D: \ Oracle_Cleint to store related files. Create a Directory D: \ Oracle_Cleint \ NETWORK \ ADMIN to store tnsnames files.2. Download the corresponding version and the system's instantclient compressed package, decom

Client: WIN10Server: Oracle server installed on Linux1, download Plsqldeveloper11.zip, Instantclient_11_2.rar and unzip to the corresponding directoryD:\instantclient_11_2, D:\PLSQL Developer2. Add environment variables on WIN10Variable name: Tns_admin variable Value: D:\instantclient_11_2\NETWORK\ADMINVariable name: Nls_lang variable value: Simplified Chinese_china. Zhs16gbkVariable tns_admin is the directory where the Tnsnames.ora file resides3./u01/app/oracle/product/11.2.0/db_1/network/admin

if not yet.4, sometimes may appear the client to the Chinese support bad question, may refer to the following third article environment variable setting:On the desktop, right-click My Computer, select Properties, select Environment variables in the Advanced page, and in the system variables, increase:1) variable name: oracle_homeVariable Value: E:\instantclient_11_22) variable name: tns_adminVariable Value: E:\instantclient_11_23) variable name: Nls_langVariable value: Simplified Chinese_china.

PL/SQL Developer does not install a client to connect to a remote oracle database (for example, developeroracle)Labels ):Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html2. Download and install PLSQL (around 16 Mb ):Http://www.onlinedown.net/soft/4902.htm3. Unzip the instantclient-basic-win32-11.2.0.1.0.zip to a new folder, such as D:/oracleclient/instantclient_11_2

Client: WIN10Server: Oracle server installed on Linux1, download Plsqldeveloper11.zip, Instantclient_11_2.rar and unzip to the corresponding directoryD:\instantclient_11_2, D:\PLSQL Developer2. Add environment variables on WIN10Variable name: Tns_admin variable Value: D:\instantclient_11_2\NETWORK\ADMINVariable name: Nls_lang variable value: Simplified Chinese_china. Zhs16gbkVariable tns_admin is the directory where the Tnsnames.ora file resides3./u01/app/oracle/product/11.2.0/db_1/network/admin

Tags: des style blog Class Code javaRemote connection to Oracle is cumbersome and usually requires client installation of Oracle to be implemented. With instantclient, you can compare simple connections to remote Oracle.1. New directory D:\Oracle_Cleint used to store related files, new directory D:\Oracle_Cleint\NETWORK\ADMIN for tnsnames files2. Download the corresponding version and the System Instantclient compressed package, extract the Instantcli

Modify the database configuration file: Tnsnames.ora "My database location: D:\app\Icey-evil\product\11.2.0\dbhome_1\NETWORK\ADMIN"Add the following to the server address:10.88. 250.28 = = =10.88. 250.281521) ))) (= ORCL ) )) Description: HOST = 10.88.250.28 is the Oracle server that needs to be connected Ip,service_name = ORCL is a connected db instance, Port = 1521 is the Oracle Server listener.Configuration complete, with the PL/SQL

Tags: PL/SQL developer do not install client connection to remote Oracle databasePL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. Now that more and more business logic and application logic has shifted to Oracle Server, PL/SQL programming has become an important part of t

of the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * from N

example, my machine is: d:/instantclient_11_2/network/admin4. Set the Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;

Oracle Database installation process is cumbersome, and uninstall more cumbersome, if the uninstallation is not clean, the next time you install Oracle will not succeed. Here's a way to remotely connect an Oracle database using the PLSQL Developer tool without having to install an Oracle client.First you need to download this software on the Oracle official website: INSTANTCLIENT-BASIC-WIN32. Then unzip, open this file, create a new file inside: Netwo

Tags: PL/SQL Developer remote database without native Oracle clientI. Download PL/SQL DeveloperPL/SQL Developer download page, you can choose to download 32-bit or 64-bit, if you need Chinese language interface can also downloadSecond, download instant Client, which contains access to the database of the OCI and other documentsInstant client Download page, downlo

appropriate IP address to5. Place the modified Tnsnames.ora file under the D:\Oracle_Cleint\NETWORK\ADMIN folder.6. Environment variable settings (user variable, environment variable, "Properties", "My Computer," right), create a new user variable, variable name nls_lang, variable value simplified Chinese_china. Zhs16gbk7. Configure Plsql Developer, tools → preferences →oracle→ connection, complete Oracle home folder name: D:\Oracle_Cleint\OCI Librar