Database Administrator

Oracle 10 Gb is used in work. It is often necessary to insert the Event Date and time to a table in it. Note the date and time display and insertion modes of Oracle.Like the built-in data types such as Number and varchar2, Oracle uses the built-in

1. ORA-01102: cannot mount database in EXCLUSIVE mode Symptom: SQL> startupOracle instance started.Total System Global Area 1224736768 bytesFixed Size 2020384 bytesVariable Size 318770144 bytesDatabase Buffers 889192448 bytesRedo Buffers 14753792

The configuration file of the newly added tablespace mainly uses this parameter.Test EnvironmentInnodb_data_file_path = ibdata1: 370 M; ibdata2: 50 M; ibdata3: 50 M; ibdata4: 500 M; ibdata5: 500 M: autoextend There are several situations1. During

The steps in this article have been verified in both virtual machines and servers. At the end of the article, I listed the solutions to the vast majority of problems encountered during the installation process. System and Oracle installation file

For example, to back up an existing mysql database named linux, run the mysqldump command.The command format is as follows:[Root @ bkjia root] # mysqldump-u root-p linux>/root/linux. SQLEnter password: Enter the Database password here Through the

After the LAMP environment is set up in Linux, I want to link some of my websites to Linux. To ensure security, I need to set the root password in mysql (the default root password is blank) previously, the mysqladmin-u root-p password bixinnan

The Oracle11g database is installed. Deleting the table after the table is created will generate a table name similar to "BIN $ 1Oiy3qm/QJubov1BwBUOgw = $0, (select * from tab to view) For example, the drop table books command will put the table

Requirement: I want to enable the database under my current user and use MyEclipse to directly connect to the installed database. I have not created any new groups or users, instead, Oracle is installed under the current user of Ubuntu 10.04. 1.

1. Ensure that the system users you log on to have sufficient permissions. Windows: add your users to the Oracle DBA Group. Use root to log on to UNIX. 2. Run sqlplus/nolog in command 3. Enter the conn/as sysdba after the SQL> command If the

Oracle online logs are generally divided into multiple groups. Starting from 8i, The dbwr process of Oracle is performed in the background. The database checkpoint is performed every 3 seconds. The function is to switch online logs to another

For relational databases, It is very common to directly write SQL statements to pull data in the list. But this brings about a problem: when the data volume reaches a certain level, the system memory will consume sooner or later. In addition,

Problem:Org. postgresql. util. PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.Solution: Edit/var/lib/pgsql/data/postgresql. conf fileChange# Listen_addresses = '

Method 1 for Oracle to implement the fibonacci series: Select replace (MAX (SYS_CONNECT_BY_PATH (fib | ',', '/'), '/', '') | '...' fiblistFROM (SELECT n, fib, ROW_NUMBER ()OVER (order by n) rFROM (select n, round (1 + sqrt (5) * 0.5, n)-power

Oracle user management and permission settings Create a user:Create user user_nameIdentified by password[Default tablespace tablespace_name][Temporary tablespace tablespace_name][QUOTA... ON tablespace_name] -- sets the disk space QUOTA.[Password

When collecting the statistical information and histograms of a column, we usually collect the statistics of a column. When a predicate uses multiple related columns, the constraints are redundant. These related columns are also called associated

1. install and configure the database (master \ slave)System Information:192.168.1.20 gserver20 (master)192.168.1.21 gserver21 (slave)1. Create a directoryMkdir/opt/pgsql-9.3.1Mkdir/opt/pgdata/mainMkdir/opt/pgdata/archive 2. Create an ipvs

Problem description: I have installed the Oracle 11g R2 Database Service on my PC. I cannot connect to the database through PL/SQL. The following describes the installation environment. PC operating system: Window7 (64bit) Oracle Server version:

When the amount of data to be backed up or restored by RMAN is large, RMAN may have no feedback for a long time, which may lead to the mistaken failure of RMAN.Use the following SQL statement to view the running Progress of RMAN:Select sid, SERIAL #,

Most of the time, we need to initialize database settings, such as creating indexes, especially when configuring multiple MongoDB servers, or when initializing and archiving. Run the following command to execute a js file: ./Mongo IP/DBName init.

When you use a client or other methods to connect to data and type Chinese data, garbled characters are displayed in the client. Of course, this is a problem with character set settings. I tried many methods, but still cannot display Chinese in the