欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入 1.创建大小为4G的ORACLE安装文件系统orainst,是JFS2文件系统,在ROOTVG里,MOUNT点在/orainst; 创建大小为5G的ORACLE软件文件系统(JFS2),页在ROOTVG里,MOUNT点在/oracle 2.换页空间要求2G,/tm
欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入
1.创建大小为4G的ORACLE安装文件系统orainst,是JFS2文件系统,在ROOTVG里,MOUNT点在/orainst;
创建大小为5G的ORACLE软件文件系统(JFS2),页在ROOTVG里,MOUNT点在/oracle
2.换页空间要求2G,/tmp空间要求400M.创建DBA组和ORACLE用户,并将ORACLE用户的路径指到/oracle
3.将下载的数据库安装软件FTP到服务器上的orainst下,然后使用gunzip和cpio解包解压:
1.创建大小为4G的ORACLE安装文件系统orainst,是JFS2文件系统,在ROOTVG里,MOUNT点在/orainst;
创建大小为5G的ORACLE软件文件系统(JFS2),页在ROOTVG里,MOUNT点在/oracle
2.换页空间要求2G,/tmp空间要求400M.创建DBA组和ORACLE用户,并将ORACLE用户的路径指到/oracle
3.将下载的数据库安装软件FTP到服务器上的orainst下,然后使用gunzip和cpio解包解压:
$gunzip *.gz
$cpio -idcmv 4.修改/oracle目录下的.profile文件,添加:
#oracle_env
ORACLE_BASE=/oracle;export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.1.0;export ORACLE_HOME
ORACLE_SID=iasdb;export ORACLE_SID.
NLS_LANG=american_america.zhs16gbk;export NLS_LANG
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data;export ORA_NLS33
PATH=$ORACLE_HOME/bin:$PATH;export PATH
5.安装bos.adt.libm包
6.以ORACLE用户登陆
#xhost +
#su - oracle
$export DISPLAY=127.0.0.1:0.0
$cd /orainst/Disk1
$./runInstaller
提示使用ROOT用户执行/orainst/Disk1/rootpre.sh
提示需要jce-1_2_2.zip文件的路径:/oracle
从http://java.sun.com/products/jce/index-122.html当下文件放到服务器的/ORACLE目录下
然后检查系统环境
The following filesets are required:
bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools #没有
X11.motif.lib
用root运行/oracle/oraInventory/orainstRoot.sh
创建IAS的数据库Infrastructure,选择语言英文和简体中文
实例 iasdb 数据库 asdb
infra/oracle10
72%的时候报错:The OPMN Process Manager failed to start.Please check the logs in the /oracle/product/10.1.0/opmn/logs
directory for the cause of failure.Once the cause of failure has been remedied,start OPMN manually and click Retry.
手工启动:./oracle/product/opmn/bin/opmnctl start
需要运行root脚本 /oracle/product/10.1.0/root.sh
Internet Directory配置助手失败了
output generated from configuration assistant "Internet Directory Configuration Assistant":
389
636
cn=orcladmin
asdb
infra.p630tJVMDG217: Dump Handler is Processing a Signal - Please Wait.
JVMDG303: JVM Requesting Java core fileJVMDG304: Java core file written to /oracle/product/10.1.0/ldap/admin/javacore397334.1115828651.txt
JVMDG215: Dump Handler has Processed Exception Signal 11./oracle/product/10.1.0/bin/oidca[37]: 397334 Segmentation fault(coredump)
Configuration assistant "Internet Directory Configuration Assistant" failed
这是检查下面
Check that the following patches are installed:
IY43980: libperfstat.h not ANSI-compliant
IY44810: DSI IN BMRECYCLE
IY45462: Definition of isnan() in math.h incorrect
IY45707: J2 READAAHEAD/CIO INTERACTION
IY46214: dropping partial connections leaves them on so_q0
IY46605: exec of 32 bit application can fail on 64 bit kernel
IY48525: SDK 1.4.1 32-BIT SR1: CA141-20030930
IY51801: race condition in aio_nwait_timeout
To determine whether an APAR is installed, enter a command similar to the following:
# /usr/sbin/instfix -i -k "IY22854 IY26778 ..."
发现IY48525没有,从https://techsupport.services.ibm.com/server/aix.fdc下载 并安装
要求Java14.debug.1.4.0.0
Java14.ext.javahelp 1.4.0.0
Java14.samples 1.4.0.0
Java14.source 1.4.0.0
最终解决方法:下载java142并安装,并ftp上了java环境脚本javaenv在根下,进入系统后运行. /javaenv /usr/java14就可以加上java环境了
安装oracle application server 10g,选择路径/oracle/product/as,管理员 j2ee_9204/oracle10 ,只选择了web cache

