oracle 11g dba tutorial

At oracle11g, the Enterprise Manager of the client cannot be found. Does Oracle provide enterprise manager? Of course not, but Oracle does not provide enterprise managers in the C/S architecture. Oracle provides an Enterprise Manager with B/S architecture. Run emctl start dbconsole on the Linux server to start the Enterprise Manager, and emctl stop dbconsole to

Tags: Oracle 11g database management Data 11g DBA1. Oracle Database Overview1.1. Structure and compositionOracle Database 11G has a total of 4 versions, Enterprise, standard, standard 1, and personal.1.1.1, Enterprise EditionAdvantages:High reliability. Prevent server failur

"Sqlplus" and the Sqlplus prompt in the console does not have such a command because the environment variable path is not joined to the Sqlplus path. Add it this way: right-click on "Run SQL command line" and view the properties as follows Copy the paths in the target, and then open the environment variablesSelect the path of the user variable, click Edit, and then at the end of the copy of the path to paste in, paste before you remember to enter a ";" To facilitate isolation from the fron

Also referenceHttp://www.linuxidc.com/Linux/2012-08/69082.htmHttp://www.linuxidc.com/Linux/2013-10/91270.htmFirst, hardware detection1, memory detection oracle11g minimum 1GB memory requiredgrep Memtotal /proc/meminfo2, swap space detection usually swap space is 1.5 times times the memorygrep Swaptotal/proc/meminfo3. Temp directory/tmp checkDF -h/tmpSecond, the configuration process1. Create users and user groups/usr/sbin/groupadd dba/usr/sbin/usera

configuration. Check whether the IP address and host name are written into the "/etc/hosts" file. Vi/etc/hosts If no, you need to manually add the ing between the IP address and the host name, for example: 10.71.124.53 mmgg 4. create necessary user groups and users. 1. I like to directly change relevant files, as shown below: /// Etc/group Dba :! : 1000: Oracle Success :! : 1001:

1. Error-ORA-12514: TNS: ListenerProgramThe Service requested in the connection descriptor cannot be recognized currently If your server somehow reports this error, It was always normal before , Then try the following method ( Remember to back up the file you want to modify, because the error may be different ): Open "Listener. ora", Copy the following red font to your file Sid_list_listener =(Sid_list =(Sid_desc =(Sid_name = plsextproc)(ORACLE_HOME = D: \

with GUI tools or SQL! Otherwise, you will not be able to log in, prompting the user/password incorrectly. Use uppercase to create the user, but use the case can log in, wonderful! If the Web management interface is inaccessible or the database cannot be connected, you may consider modifying the Listener.ora and D:\OracleXE\app\oracle\product\11.2.0\server\network\ADMIN in the Tnsnames.ora, change the computer name to localhost. "Cannot find file '

Starting to test Oracle 11g rac, the current performance is limited, so a single node rac is installed. The procedure is as follows: Modify ifcfg-bond * ifcfg-eth * in/etc/modprobe. conf and/etc/sysconfig/network-scripts by binding the NIC * I will not talk more here Configure Xmanager connection Vi/usr/share/TPD/defaults. conf Change Enable = false under [xdmcp] to Enable = true. Change AllowRemoteRoot

1. Modify the host name:[Email protected] ~]# sed-i "s/hostname=localhost.localdomain/hostname=oracledb/"/etc/sysconfig/network2. Set the IP address:If the virtual machine is installed, it is recommended to use only host mode. Fixed IP address.3. Modify the Hosts fileVi/etc/hosts 192.168.138.120 OracleDB3. To install the dependent packages, install the following packages:4. Create users and Groups[Email protected] ~]# sysctl-p[Email protected] ~]# groupadd-g Oinstall[[email protected] ~]# GROUPA

Oracle 11g flash back archiving Technology Oracle flash back Data Archiving Oracle flash back data archiving can be used to automatically track and archive data in tables with flash back data archiving enabled. This ensures that the flashback query can obtain the SQL-level access permission for the database object vers

datafile ' E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\Facial.DBF ' size 500M autoextend on next 50M ;--Create UserCreate user facial identified by facial default tablespace ts_facial;--Authorized to UserGrant CONNECT,RESOURCE,DBA to facial;Test.dmp and Test.log are placed in the E:\oracle\product\10.2.0\admin\orcl\dpdump directory.10g import statement: IMPDP userid=

Starting to test Oracle 11g RAC, the current performance is limited, so a single node RAC is installed. The procedure is as follows: Nic binding Modify ifcfg-bond * ifcfg-eth * in/etc/modprobe. conf and/etc/sysconfig/network-scripts * I will not talk more here Configure xmanager connection VI/usr/share/TPD/defaults. conf Change enable = false under [XDMCP] to enable = true. Change allowremoteroot = fa

First, install the software package required by Oracle (depending on the Oracle official documentation)can use# yum-y Install binutils* compat-lib* gcc-* glibc-* ksh libgcc-* libstdc++-* libaio-* make-* sysstat*For installation.Ii. creating user groups and users (Root)# groupadd oinstall# groupadd dba# useradd-g oinstall-g db