Alibabacloud.com offers a wide variety of articles about sql developer installation steps, easily find your sql developer installation steps information here online.
1. The downloaded Oracle SQL Developer, rpm file,: http://www.oracle.com/technology/software/products/ SQL /index.html 2. Install sun's jdk1.6. If it is already installed, skip this step. (linux mint 12 is installed by default.) command:Sudo apt-get install sun-java6-jdk 3. l SQL Develoepr setting is an rpm package b
August 6, 2017 21:12 minutes, today is the third week of my 10 blog plan! Today I finished a big event, I think years later, this thing will make me proud and proud, specific I do not want to say here, cut a few pictures to understand the peopleToday I would like to share about the SQL Server database installation and uninstallation steps, online about this kind
Tags: recommended https down nload beautification tool stored procedure recommended check DownloadFor a stored procedure to write a large number of SQL statements, which inevitably need to beautify the statement, making the program more readable.The PL/SQL Developer development tool comes with a beautification tool, but it's easy to make the statement all the way
PL/SQL Developer customizes the case-sensitivity conversion icon to the toolbar. pldeveloper For case-insensitive conversion shortcuts, see http://blog.csdn.net/itmyhome1990/article/details/41363633 You can add the case-insensitive conversion icon to the toolbar using the following methods: Steps: Tools --> Preferences --> User Interface --> Toolbar --> Add
, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements. Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit 1), create a text file Shortcuts.txt, and write the following content:I=insertU=updateS=selectF=fromW=whereO=order byD=deleteDf=delete fromSf=select * FROMSc=select COUNT (*) fromSfu=select * from for UPDATECor=create OR REPLACEP=procedureFn=functionT=tiggerV=
Local Oracle client connects to remote database with Plsql developer , log in when reported ORA-12638: resolution of failure of identity certificate retrievalLocate the installation directory: C:\oracle\BIToolsHome_1\network\ADMIN Open Sqlnet.oraFind sqlnet in there . Authentication_services= (NTS)Change it to: sqlnet. Authentication_services= (Beq,none)or comment out : #SQLNET. Authentication_services= (N
Tags: des style blog color os io file data1, found in the local installation of Oracle directory oracle\product\11.2.0\dbhome_1\network\admin, it generally has two files can be edited Tnsnames.ora Listener.ora, generally as long as the configuration Tnsnames.ora can. Configure how the content looks like.# Tnsnames.ora Network Configuration file:d:\app\oracle\product\11.2.0\dbhome_1\network\admin\ tnsnames.ora# Generated by Oracle configuration tools.
Locate the installation directory: C:/oracle/product/10.2.0/db_1/network/admin Open Sqlnet.oraFind sqlnet in there . Authentication_services= (NTS)Change it to: sqlnet. Authentication_services= (Beq,none)or comment out: # Sqlnet. Authentication_services= (NTS)The reason: My computer is in domain control, and NTS is just the window OS authentication method.PL/SQL Develop
client directory, create a new folder network, the network in the new admin, in the admin directory, a suffix named. ora file: Tnsnames.ora\instantclient_11_2\network\admin\tnsnames.oraNotepad opens and the content is added as follows:# Tnsnames.ora Network Configuration File:d:\oracle\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORCL =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521)))(Connect_data =(service_name = ORCL)))Test-name
=650; "src=" Http://s3.51cto.com/wyfs02/M02/76/A3/wKiom1ZYEkzQ0S6hAAC0mppqcpU848.png "style=" float: none; "title=" QQ picture 20151127161554.png "alt=" Wkiom1zyekzq0s6haac0mppqcpu848.png "/>650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/76/A3/wKiom1ZYEk2TxuOGAACuamQQdIc156.png "style=" float: none; "title=" QQ picture 20151127161617.png "alt=" Wkiom1zyek2txuogaacuamqqdic156.png "/>650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/76/A3/wKiom1ZYEk7g_hWrAACr_nKZcxY607.png "st
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_
PL/SQL Developer experience with oaracle11g64-bit systems in Windows7 64-bit SystemsI. Problem phenomena and solving methodsPhenomenon:1.pl/sql cannot log on to a 64-bit database2. Enter Chinese in PL/SQL developer, after saving, Chinese becomes '?? ' Such a garbled symbol3.
How to create a user using oracle SQL Developer, oracledeveloper This is for Oracle11g. I don't know if I haven't tested other versions. First, use system to establish a connection. The password is the password you specified during installation, and then create a new user in the "other users" at the bottom. Note 1: After creating a role, you must grant the DBA
There are two ways to find it online:1. Through Configuration and migration ToolsNet manager→ local → profile →oracle Advanced Security → validation → Remove the "NTS" in the selected method, the key is to not restart the database.2. Locate the installation directory: App/product/10.2.0/dbhome_1/network/admin Open Sqlnet.oraFind Sqlnet in there. Authentication_services= (NTS)Change it to: sqlnet. Authentication_services= (Beq,none)or comment out: #SQL
name, the administrator behind the slash is the user who is currently logged on to the operating system. 3. If you are copying an Oracle installation file to your computer for installation, be aware that the directory where the Oracle installation files reside cannot be a Chinese path. 4. The target directory for Oracle inst
1) Install Oracle 11g 64-bit2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0)Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has downloaded), Unzip it to product under the Oracle installation directory (this machine is named: instantclient_11_2): D:\Oracle\app\YM\product\instantclient_11_2.Copy a directory under the root directory of the database
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 server settings, different values
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 server settings, different
Installing JAVA-JDKThis part of the tutorial is a lot, you can follow the online tutorial to installInstalling SqldeveloperDownload Sqldeveloper Linux RPM http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.htmlSince Oracle does not provide the. deb installation package, you need to download
development. (2) ORACLESERVICEORCL: Represents the primary service of a database, naming rule: Oracleservice database name. This service must be turned on or Oracle will not be available at all. attached: Installation notes for A, 32-bit Oracle 11g Client (win32_11gr2_client.zip): When choosing an installation type, select Administrator, as shown in the following figure: The other
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
