資訊理想化的延伸

勞動節這天,因為放假,又剛好是 油桐花季節,
就到土城賞油桐花,
有朋友問這是數位單眼拍的嗎?
其實這是用普通的DC拍的... 真的!
1.階梯

最近有時使用Database 10g R2(10.2.0.3) 的 RMAN(Recovery Manager) 超不順手,因每次進入 RMAN 都會出現入以下這樣的訊息.oracle@ora10g:~> rman target /
rman: can't open target

雖說可以用絕對入徑方式解決:oracle@ora10g:~> $ORACLE_HOME/bin/rman target /Recovery Manager: Release 10.2.0.3.0 - Production on Sat Apr 5 12:26:23 2008Copyright (c) 1982, 2005, Oracle.  All rights reserved.

為了過年拜拜使用...
所以自己動手做了發糕...
沒想到做上癮了...哈哈
祝大家 新年快樂!

想一想,好像沒有寫過 Oracle Database 9i的東西...
就來補個 for RHEL3 安裝說明吧... 雖然說過很久了!
(~修改自創的喔!~)

1.安裝 Linux：
　安裝RHEL AS3時要注意幾點：　　(1)記憶體至少要512MB，硬碟空間至少 4GB 空間給 Oracle Database使用。　　(2)套件安裝時，在程式開發部份，需勾選舊式軟體開發套件。

日前把一些有關 
安裝Apache2,php5,Tomcat4,MySQL,
等安裝資訊設定發表出來,
整理出來的東西發現還挺多的!
當然這是一種學習討論的經驗,
有興趣的朋友歡迎來信批評指教,
並會努力改進的.
完成這些東西~
接下來的努力目標當然是 
Oracle Database  的部份啦!
不過 oracle 的產品真的真的是越來越多了,
也看到了一些報導資訊,真的併了許多大廠,
想學的東西真的學不完阿~
所以~每個人想學習的出發點不同,
因為有興趣的培養才是人生的一大樂事!

完整啟動順序:
1) 啟動 MySQL:
/usr/local/mysql/support-files/mysql.server start2) 啟動 tomcat:
export CATALINA_HOME=/usr/local/tomcat
export JAVA_HOME=/usr/java/jdk1.5.0_10   ( 自訂:視版本而定喔!)
export CLASSPATH=/usr/local/tomcat/common/lib/servlet.jar
$CATALINA_HOME/bin/startup.sh &3) 啟動 Apache:
/usr/local/apache/bin/apachectl -k start====================================================

完整關閉順序:1) 關閉 MySQL:
/usr/local/mysql/support-files/mysql.server stop2) 關閉 tomcat:
export CATALINA_HOME=/usr/local/tomcat
export JAVA_HOME=/usr/java/jdk1.5.0_10    ( 自訂:視版本而定喔!)
export CLASSPATH=/usr/local/tomcat/common/lib/servlet.jar
$CATALINA_HOME/bin/shutdown.sh &3) 關閉 Apache:/usr/local/apache/bin/apachectl -k stop====================================================
vi all_start.local
---
#Startup MySQL
/usr/local/mysql/support-files/mysql.server start &#Startup Tomcat
export CATALINA_HOME=/usr/local/tomcat
export JAVA_HOME=/usr/java/jdk1.5.0_10 ( 自訂:視版本而定喔!)
export CLASSPATH=/usr/local/tomcat/common/lib/servlet.jar
$CATALINA_HOME/bin/startup.sh &#Startup Apache
/usr/local/apache/bin/apachectl -k start &====================================================

vi all_stop.local
---#Stop Apache
/usr/local/apache/bin/apachectl -k stop &#Stop Tomcat
export CATALINA_HOME=/usr/local/tomcat
export JAVA_HOME=/usr/java/jdk1.5.0_10  ( 自訂:視版本而定喔!)
export CLASSPATH=/usr/local/tomcat/common/lib/servlet.jar
$CATALINA_HOME/bin/shutdown.sh &#Stop MySQL
/usr/local/mysql/support-files/mysql.server stop &

 [五]安裝 Java 與 Tomcat:
