Oracle

Do an Oracle Data Guard experiment. 2 nodes, one node configuration monitoring is no problem. In another node. The execution of any command related to the interception is hang live.  such as: Lsnrctl Stop/start/status, there is the time to run

Work found his computer "Telnet 127.0.0.1 1521" (Note: Do not spell telnet 127.0.0.1:1521) can be passed, but use localhost, host name to Telnet, then failed. Workaround: View port Status: CMD-> netstat-a-N The results shown are: 1521 port

Package jp.co.kindlingsoft; Import java.sql.CallableStatement; Import java.sql.Connection; Import Java.sql.DriverManager; Import Java.sql.ResultSet; Import java.sql.SQLException; public class TestDB {public static void main (string[] args) throws

The principle of 5.5.1 based on web management 1. Client The client operating system is Windows 2000, Windows 98, or Windows NT, installing IE over 5.0 browsers, installing the Java plug-in Oracle Jinitiator 1.1.8.10 and the applet technology-based

Installation of Oracle Database1. Login to Oracle website-Trial and download2. Consent Agreement--->file13. Complete the configuration4. Test Connection: Open Oracle Developer---> New connection, note user name sys, password is set in step three,

In the development process encountered a problem, that is, the primary key ID in the Oracle database data type is VARCHAR2, in the background model is a string type,Add sequence annotations to this field at this time, error: Unkonwn integral data

1. Create a jdbc.properties file　　driver=oracle.jdbc.driver.oracledriverurl=jdbc:oracle:thin:@127.0.0.1:1521:orclusername=systempassword=1234562. Create a connection tool

Questions:1. Does the logical backup contain a table structureThe answer contains the table structure2.Rman is a logical or physical backup, or is it a backup?The answer is physically prepared and belongs to the hot backup3. What is the way to hot

About OracleOracle Database, also known as Oracle RDBMS, or Oracle. is a relational database management system of Oracle Corporation. It is a leading product in the field of database. It can be said that Oracle database system is currently the world'

Recently in the Data Warehouse, because some of the almost fixed value of the table, need to write some data directly, read some information. It is found that many are from dual.What is dual?Dual is a pseudo-table in Oracle that can be used to set

I. Oracle database installation PROCEDURE reference: https://jingyan.baidu.com/article/363872eccfb9266e4aa16f5d.htmlIi. Oracle Client Installation: https://www.jb51.net/article/101306.htmThird, plsql install or use the free installation version.Iv.

Oracle's architecture is roughly divided into 3 parts,Client: User-sideOracle instance: is called an instance, consisting of a memory structure (a memory pool or an SGA) and a background process. Oracle instance is one of the core of Oracle RDBMS

1. Create an increment sequenceCREATE SEQUENCE id_add (sequence name)INCREMENT by 1START with 1MINVALUE 1Nomaxvalue;2. Create a trigger to bind to the tableCreate or Replace trigger Id_add_tri (trigger name)Before insert on bi_provincename (table

First, SQL optimization1.* and column names, use column names as much as possible-reason: If you use *,oracle first to resolve what column names are represented in the 2.where parsing order is right-to-left-the and condition tries to put the dummy

1. About number type.Here's a short excerpt from its documentation:P is the precision, or the total number of significant decimal digits, where the most significant digit is the left-most n Onzero Digit, and the least significant digit is the

If you want to see the presence of a user in an Oracle system Dba_users viewIf you use Sqlplus queries you need to format them in advanceSql> col username for A20Sql> Col Account_status for A20Sql> Col default_tablespace fora20Sql> Set Linesize

Directory Daily maintenance and management of Oracle table space 1. Create a data table space 2. Create a temporary table space 3. Create UNDO table Space 4, table space expansion and modification size 5.

supported data types:Character typeChar fixed length Max 2000VARCHAR2 () variable length max 4000Clob character large Object Max 4GDigital typeNumber Range-10 of 38 Square to 10 + 38 times;Number (5,2) a decimal, valid bit 5, 2 digits after the

1) String function---length () functionUsed to return string lengthsSelect T.name,length (t.name) from Tb_person t2) left complement string---lpad () functionThe Lpad () function is used to complement a full string to the left, primarily for the

Conn Sys as SYSDBA;Create role TestRole;Grant create session, CREATE TABLE, unlimited tablespace to TestRole;Create user test identified by test;Grant TestRole to test;Conn Test/test;Roles that are commonly used in Oracle:Connect ResourceConn Sys as