2008年6月21日
在腳注分割線下方出現一個多余空行，無法刪除。
這時，可以將“視圖”轉成“普通視圖”，雙擊正文中腳注索引，在普通視圖下方會自動出現腳注窗口。或者在“引用”選項板“腳注”中選擇“顯示備注”，可以達到同樣的效果。
在下拉列表中選擇“腳注分隔符”，此時可以對分隔符進行編輯
此時刪除多余回車就可以了。點擊“默認設置”可以對腳注分隔符的默認格式進行修改。
posted @
2010-01-10 01:09 思考 閱讀(19896) |
評論 (10) |
編輯 收藏這個方法也是在網上看到的，自己總結了一下，方面以后查詢。
netsh interface dump > cssl.txt
這樣可以在本地目錄下生成一個cssl.txt文件。該文件記錄了當前網絡的配置情況。通過執行如下命令可以應用cssl.txt文件中的網絡配置。
netsh exec cssl.txt
這樣，可以寫一個批處理文件完成網絡配置的切換。
posted @
2008-07-04 13:51 思考 閱讀(608) |
評論 (0) |
編輯 收藏1、進入命令提示符環境
2、進入DISKPART程序
3、輸入AUTOMOUNT ENABLE指令
4、ok，下次USB硬盤放入后就可以像XP一樣自動裝載了。
posted @
2008-06-27 16:07 思考 閱讀(476) |
評論 (0) |
編輯 收藏Windows 2003 server遠程桌面連接數限制已經困擾很久了，給平時的維護帶來麻煩。既然微軟不會從根本上解決這個問題，那只有通過其他方式來減少問題的發生幾率。
一、在服務器端的處理辦法如下
1. 設定已經斷開的會話結束時間限制，這樣避免會話已經斷開，但仍然占用一個Session
開始－運行－gpedit.msc－計算機配置－管理模板－windows組件－終端服務－會話，右邊窗口選擇"為斷開的會話設置時間限制"－選擇"已啟用"，選擇一個時間；
開始－運行－gpedit.msc－計算機配置－管理模板－windows組件－終端服務－會話，右邊窗口選擇"到達時間限制時終止會話"－選擇"已啟用"。
2. 無限時保持連接會話，便于遠程控制共享任意時候連接會話的數據，也就是共享任意時候連接的遠程桌面的當時狀態：
開始－管理工具－終端服務配置－服務器配置－限制每個用戶使用一個會話
3. 養成良好習慣，退出連接時不要直接關閉，而是使用注銷。
二、如果已經有多個連接存在
1 可以通過命令的方式將連接斷開，這個方法在2000系統同樣可用；如果在任務管理器的用戶里注銷的方法：
1.1 在Command Line模式下，輸入命令query user：
C:\>query user
USERNAME SESSIONNAME ID STATE IDLE TIME LOGON TIME
>dfsadmin 0 Disc . 7/23/2007 7:53 PM
mrsadmin rdp-tcp#10 1 Active . 7/24/2007 9:31 AM
ID 0的用戶是本地登陸的，ID 1是3389登陸的用戶，正在運行中，但是仍然占用系統資源和通道，我們要把它踢掉。
1.2 可通過logoff x命令來注銷id為x的登錄用戶。輸入命令：logoff 1，再用query user查詢狀態
C:\>logoff 1
C:\>query user
USERNAME SESSIONNAME ID STATE IDLE TIME LOGON TIME
>dfsadmin 0 Disc none 7/23/2007 7:53 PM
三、如果連接已經受限制
此時通過遠程登錄，可以用一個"3389DOS版"軟件來進行牽制登錄。這個軟件只能解決windows2003系統的限制，2000系統也沒辦法。
四、超過最大連接時連接
在超過最大連接數時，通過運行mstsc /v:IP /console命令就可以連接到遠程系統的會話。
MSTSC [＜Connection File＞] [/v:＜sever[:port]＞] [/console] [/f[ullscreen]]
[/w:＜width＞/h:＜height＞] | /Edit"ConnectionFile" | /Migrate | /?
＜Connection File＞-- 指定連接的.rdp 文件的名稱。
/v:＜sever[:port]＞-- 指定要連接到的終端服務器。
/console -- 連接到服務器的控制臺會話。
/f -- 以全屏模式啟動客戶端。
/w: ＜width＞-- 指定遠程桌面屏幕的寬度。
/h:＜height＞-- 指定遠程桌面屏幕的亮度。
/edit -- 打開指定的.rdp 文件來編輯。
/migrate -- 將客戶端連接管理器創建的舊版連接文件遷移到新的.rdp 連接文件。
/? -- 生成這個用法消息。
posted @
2008-06-27 16:07 思考 閱讀(16684) |
評論 (0) |
編輯 收藏tracert命令
C:\Documents and Settings\Administrator>tracert /?
Usage: tracert [-d] [-h maximum_hops] [-j host-list] [-w timeout]
[-R] [-S srcaddr] [-4] [-6] target_name
Options:
-d Do not resolve addresses to hostnames.
-h maximum_hops Maximum number of hops to search for target.
-j host-list Loose source route along host-list (IPv4-only).
-w timeout Wait timeout milliseconds for each reply.
-R Trace round-trip path (IPv6-only).
-S srcaddr Source address to use (IPv6-only).
-4 Force using IPv4.
-6 Force using IPv6.
說明
tracert（跟蹤路由）是路由跟蹤公用程序，用于確定 IP 數據包訪問目標所采取的路徑。Tracert 命令用 IP 生存時間 (TTL) 字段和 ICMP錯誤消息來確定從一個主機到網路上其它主機的路由。
Tracert 工作原理
透過向目標發送不同 IP 生存時間 (TTL) 值的"Internet 控制消息協議 (ICMP)"回
應數據包，Tracert 診斷程序確定到目標所采取的路由。要求路徑上的每個路由器在轉
發數據包之前至少將數據包上的 TTL 遞減 1。數據包上的 TTL 減為 0 時，路由器應
該將"ICMP已超時"的消息發回源系統。
Tracert 先發送 TTL 為 1 的響應數據包，并在隨后的每次發送過程將 TTL 遞增1，直
到目標響應或 TTL 達到最大值，從而確定路由。透過檢查中間路由器發回的"ICMP已
超時"的消息確定路由。某些路由器不經詢問直接丟棄 TTL 過期的數據包，這在Trac
ert 公用程序中看不到。
posted @
2008-06-27 16:07 思考 閱讀(402) |
評論 (0) |
編輯 收藏id命令
顯示用戶信息
oracle:~ # id
uid=0(root) gid=0(root) groups=0(root)
oracle:~ # id esecadm
uid=1000(esecadm) gid=1000(esec) groups=1000(esec),16(dialout),33(video)
groups命令
顯示組信息
oracle:~ # groups
root
oracle:~ # groups esecadm
esecadm : esec dialout video
finger命令
顯示用戶信息
oracle:~ # finger
Login Name Tty Idle Login Time Where
root root pts/0 - Sat 22:16 192.168.100.1
oracle:~ # finger esecadm
Login: esecadm Name:
Directory: /export/home/esecadm Shell: /bin/bash
Never logged in.
No Mail.
No Plan.
oracle:~ # finger root
Login: root Name: root
Directory: /root Shell: /bin/bash
On since Sat Jun 21 22:16 (CST) on pts/0 from 192.168.100.1
New mail received Sat Jun 21 22:09 2008 (CST)
Unread since Fri Jun 20 09:21 2008 (CST)
No Plan.
/etc/paswd
所有用戶的信息都存放在該文件中。該文件中每行都代表以該用戶，每行的格式如下圖所示。因為該文件是所有用戶都可以讀的，為了系統安全，將用戶的口令信息放置在另一文件中。
/etc/shadow
該文件中存放有加密的用戶口令信息，并且該文件只有root可讀的。
如果用戶口令字段是空、*或者!，說明用戶不能登錄系統。需要通過passwd給用戶提供密碼，這時用戶才能登錄系統。
ssh登錄
默認情況下，只有root用戶可以通過ssh遠程登錄系統。為了使其它用戶登錄，需要修改/etc/ssh/sshd_config文件。在文件中加入下面一行：
AllowUsers root esecadm
后面可以跟若干用戶，其間用空格分開。
posted @
2008-06-22 01:52 思考 閱讀(2696) |
評論 (0) |
編輯 收藏Sentinel 6安裝
Sentinel有兩種安裝方式，一種是通過命令行的方式，一種是通過GUI的方式。本文主要介紹以命令行方式安裝Sentinel 6的方法。
首先，在命令行中輸入setup.sh -console，則打開安裝程序。
oracle:/media/cdrom # ./setup.sh -console
Installing Sentinel Suite in console mode ...
安裝程序首先啟動JVM裝載安裝程序。這里需要等待一段時間。
Initializing Wizard........
Launching InstallShield Wizard........
緊接著是選擇安裝語言，默認是英文。
----------------------------------------------------------------------------
Select a language to be used for this wizard.
[X] 1 - English
[ ] 2 - French
[ ] 3 - German
[ ] 4 - Italian
[ ] 5 - Portuguese (Brazil)
[ ] 6 - Spanish
[ ] 7 - Simplified Chinese
[ ] 8 - Traditional Chinese
[ ] 9 - Japanese
To select an item enter its number, or 0 when you are finished: [0]
下面英文界面的安裝向導將出現，回車繼續安裝。
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Welcome to the InstallShield Wizard for Sentinel 6
The InstallShield Wizard will install Sentinel 6 on your computer.
To continue, choose Next.
Sentinel 6
Novell, Inc.
www.Novell.com
Press 1 for Next, 3 to Cancel or 5 to Redisplay [1]
接下來是安裝向導提示的Sentinel 6的許可證信息，選擇q退出閱讀即可。
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Please read the following license agreement carefully.
Novell Sentinel 6
Novell Sentinel 6.0
Novell Software License Agreement
PLEASE READ THIS AGREEMENT CAREFULLY. BY INSTALLING, DOWNLOADING OR OTHERWISE
USING THE SOFTWARE, YOU AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU DO NOT
AGREE WITH THESE TERMS, DO NOT DOWNLOAD, INSTALL OR USE THE SOFTWARE. THE
SOFTWARE MAY NOT BE SOLD, TRANSFERRED, OR FURTHER DISTRIBUTED EXCEPT AS
AUTHORIZED BY NOVELL.
This Novell Software License Agreement (Agreement) is a legal agreement between
You (an entity or a person) and Novell, Inc. (Novell). The software product
Press ENTER to read the text [Type q to quit] q
接下來，選擇1，回車，同意該許可信息。再按回車繼續。
Please choose from the following options:
[ ] 1 - I accept the terms of the license agreement.
[X] 2 - I do not accept the terms of the license agreement.
To select an item enter its number, or 0 when you are finished: [0] 1
[X] 1 - I accept the terms of the license agreement.
[ ] 2 - I do not accept the terms of the license agreement.
To select an item enter its number, or 0 when you are finished: [0]
Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]
緊接著安裝向導提示選擇Sentinel 6的安裝位置。
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Sentinel 6 Install Location
Please specify a directory or press Enter to accept the default directory.
Destination Directory [/opt/novell/sentinel6]
Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]
接下來選擇Sentinel的安裝方式。因為這里我們只是用作測試，并安裝在虛擬機上，因此選擇簡單方式。這時，Sentinel的所有組件將被安裝在同一臺電腦上。
-------------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Choose the installation type that best suits your needs.
[ ] 1 - Simple
All-In-One easy installation.
[X] 2 - Custom
Allows the user to configure a custom installation.
Select the number corresponding to the type of install you would like. Enter 0
to continue: [0]1
[X] 1 - Simple
All-In-One easy installation.
[ ] 2 - Custom
Allows the user to configure a custom installation.
Select the number corresponding to the type of install you would like. Enter 0
to continue: [0]
Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]
輸入Sentinel 6的安裝序列號：12345678和許可證：19c3d24adc1df104。輸入后，系統會提示這是一個臨時許可證，將在2009年5月31日過期。
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Serial Number: [] 12345678
License Key: [] 19c3d24adc1df104
You have entered a temporary license key. If a new license key is not provided,
this software will automatically disable itself after the expiration date :
'5/31/09'
[OK]
緊接著系統會詢問SMTP服務器和發送郵件的郵件地址信息，默認是本地的SMTP服務器和esecadm。
SMTP Server: [localhost]
E-mail: [esecadm]
下面將詢問是否安裝Advisor，這里我們不進行安裝。
Do you wish to install 'Advisor'?
1. Yes
2. No
Enter one of the options above: [2]
之后，系統會提示輸入全局系統口令。其中包括Sentinel管理員用戶和數據庫用戶的口令。并制定數據庫用戶的用戶名，默認是oracle。
Global System Password (used for all Sentinel users)
Password:
Confirm Password:
Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]
Specify the Oracle username [oracle]
Specify the Oracle username
[OK]
選擇已經安裝的Oracle版本，選擇2并繼續。
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Select the target database server platform:
1. Oracle 9i
2. Oracle 10g
Enter one of the options above: [1] 2
Oracle JDBC Driver File: [] /opt/oracle/product/10gR2/db/jdbc/lib/ojdbc14.jar
Database Name: [ESEC]
Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]
接下來將顯示前面配置的Oracle安裝信息。
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Oracle Configuration
SUMMARY
An Oracle database will be created with the following parameters
A new instance will be created named: ESEC.
This database will have a total size of: 10000 MB.
Data file locations are as follows
Data Files: /opt/novell/sentinel6/database
Index Files: /opt/novell/sentinel6/database
Summary Data Files: /opt/novell/sentinel6/database
Summary Index Files: /opt/novell/sentinel6/database
Temporary Files: /opt/novell/sentinel6/database
Redo Logs A: /opt/novell/sentinel6/database
Redo Logs B: /opt/novell/sentinel6/database
The database will listen on port: 1521
The database will use 256 MB of system memory.
The schema will be owned by: esecdba
The application user will be: esecapp
The Sentinel Administrator will be: esecadm
Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]
接下來，將顯示Sentinel 6的安裝信息，回車繼續。
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Sentinel 6 will be installed in the following location:
/opt/novell/sentinel6
with the following features:
Database
Sentinel Services
Communication Server
Correlation Engine
Data Access Server
Sentinel Collector Service
Applications
Sentinel Control Center
Sentinel Data Manager
for a total size:
460.2 MB
Press 1 for Next, 2 for Previous, 3 to Cancel or 5 to Redisplay [1]
系統收集完上述信息之后將進行安裝，下面是安裝時的顯示信息。安裝時間比較長，跟機器的性能有關。在我的電腦上安裝大概進行了40分鐘，包括數據庫、分區和Sentinel產品各組件的安裝。
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Installing Sentinel Database. Please wait...
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Adding enough partitions for '10' days. Please wait...
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Installing Sentinel 6. Please wait...
|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||||||||||||||||||||||||||||||||||||||||||||||
Creating uninstaller...
Finalizing the Vital Product Data Registry. Please wait...
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Setting JVM permissions...
|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||||||||||||||||||||||||||||||||||||||||||||||
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Installing Sentinel Communication Server. Please wait...
|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||||||||||||||||||||||||||||||||||||||||||||||
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Installing Sentinel Communication Server. Please wait...
|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||||||||||||||||||||||||||||||||||||||||||||||
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Setting permissions on installed files...
|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||||||||||||||||||||||||||||||||||||||||||||||
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
Updating container configuration file. Please wait...
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Setting permissions on installed files...
|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||||||||||||||||||||||||||||||||||||||||||||||
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
Setting permissions on installed files...
|-----------|-----------|-----------|------------|
0% 25% 50% 75% 100%
||||||||||||||||||||||||||||||||||||||||||||||||||
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
The InstallShield Wizard has successfully installed Sentinel 6. Choose Finish
to exit the wizard.
Press 3 to Finish or 5 to Redisplay [3]
最后，系統提示需要重新啟動系統才能完成安裝。
----------------------------------------------------------------------------
Sentinel 6 - InstallShield Wizard
The wizard requires that you logout and log back in. To start Sentinel 6
processes, reboot the machine or log back in and start them manually.
Press 3 to Finish or 5 to Redisplay [3]
Sentinel數據庫安裝好了之后，會在系統中創建如下用戶：
esecdba：數據庫Schema所有者，出于安全考慮，該用戶并未授予數據庫DBA的特權
esecapp：數據庫應用程序用戶，該用戶用來連接數據庫
esecadm：Sentinel管理員的數據庫用戶，該用戶不同于Sentinel管理員的操作系統用戶
esecrpt：數據庫報告用戶
posted @
2008-06-21 20:24 思考 閱讀(519) |
評論 (0) |
編輯 收藏安裝SLES 10 x86_64
分區時使用Ext3文件系統；
選擇軟件包時，選擇"Oracle Server Base"和"C/C++ Compiler and Tools"，同時保證選擇了"32Bit Runtime Environment"；下面是軟件包選擇的一個截圖。
安裝SLES 10的Server Pack
使用SPident或者"cat /etc/SuSE-release"來校驗
oracle:~ # cat /etc/SuSE-release
SUSE Linux Enterprise Server 10 (x86_64)
VERSION = 10
PATCHLEVEL = 2
oracle:~ # SPident -v
Summary (using 890 packages)
Product/ServicePack conflict match update (shipped)
SLE-10-x86_64 0 0% 325 36.5% 0 (2754 11.8%)
SLE-10-x86_64-SP1 0 0% 470 52.8% 0 (2938 16.0%)
SLE-10-x86_64-SP2 0 0% 889 99.9% 0 (2337 38.0%)
Unknown 1 0.1%
CONCLUSION: System is up-to-date!
found SLE-10-x86_64-SP2
Oracle安裝先決條件
SuSE提供了orarun來自動完成很多Oracle預安裝的任務。為了下面安裝Oracle，需要進行如下配置。
激活oracle用戶
在安裝了Oracle Server Base之后，系統就自動創建了oracle用戶。但是，默認的該用戶是被禁用了的。
oracle:~ # vim /etc/passwd
oracle:x:103:106:Oracle user:/opt/oracle:/bin/false
為此，我們需要激活該用戶。手工編輯/etc/passwd文件：
oracle:x:103:106:Oracle user:/opt/oracle:/bin/bash
修改oracle用戶口令
oracle:~ # passwd oracle
Changing password for oracle.
New Password:
Bad password: too simple
Reenter New Password:
Password changed.
修改Oracle環境變量
編輯/etc/profile.d/oracle.sh文件中Oracle的環境變量如下：
oracle:~ # vim /etc/profile.d/oracle.sh
# ORACLE_HOME=$ORACLE_BASE/product/10.2/db_1
ORACLE_HOME=$ORACLE_BASE/product/10gR2/db
ORACLE_SID=ESEC
修改ORACLE_HOME和ORACLE_SID環境變量。
設置內核參數
運行rcoracle start命令設置內核參數。因為還沒有安裝Oracle數據庫，忽略期間報的錯誤。
oracle:~ # rcoracle start
#############################################################################
# Begin of O R A C L E startup section #
#############################################################################
Oracle Database Software not yet installed!
SETTINGS start from /etc/sysconfig/oracle
- Set Kernel Parameters for Oracle: yes
- Start Oracle Listener: no
- Start Oracle Database: no
- Start Oracle Webserver: no
- Start Oracle EManager: no
- Start Oracle iSQLPLUS Manager: no
- Start Oracle Agent: no
- Start Oracle Internet Filesystem: no
- Start Oracle Directory Manager: no
Oracle Agent undefinied or not properly set. Please check.
Setting kernel parameters for Oracle, see file
/etc/sysconfig/oracle for explanations.
Shared memory: SHMMAX=3294967296 SHMMNI=4096 SHMALL=2097152
Semaphore values: SEMMSL=1250 SEMMNS=32000 SEMOPM=100 SEMMNI=256
Other values: FILE_MAX_KERNEL=131072 IP_LOCAL_PORT_RANGE=1024 65000
RMEM_DEFAULT=4194304 WMEM_DEFAULT=262144 RMEM_MAX=4194304 WMEM_MAX=262144
Huge Pages: SHM_GROUP=dba NR_HUGE_PAGES=0
ULIMIT values: MAX_CORE_FILE_SIZE_SHELL=unlimited
FILE_MAX_SHELL=65536 PROCESSES_MAX_SHELL=16384
Kernel parameters set for Oracle: done
- Starting Listener... unused
+ Starting Database(s)...
unused
- Starting Apache... unused
- Starting Application Server... unused
- Starting Application Server Console... unused
- Starting Agent... unused
- Starting Enterprise Manager... unused
- Starting iSQLPLUS Manager... unused
- Starting Oracle Internet Filesystem... unused
- Starting Oracle Internet Directory... unused
#############################################################################
# End of O R A C L E section #
#############################################################################
檢驗oracle用戶
oracle:~ # su oracle
oracle@oracle:/root> id
uid=103(oracle) gid=106(oinstall) groups=106(oinstall),107(dba)
安裝Oracle 10g
解壓Oracle軟件
#gunzip 10201_database_linux_x86_64.cpio.gz
#cpio -idmv < 10201_database_linux_x86_64.cpio
安裝Oracle 10g SP2
確保使用oracle用戶登錄系統，必須使用圖形界面進行安裝。為了在SuSE 10上安裝Oracle 10g，必須手工修改安裝配置文件，以確保Oracle支持SuSE 10系統。在Oracle安裝文件路徑下編輯文件：
vim install/oraparam.ini
[Certified Versions]
Linux=redhat-3,SuSE-9,SuSE-10,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2
選擇高級安裝
選擇默認的Inventory目錄
選擇安裝企業版
在安裝之前，Oracle會檢查系統設置燈信息是否符合要求。我們將檢查未成功的選擇為"User Verified"。
選擇"Install database Software only"
查看安裝概要并選擇安裝
下面是安裝進程。
在安裝結束之前，系統會提示使用root用戶登錄，執行下面腳本。
使用另一個窗口登錄，執行腳本。
選擇"Exit"完成安裝。
安裝補丁
在Novell官方的文檔中，Sentinel需要Oracle安裝補丁10.2.0.3。從metalink網站上下載Oracle的補丁p5337014_10203_Linux-x86-64.zip。該補丁有1G多，而且下載時需要metalink的帳號才能下載。
下載后解壓，并確保使用oracle用戶運行Disk1中的runInstaller進行安裝。跟安裝Oracle 10g時一樣，安裝程序首先要檢查系統兼容性，為了在SLES 10上安裝，需要修改配置文件，使之支持在SuSE 10上的安裝。修改方法與Oracle 10g安裝時的一樣。
下圖是安裝時的歡迎界面。
首先現在Oracle 10g的安裝目錄。
接下來，是安裝的信息。確認后執行安裝。
下圖是安裝進度。
安裝結束前，提示需要用戶以root身份手工執行root.sh腳本。
打開另一個窗口，執行ORACLE_HOME目錄下的root.sh腳本。
執行完腳本后，點擊"OK"，系統提示完成補丁安裝，點擊"Exit"退出系統安裝。
應用關鍵補丁
下面，需要通過opatch工具安裝Oracle的關鍵補丁。同樣，首先從metalink網站上下載補?。簆5881721_10203_Linux-x86-64.zip并解壓。請確保使用oralce用戶進行下面的操作。
進入5881721目錄，運行$ORACLE_HOME/OPatch/opatch apply -local。下圖是安裝過程。
輸入y之后繼續安裝。
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '5881721' for restore. This might take a while...
Backing up files affected by the patch '5881721' for rollback. This might take a while...
Execution of 'sh /mnt/hgfs/oracle/Oracle10g/Linux/patch/p5881721_10203_Linux-x86-64/5881721/custom/scripts/pre -apply 5881721 ':
Return Code = 0
Patching component oracle.sysman.repository.core, 10.2.0.3.0a...
Updating jar file "/opt/oracle/product/10gR2/db/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/emo/util/DBVerify.class"
Updating jar file "/opt/oracle/product/10gR2/db/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/emo/util/dbclone/DBCloneObject.class"
Updating jar file "/opt/oracle/product/10gR2/db/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/emo/util/dbclone/DBCloneVerify.class"
Patching component oracle.sysman.bsln, 10.2.0.3.0...
Updating jar file "/opt/oracle/product/10gR2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/emSDK/chart/EmChartBean.class"
Updating jar file "/opt/oracle/product/10gR2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/emSDK/svlt/RedirectServlet.class"
Patching component oracle.sysman.agent.core, 10.2.0.3.0a...
Updating archive file "/opt/oracle/product/10gR2/db/sysman/lib32/libnmem.a" with "sysman/lib32/libnmem.a/nmemdisp.o"
Updating archive file "/opt/oracle/product/10gR2/db/sysman/lib32/libnmexml.a" with "sysman/lib32/libnmexml.a/nmex.o"
Updating archive file "/opt/oracle/product/10gR2/db/sysman/lib32/libnmehl.a" with "sysman/lib32/libnmehl.a/nmehl.o"
Patching component oracle.rdbms, 10.2.0.3.0...
Updating archive file "/opt/oracle/product/10gR2/db/lib/libserver10.a" with "lib/libserver10.a/qmurd.o"
Copying file to "/opt/oracle/product/10gR2/db/cpu/CPUJan2007/catcpu.sql"
Copying file to "/opt/oracle/product/10gR2/db/cpu/CPUJan2007/catcpu_rollback.sql"
ApplySession adding interim patch '5881721' to inventory
Verifying the update...
Inventory check OK: Patch ID 5881721 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5881721 are present in Oracle Home.
--------------------------------------------------------------------------------****************************************************************************************************************************************************************** ATTENTION **** **** Please note that the Security Patch Installation (Patch Deinstallation) is **** not complete until all the Post Installation (Post Deinstallation) **** instructions noted in the Readme accompanying this patch, have been **** successfully completed. **** ******************************************************************************************************************************************************************
--------------------------------------------------------------------------------
Execution of 'sh /mnt/hgfs/oracle/Oracle10g/Linux/patch/p5881721_10203_Linux-x86-64/5881721/custom/scripts/post -apply 5881721 ':
Return Code = 0
Running make for target libnmemso
Running make for target ioracle
The local system has been patched and can be restarted.
OPatch succeeded.
最后，通過$ORACLE_HOME/OPatch/opatch lsinventory命令進行補丁狀態檢查。
oracle@oracle:/mnt/hgfs/oracle/Oracle10g/Linux/patch/p5881721_10203_Linux-x86-64/5881721> /opt/oracle/product/10gR2/db/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.3.0
Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
Oracle Home : /opt/oracle/product/10gR2/db
Central Inventory : /opt/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /opt/oracle/product/10gR2/db/oui
Log file location : /opt/oracle/product/10gR2/db/cfgtoollogs/opatch/opatch2008-06-20_14-33-53PM.log
Lsinventory Output file location : /opt/oracle/product/10gR2/db/cfgtoollogs/opatch/lsinv/lsinventory2008-06-20_14-33-53PM.txt
--------------------------------------------------------------------------------Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 2 products installed in this Oracle Home.
Interim patches (3) :
Patch 5881721 : applied on Fri Jun 20 14:26:08 GMT+08:00 2008
Created on 19 Feb 2007, 02:16:34 hrs US/Pacific
Bugs fixed:
5885186, 5881721
Patch 5556081 : applied on Fri Jun 20 11:51:55 GMT+08:00 2008
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081
Patch 5557962 : applied on Fri Jun 20 11:51:46 GMT+08:00 2008
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974
--------------------------------------------------------------------------------
OPatch succeeded.
如果成功，將出現"OPatch succeeded."字樣。
至此，針對Sentinel 6的Oracle安裝已經完成。接下來就是進行Sentinel產品的安裝。
安裝SLES 10的Server Pack
使用SPident或者"cat /etc/SuSE-release"來校驗
oracle:~ # cat /etc/SuSE-release
SUSE Linux Enterprise Server 10 (x86_64)
VERSION = 10
PATCHLEVEL = 2
oracle:~ # SPident -v
Summary (using 890 packages)
Product/ServicePack conflict match update (shipped)
SLE-10-x86_64 0 0% 325 36.5% 0 (2754 11.8%)
SLE-10-x86_64-SP1 0 0% 470 52.8% 0 (2938 16.0%)
SLE-10-x86_64-SP2 0 0% 889 99.9% 0 (2337 38.0%)
Unknown 1 0.1%
CONCLUSION: System is up-to-date!
found SLE-10-x86_64-SP2
Oracle安裝先決條件
SuSE提供了orarun來自動完成很多Oracle預安裝的任務。為了下面安裝Oracle，需要進行如下配置。
激活oracle用戶
在安裝了Oracle Server Base之后，系統就自動創建了oracle用戶。但是，默認的該用戶是被禁用了的。
oracle:~ # vim /etc/passwd
oracle:x:103:106:Oracle user:/opt/oracle:/bin/false
為此，我們需要激活該用戶。手工編輯/etc/passwd文件：
oracle:x:103:106:Oracle user:/opt/oracle:/bin/bash
修改oracle用戶口令
oracle:~ # passwd oracle
Changing password for oracle.
New Password:
Bad password: too simple
Reenter New Password:
Password changed.
修改Oracle環境變量
編輯/etc/profile.d/oracle.sh文件中Oracle的環境變量如下：
oracle:~ # vim /etc/profile.d/oracle.sh
# ORACLE_HOME=$ORACLE_BASE/product/10.2/db_1
ORACLE_HOME=$ORACLE_BASE/product/10gR2/db
ORACLE_SID=ESEC
修改ORACLE_HOME和ORACLE_SID環境變量。
設置內核參數
運行rcoracle start命令設置內核參數。因為還沒有安裝Oracle數據庫，忽略期間報的錯誤。
oracle:~ # rcoracle start
#############################################################################
# Begin of O R A C L E startup section #
#############################################################################
Oracle Database Software not yet installed!
SETTINGS start from /etc/sysconfig/oracle
- Set Kernel Parameters for Oracle: yes
- Start Oracle Listener: no
- Start Oracle Database: no
- Start Oracle Webserver: no
- Start Oracle EManager: no
- Start Oracle iSQLPLUS Manager: no
- Start Oracle Agent: no
- Start Oracle Internet Filesystem: no
- Start Oracle Directory Manager: no
Oracle Agent undefinied or not properly set. Please check.
Setting kernel parameters for Oracle, see file
/etc/sysconfig/oracle for explanations.
Shared memory: SHMMAX=3294967296 SHMMNI=4096 SHMALL=2097152
Semaphore values: SEMMSL=1250 SEMMNS=32000 SEMOPM=100 SEMMNI=256
Other values: FILE_MAX_KERNEL=131072 IP_LOCAL_PORT_RANGE=1024 65000
RMEM_DEFAULT=4194304 WMEM_DEFAULT=262144 RMEM_MAX=4194304 WMEM_MAX=262144
Huge Pages: SHM_GROUP=dba NR_HUGE_PAGES=0
ULIMIT values: MAX_CORE_FILE_SIZE_SHELL=unlimited
FILE_MAX_SHELL=65536 PROCESSES_MAX_SHELL=16384
Kernel parameters set for Oracle: done
- Starting Listener... unused
+ Starting Database(s)...
unused
- Starting Apache... unused
- Starting Application Server... unused
- Starting Application Server Console... unused
- Starting Agent... unused
- Starting Enterprise Manager... unused
- Starting iSQLPLUS Manager... unused
- Starting Oracle Internet Filesystem... unused
- Starting Oracle Internet Directory... unused
#############################################################################
# End of O R A C L E section #
#############################################################################
檢驗oracle用戶
oracle:~ # su oracle
oracle@oracle:/root> id
uid=103(oracle) gid=106(oinstall) groups=106(oinstall),107(dba)
安裝Oracle 10g
解壓Oracle軟件
#gunzip 10201_database_linux_x86_64.cpio.gz
#cpio -idmv < 10201_database_linux_x86_64.cpio
安裝Oracle 10g SP2
確保使用oracle用戶登錄系統，必須使用圖形界面進行安裝。為了在SuSE 10上安裝Oracle 10g，必須手工修改安裝配置文件，以確保Oracle支持SuSE 10系統。在Oracle安裝文件路徑下編輯文件：
vim install/oraparam.ini
[Certified Versions]
Linux=redhat-3,SuSE-9,SuSE-10,redhat-4,UnitedLinux-1.0,asianux-1,asianux-2
選擇高級安裝
選擇默認的Inventory目錄
選擇安裝企業版
在安裝之前，Oracle會檢查系統設置燈信息是否符合要求。我們將檢查未成功的選擇為"User Verified"。
選擇"Install database Software only"
查看安裝概要并選擇安裝
下面是安裝進程。
在安裝結束之前，系統會提示使用root用戶登錄，執行下面腳本。
使用另一個窗口登錄，執行腳本。
選擇"Exit"完成安裝。
安裝補丁
在Novell官方的文檔中，Sentinel需要Oracle安裝補丁10.2.0.3。從metalink網站上下載Oracle的補丁p5337014_10203_Linux-x86-64.zip。該補丁有1G多，而且下載時需要metalink的帳號才能下載。
下載后解壓，并確保使用oracle用戶運行Disk1中的runInstaller進行安裝。跟安裝Oracle 10g時一樣，安裝程序首先要檢查系統兼容性，為了在SLES 10上安裝，需要修改配置文件，使之支持在SuSE 10上的安裝。修改方法與Oracle 10g安裝時的一樣。
下圖是安裝時的歡迎界面。
首先現在Oracle 10g的安裝目錄。
接下來，是安裝的信息。確認后執行安裝。
下圖是安裝進度。
安裝結束前，提示需要用戶以root身份手工執行root.sh腳本。
打開另一個窗口，執行ORACLE_HOME目錄下的root.sh腳本。
執行完腳本后，點擊"OK"，系統提示完成補丁安裝，點擊"Exit"退出系統安裝。
應用關鍵補丁
下面，需要通過opatch工具安裝Oracle的關鍵補丁。同樣，首先從metalink網站上下載補丁：p5881721_10203_Linux-x86-64.zip并解壓。請確保使用oralce用戶進行下面的操作。
進入5881721目錄，運行$ORACLE_HOME/OPatch/opatch apply -local。下圖是安裝過程。
輸入y之后繼續安裝。
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '5881721' for restore. This might take a while...
Backing up files affected by the patch '5881721' for rollback. This might take a while...
Execution of 'sh /mnt/hgfs/oracle/Oracle10g/Linux/patch/p5881721_10203_Linux-x86-64/5881721/custom/scripts/pre -apply 5881721 ':
Return Code = 0
Patching component oracle.sysman.repository.core, 10.2.0.3.0a...
Updating jar file "/opt/oracle/product/10gR2/db/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/emo/util/DBVerify.class"
Updating jar file "/opt/oracle/product/10gR2/db/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/emo/util/dbclone/DBCloneObject.class"
Updating jar file "/opt/oracle/product/10gR2/db/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/emo/util/dbclone/DBCloneVerify.class"
Patching component oracle.sysman.bsln, 10.2.0.3.0...
Updating jar file "/opt/oracle/product/10gR2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/emSDK/chart/EmChartBean.class"
Updating jar file "/opt/oracle/product/10gR2/db/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/emSDK/svlt/RedirectServlet.class"
Patching component oracle.sysman.agent.core, 10.2.0.3.0a...
Updating archive file "/opt/oracle/product/10gR2/db/sysman/lib32/libnmem.a" with "sysman/lib32/libnmem.a/nmemdisp.o"
Updating archive file "/opt/oracle/product/10gR2/db/sysman/lib32/libnmexml.a" with "sysman/lib32/libnmexml.a/nmex.o"
Updating archive file "/opt/oracle/product/10gR2/db/sysman/lib32/libnmehl.a" with "sysman/lib32/libnmehl.a/nmehl.o"
Patching component oracle.rdbms, 10.2.0.3.0...
Updating archive file "/opt/oracle/product/10gR2/db/lib/libserver10.a" with "lib/libserver10.a/qmurd.o"
Copying file to "/opt/oracle/product/10gR2/db/cpu/CPUJan2007/catcpu.sql"
Copying file to "/opt/oracle/product/10gR2/db/cpu/CPUJan2007/catcpu_rollback.sql"
ApplySession adding interim patch '5881721' to inventory
Verifying the update...
Inventory check OK: Patch ID 5881721 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 5881721 are present in Oracle Home.
--------------------------------------------------------------------------------****************************************************************************************************************************************************************** ATTENTION **** **** Please note that the Security Patch Installation (Patch Deinstallation) is **** not complete until all the Post Installation (Post Deinstallation) **** instructions noted in the Readme accompanying this patch, have been **** successfully completed. **** ******************************************************************************************************************************************************************
--------------------------------------------------------------------------------
Execution of 'sh /mnt/hgfs/oracle/Oracle10g/Linux/patch/p5881721_10203_Linux-x86-64/5881721/custom/scripts/post -apply 5881721 ':
Return Code = 0
Running make for target libnmemso
Running make for target ioracle
The local system has been patched and can be restarted.
OPatch succeeded.
最后，通過$ORACLE_HOME/OPatch/opatch lsinventory命令進行補丁狀態檢查。
oracle@oracle:/mnt/hgfs/oracle/Oracle10g/Linux/patch/p5881721_10203_Linux-x86-64/5881721> /opt/oracle/product/10gR2/db/OPatch/opatch lsinventory
Invoking OPatch 10.2.0.3.0
Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
Oracle Home : /opt/oracle/product/10gR2/db
Central Inventory : /opt/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /opt/oracle/product/10gR2/db/oui
Log file location : /opt/oracle/product/10gR2/db/cfgtoollogs/opatch/opatch2008-06-20_14-33-53PM.log
Lsinventory Output file location : /opt/oracle/product/10gR2/db/cfgtoollogs/opatch/lsinv/lsinventory2008-06-20_14-33-53PM.txt
--------------------------------------------------------------------------------Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 2 10.2.0.3.0
There are 2 products installed in this Oracle Home.
Interim patches (3) :
Patch 5881721 : applied on Fri Jun 20 14:26:08 GMT+08:00 2008
Created on 19 Feb 2007, 02:16:34 hrs US/Pacific
Bugs fixed:
5885186, 5881721
Patch 5556081 : applied on Fri Jun 20 11:51:55 GMT+08:00 2008
Created on 9 Nov 2006, 22:20:50 hrs PST8PDT
Bugs fixed:
5556081
Patch 5557962 : applied on Fri Jun 20 11:51:46 GMT+08:00 2008
Created on 9 Nov 2006, 23:23:06 hrs PST8PDT
Bugs fixed:
4269423, 5557962, 5528974
--------------------------------------------------------------------------------
OPatch succeeded.
如果成功，將出現"OPatch succeeded."字樣。
至此，針對Sentinel 6的Oracle安裝已經完成。接下來就是進行Sentinel產品的安裝。
posted @
2008-06-21 20:14 思考 閱讀(2262) |
評論 (0) |
編輯 收藏