Database Administrator

First download several compressed packages from OTN For: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html Then select different downloads based on your platform. I installed them in rhel5, so I chose linux x86 and

How to view the Oracle database lock and unlock -- View database lock details SelectA. sid, B. serial #, B. username, B. oSUSEr, B. machine, B. program, c. object_name, d. spid, Decode (a. type, 'Mr','Media recovery', 'Rt','Redo thread', 'Non'

-View the Oracle archiving ModeSQL> conn evan/evan (dba)Connected.SQL> archive log listORA-01031: insufficient privilegesSQL> conn/as sysdba -- archive log list must be executed by sysdbaConnected.SQL> archive log listDatabase log mode No Archive

In the Oracle PL-SQL, left and right connections can be implemented in the following way: Statement segment: Select modelname, TABLENAME FORM EMCD_MONITOR_MODEL, EMCD_MONITOR_TABLE WHERE EMCD_MONITOR_TABLE.MODELID (+) = EMCD_MONITOR_MODEL.ID

After installing Oracle 11 GB in VMware 7.14, it was found that sqlplus could not be started. I searched the internet. It is estimated that the environment variable is not set. The current oracle is installed in/fantlam/oracle/app/oracle/product/11.2

1. xml file {Call GYL_COMMON.GETGROUPNUM (# {IN_PARAMETERID, jdbcType = VARCHAR, mode = IN },# {IN_STEELID, jdbcType = VARCHAR, mode = IN}, null,# {OUT_GN, jdbcType = INTEGER, mode = OUT },# {RST, jdbcType = CURSOR, mode = OUT, resultMap =

When declaring the VARCHAR2 variable, we can specify its maximum length unit as CHAR: v1 VARCHAR2 (2 CHAR); or BYTE: v2 VARCHAR2 (2 BYTE );, Most of the default values are not specified: v3 VARCHAR2 (2 );. So what are the differences between the

1. Block Cleanout description Previous test references: Effece ITL (Interested Transaction List) Description OracleBlock scn/commit scn/cleanout scn description Block clean out refers to changing the data in a block from dirty to clean. It is

Expdp and impdp are used only in Oracle10g. the following source database is Oracle10.2 and the target database is Oracle11.2.1. Create an expdp export directory on source database server.$ Pwd/Home/oraoms$ Mkdir exp_dir SQL> create or replace

Install MySQL 5.5.15 in CentOS 6.0 #! /Bin/bash# Mysql dependencyYum-y install gcc make gcc-c ++ ncurses-devel openssl-devel Wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.15.tar.gz/from/http://mysql.he.net/Wget

When we operate databases, database tables may be locked due to improper operations, so we are often at a loss and do not know how to unlock these tables, the "sessions" in the menu "tools" of pl/SQL Developer can query existing sessions, but it is

Sequence: A sequence is a SEQUENCE number generator. It can automatically generate a SEQUENCE number for rows in a table and generate a set of equal-interval values (numbers ). Its main purpose is to generate the table's primary key value, which can

Chinese garbled characters in MySQL databases have been a problem for a long time, whether it is java Development or php development. For the sake of simplicity, I have always set the encoding to UTF-8 on all my JSP pages. At the same time, when I

During this time, a configuration library needs to be imported to different people. After each person is imported to the database, all the tables in the Database need to be cleared. If you want to import tables one by one, it is very troublesome,

I. When do I need instance recovery? In shutdown normal or shutdown immediate, the so-called clean shutdown will automatically trigger the checkpoint and write the SCN record back. When a checkpoint occurs, the SCN is written to four places: Three

1. query all users -- select * from dba_users 2. query all roles -- select * from dba_roles 3. query user _ role -- select * from dba_role_privs 4. query user _ system permissions -- select * from dba_sys_privs 5. query user _ object permissions --

Use shell to call sqlplus to access Oracle for direct execution. However, when you use crontab for calling, sqlplus is not considered as a valid command because the environment variable does not take effect. Note: Oracle users used for

/* Create a stored procedure Create Or Replace ProcedureProc_nameAs Begin Do something; EndProc_name; */ Create Or Replace ProcedureUpdateAAs Begin UpdateASetEname ='Dog'; Commit; EndUpdateA; -- Test Begin UpdateA; End;

1. Compile MySQL5.0#. /Configure -- prefix =/usr/local/mysql -- localstatedir =/usr/local/mysql/data -- enable-thread-safe-client -- enable-local-infile -- enable-validator -- enable-community-features -- enable-profiling -- with-client-ldflags

1. Parameter files and server parameter filesA Parameter File is usually called an init file or an init. ora File. The default name is the init . ora text file.SPFILE generation PFILE: create pfile = '/tmp/initorcl. ora' from spfile;Server Parameter