Database Administrator

System Environment: Operating System: RedHat EL6 Oracle: Oracle 10g and Oracle 11g Manual database creation is relatively easy to implement. In this case, we will make a simple comparison from 10g and 11g. We can see a simple difference between 11g

After Oracle accidentally deleted the data file, the following error occurs during connection and login: ERROR:ORA-01033: ORACLE initialization or shutdown in progress Solution: First, Log On As a dba user. SQL> conn sys/orcl as sysdba; If you

MOSOracle E-Business Suite Release 11.5.10 introduced support for the Oracle Net security feature, tcp. validnode_checking, which is used to prevent unauthorized Oracle Net access (for example via SQL * Plus) to the Applications database. if a node

Start: net start mySql;Enter: mysql-u root-p/mysql-h localhost-u root-p databaseName;List databases: show databases;Select Database: use databaseName;List tables: show tables;Show columns from tableName;Create a database: source

I installed MySQL in Ubuntu 14.04 today. I used to download the installation package from the official website, but it was not available after installation. I guess it is necessary to configure it. I found a lot of information on the Internet, the

Main features of MeayunDB Cloud Platform Architecture The cloud platform consists of N> = 1 MeayunDB sub-cluster. The applications on each sub-cluster are identical. The only difference is that the data stored in each MeayunDB sub-cluster is

We recommend that you deploy this tool under root or non-Oracle users. 1. Software preparation, go to the https://support.oracle.com according to the corresponding version of oracle download 2. Install and uninstall osw Copy the downloaded osw.tar

1. OverviewThere are two ways to import a MySQL database:1) Export the database SQL script first and then import it;2) directly copy database directories and files. In different operating systems or MySQL versions, the method of directly copying

Oracle Database startup involves three steps: Nomount: Find the initialization file pfile or spfile, create the SGA and start the background process, but do not allow access to the database. Mount: locate the Control File based on the initialization

The previous article discussed the new features of adding columns to a large table in 11g, Before 11g is mentioned, you can add rows and columns (with default values) by means of online redefinition of tables ). Online permission redefinition

RMAN backup can only be performed in Oracle archive mode.Check whether the database is in archive ModeArchive log list Change the database archive ModeShutdown immediateStartup mountAlter database archivelog;Alter database open; View the RMAN backup

Oracle PLS-00231 error analysis, this error is generally caused by the function access permissions, declared as a common function in the header is fully pass, if declared in the package body will die from the function will cause errors. Create or

There is a name field in nearly 10 million data tables that stores Chinese names. Currently, You need to perform fuzzy search for data based on the name field. The general practice is to create a B * tree index for the name field, the query uses

In the morning, the boss said that the temporary tablespace is empty. Let me see it. I see the ORA-25153, it must be because the logical name of the temporary tablespace is still there, but the temporary file cannot be found. Solution: 1. query the

Java database connection steps 1. Open the connection 2. Create a statement set: a normal statement set and a predefined statement set Statement stat = conn. createStatement (); PreparedStatement priceUpdateStmt = Conn. prepareStatement ("SQL

The tablespace data file capacity is related to the DB_BLOCK_SIZE setting. this parameter is specified when you create a database instance. The DB_BLOCK_SIZE parameter can be set to 4 K, 8 K, 16 K, 32 K, 64 K, etc, A maximum of 4194304 data blocks

Recently, developers are creating data for the company. The DBMS_RANDOM function is used for random data ranges. This function can not only create random numbers, but also randomly create dates and characters. DBMS_RANDOM is in the position of

I. MySQL logical backup 1. Use the mysqldump command to generate an INSERT statement backup This method is similar to the expdp \ exp tool of Oracle. Syntax: Mysqldump [arguments]> file_name. SQL   Help: [Root @ gc ~] # Mysqldump Usage: mysqldump

I. Features of enabling flashback database:1. Make sure that the database is in archive mode. If it is not in archive mode, convert the database to archive mode.SQL> archive log list;Database Log mode archiving ModeEnable automatic archivingArchive

Check whether sqlnet. ora is available. [Oracle @ localhost ~] $ Cd $ ORACLE_HOME[Oracle @ localhost dbhome_1] $ cd network[Oracle @ localhost network] $ cd admin[Oracle @ localhost admin] $ lsListener. ora samples shrept. lst[Oracle @ localhost