J2SDK: 檔案j2sdk-1_4_1_05-linux-i586-rpm.bin    ( 自訂:視自己想要的版本而定喔!)
#chmod 755 j2sdk-1_4_1_05-linux-i586-rpm.bin
#./j2sdk-1_4_1_05-linux-i586-rpm.bin執行後，它會顯示版權宣告，並出現下列訊息：
Do you agree to the above license terms? [yes or no]
yes
Unpacking...
Checksumming...
0
0
Extracting...
UnZipSFX 5.40 of 28 November 1998, by Info-ZIP (Zip-Bugs@lists.wku.edu).
inflating: j2sdk-1_4_1_05-fcs-linux-i586.rpm
Done.
#解壓後再做安裝命令如下:#rpm -ivh j2sdk-1_4_1_05-linux-i586.rpm安裝後請檢視目錄 /usr/java 是否有產生 j2sdk1.4.1_05 這個目錄。    ( 注意版本喔!!)
====================================================
Linux安裝TOMCAT   檔案: jakarta-tomcat-4.1.29.tar.gztar zxvf jakarta-tomcat-4.1.29.tar.gz
mv jakarta-tomcat-4.1.29/ /usr/local/tomcat
cd /usr/local
chmod -R 755 tomcat

1) 下載最新的JK2 http://www.apache.org/dist/jakarta/tomcat-connectors/jk2/jakarta-tomcat-connectors-jk2-src-current.tar.gz

2)安裝 JK2 模組:
# cd /home/myhome/software/
# tar zxvf jakarta-tomcat-connectors-jk2-src-current.tar.gz
# cd jk2/jk/native2
# ./buildconf.sh
# ./configure --with-apxs2=/usr/local/apache/bin/apxs
# make
# make install

# cp /home/myhome/software/jakarta-tomcat-connectors-jk2-2.0.4-src/jk/build/jk2/apache2/mod_jk2.so /usr/local/apache/modules

3) 把mod_jk2加入 httpd.conf中
# vi /usr/local/apache/conf/httpd.conf
LoadModule jk2_module modules/mod_jk2.so

4) vi /usr/local/tomcat/conf/jk2.properties
把原有位置的相關檔換成下面這些:

# list of needed handlers.
handler.list=channelSocket,request
# Override the default port for the channelSocket
channelSocket.port=8009

 

5) vi /usr/local/apache/conf/workers2.properties
這個是設定檔，
請參考著修改:
# only at beginnin. In production uncomment it out
[logger.apache2]
level=DEBUG

[shm]
file=/usr/local/apache/logs/shm.file
size=1048576

# Example socket channel, override port and host.
[channel.socket:localhost:8009]
port=8009
host=127.0.0.1

# define the worker
[ajp13:localhost:8009]
channel=channel.socket:localhost:8009

