Get ready:
PL/SQL Developer: I'm using plsqldev1005 (32-bit)
Win32_11gr2_client: Remember that it must be 32-bit, because PL/SQL developer only recognize 32-bit
After the installation is successful, you need to configure the environment variables:Tns_admin environment variable, similar to: C:\app\Lzj\
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
At the end of the year, the main write Java has been more than half a year. During this half-year period, I learned to use Spring-boot, learned SQL, and learned to use MongoDB. At first glance, the content of my work seems to be mostly "back-end", so can I calculate a half back-end development? I don't think so.Yes, I started working on Java and databases in the last six months, but my job is essentially "data presentation" to the front page. Just bef
Label: 1, PL/SQL Developer Text field display garbled Reason: Because the database number format and the PL/SQL Developer encoding format is not unified.2, PL/SQL Developer Encoding Format Setup detailed solution is as follows:Fir
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
1. Configure the Oracle database connection
In the previous article, we have learned how to use Oracle's net configuration assistant to configure database connections. In addition, you can modify the configuration file to connect to the database. Find the tnsnames. ora file under the Oracle Installation File. The general path is ORACLE_HOME % \ Network \ ADMIN:
Orcl =(Description =(Address = (Protocol = TCP) (host = localhost) (Port = 1521 ))(CONNECT_DATA =(
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
Tags: RAC blog file reference style environment Admin CSDN timeoutPrerequisite: The Oracle database has been successfully installed. Installation environment: Win7 64-bit Oracle installation version 11g 64-bit Question 1) Oracle comes with Sqldeveloper Let me enter the full path of the Java.exe and then report a warning Warning:could not find jvm.cfg! In ' C:\Program files\java\jdk1.8.0_151\jre\lib\jvm.cfg ' The other person's experience is that the installed Sqldeveloper is 32-bit and the JDK
, and then in the Instantclient_11_2 directory, create a new Layer two folder \NETWORK\ADMIN, Then build a tnsnames.ora file under the Admin folder and add the following to the file: [Plain]View PlainCopyprint?
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORACLE)
)
)
Listener_oracle =
(ADDRESS = (PROTOCOL = TCP) (HOST = l
derived from V$parameter, which represents the setting of the client's character set, which may be a parameter file, an environment variable, or a registrySession Character Set Environment select * from Nls_session_parameters, which originates from V$nls_parameters, represents the session's own settings, which may be the session's environment variable or alter session completion, If the session does not have a special setting, it will be consistent with nls_instance_parameters.Querying the char
If you establish a connection server with a 32-bit database server on a 64-bit computer and use the connection server for Distributed queries on 64-bit computers, the following error message is returned:
Server: Message
7399
, Level
16
, Status
1
, Line
1
Ole db Provider
'
Sqloledb
'
Reported an
Tags: ant article directory name add protoc Imp directory database comOracle 11g Lite Client ConfigurationOracle is typically deployed on the server, and the client needs to connect to Oracle on the server using connection tools such as PL/SQL Developer.At this point, it is often necessary to install hundreds of megabytes of Oracle on the client and then configur
Resolved in three steps:1. Check the server code:Execute SQL Syntax: SELECT * FROM V$nls_parameters;2. Set the local client code:Enter My computer, properties, advanced, environment variables, add 2 items: LANG=ZH_CN. GBK and nls_lang= "simplified Chinese_china. ZHS16GBK "Note: Nls_lang is determined by the value of step 1 {nls_language}_{nls_characterset} (different Oracle
Label:Resolved in three steps:1. Check the server encoding:Run SQL Syntax: SELECT * FROM V$nls_parameters;2. Set the local client code:Enter My computer, properties, advanced, environment variables, add 2 items: LANG=ZH_CN. GBK and nls_lang= "simplified Chinese_china. ZHS16GBK "Note: Nls_lang is determined by the value of step 1 {nls_language}_{nls_characterset} (different Oracle
them by the last update time. Run the following statement: SELECT * from sys.objects where type in (' U ', ' V ', ' P ') Order by modify_dateThis statement identifies all the user tables, views, and stored procedures in the database and sorts them by time, so that you can see others recently added and modified those database objects. Sys.objects does not contain triggers, and triggers are in sys.triggers. There are similar sys.tables,sys.views and so on. Information_schemaIf we want to quickly
Original Oracle SQL Developer useComparison:Plsqldev: Third-party, fast startup software, slow execution of SQL queriesSqldeveloper:oracle company, slow startup software, fast execution of SQL queriesDisadvantages:Every once in a while (about 10 minutes), will be disconnected, need to reconnect, bitter force!Ask for he
Label:Recently in the study of the relevant content of the database, after Sqlplus knocked a few days command line window, want to try to connect with SQL Developer database but has not been implemented. After searching the relevant information on the net now finally fix, write down this blog to share with you!1. Configure the Java.exe path after you open SQL
Tags: background database management tool Oracle ClientFor the traditional large-scale software products using relational database, the continuous development and maintenance of the background database can produce a large number of script files, how to make versioning more convenient for these script files, and how to quickly manage the permissions between the teams. The level of integration between the different database products and the corresponding client management tools and different produ
Before you start
About this series
This six-part series on DB2 SQL Procedure Developer describes all the basic constructs and methods of SQL procedural Language, and explains how to use it in stored procedures, user-defined functions, and triggers, including error handling and deployment. Also describes some of the DB2 9.5 advanced features, such as optimistic
\tnsnames.ora or write one of their own content as follows:# Generated by Oracle configuration tools.ORCL =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 10.5.10.252) (PORT = 1521)))(Connect_data =(service_name = ORCL)))The above three must pay attention to, in addition some Windows version of the tnsnames.ora.txt behind the txt to be removed;4, double hit open plsql point cancel650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/75/C7/wKiom1ZCWg2jjIVYAACFBK6WYNE843.png
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.