Database Administrator

(1) listener. ora In this experiment, static listening is configured to listener L1, and the project SID_LIST_L1 is the static listening configuration of L1: L1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = PC1255-2011

Several important MySQL DirectoriesDatabase directory/var/lib/mysql/ Configuration File/usr/share/mysql (mysql. server command and configuration file) Related commands/usr/bin (mysqladmin mysqldump and other commands) Start script/etc/rc. d/init. d/(

I. version count description This issue is described in the MOS documentation. For details, refer to [ID296377.1]. All SQL statements in Oracle are implicitly sharable. When a user submits an SQL statement, RDBMS performs a hash operation on the SQL

1. The steps for compiling an Oracle stored procedure are as follows: Create or replace procedure P_AUTO_CREATE_PARTITION (Result Out int, LogErrDesc Out varchar2 ) Is Type TypeTable is table of varchar2 (20 ); CreatePartitionErr exception;

[Oracle @ oracle_taowei_RedHat ~] $ Lsnrctl status check whether the listener is startedIf the listener is not started, run the command lsnrctl start to start the listener (lsnrctl stop to stop the listener)After the listener can be started with

Database Version:Oracle Database 10g Enterprise Edition Release 10.1.0.3.0Create a test table:SQL> create table a as select * from all_objects;Table created.SQL> set autotrace on statistics;Insert data (hint append ):SQL> insert/* + append */into a

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

1Error prompt SlaveI/O:ErrorConnecting to master 'backup @ 192.168.1.x: 100'-retry-time: 60 retries: 3306, Error_code: 86400 Solution (f ā ng f ǎ) Delete all binary log files from the server, including one data

Now the new version of WebLogic is a product in Oracle, so we will see the red Oracle logo. The installation process is as follows: 1. Download the free installation package wls1033_oepe111150_linux32.bin. 2. log on to the system as a non-root

1. su-Oracle-switch Oracle users (If su oracle is used, the. profile user environment configuration file is not run at startup) $ Lsnrctl start-start the listener 2. Start the database $ Sqlplus "/as sysdba"-use the sys user to log on to sqlplus SQL

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

Create user myuser identified by mypassword default tablespace users;/**Enter the User name: myuserEnter the password:ERROR:ORA-01045: user MYUSER lacks create session privilege; logon deniedAfter creating a user, the user cannot log on immediately*/

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

My Linux version is CentOS 5.5 and the kernel version is 2.6.18-194. el5. in Linux, it is best to install the Oracle System with 1 GB memory and 2 GB swap space. The hard disk requires at least 4 GB space. 1. Download oracle Go to the oracle

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

I. [preparations]1. SQL> alter database add supplemental log data; -- add log support (User session_info can be obtained to facilitate searching and operating users );2. SQL> @ $ Oracle_HOME/rdbms/admin/dbmslm. SQL; -- install the log analysis

Redo is the information recorded in Oracle online (or archived) redo log files and used to redo transactions. undo is the information recorded in oracle's undo segment, used to cancel or roll back a transaction. The undo operations on the database

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. Switch the server archive mode. skip this step if the archive mode is already used:% Sqlplus/nolog (start sqlplus)SQL> conn/as sysdba (connect to the database as DBA)SQL> shutdown immediate; (close the database immediately)SQL> startup mount