{"id":863,"date":"2009-05-11T21:11:23","date_gmt":"2009-05-12T02:11:23","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=863"},"modified":"2011-10-12T11:50:52","modified_gmt":"2011-10-12T16:50:52","slug":"oracle-10g-install","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=863","title":{"rendered":"Oracle 10G Install"},"content":{"rendered":"

Optimal Flexible Architecture<\/h2><\/span>\n

Directory structure<\/h3><\/span>\n

Three sets of directories<\/h4><\/span>\n

* One for Oracle binary files
\n* One for control files, redo log files, other admin files
\n* One for data files<\/p>\n

Naming scheme<\/h3><\/span>\n

Mount points: \/pm<\/h4><\/span>\n

* p: literal; m: variable<\/p>\n

Examples<\/h5><\/span>\n

* \/u01 \/u02 \/u03
\n* \/ora01 \/ora02 \/ora03<\/p>\n

Oracle install directory: \/pm\/h\/u\/product\/v<\/h4><\/span>\n

* h: purpose; u: user; v: version<\/p>\n

Examples<\/h5><\/span>\n

* \/u02\/db\/oracle\/product\/10.1.0
\n* \/u01\/app\/oracle\/product\/9.0.4<\/p>\n

Admin directory: \/pm\/h\/admin\/d\/a<\/h4><\/span>\n

* d: sid; a: subdirectory (adhoc, arch, adump, bdump, cdump, create, exp, logbook, pfile, udump<\/p>\n

Examples<\/h5><\/span>\n

* \/u02\/db\/admin\/orcl\/create<\/p>\n

File naming convention<\/h4><\/span>\n
Root directory: \/pm\/q\/d<\/h5><\/span>\n

* q: literal, d: db name or sid<\/p>\n

Examples<\/h5><\/span>\n

* \/u03\/oradata\/ocp10g<\/p>\n

Files<\/h5><\/span>\n

* Control files: controlnn.ctl (control01.ctl)
\n* Redo log files: redonn.log (redo01.log)
\n* Data files: tablespacenn.dbf (system01.dbf, undo01.dbf)<\/p>\n

Install<\/h2><\/span>\n

Create User and Group<\/h3><\/span>\n

Unix\/Linux<\/h4><\/span>\n

* User: oracle
\n* Groups: oinstall, dba<\/p>\n

groupadd -g 500 oinstall\r\ngroupadd -g 501 dba\r\nuseradd -u 500 -g oinstall -G dba -d \/home\/oracle oracle -s \/bin\/bash<\/pre>\n
Windows<\/h4><\/span>\n
* User: any user belong to Admin group
\n* Group: ORA_DBA<\/p>\n
Set Environment Variables<\/h3><\/span>\n
* ORACLE_BASE (\/opt\/oracle)
\n* ORACLE_HOME ($ORACLE_BASE\/product\/10.1.0)
\n* ORACLE_SID (ORCL)
\n* NLS_LANG (American_America.US7ASCII)
\n* DISPLAY (db1.my.com:1.0)<\/p>\n
Oracle Universal Installer<\/h3><\/span>\n
Command<\/h4><\/span>\n
* Unix:
\n– runInstaller
\n– runInstaller -parameterFile \/home\/oracle\/oraparam.ini
\n* Windows: setup.exe<\/p>\n
Features<\/h4><\/span>\n
* Dependency checking (to disable: runInstaller -ignoreSysPrereqs)
\n* Multiple Oracle home support
\n* National language\/globalization support
\n* Web based installation (??)
\n* Unattended installation <\/p>\n
runInstaller -responsefile respfile [-silent] [-nowelcome]<\/pre>\n
* Uninstall
\n* Support for user defined packages<\/p>\n
Install<\/h4><\/span>\n
* Specify database file storage option:
\n– Local file system
\n– Automatic storage management (ASM)
\n– Raw devices<\/p>\n
Post install<\/h3><\/span>\n
\r\n# Oracle Settings\r\nTMP=\/tmp; export TMP\r\nTMPDIR=$TMP; export TMPDIR\r\nORACLE_BASE=\/opt\/oracle; export ORACLE_BASE\r\nORACLE_HOME=$ORACLE_BASE\/product\/10.1.0\/orcl; export ORACLE_HOME\r\nORACLE_SID=ORCL; export ORACLE_SID\r\nPATH=$ORACLE_HOME\/bin:\/usr\/sbin:$PATH; export PATH\r\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH\r\nCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\nLD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL\r\nulimit -u 16384 -n 65536<\/pre>\n","protected":false},"excerpt":{"rendered":"
Optimal Flexible Architecture Directory structure Three sets of directories * One for Oracle binary files * One for control files, redo log files, other admin files * One for data files Naming scheme Mount points: \/pm * p: literal; m: … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[93,35],"tags":[],"class_list":["post-863","post","type-post","status-publish","format-standard","hentry","category-10g","category-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-dV","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=863"}],"version-history":[{"count":9,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/863\/revisions"}],"predecessor-version":[{"id":3624,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/863\/revisions\/3624"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}