在本文中，我们将为您详细介绍ORACLE的相关知识，并且为您解答关于系统表emp基本与深入学习的疑问，此外，我们还会提供一些关于Fororacledatabases,ifthetopshowingth
在本文中，我们将为您详细介绍ORACLE的相关知识，并且为您解答关于系统表emp 基本与深入学习的疑问，此外，我们还会提供一些关于For oracle databases, if the top showing the oracle database, then oracle process is using the top c、How I Simplified Oracle Database 12c and 11g Installations on Oracle Linux 6、NodeJS-Oracle DB - NJS-040 连接超时，在 ICP 中使用带有 Lopback 的 oracle 驱动程序（loopback-connector-oracle）、Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g的有用信息。
本文目录一览：- ORACLE（系统表emp） 基本与深入学习（oracle数据库emp表）
- For oracle databases, if the top showing the oracle database, then oracle process is using the top c
- How I Simplified Oracle Database 12c and 11g Installations on Oracle Linux 6
- NodeJS-Oracle DB - NJS-040 连接超时，在 ICP 中使用带有 Lopback 的 oracle 驱动程序（loopback-connector-oracle）
- Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g
ORACLE（系统表emp） 基本与深入学习（oracle数据库emp表）
(一)、首先我们先创建emp表（系统有的可以跳过往下看）没有直接复制运行即可。
create table DEPT
(
deptno NUMBER(2) not null,
dname VARCHAR2(14),
loc VARCHAR2(13)
)
;
alter table DEPT
add constraint PK_DEPT primary key (DEPTNO);
create table EMP
(
empno NUMBER(4),
ename VARCHAR2(10),
job VARCHAR2(9),
mgr NUMBER(4),
hiredate DATE,
sal NUMBER(7,2),
comm NUMBER(7,2),
deptno NUMBER(2)
)
;
insert into DEPT (deptno, dname, loc)
values (10, ''ACCOUNTING'', ''NEW YORK'');
insert into DEPT (deptno, dname, loc)
values (20, ''RESEARCH'', ''DALLAS'');
insert into DEPT (deptno, dname, loc)
values (30, ''SALES'', ''CHICAGO'');
insert into DEPT (deptno, dname, loc)
values (40, ''OPERATIONS'', ''BOSTON'');
commit;
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (1, ''dog'', ''code'', 7369, to_date(''05-06-2018'', ''dd-mm-yyyy''), 5000, 5000, 10);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7369, ''SMITH'', ''CLERK'', 7902, to_date(''17-12-1980'', ''dd-mm-yyyy''), 800, null, 20);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7499, ''ALLEN'', ''SALESMAN'', 7698, to_date(''20-02-1981'', ''dd-mm-yyyy''), 1600, 300, 30);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7521, ''WARD'', ''SALESMAN'', 7698, to_date(''22-02-1981'', ''dd-mm-yyyy''), 1250, 500, 30);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7566, ''JONES'', ''MANAGER'', 7839, to_date(''02-04-1981'', ''dd-mm-yyyy''), 2975, null, 20);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7654, ''MARTIN'', ''SALESMAN'', 7698, to_date(''28-09-1981'', ''dd-mm-yyyy''), 1250, 1400, 30);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7698, ''BLAKE'', ''MANAGER'', 7839, to_date(''01-05-1981'', ''dd-mm-yyyy''), 2850, null, 30);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7788, ''SCOTT'', ''ANALYST'', 7566, to_date(''19-04-1987'', ''dd-mm-yyyy''), 3000, null, 20);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7839, ''KING'', ''PRESIDENT'', null, to_date(''17-11-1981'', ''dd-mm-yyyy''), 5000, null, 10);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7844, ''TURNER'', ''SALESMAN'', 7698, to_date(''08-09-1981'', ''dd-mm-yyyy''), 1500, 0, 30);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7876, ''ADAMS'', ''CLERK'', 7788, to_date(''23-05-1987'', ''dd-mm-yyyy''), 1100, null, 20);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7900, ''JAMES'', ''CLERK'', 7698, to_date(''03-12-1981'', ''dd-mm-yyyy''), 950, null, 30);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7902, ''FORD'', ''ANALYST'', 7566, to_date(''03-12-1981'', ''dd-mm-yyyy''), 3000, null, 20);
insert into EMP (empno, ename, job, mgr, hiredate, sal, comm, deptno)
values (7934, ''MILLER'', ''CLERK'', 7782, to_date(''23-01-1982'', ''dd-mm-yyyy''), 1300, null, 10);
commit;
(二)题目学习与实践。（答案小编会在近期更新）
（1） 查询20部门的所有员工信息。
（2） 查询所有工种为CLERK的员工的员工号、员工名和部门号。
（3） 查询奖金（COMM）高于工资（SAL）的员工信息。
（4） 查询奖金高于工资的20%的员工信息。
（5） 查询10号部门中工种为MANAGER和20部门中工种为CLERK的员工的信息。
（6） 查询所有工种不是MANAGER和CLERK，
（7） 查询有奖金的员工的不同工种。
（8） 查询所有员工工资与奖金的和。
（9） 查询没有奖金或奖金低于100的员工信息。
（10） 查询各月倒数第3天(倒数第2天)入职的员工信息。
（11） 查询工龄大于或等于25年的员工信息。
（12） 查询员工信息，要求以首字母大写的方式显示所有员工的姓名。
（13） 查询员工名正好为6个字符的员工的信息。
（14） 查询员工名字中不包含字母“Ｓ”的员工。
（15） 查询员工姓名的第二字母为“M”的员工信息。
(16） 查询所有员工姓名的前三个字符。
（17） 查询所有员工的姓名，如果包含字母“S”，则用“s”替换。
（18）查询员工的姓名和入职日期，并按入职日期从先到后进行排序。
（19） 显示所有员工的姓名、工种、工资和奖金，按工种降序排序，
（20） 显示所有员工的姓名、入职的年份和月份，
--提示：按入职日期所在的月份排序，若月份相同则按入职的年份排序。
（21） 查询在2月份入职的所有员工信息。
（22） 查询所有员工入职以来的工作期限，用“XX年XX月XX日”的形式表示。
（23.1） 查询至少有一个员工的部门信息。
（23.2） 查询至少有两个员工的部门信息。
（24） 查询工资比SMITH员工工资高的所有员工信息。
（25） 查询所有员工的姓名及其直接上级的姓名。
（26） 查询入职日期早于其直接上级领导的所有员工信息。
（27） 查询所有部门及其员工信息，包括那些没有员工的部门。
（28） 查询所有员工及其部门信息，包括那些还不属于任何部门的员工。
（29） 查询所有工种为CLERK的员工的姓名及其部门名称。
（30） 查询最低工资大于2500的各种工作。
-----------------------------------------------------------------
（31） 查询平均工资低于2000的部门及其员工信息。
（32） 查询在SALES部门工作的员工的姓名信息。
（33） 查询工资高于公司平均工资的所有员工信息。
（34） 查询出与SMITH员工从事相同工作的所有员工信息。
（35） 列出工资等于30部门中某个员工的工资的所有员工的姓名和工资。
（36） 查询工资高于30部门工作的所有员工的工资的员工姓名和工资。
（37） 查询每个部门中的员工数量、平均工资和平均工作年限。
（38） 查询从事同一种工作但不属于同一部门的员工信息。
（39） 查询各个部门的详细信息以及部门人数、部门平均工资。
（40） 查询各种工作的最低工资。
（41） 查询各个部门中不同工种的最高工资。
（42） 查询10号部门员工及其领导的信息。
（43） 查询各个部门的人数及平均工资。
（44） 查询工资为某个部门平均工资的员工的信息。
（45） 查询工资高于本部门平均工资的员工的信息。
（46） 查询工资高于本部门平均工资的员工的信息及其部门的平均工资。
（47） 查询工资高于20号部门某个员工工资的员工的信息。
（48）统计各个工种的员工人数与平均工资。
（49） 统计每个部门中各工种的人数与平均工资。
（50） 查询其他部门中工资、奖金与30号部门某员工工资、
（51） 查询部门人数大于5的部门的员工信息。
（52） 查询所有员工工资都大于1000的部门的信息。
（53） 查询所有员工工资都大于1000的部门的信息及其员工信息。
（54） 查询所有员工工资都在900～3000之间的部门的信息。
（55） 查询有工资在900～3000之间的员工所在部门的员工信息。
（56） 查询每个员工的领导所在部门的信息。
（57） 查询人数最多的部门信息。
（58） 查询30号部门中工资排序前3名的员工信息。
（59） 查询所有员工中工资排序在5到10名之间的员工信息。
（60） 查询指定年份之间入职的员工信息。(1980-1985)
欢迎关注小编的公众号，更多学习视频、模板、工具（wind激活工具）！！！
原文出处：https://www.cnblogs.com/1906396809liufg/p/10935422.html
For oracle databases, if the top showing the oracle database, then oracle process is using the top c
Note 805586.1 Troubleshooting Session Administration (Doc ID 805586.1) Note 822527.1 How To Find Where The Memory Is Growing For A Process (Doc ID 822527.1) Note 273646.1 How to diagnose the high cpu utilization of ORACLE.EXE in Windows environment Note 728539.1 Find Blocking Sessions In sqlPLUS Note 61552.1 Troubleshooting Oracle Database Hanging Issues for versions from 7 to 9--Exhaustive Note 164760.1 Detecting and Resolving Locking Conflicts using TopSessions
How I Simplified Oracle Database 12c and 11g Installations on Oracle Linux 6
How I Simplified Oracle Database 12c and 11g Installations on Oracle Linux 6
by Ginny Henningsen; updated by Michele Casey
How to simplify the installation of Oracle Database 12c or 11g on Oracle Linux 6 by installing the oracle-rdbms-server-12cR1-preinstall or oracle-rdbms-server-11gR2-preinstall RPM package, which automatically performs a number of tasks, such as installing required software packages, resolving package dependencies, and modifying kernel parameters.
Published September 2012 (updated September 2017)
READ THIS FIRST: Important Changes Since Publication
While the content in this article is still valid, several details have changed. For example:
- For Oracle Database 12c Release 2, the preinstall RPM has a different name than the one used in the article belowpu:
- oracle-database-server-12cR2-preinstall
- See also this documentation: Automatically Configuring Oracle Linux with Oracle Preinstallation RPM
- The preinstall RPMs are published on Oracle Linux yum server for both Oracle Linux 6 and 7 in the Latest repositories which are configured and enabled by default in recent releases of Oracle Linux 6 and 7
Introducing the oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall RPM for Oracle Linux
Before installing Oracle Database 12c or 11g on a system, you need to preconfigure the operating environment since the database requires certain software packages, package versions, and tweaks to kernel parameters. (Be sure to review the appropriate Oracle Database installation guide to familiarize yourself with hardware, software, and operating system requirements.)
|
Note: This article applies to Oracle Linux 6. A previous article, "How I Simplified Oracle Database Installation on Oracle Linux," covered performing a similar task on versions of Oracle Linux 5.
On Oracle Linux, I discovered that there is a remarkably easy way to address these installation prerequisites: First, depending on your database version, install either the RPM package called oracle-rdbms-server-12cR1-preinstall or oracle-rdbms-server-11gR2-preinstall. This RPM performs a number of preconfiguration steps, including the following:
- Automatically downloading and installing any additional software packages and specific package versions needed for installing Oracle Grid Infrastructure and Oracle Database 12 c Release 1 (12.1) or 11g Release 2 (11.2.0.3), with package dependencies resolved via
yumorup2datecapabilities. - Creating the user
oracleand the groupsoinstall(forOraInventory) anddba(forOSDBA), which are used during database installation. (For security purposes, this user has no password by default and cannot log in remotely. To enable remote login, please set a password using thepasswdtool.) - Modifying kernel parameters in
/etc/sysctl.confto change settings for shared memory, semaphores, the maximum number of file descriptors, and so on. - Setting hard and soft shell resource limits in
/etc/security/limits.conf, such as the locked-in memory address space, the number of open files, the number of processes, and core file size. - Setting
numa=offin the kernel for x86_64 machines.
Note that oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall parses the existing /etc/sysctl.conf and /etc/security/limits.conf files and updates values only as needed for database installation. Any precustomized settings not related to database installation are left as is.
The oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall RPM packages are accessible through the Oracle Unbreakable Linux Network (ULN, which requires a support contract), from the Oracle Linux distribution media, or from the Oracle public yum repository. Thus, whether or not your system is registered with ULN to access Oracle patches and support, you can use oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall to simplify database installation on Oracle Linux. In addition, the Oracle public yum repository now includes all security and bug errata, ensuring systems are secured and stable with the latest security updates and bug fixes.
Installing the oracle-rdbms-server-12cR1-preinstall or oracle-rdbms-server-11gR2-preinstall RPM
The remainder of this article steps through the procedure that I used for installing oracle-rdbms-server-11gR2-preinstall on Oracle Linux via the Oracle public yum repository. The same steps outlined in the following section can be used for either version of the preinstall RPM package. I started with a system running Oracle Linux Release 6 Update 4 for x86_64, a 64-bit version of Oracle Linux that I downloaded from the Oracle software delivery cloud (requires registration or login). First, I set up a yum configuration file that pointed to the correct repository, and then I installed the oracle-rdbms-server-11gR2-preinstall RPM from that repository.
Here are the steps for preconfiguring a system for Oracle Database installation using oracle-rdbms-server-11gR2-preinstall. Remember, the steps are the same when using the oracle-rdbms-server-12cR1-preinstall package; you simply need to change the name of the RPM package during the yum installation step.
- As an authorized user (for example,
root), retrieve the file that configures repository locations:
# cd /etc/yum.repos.d # wget http://yum.oracle.com/public-yum-ol6.repo
- Using a text editor, modify the file, changing the field
enabled=0toenabled=1to reflect repositories that correspond to the machine''s operating system release.
Here is an excerpt of
public-yum-old6.repowith the changed lines in boldface.[ol6_latest] name=Oracle Linux $releasever Latest ($basearch) baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/ gpgkey=http://yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=1 enabled=1 [ol6_UEK_latest] name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch) baseurl=http://yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/ gpgkey=http://yum.oracle.com/RPM-GPG-KEY-oracle-ol6 gpgcheck=1 enabled=1
Because the target system is running Oracle Linux Release 6 Update 4 for x86_64, which installs the Oracle Unbreakable Enterprise Kernel by default, there are two repositories to enable,
[ol6_latest]and[ol6_UEK_latest]. - Next, install the
oracle-rdbms-server-11gR2-preinstallRPM using theyum installcommand. If you are using Oracle Database 12c, then you would typeyum install.
The output in Listing 1 shows how the installation checks dependencies and then downloads and installs the required packages.
# yum install oracle-rdbms-server-11gR2-preinstall Loaded plugins: refresh-packagekit, rhnplugin, security Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-6.el6 will be installed --> Processing Dependency: gcc-c++ for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: gcc for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: libaio-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: libstdc++-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: glibc-devel for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: compat-libstdc++-33 for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: ksh for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Processing Dependency: compat-libcap1 for package: oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 --> Running transaction check ---> Package compat-libcap1.x86_64 0:1.10-1 will be installed ---> Package compat-libstdc++-33.x86_64 0:3.2.3-69.el6 will be installed ---> Package gcc.x86_64 0:4.4.6-4.el6 will be installed --> Processing Dependency: cpp = 4.4.6-4.el6 for package: gcc-4.4.6-4.el6.x86_64 --> Processing Dependency: cloog-ppl >= 0.15 for package: gcc-4.4.6-4.el6.x86_64 ---> Package gcc-c++.x86_64 0:4.4.6-4.el6 will be installed --> Processing Dependency: libmpfr.so.1()(64bit) for package: gcc-c++-4.4.6-4.el6.x86_64 ---> Package glibc-devel.x86_64 0:2.12-1.80.el6_3.4 will be installed --> Processing Dependency: glibc-headers = 2.12-1.80.el6_3.4 for package: glibc-devel-2.12-1.80.el6_3.4.x86_64 --> Processing Dependency: glibc-headers for package: glibc-devel-2.12-1.80.el6_3.4.x86_64 ---> Package ksh.x86_64 0:20100621-16.el6 will be installed ---> Package libaio-devel.x86_64 0:0.3.107-10.el6 will be installed ---> Package libstdc++-devel.x86_64 0:4.4.6-4.el6 will be installed --> Running transaction check ---> Package cloog-ppl.x86_64 0:0.15.7-1.2.el6 will be installed --> Processing Dependency: libppl_c.so.2()(64bit) for package: cloog-ppl-0.15.7-1.2.el6.x86_64 --> Processing Dependency: libppl.so.7()(64bit) for package: cloog-ppl-0.15.7-1.2.el6.x86_64 ---> Package cpp.x86_64 0:4.4.6-4.el6 will be installed ---> Package glibc-headers.x86_64 0:2.12-1.80.el6_3.4 will be installed --> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.12-1.80.el6_3.4.x86_64 --> Processing Dependency: kernel-headers for package: glibc-headers-2.12-1.80.el6_3.4.x86_64 ---> Package mpfr.x86_64 0:2.4.1-6.el6 will be installed --> Running transaction check ---> Package kernel-uek-headers.x86_64 0:2.6.32-300.32.1.el6uek will be installed ---> Package ppl.x86_64 0:0.10.2-11.el6 will be installed --> Finished Dependency Resolution Dependencies Resolved ================================================================================ Package Arch Version Repository Size ================================================================================ Installing: oracle-rdbms-server-11gR2-preinstall x86_64 1.0-6.el6 ol6_latest 15 k Installing for dependencies: cloog-ppl x86_64 0.15.7-1.2.el6 ol6_latest 93 k compat-libcap1 x86_64 1.10-1 ol6_latest 17 k compat-libstdc++-33 x86_64 3.2.3-69.el6 ol6_latest 183 k cpp x86_64 4.4.6-4.el6 ol6_latest 3.7 M gcc x86_64 4.4.6-4.el6 ol6_latest 10 M gcc-c++ x86_64 4.4.6-4.el6 ol6_latest 4.7 M glibc-devel x86_64 2.12-1.80.el6_3.4 ol6_latest 970 k glibc-headers x86_64 2.12-1.80.el6_3.4 ol6_latest 600 k kernel-uek-headers x86_64 2.6.32-300.32.1.el6uek ol6_latest 713 k ksh x86_64 20100621-16.el6 ol6_latest 684 k libaio-devel x86_64 0.3.107-10.el6 ol6_latest 13 k libstdc++-devel x86_64 4.4.6-4.el6 ol6_latest 1.5 M mpfr x86_64 2.4.1-6.el6 ol6_latest 156 k ppl x86_64 0.10.2-11.el6 ol6_latest 1.3 M Transaction Summary ================================================================================ Install 15 Package(s) Total download size: 25 M Installed size: 61 M Is this ok [y/N]: Downloading Packages: -------------------------------------------------------------------------------- Total 710 kB/s | 25 MB 00:35 Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction Installing : mpfr-2.4.1-6.el6.x86_64 1/15 Installing : libstdc++-devel-4.4.6-4.el6.x86_64 2/15 Installing : cpp-4.4.6-4.el6.x86_64 3/15 Installing : ppl-0.10.2-11.el6.x86_64 4/15 Installing : cloog-ppl-0.15.7-1.2.el6.x86_64 5/15 Installing : kernel-uek-headers-2.6.32-300.32.1.el6uek.x86_64 6/15 Installing : glibc-headers-2.12-1.80.el6_3.4.x86_64 7/15 Installing : glibc-devel-2.12-1.80.el6_3.4.x86_64 8/15 Installing : gcc-4.4.6-4.el6.x86_64 9/15 Installing : gcc-c++-4.4.6-4.el6.x86_64 10/15 Installing : compat-libstdc++-33-3.2.3-69.el6.x86_64 11/15 Installing : libaio-devel-0.3.107-10.el6.x86_64 12/15 Installing : ksh-20100621-16.el6.x86_64 13/15 Installing : compat-libcap1-1.10-1.x86_64 14/15 Installing : oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 15/15 Verifying : gcc-4.4.6-4.el6.x86_64 1/15 Verifying : compat-libcap1-1.10-1.x86_64 2/15 Verifying : ksh-20100621-16.el6.x86_64 3/15 Verifying : glibc-devel-2.12-1.80.el6_3.4.x86_64 4/15 Verifying : libaio-devel-0.3.107-10.el6.x86_64 5/15 Verifying : oracle-rdbms-server-11gR2-preinstall-1.0-6.el6.x86_64 6/15 Verifying : gcc-c++-4.4.6-4.el6.x86_64 7/15 Verifying : glibc-headers-2.12-1.80.el6_3.4.x86_64 8/15 Verifying : libstdc++-devel-4.4.6-4.el6.x86_64 9/15 Verifying : compat-libstdc++-33-3.2.3-69.el6.x86_64 10/15 Verifying : mpfr-2.4.1-6.el6.x86_64 11/15 Verifying : kernel-uek-headers-2.6.32-300.32.1.el6uek.x86_64 12/15 Verifying : cpp-4.4.6-4.el6.x86_64 13/15 Verifying : ppl-0.10.2-11.el6.x86_64 14/15 Verifying : cloog-ppl-0.15.7-1.2.el6.x86_64 15/15 Installed: oracle-rdbms-server-11gR2-preinstall.x86_64 0:1.0-6.el6 Dependency Installed: cloog-ppl.x86_64 0:0.15.7-1.2.el6 compat-libcap1.x86_64 0:1.10-1 compat-libstdc++-33.x86_64 0:3.2.3-69.el6 cpp.x86_64 0:4.4.6-4.el6 gcc.x86_64 0:4.4.6-4.el6 gcc-c++.x86_64 0:4.4.6-4.el6 glibc-devel.x86_64 0:2.12-1.80.el6_3.4 glibc-headers.x86_64 0:2.12-1.80.el6_3.4 kernel-uek-headers.x86_64 0:2.6.32-300.32.1.el6uek ksh.x86_64 0:20100621-16.el6 libaio-devel.x86_64 0:0.3.107-10.el6 libstdc++-devel.x86_64 0:4.4.6-4.el6 mpfr.x86_64 0:2.4.1-6.el6 ppl.x86_64 0:0.10.2-11.el6 Complete!Listing 1: Installing the
oracle-rdbms-server-11gR2-preinstallRPMThe yum installation logs messages about kernel changes in the file
/var/log/oracle-rdbms-server-11gR2-preinstall/results/orakernel.log, and it makes backups of current system settings in the directory/var/log/oracle-rdbms-server-11gR2-preinstall/backup. - At this point, the system is ready for the installation of Oracle Database. For example, to install Oracle Database 11g Release 2, follow the directions in Chapter 4, "Installing Oracle Database," of the Database Installation Guide for Linux."
Here are the steps I followed while installing Oracle Database 11g Release 2 in my test environment. Make sure you review all documentation and follow recommended best practices before installing into your production environment.
- As
root, create a parent directory in a file system that has sufficient space to be the target location for the downloaded files:
# mkdir /home/OraDB11g # cd /home/OraDB11g
The amount of disk space needed in the file system varies according to the specific installation type, but roughly twice the size of the zip archives, or 5 GB, is enough to house the software and data files.
- Into this target directory, download the installation media files from the Oracle Database Software Downloads page on Oracle Technology Network.
- Extract the files:
# unzip linux.x64_11gR2_database_1of2.zip # unzip linux.x64_11gR2_database_2of2.zip
- Log in as the user
oracle. Change directory to thedatabasedirectory and enter the following command to run the Oracle Universal Installer:
$ cd /home/OraDB11g/database $ ./runInstaller
The Oracle Universal Installer performs a number of checks, verifying that the necessary OS packages and versions are installed. In addition, it checks kernel parameters set by the
oracle-rdbms-server-11gR2-preinstallinstallation. During the kernel settings check, the installer might flag a few settings as "failed," and you should investigate these failures. In some cases, you still might be able to continue with the database installation. If you check kernel settings in/etc/sysctl.conf, you''ll see thatoracle-rdbms-server-11gR2-preinstallhas modified and added the necessary settings to ensure the minimum requirements are met, as defined in section 2.10.1, "Displaying and Changing Kernel Parameter Values," in Chapter 2, "Oracle Database Preinstallation Requirements," of the Oracle Database Installation Guide 11g Release2 (11.2) for Linux. Below is the list of requirements:fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576
If necessary, you can (as
root) edit the file/etc/sysctl.confto specify a setting manually, for example:# vi /etc/sysctl.conf # /sbin/sysctl -p
The Oracle Universal Installer performs additional checks, such as verifying the
glibcversion, sufficient disk space, environmental variable and path settings, and sufficient physical memory and swap space. Generally, installingoracle-rdbms-server-11gR2-preinstalltakes care of the prerequisites so that you can proceed directly with installing the database. - As
Final Thoughts
Installing the oracle-rdbms-server-12cR1-preinstall and oracle-rdbms-server-11gR2-preinstall RPMs can save time when installing Oracle Database 12c and 11g on Oracle Linux. These RPMs address most Oracle Database installation prerequisites and greatly simplify the installation process.
See Also
Here are the resources referenced earlier in this document:
- Oracle Unbreakable Linux Network: https://linux.oracle.com
- Oracle Linux yum server: http://yum.oracle.com/
- Oracle software delivery cloud (requires registration or login): https://edelivery.oracle.com/linux
- Chapter 4, "Installing Oracle Database," of the Database Installation Guide for Linux: http://docs.oracle.com/cd/E11882_01/install.112/e24321/inst_task.htm#BABBBHJH
- Oracle Database Software Downloads page on Oracle Technology Network: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
And here are some additional resources from the Oracle Database Documentation Library (http://www.oracle.com/pls/db112/homepage). Relevant subsections from the Oracle Database Installation Guide 11g Release 2 (11.2) for Linux (http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/toc.htm) with currently valid URLs are as follows:
- "About the Oracle RDBMS Pre-Install and Oracle Validated RPMs" from Chapter 1, "Overview of Oracle Database Installation": http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/install_overview.htm#BABDBHCJ
- Chapter 2, "Oracle Database Preinstallation Requirements": http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/pre_install.htm#BABFDGHJ
- "Downloading Oracle Software" from Chapter 4, "Installing Oracle Database," which describes how to download installation files from the Oracle Technology Network Website: http://docs.oracle.com/cd/E11882_01/install.112/e16763/inst_task.htm#autoId6
Also see the blog entry "Oracle RDBMS Server 11gR2 Pre-Install RPM for Oracle Linux 6 has been released": https://blogs.oracle.com/linux/entry/oracle_rdbms_server_11gr2_pre
About the Authors
Ginny Henningsen has worked for the last 15 years as a freelance writer developing technical collateral and documentation for high-tech companies. Prior to that, Ginny worked for Sun Microsystems, Inc. as a Systems Engineer in King of Prussia, PA and Milwaukee, WI. Ginny has a BA from Carnegie-Mellon University and a MSCS from Villanova University.
Michele Casey is the Director of Product Management for Oracle Linux. She has worked with commercial Linux distributions and open source projects as a product manager since 2006. She has also held positions as a system administrator, project manager, and technical support engineer.
Revision 1.1, 07/09/2013; added information about using theoracle-rdbms-server-12cR1-preinstall package to installOracle Database 12c |
Follow us:
NodeJS-Oracle DB - NJS-040 连接超时，在 ICP 中使用带有 Lopback 的 oracle 驱动程序（loopback-connector-oracle）
如何解决NodeJS-Oracle DB - NJS-040 连接超时，在 ICP 中使用带有 Lopback 的 oracle 驱动程序（loopback-connector-oracle）？
我正在使用 loopback-connector-oracle 4.1.1 版寻求有关我面临的问题的一些信息。分析如下： 我们有 DB 连接配置，可以使用 json 文件格式的 oracle 连接器使用属性连接到 oracle DB 数据源。 "maxConn": 20,“主机”：DB_HOST， “端口”：DB_PORT， “数据库”：DB_NAME， “密码”：DB_PASSWORD， “用户”：DB_USER， "connector": "oracle",
有两个进程/pod 正在运行，每个进程/pod 都有自己的池供oracle 连接器使用。发生的情况是，在一个实例中，oracle 能够连接并处理请求，但在第二个 pod/进程中，我注意到 njs-040 错误连接超时。由于两者都运行在同一个环境中，所以连接性不会成为问题。我正在寻求您的帮助或意见以了解连接池耗尽的原因？正如我所看到的，DB 上的连接/会话数量配置的数量较少。 当我重新启动 pod/进程时，一切都会恢复正常。在我的流程中遇到的一些问题，如果您可以指导并提供宝贵的意见，我正在寻求您的帮助。
- 如果使用连接池（oracle 连接器），它也应该释放对象，耗尽的机会会减少吗？
- 在进程/pod 启动并通过连接器 (oracle) 获取数据源中的连接对象后，发生网络问题并且进程和数据库之间的连接丢失，连接器是否恢复？根据我的观察，我在其他进程中注意到的似乎应该被恢复，当它与范围一起运行时，在一个进程中可能会导致什么？
我非常感谢您的回复。 提前致谢 桑吉夫
解决方法
暂无找到可以解决该程序问题的有效方法，小编努力寻找整理中！
如果你已经找到好的解决方法，欢迎将解决方案带上本链接一起发送给小编。
小编邮箱:dio#foxmail.com (将#修改为@）
Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g
Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g
系统环境：
操作系统： RedHat EL6
Oracle： Oracle 10g and Oracle 11g
手工建库相对来说很容易实现，本案例是从10g和11g，通过手工建库的方式做一个简单的对比，可以看出11g和10g之间的一个简单的差异！
VMware+Linux+Oracle 10G RAC全程详细图解
案例二：
在Oracle 11g 环境下手工建库
DB_NAME=''test1''
INSTANCE_NAME=''test1''
1、建立Instance的初始化参数文件和口令文件
[oracle@rh6 dbs]$cat inittest1.ora
db_name=''test1''
memory_target=400m //Oracle 11g增加了内存自动管理
processes = 150
audit_file_dest=''$ORACLE_BASE/admin/test1/adump''
audit_trail =''db''
db_block_size=8192
db_domain=''''
open_cursors=300
remote_login_passwordfile=''EXCLUSIVE''
undo_tablespace=''UNDOTBS1''
# You may want to ensure that control files are created on separate physical
# devices
control_files = /u01/app/oracle/oradata/test1/control01.ctl
compatible =''11.2.0''
[oracle@rh6 dbs]$ orapwd file=orapwtest1 password=oracle entries=3
2、建立数据库相关的目录
Oracle 11g增加了diagnostic directory，，默认的为$ORACLE_BASE
[oracle@rh6 dbs]$ mkdir -p $ORACLE_BASE/admin/test1/adump
[oracle@rh6 dbs]$ mkdir -p /u01/app/oracle/oradata/test1
3、建立建库脚本
[oracle@rh6 ~]$ cat cr_db.sql
CREATE DATABASE test1
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE
GROUP 1 (''/u01/app/oracle/oradata/test1/redo01a.log'') SIZE 50M ,
GROUP 2 (''/u01/app/oracle/oradata/test1/redo02a.log'') SIZE 50M
MAXLOGFILES 10
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 200
CHARACTER SET zhs16gbk
DATAFILE ''/u01/app/oracle/oradata/test1/system01.dbf'' SIZE 325M REUSE
SYSAUX DATAFILE ''/u01/app/oracle/oradata/test1/sysaux01.dbf'' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE ''/u01/app/oracle/oradata/test1/temp01.dbf''
SIZE 100M REUSE
UNDO TABLESPACE undotbs1
DATAFILE ''/u01/app/oracle/oradata/test1/undotbs01.dbf''
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
4、启动Instance并建立数据库
[oracle@rh6 ~]$ export ORACLE_SID=test1
[oracle@rh6 ~]$ sqlplus ''/as sysdba''
SQL*Plus: Release 11.2.0.1.0 Production on Wed May 21 10:59:58 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
10:59:59 SYS@ test1>startup nomount;
ORACLE instance started.
Total System Global Area 417546240 bytes
Fixed Size 2213936 bytes
Variable Size 268437456 bytes
Database Buffers 142606336 bytes
Redo Buffers 4288512 bytes
11:00:12 SYS@ test1>@/home/oracle/cr_db
Database created.
Elapsed: 00:01:23.44
11:01:51 SYS@ test1>
建库告警日志：
CREATE TABLESPACE sysaux DATAFILE ''/u01/app/oracle/oradata/test1/sysaux01.dbf'' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE
Wed May 21 11:01:08 2014
Completed: CREATE TABLESPACE sysaux DATAFILE ''/u01/app/oracle/oradata/test1/sysaux01.dbf'' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO ONLINE
processing ?/rdbms/admin/dplsql.bsq
processing ?/rdbms/admin/dtxnspc.bsq
CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE ''/u01/app/oracle/oradata/test1/undotbs01.dbf''
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
Wed May 21 11:01:23 2014
Successfully onlined Undo Tablespace 2.
Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE ''/u01/app/oracle/oradata/test1/undotbs01.dbf''
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE ''/u01/app/oracle/oradata/test1/temp01.dbf''
SIZE 100M REUSE
Completed: CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE ''/u01/app/oracle/oradata/test1/temp01.dbf''
SIZE 100M REUSE
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1
ALTER DATABASE DEFAULT TABLESPACE SYSTEM
Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM
processing ?/rdbms/admin/dfmap.bsq
processing ?/rdbms/admin/denv.bsq
processing ?/rdbms/admin/drac.bsq
processing ?/rdbms/admin/dsec.bsq
processing ?/rdbms/admin/doptim.bsq
processing ?/rdbms/admin/dobj.bsq
processing ?/rdbms/admin/djava.bsq
processing ?/rdbms/admin/dpart.bsq
Wed May 21 11:01:34 2014
processing ?/rdbms/admin/drep.bsq
processing ?/rdbms/admin/daw.bsq
processing ?/rdbms/admin/dsummgt.bsq
processing ?/rdbms/admin/dtools.bsq
processing ?/rdbms/admin/dexttab.bsq
processing ?/rdbms/admin/ddm.bsq
processing ?/rdbms/admin/dlmnr.bsq
processing ?/rdbms/admin/ddst.bsq
Wed May 21 11:01:43 2014
SMON: enabling tx recovery
Starting background process SMCO
Wed May 21 11:01:44 2014
SMCO started with pid=17, OS id=2816
Wed May 21 11:01:50 2014
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Wed May 21 11:01:50 2014
QMNC started with pid=20, OS id=2826
Completed: CREATE DATABASE test1
USER SYS IDENTIFIED BY ****USER SYSTEM IDENTIFIED BY ****LOGFILE
GROUP 1 (''/u01/app/oracle/oradata/test1/redo01a.log'') SIZE 50M ,
GROUP 2 (''/u01/app/oracle/oradata/test1/redo02a.log'') SIZE 50M
MAXLOGFILES 10
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 200
CHARACTER SET zhs16gbk
DATAFILE ''/u01/app/oracle/oradata/test1/system01.dbf'' SIZE 325M REUSE
SYSAUX DATAFILE ''/u01/app/oracle/oradata/test1/sysaux01.dbf'' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE ''/u01/app/oracle/oradata/test1/temp01.dbf''
SIZE 100M REUSE
UNDO TABLESPACE undotbs1
DATAFILE ''/u01/app/oracle/oradata/test1/undotbs01.dbf''
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
更多详情见请继续阅读下一页的精彩内容：
10gRAC-10.2.0.4-dbca建库时配置OEM遇到BUG-p8350262
Oracle 11g R2 手动建库(create database manually)
Oracle 11g + ASM DBCA 建库问题解决心得
Linux下Oracle 10g手工建库全过程
Oracle 9i数据库手工建库过程简记
静默安装Oracle 11gR2软件并且手动建库
关于ORACLE和系统表emp 基本与深入学习的介绍已经告一段落，感谢您的耐心阅读，如果想了解更多关于For oracle databases, if the top showing the oracle database, then oracle process is using the top c、How I Simplified Oracle Database 12c and 11g Installations on Oracle Linux 6、NodeJS-Oracle DB - NJS-040 连接超时，在 ICP 中使用带有 Lopback 的 oracle 驱动程序（loopback-connector-oracle）、Oracle 10g AND Oracle 11g手工建库案例--Oracle 11g的相关信息，请在本站寻找。
本文标签：
![[转帖]Ubuntu 安装 Wine方法（ubuntu如何安装wine）](https://www.gvkun.com/zb_users/cache/thumbs/4c83df0e2303284d68480d1b1378581d-180-120-1.jpg)
