Database Administrator

Write down some important knowledge about Oracle databases for future reference! I. file systems and functionsExecution file: the Core of the Oracle system. data files can only be identified by Oracle processing programs. it is meaningless to leave

I. Installation of LINUX1. RedHat AS4 system installation:Disk Partition Note: SWAP space is twice the memory size.The basic network configuration is based on local network conditions.Host Name: linuxsvrBasic Firewall Configuration:⊙ No firewall⊙

Create Database User S_NQ_SCHED/S_NQ_SCHED Connect sqlplus to the user and run the SQL statement $ OracleBI_HOME/server/Schema/SAJOBS. Oracle. SQL and SAACCT. Oracle. SQL The DSN error is prompted. You need to modify odbc. ini. Add a DSN

Yesterday I installed 64-bit Linux and Oracle 10 GB on a new machine, 32-bit Linux and oracle for countless times. I thought this was not a small dish for me. I did not expect to encounter a few very difficult problems. Today I finally got it

MySQL cannot be startedToday, there is another problem with MySQL on the server. If there is no exception, no error is reported. After mysql is started in the service, no error is reported, but the startup is not successful. It is not like a 1067

1. Download the source code package Download To http://dev.mysql.com/downloads/mysql/6.0.html in mysql-6.0.0-alpha.tar.gz 2. Create a user group and user group for mysql Groupadd mysqlUseradd-g mysql 3. Compile and install mysql Cp mysql-6.0.0-alpha.

1. What is ASM? ASM is called Automatic Storage Management (Automatic Storage Management). It is a new feature launched by Oracle 10 Gb. This is a volume manager provided by Oracle to replace the LVM provided by the operating system. It not only

1. receive service requests A customer's dual-node RAC is not synchronized at two nodes. Ii. problem diagnosis 1. Check service status: Command crs_stat-t 2. Check time: the date node is two minutes faster than the second time of the node. 3. Check

On SQL server, it is easier to verify whether the data is Numeric. You can use the following methods: ISNUMERIC When it is a number type, the return value of the method is 1; otherwise, the return value is 0. Example: Select * from tablename

Deleting database tables from Oracle 10 Gb is not actually deleted, but stored in recyclebin. This process is similar to that of deleting files in windows and will be temporarily put into the recycle bin. The system will automatically rename the

In some EBS projects that focus on permissions, common users usually do not have the System Administrator permission. Instead, the DBA can only add one role to one user. It is very troublesome to manually write a PLSQL script, keep the backup. since

A friend asked me this question today. If the record does not exist, a no data error will be prompted. The following is a solution to this problem on the Internet. When you execute SELECT… In PL_ SQL... INTO... If the returned result set is null,

When I shut down the server today, the database could not be shut down due to inexplicable reasons, so I had to use the Forced Command shutdown abort; but casually Oracle database could not open, always reported "ORA-03113: the "end" of the file in

--******************* -- CRS-0215 error handling --*******************   When installing Clusterware, Receive the following error message: The given interface (s), "eth0" is not public. Public interfaces shoshould be used to configure virtual

Oracle 10G R2 can be installed in the following versions of Linux: Oracle Enterprise Linux 5 (OEL5) Oracle Enterprise Linux 4 (OEL4) Red Hat Enterprise Linux 5 (RHEL5) Red Hat Enterprise Linux 4 (RHEL4) Red Hat Enterprise Linux 3 (RHEL3) Novell SUSE

It is much easier to write a long script than to use other views. It is said that it can be used from Oracle 7.x to 11g. Sm $ ts_used & sm $ ts_free Idle> select * from sm $ ts_used; TABLESPACE_NAME

An error is reported when "space = user tablespace: -- View the tablespace size; SQL> SELECT TABLESPACE_NAME, SUM (BYTES)/1024/1024 MB FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME; -- View the path where data files are stored in the tablespace: SQL>

For DBAs, you often encounter database upgrades or apply patches, and sometimes need to run a large number of scripts. For these operations, we want to output files simultaneously on the screen for subsequent steps or errors that have been lost

Chapter 1: configure the experiment environment The experiment environment is implemented using virtual box virtual Machine Software. The steps for installing the operating system are ignored... 1.1 server operating system: 1.2. Oracle software

For rownum, it is the number of the row returned from the query that is sequentially allocated by the Oracle system. The first row is allocated 1, and the second row is 2, this pseudo field can be used to limit the total number of rows returned by