rpm-ivh command.# From Red Hat Enterprise Linux AS5 Disc 1Cd/media/cdrom/ServerRpm-ivh setarch-2 *Rpm-ivh make-3 *Rpm-ivh glibc-2 *Rpm-ivh libaio-0 *# From Red Hat Enterprise Linux AS5 CD 2Cd/media/cdrom/ServerRpm-ivh compat-libstdc ++-33-3 *Rpm-ivh compat-gcc-34-3 *Rpm-ivh compat-gcc-34-c ++-3 *Rpm-ivh gcc-4 *Rpm-ivh libXp-1 *# From Red Hat Enterprise
1. Create a userSu-rootGroupadd OinstallGroupadd dbaUSERADD-G oinstall-g dba-m OracleCentos7ADDUSER-G oinstall-g dba-m Oraclepasswd Oracle2. Configure X11Whether to install the X Window SystemUse Rpm-qa |grep-i x11Installation is not installedConfigure X11Su-rootVi/etc/gdm/custom.conf[Security]Allowremoteroot=true[XDMCP]port=177Enable=trueXhost +Enables Oracle's installation interface to be displayed on the client####### #可以不操作 #########################[Email protected]
"7.1" Directory and Path"7.1.2" directory-related actions
1 Special Directory list:
(1)
2 Directory Operation command, let's talk about a few common processing directory commands bar:
CDS: Transforming Catalogs
PWD: Displaying the current directory
mkdir: Create a new directory
RmDir: Delete an empty directory
"Litchi" pwd Display current directory = = Print working directory
PWD [-p] Displays the current path instead of using the link link path;
(2)
Because/var/mail is a link, conne
Oracle Learning Series 7************************************************************************************constraint on the associated table: forcibly delete the parent table from the associated table: DROP table tab_name cascade constraint; The constraint itself can be modified, but it is not recommended to modify the constraint Knowledge point:1to master the role and definition of the view2, mastering t
Oracle Study Notes --- (4)
Thu
Create a user and authorize the user in the System user:Create user usera identifiedBy usera defalut tablespace test;Grant connect, resourceUsera;
1. Synonyms
Private and public
PRIVATE: created by a common user. Only the user who creates the synonym can use it.Prerequisites: normal users have access rights to Scott's table EMP.Connect Scott/tiger;Grant
execute the file again.
7. When I want to query/usr/bin/passwd This file's traditional permissions, file types and file hidden properties, what command can I use to query?To query Traditional permissions:[Email protected] ~]# ls-l/usr/bin/passwd-rwsr-xr-x. 1 root root 30768 February 2012/usr/bin/passwdQuery file type:[[email protected] ~]# file/usr/bin/passwd/usr/bin/passwd:setuid ELF 64-bit LSB Shared Object, x86-64, version 1 (SYSV) , dynamic
Label:Nothing to do, today under the virtual machine installed a single instance of ORACLE11G, hereby record sharing! Software used: Virtualbox-4.0.8-71778-win.exe Oracle Linux 6.3 (V33411-01.ISO) oracle11g (p10404530_112030_linux-x86-64_ 1of7.zip, P10404530_112030_linux-x86-64_2of7.zip) First, install Linux. Virtual machine configuration: 1g memory, 30g HDD, one
the SQL92 standard for inconsistencies that may occur when reading data:
isolation level
Dirty Read
non-repeatable read
Magic Read
READ UNCOMMITTED (not submitted)
Is
Is
Is
Read Committed (Reading submitted)
Whether
Is
Is
REPEATABLE READ (Repeatable Read)
Whether
Whether
Is
Serializable (Serial Read)
Whether
Whether
7 command-line tools for monitoring Linux systems: "DepthOne of the best things about Linux is that you can drill into the operating system to explore how it works and look for opportunities to fine tune performance or diagnose problems. Here are some basic command-line tools that allow you to explore and manipulate Linux
default value by executing the umask command again, and the new permission will overwrite the old.Cannot have execute permissions based on security considerationsSet limit file default Permissions command format:umask [OPTION] [ARGS]OPTION:-S output a permission mask in symbolic form[Email protected] lab]# umask-sU=rwx,g=rx,o=rxDefault root masking code: 0022Default masking code for normal users: 0002Normal file initialization permissions are: 666The directory file initialization permission is:
Start ;; Esac
3. Change File Permissions# Chmod 755/etc/init. d/Oracle
4. Add a service# Chkconfig -- level 35 oracle on
5. You need to stop the database before shutting down or restarting the machine.# Ln-S/etc/init. d/Oracle/etc/rc0.d/k01oracle // Shutdown# Ln-S/etc/init. d/
Differences between oracle and SQL (common functions) (4) ORACLE functions
BitsCN.com
Ual
41. a day of the week (such as Sunday)
S: unknown
O: SELECT Next_day (sysdate, 7) vaule from dual;
42. string conversion time
S: can be directly converted to or select cast ('2017-09-08 'as datetime) value
O: SELECT To_date ('2017
In order to install Oracle on Windows 7x64, the system tried two days and downloaded several files, prompting various errors, such as unsupported operating system. The final success was recorded.
1. download the latest Oralce 11gR2. Only this version supports Windows 7 x64.
The previous version includes 11 GB. During installation, the system prompts that the operating system is not supported. Although you
Tags: redo declare when ace Eric value OTA processes ACLRevocation ManagementWhat is undo data: 1. Transaction fallback: No transaction submitted can be rollback 2. Transaction recovery: When the database crashes, the incorrect data of the disk is restored to the pre-transaction 3. Read consistency: The queried record has a transaction occupation, to the rollback segment to find the pre-change mirror 4. Flashback data: Constructing historical data fr
will show null! SQL syntax Format: Syntax 1:Select* fromtable 1 LEFT OUTER join Table 2 on table 1. Field 1=table 2. Field 1; Syntax 2:Select* fromtable 1 LEFT OUTER join table 2whereTable 1. field 1= table 2. Field 1 (+); 2, right outer connection: RIGHT outer join effect: All data in the table on the left will be displayed, but the data on the table And the fields on the right match will be queried! Otherwise it will show null! SQL syntax Format: Syntax 1:Select* fromtable 1 Right
The default Java in the Debian source is openjdk, and the current version is 7. If you need to install the official Oracle JDK8, you can install the official JDK by using java-package:1. Installation Java-package# Apt-get Install Java-package2. Download Oracle JDK 8Download the Linux x64 tar.gz package, the current dow
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.