oracle linux 7 4

. Modify the configuration again, which is available in the install directory.15. Run, pietty file, root telnet16. On Linux, configure the Modify environmentmodifying control filesVim/etc/sysctl.conf1 Kernel.shmmax = 536870912 2 Kernel.shmmni = 8192 3 Kernel.sem =250 32000 4 Fs.file-max = 6815744 5 net.ipv4.ip_l Ocal_port_range = 65000 6 net.core.rmem_default = 4194304

1. User identifier UID and GID/etc/passwd articlePiece structure: There are several lines that represent a few accounts in your system with each line: Split, altogether 7 fields. 1. Account name 2. Password: Get up early Unix, now put the password data in the/etc/shadow file, where x means that 3.uid:0 represents the system administrator. 1-499: System account 500-65535: General users with 4.GID:/etc

Error "ORA-28002 the password would expire within 7 days. Cannot logon to the database "This error may be encountered when running the AE program on the process scheduler, and many times this error is not only present in the process scheduler, but may also be used when accessing the database using Plsql developer or Sqlplus.This error is due to the Connectid account or Sysadm account in the Dba_users table has expired, before the 11g version of the pr

and down stitching, not the column splicing! 2, using three consistent conditions: (quantity consistent, type consistent, order consistent). 3, the column name of the final displayed column is subject to the first select! Examples of use:SelectEname,sal asSalary fromScott.empwhererownum2UnionSelectEname asName, Sal fromscott.emp; Search Result: ename salary ADAMS1100.00ALLEN1600.00BLAKE2850.00CLARK2450.00FORD3000.00JAMES950.00 7, query the data for

On the Linux platform, there are several steps to manually create a database: 1. Confirm the unique instance and database name; 2. Select the character set of the database; 3. Set the OS environment variables; 4. Create the initialization parameter file; 5. Start the instance to the nomount state; 6. Execute the create database Command. 7. run at least two script

Oracle SQL classical query expert Article 4 Oracle SQL classical query expert Article 4 This article is the fourth article on typical query of OracleSQL. It is just the author's own opinion. If you have any questions, I hope you can provide suggestions or methods. At the same time, you are welcome to add that, if you h

Ora-01110:data file 6: '/TEST/LUNAR_TEST01.DBF ' ora-27041:unable to open file linux-x86_64 error:2: No such file or directory Additional Information:3 Check the SPID of the DBWR process sql>!ps-ef|grep dBW Oracle 2757 1 0 12:29? 00:00:14 ora_dbw0_bb Oracle 8912 8872 0 23:50 pts/3 00:00:00/bin/bash-c ps-ef|grep dbw

Oracle trigger 4-database event trigger Oracle trigger 3-DDL trigger http://www.bkjia.com/database/201304/201421.html Create database event TRIGGER Syntax 1 CREATE [or replace] TRIGGER trigger_name2 {BEFORE | AFTER} {database_event} ON {DATABASE | SCHEMA} 3 DECLARE4 Variable declarations5 BEGIN6... some code... 7. The

Oracle BASICS (4) pl/SQL PL/SQL is also a program Language called Procedural Language/SQL ). PL/SQL is an extension of SQL statements in Oracle databases. The features of the programming language are added to the use of common SQL statements. Therefore, PL/SQL organizes data operations and query statements into procedural units of PL/SQL code, implement complex f

, 2) LENGTH ('World') REPLACE ('SQL', 'Q', 'x ') -------------------------------------------------------- He 5 sXl In the above example, we can see that the function of substr () is to intercept a string, followed by two parameters. The first parameter represents Start position. The second parameter indicates the number of interceptions. The length () function returns the length of the string. Replace () string followed by two Parameters. The first parameter indicates the letter to be replaced

Exercise 1: Create a user Oracle, an additional group that belongs to the database and Sql,id number 3000, and a home directory of/home/databaseGroupadd DatabaseGroupadd SQL (Create a new two user group first, Q: Groupadd can I create multiple groups at once?) ) useradd oracle-u 3000-d/home/database-g database,sqlID Oracle (view user

Linux Oracle service starts and stops scripts and starts automatically. After installing Oracle 10g R2 in CentOS 6.3 and restarting it, you will find that Oracle is not started on your own. This is normal because Oracle Installation in L