還有一項任務，就是把公司的資料庫的運作，看管好！
若是它發生異常，寫資料庫程式的PROGRAMER不會修，
我就得趕緊找資料庫廠商的工程師來維護了。
也算是讓自己有多點專長，
我打算研究ORACLE資料庫的架構，
也許以後TROUBLE SHOOTTING可以派上用場！
我現在的電腦OS是用FEDORA6，
ORACLE是不能裝上去的，但ORACLE為了與MYSQL比美，
釋出了ORACLE XE的版本，
太好了，不是嗎？
趕緊來試試···
以下是安裝的過程，
有點小麻煩，但問題不大，安裝過程算是非常順利。
先把過程記錄下來，日後再來註解，OK！
[root@fc6 bullock]# cd oracleXE/
[root@fc6 oracleXE]# ls
adodb-9-2-6-1.php PLSQL練習950806.txt XE10-5-4-1.php XE6_6_4.SQL
adodb-9-2-7-1.php PLSQL練習950816.txt XE10-6-1-1.PHP XE6_6_5.SQL
adodb-9-2-7-2.php windows XE10-6-2-1.php XE6_7_1.SQL
adodb-9-2-7-3.php XE10-2-2-1.php XE10-6-2-2.php XE6_7_2.SQL
adodb-9-2-7-4.php XE10-5-1-1.php XE10-6-2-3.php XE6_9_3A.SQL
adodb-9-2-7-5.php XE10-5-1-2.php XE10-6-3-1.php XE6_9_3.sql
adodb-9-2-7-6.php XE10-5-1-3.php XE10-6-3-2.php XE8_5_2.SQL
adodb-9-2-7-8.php XE10-5-1-4.php XE10-6-3-3.php XE8_5_2.txt
adodb-9-2-8-1.php XE10-5-1-5.php XE10-6-4-1.php XESample.sql
adodb-9-2-9-1.php XE10-5-1-6.php XE10-6-5-1.php XE第五章950828.txt
CLOB.txt XE10-5-1-7.php XE10-6-5-2.php XE第六章950814.txt
ec.html XE10-5-1-8.php XE10-6-6-1.php XE第四章950829.txt
Linux XE10-5-2-1.php XE10-6-7-1.php
load_sample.sql XE10-5-3-1.php XE4_7.SQL
[root@fc6 oracleXE]# cd Linux/
[root@fc6 Linux]# ls
oracle-xe-client-10.2.0.1-1.0.i386.rpm oracle-xe-univ-10.2.0.1-1.0.i386.rpm
[root@fc6 Linux]# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
error: Failed dependencies:
libaio >= 0.3.96 is needed by oracle-xe-univ-10.2.0.1-1.0.i386
[root@fc6 Linux]# yum install libaio
Loading "installonlyn" plugin
Setting up Install Process
Setting up repositories
http://rpm.livna.org/fedora/6/i386/repodata/repomd.xml: [Errno 12] Timeout:
Trying other mirror.
livna 100% |=========================| 1.1 kB 00:00
gst-0.10-apps 100% |=========================| 951 B 00:00
updates 100% |=========================| 1.2 kB 00:00
core 100% |=========================| 1.1 kB 00:00
freshrpms 100% |=========================| 1.1 kB 00:00
gst-0.10-deps 100% |=========================| 951 B 00:00
extras 1.1 kB 00:00
gst-0.10-gst 100% |=========================| 951 B 00:00
Reading repository metadata in from local files
primary.xml.gz 1.8 MB 00:11
extras : ################################################## 5718/5718
Excluding Packages from Livna for Fedora Core 6 - i386 - Base
Finished
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for libaio to pack into transaction set.
libaio-0.3.106-3.2.i386.r 100% |=========================| 7.7 kB 00:00
---> Package libaio.i386 0:0.3.106-3.2 set to be updated
--> Running transaction check
Dependencies Resolved
=============================================================================
Package Arch Version Repository Size
=============================================================================
Installing:
libaio i386 0.3.106-3.2 core 19 k
Transaction Summary
=============================================================================
Install 1 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 19 k
Is this ok [y/N]: y
Downloading Packages:
(1/1): libaio-0.3.106-3.2 100% |=========================| 19 kB 00:00
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: libaio ######################### [1/1]
Installed: libaio.i386 0:0.3.106-3.2
Complete!
[root@fc6 Linux]# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm
Preparing... ########################################### [100%]
1:oracle-xe-univ ########################################### [100%]
Executing Post-install steps...
You must run '/etc/init.d/oracle-xe configure' as the root user to
configure the database.
[root@fc6 Linux]# /etc/init.d/oracle-xe configure
Oracle Database 10g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 10g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press
Ctrl-C will abort.
Specify the HTTP port that will be used for Oracle Application Express [8080]:
Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:
Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:
Starting Oracle Net Listener...Done
Configuring Database...Done
Starting Oracle Database 10g Express Edition Instance...Done
Installation Completed Successfully.
To access the Database Home Page go to "http://127.0.0.1:8080/apex"
[root@fc6 Linux]#
沒有留言:
張貼留言