Oracle

ORACLE encountered a TNS-04415 error with netca configuration listeningError descriptionD: \ Users \ Elvis> netcaOracle Net Services Configuration:Configuring LISTENER: LISTENERServiceAliasException: unable to save service alias: TNS-04415: file I/O

Query statement related to oracle tablespace -- merge tablespace size alter tablespace users coalesce -- query data file select file_name, file_id from dba_data_files -- query database object space size select owner, segment_name, sum (bytes) from

Basic Steps for connecting to a remote Oracle database on Mac 1. Open the terminal and enter ssh to see [plain] chenmatoMacBook-Pro :~ Nono $ ssh usage: ssh [-1246 AaCfgKkMNnqsTtVvXxYy] [-B bind_address] [-c cipher_spec] [-D [bind_address:] port]

What is the Oracle Diagnostic Methodology (ODM )? [ID 312789.1] odm test: query statement: select to_number (addr, 'xxxxxxxxxxxxxxxxxx') from v $ latch_parent where name = 'process allocation '; select name from v $ latch_parent where name like '%

The oracle expdp command uses detailed parameters and export example: 1. DIRECTORY specifies the DIRECTORY where the dump and log files are located DIRECTORY = directory_object Directory_object is used to specify the DIRECTORY object name. note that

Oracle stored procedure: cursor and dynamic SQL 1. create package + CURSOR SQL code CREATE OR REPLACE PACKAGE RefCursor IS type t_RefCursor IS ref CURSOR; END RefCursor; 2. create a stored procedure and define the in and out parameters. SQL code

When you use emctl to start the Oracle console, the following ERROR occurs: NMO not setuid-root (Unix-only), multiple databases run on one server, and EM cannot be used properly. re-create EM through emca. the command is as follows: emca-config all

Remember how to use the oracle sqlplus logon command. 1, { [/] [@ ] |/} [AS {SYSDBA | SYSOPER | SYSASM}] [EDITION = value] specifies the database account user name, the connection identifier of the password and the database connection. If there is

Oracle archive Mode 1. Check whether archive log list is archived; 2. Enable archive mode shutdown immediate; startup mount; alter database archivelog; alter database open; archive log list; ----- confirm whether archive is enabled 3. The number of

Comparison between LOGMNR mining logs and DUMP logs many people know that LOGMNR is used to analyze logs, but few people use DUMP to analyze logs. This is because the information analyzed by LOGMNR is easy to read and understand. but sometimes we

Run DBCA. NETCA reports Xlib: connection to ": 0.0" refused by server error troubleshooting fault symptom: Fault Analysis: From the fault symptom, it is caused by xhost problem, this error usually occurs when you remotely execute the pop-up window.

Sqlldr Load file, ORA-01722: invalid number solve dos2unix file: convert file into unix mode (internal for text) Case: csv file sqlldr. control File load datainto table totofields terminated by ',' (BALL_No, MAIN_BALL_FREQUENCY,

During oracle installation, the system prompts that the program Input Point getprocessimagefilenamea could not be located and solved the problem two days ago on the Dynamic Link Library PSAPI. DLL. The final success: one person has completed the

Common Oracle exception types: exception description CURSOR_ALREADY_OPEN tries to "OPEN" an opened cursor DUP_VAL_ON_INDEX tries to insert a duplicate value INVALID_CURSOR to "UNIQUE" and tries to operate on the closed cursor INVALID_NUMBER in the

Count the number of tables in the system and query the field information of all tables -- count the number of tables in the system: -- table description field: -- required field: Name, Code, Commente select lower (. TABLE_NAME) | '-' | B. comments,

The Oracle audit technique is used to track the DML action of the oracle background database create or replace package when is procedure pro_monitor_drop_policy (object_schema in varchar2); procedure when (object_schema in varchar2); procedure when;

Greenplum db configuration 1. adjust the kernel Parameter kernel. sysrq = 1fs. file-max = 101365kernel. shmmax = 5001000000kernel. shmall = 4000000000kernel. msgmni = 2048kernel. sem = 250 512000 100 2048kernel. shmmni = 4096net. core.

Reasons for slow query speed in Database Analysis: 1. No index or no index is used (this is the most common problem of slow query and is a defect in programming) 2. Low I/O throughput, resulting in a bottleneck effect. 3. the query is not optimized

Common principles of oracle tablespace design principles: 1. Generally, a large table or index is allocated with a single tablespace. 2. The Read only object or Read mostly object is grouped into a group and exists in the corresponding tablespace. 3.

Sysbench test oracle Installation Method 32-bit export CC = ccexport CFLAGS = "-I/u01/app/oracle/product/11.2.0/db_1/rdbms/public" export CXXFLAGS = "$ CFLAGS" export ORACLE_HOME =/u01/app/oracle/product/11.2.0/db_1export LD_LIBRARY_PATH = $