# Uri mapping
[uri:127.0.0.1/*.jsp]
worker=ajp13:localhost:8009

[uri:myip.ip.com/*.jsp]
worker=ajp13:localhost:8009

6) vi /usr/local/apache/conf/httpd.conf 虛擬主機配置部分

#…………
#不相關的部分已經省略

NameVirtualHost *:80
<VirtualHost *:80>
ServerAdmin myemil@test.mail.com
DocumentRoot /home/myhome/tomcat_web
ServerName www.myip.org
ErrorLog logs/myweb-error_log
CustomLog logs/myweb-access_log common
Options None
</VirtualHost>

 

7) server.xml 的設定
# vi /usr/local/tomcat/conf/server.xml 的設定

<Server port="8005" shutdown="SHUTDOWN" debug="0">
  <Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"
            debug="0"/>
  <Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"
            debug="0"/>

  <!-- Global JNDI resources -->
  <GlobalNamingResources>

    <!-- Test entry for demonstration purposes -->
    <Environment name="simpleValue" type="java.lang.Integer" value="30"/>

    <!-- Editable user database that can also be used by
         UserDatabaseRealm to authenticate users -->
    <Resource name="UserDatabase" auth="Container"
              type="org.apache.catalina.UserDatabase"
       description="User database that can be updated and saved">
    </Resource>
    <ResourceParams name="UserDatabase">
      <parameter>
        <name>factory</name>
        <value>org.apache.catalina.users.MemoryUserDatabaseFactory</value>;
      </parameter>
      <parameter>
        <name>pathname</name>;
        <value>conf/tomcat-users.xml</value>
      </parameter>
    </ResourceParams>

  </GlobalNamingResources>
  <Service name="Catalina">
    <!-- Define a non-SSL Coyote HTTP/1.1 Connector on port 8080 -->;
    <Connector port="8080"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               debug="0" connectionTimeout="20000"
               disableUploadTimeout="true" />

    <!-- Define a Coyote/JK2 AJP 1.3 Connector on port 8009 -->
    <Connector port="8009"
               enableLookups="false" redirectPort="8443" debug="0"
               protocol="AJP/1.3" />

    <!-- Define the top level container in our container hierarchy -->
    <Engine name="Catalina" defaultHost="localhost" debug="0">

      <!-- Global logger unless overridden at lower levels -->
      <Logger className="org.apache.catalina.logger.FileLogger"
              prefix="catalina_log." suffix=".txt"
              timestamp="true"/>

      <!-- Because this Realm is here, an instance will be shared globally -->

      <!-- This Realm uses the UserDatabase configured in the global JNDI
           resources under the key "UserDatabase".  Any edits
           that are performed against this UserDatabase are immediately
           available for use by the Realm.  -->
      <Realm className="org.apache.catalina.realm.UserDatabaseRealm"
                 debug="0" resourceName="UserDatabase"/>

      <Host name="localhost" debug="0" appBase="webapps"
       unpackWARs="true" autoDeploy="true"
       xmlValidation="false" xmlNamespaceAware="false">

        <Logger className="org.apache.catalina.logger.FileLogger"
                 directory="logs"  prefix="localhost_log." suffix=".txt"
            timestamp="true"/>

        <!-- Tomcat Root Context -->
        <!--
          <Context path="" docBase="ROOT" debug="0">
        -->

      </Host>

      <Host name="hsinichi.no-ip.org" debug="0" appBase="webapps"
       unpackWARs="true" autoDeploy="true"
       xmlValidation="false" xmlNamespaceAware="false">

        <Logger className="org.apache.catalina.logger.FileLogger"
                 directory="logs"  prefix="lawcn_log." suffix=".txt"
            timestamp="true"/>
          <Context path="" docBase="lawcn" debug="0" />
      </Host>

    </Engine>

  </Service>

</Server>

====================================================
----------tomcat 4.1.31 VirtualHost 設法---------------
#mkdir -p /home/myhome/tomcat_web/
#mkdir -p /home/myhome/tomcat_web/logs
#vi server.xml
     <Host name="hsinichi.no-ip.org" appBase="/home/myhome/tomcat_web" unpackWARs="true" autoDeploy="true">
       <Logger className="org.apache.catalina.logger.FileLogger"
                 directory="/home/myhome/tomcat_web/logs"  prefix="web_log." suffix=".txt"
            timestamp="true"/>
         <Context path="" docBase="."/>
     </Host>

 

 

[四]安裝GD Graphics Library 與 安裝php5
a.安裝 jpeg6 部份﹕
# mkdir -p /usr/local/jpeg6
# mkdir -p /usr/local/jpeg6/bin
# mkdir -p /usr/local/jpeg6/lib
# mkdir -p /usr/local/jpeg6/include
# mkdir -p /usr/local/jpeg6/man
# mkdir -p /usr/local/jpeg6/man1
# mkdir -p /usr/local/jpeg6/man/man1

[三]安裝mysql 5.0
# cd /home/myhome/software/
# tar zvxf mysql-5.0.45-linux-i686-glibc23.tar.gz
# mkdir -p /usr/local/mysql （省略也可）
# cp -r mysql-5.0.45-linux-i686-glibc23/* /usr/local/mysql/
# cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf
# chmod 600 /etc/my.cnf

[二]安裝apache2。
# cd /home/myhome/software/(解壓縮httpd-2.2.4.tar.gz )
# tar zvxf httpd-2.2.4.tar.gz # cd httpd-2.2.4建立 /usr/local/apache 目錄
# mkdir -p /usr/local/apache  
# ./configure --prefix=/usr/local/apache
   或者 
# ./configure --prefix=/usr/local/apache --enable-modules=so --enable-rewrite