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

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

If the following error occurs during RMAN backup. Historical archived logs cannot be deleted. RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process RMAN-08515: archived log file name = +

Configure a retention (retention) PolicyThe backup set that does not comply with the policy is marked as expired. You can view and delete it.Three configurationsRman> the following three methods can be added after configure retention policy:1.

Slave database:SQL> alter database open read only;Alter database open read only*ERROR at line 1:ORA-10458: standby database requires recoveryORA-01152: file 1 was not restored from a sufficiently old backupORA-01110: data file 1:

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

Two methods to import nginx logs to hive 1. Create a table in hive Create table apachelog (ipaddress STRING, identd STRING, user STRING, finishtime STRING, requestlineString, Returncode INT, size INT, refererString, AgentString) ROW FORMAT

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 --

/* 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;

Add in tnsnames. ora: (the host ip addresses are all vip addresses) RAC = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.221) (PORT = 1521 )) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.222) (PORT = 1521 )) (LOAD_BALANCE =

Connection Type: 1. jdbc oci: oci is the abbreviation of Oracle call interface, which is similar to the traditional ODBC driver. Because it requires Oracle Call Interface and Net8, it needs to install the client software on the machine that runs the

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