InnoDBBufferPool reduces disk I/O by caching data and indexing pages, improving database performance. Its working principle includes: 1. Data reading: Read data from BufferPool; 2. Data writing: After modifying the data, write to BufferPool and refresh it to disk regularly; 3. Cache management: Use the LRU algorithm to manage cache pages; 4. Reading mechanism: Load adjacent data pages in advance. By sizing the BufferPool and using multiple instances, database performance can be optimized.

Compared with other programming languages, MySQL is mainly used to store and manage data, while other languages such as Python, Java, and C are used for logical processing and application development. MySQL is known for its high performance, scalability and cross-platform support, suitable for data management needs, while other languages have advantages in their respective fields such as data analytics, enterprise applications, and system programming.

MySQL is worth learning because it is a powerful open source database management system suitable for data storage, management and analysis. 1) MySQL is a relational database that uses SQL to operate data and is suitable for structured data management. 2) The SQL language is the key to interacting with MySQL and supports CRUD operations. 3) The working principle of MySQL includes client/server architecture, storage engine and query optimizer. 4) Basic usage includes creating databases and tables, and advanced usage involves joining tables using JOIN. 5) Common errors include syntax errors and permission issues, and debugging skills include checking syntax and using EXPLAIN commands. 6) Performance optimization involves the use of indexes, optimization of SQL statements and regular maintenance of databases.

MySQL is suitable for beginners to learn database skills. 1. Install MySQL server and client tools. 2. Understand basic SQL queries, such as SELECT. 3. Master data operations: create tables, insert, update, and delete data. 4. Learn advanced skills: subquery and window functions. 5. Debugging and optimization: Check syntax, use indexes, avoid SELECT*, and use LIMIT.

MySQL efficiently manages structured data through table structure and SQL query, and implements inter-table relationships through foreign keys. 1. Define the data format and type when creating a table. 2. Use foreign keys to establish relationships between tables. 3. Improve performance through indexing and query optimization. 4. Regularly backup and monitor databases to ensure data security and performance optimization.

MySQL is an open source relational database management system that is widely used in Web development. Its key features include: 1. Supports multiple storage engines, such as InnoDB and MyISAM, suitable for different scenarios; 2. Provides master-slave replication functions to facilitate load balancing and data backup; 3. Improve query efficiency through query optimization and index use.

SQL is used to interact with MySQL database to realize data addition, deletion, modification, inspection and database design. 1) SQL performs data operations through SELECT, INSERT, UPDATE, DELETE statements; 2) Use CREATE, ALTER, DROP statements for database design and management; 3) Complex queries and data analysis are implemented through SQL to improve business decision-making efficiency.

The basic operations of MySQL include creating databases, tables, and using SQL to perform CRUD operations on data. 1. Create a database: CREATEDATABASEmy_first_db; 2. Create a table: CREATETABLEbooks(idINTAUTO_INCREMENTPRIMARYKEY, titleVARCHAR(100)NOTNULL, authorVARCHAR(100)NOTNULL, published_yearINT); 3. Insert data: INSERTINTObooks(title, author, published_year)VA


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function

Zend Studio 13.0.1
Powerful PHP integrated development environment

SublimeText3 English version
Recommended: Win version, supports code prompts!

PhpStorm Mac version
The latest (2018.2.1) professional PHP integrated development tool