fedora10 下安裝 oracle xe
amd64位下安裝了fedora10,f10上安裝oracle一直有問題,先是安裝9.2.0.4,好像說版本問題。10g和xe都下了,先裝了xe。
xe出來的時候好像正是快畢業了,想當年畢業設計居然是oracle有關的,以前從來沒有想過會從事這個行當,三年了,居然還是在原地,從來沒有離開過。。恨死電腦城那幫奸商了,當時下血本買了一張10快錢的oracle9i,結果少檔案,裝不上去,當時也只有256m記憶體,窮酸的。後來找同學勻了根256,總算有了512m記憶體。9i裝不了,就下了個最新的版本--xe。 (6人共用的網路,下下來還真廢了些功夫,網內有玩wow的。。。)當時的系統是redhat9,是另外一個兄弟話大價錢買的盤,可惜當時沒有大點的u盤,結果下的xe只在windows下裝了,而且還不會配置監聽和tns,最終還是沒有起來。後來畢業設計就抄抄混混過去了,sql都不會幾個(當時只會點mysql)。
總是不會想到後來會發生什麼的,年輕有太多的不確定了,以前是這樣,現在仍然是這樣,隨遇而安把(巨蟒拼音太爛了,這個詞打我半天,擦)。
fedora10下裝東西,就一個真理,少東西的時候,儘管用yum install。桌面版就是桌面版。
現在的2g記憶體也少了可憐,裝個vmware要跳樓。放棄了,只能在系統下裝了,公司的環境就是好阿,主機上直接虛擬了個紅帽,裝了個10g,很high,總算有了自己的系統和資料庫。
google上此類文章太少,或者不全,要知道一篇好的入門指引,有的時候對於一個求問的人來說太重要了,有時甚至會影響一個人的人生軌跡。。
我來個大合集把,完全按照下面的方法肯定會有問題,但是肯定都可以解決:
1,先建立oracle使用者和組
[root@yellow] su -
[root@yellow]# groupadd oinstall
[root@yellow]# groupadd dba
[root@yellow]# useradd -g oinstall -G dba oracle
[root@yellow]# passwd oracle
2,建立安裝目錄,mkdir,建立oracle的主目錄,根據個人來定。
完了之後不管三七二十一,先裝一把再說:
下到的rpm包的目錄,更改以下設定,或者位置,保證oracle使用者可以訪問即可。
然後在root下:rpm -ivh oraclexe.rpm(略寫)
然後看情況,少什麼yum 什麼,應該很快可以完成。
裝完之後會提示設定http的埠和監聽埠,預設是8080和1521,8080最好改以下,因為apache的預設埠也是8080,修改比如:8000
完了之後:
e@yellow bin]$ ps -ef | grep ora
root 1801 1656 0 03:29 ? 00:00:00 hald-addon-storage: polling /dev/sr0 (every 2 sec)
oracle 2224 1 0 03:29 ? 00:00:00 /usr/bin/gnome-keyring-daemon -d --login
oracle 2226 2188 0 03:29 ? 00:00:00 gnome-session
oracle 2242 1 0 03:29 ? 00:00:00 dbus-launch --sh-syntax --exit-with-session
oracle 2243 1 0 03:29 ? 00:00:00 /bin/dbus-daemon --fork --print-pid 7 --print-address 9 --session
oracle 2286 1 0 03:29 ? 00:00:00 /usr/libexec/im-settings-daemon
oracle 2288 1 0 03:29 ? 00:00:00 /usr/libexec/im-info-daemon
oracle 2290 1 0 03:29 ? 00:00:00 /usr/libexec/gvfsd
oracle 2334 1 0 03:29 ? 00:00:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
oracle 2418 1 0 03:29 ? 00:00:00 /usr/bin/scim
oracle 2420 1 0 03:29 ? 00:00:00 /usr/libexec/gconf-im-settings-daemon
oracle 2422 1 0 03:29 ? 00:00:01 /usr/libexec/gconfd-2
oracle 2424 2226 0 03:29 ? 00:00:00 [Xsession]
oracle 2469 2226 0 03:29 ? 00:00:00 /usr/lib64/gnome-session/helpers/gnome-keyring-daemon-wrapper
oracle 2471 1 0 03:29 ? 00:00:01 /usr/libexec/gnome-settings-daemon
oracle 2472 2226 0 03:29 ? 00:00:03 metacity
oracle 2473 2226 0 03:29 ? 00:00:02 gnome-panel
oracle 2476 2226 0 03:29 ? 00:00:22 nautilus --no-desktop --browser
oracle 2481 1 0 03:29 ? 00:00:00 /usr/libexec/bonobo-activation-server --ac-activate --ior-output-fd=17
oracle 2489 1 0 03:29 ? 00:00:00 /usr/bin/pulseaudio --start --log-target=syslog
oracle 2495 2489 0 03:29 ? 00:00:00 /usr/libexec/pulse/gconf-helper
oracle 2513 1 0 03:29 ? 00:00:05 gnome-screensaver
oracle 2515 1 0 03:29 ? 00:00:00 /usr/libexec/gvfs-hal-volume-monitor
oracle 2518 1 0 03:29 ? 00:00:04 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:GNOME_Wncklet_Factory --oaf-ior-fd=20
oracle 2522 1 0 03:29 ? 00:00:00 /usr/libexec/trashapplet --oaf-activate-iid=OAFIID:GNOME_Panel_TrashApplet_Factory --oaf-ior-fd=26
oracle 2525 1 0 03:29 ? 00:00:00 /usr/libexec/gvfs-gphoto2-volume-monitor
oracle 2530 1 0 03:29 ? 00:00:00 /usr/libexec/gvfsd-trash --spawner :1.4 /org/gtk/gvfs/exec_spaw/1
oracle 2534 1 0 03:29 ? 00:00:00 /usr/libexec/gvfsd-burn --spawner :1.4 /org/gtk/gvfs/exec_spaw/2
oracle 2543 1 0 03:30 ? 00:00:00 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID:GNOME_MixerApplet_Factory --oaf-ior-fd=24
oracle 2547 1 0 03:30 ? 00:00:00 /usr/libexec/gdm-user-switch-applet --oaf-activate-iid=OAFIID:GNOME_FastUserSwitchApplet_Factory --oaf-ior-fd=36
oracle 2548 1 0 03:30 ? 00:00:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:GNOME_ClockApplet_Factory --oaf-ior-fd=30
oracle 2551 1 0 03:30 ? 00:00:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-ior-fd=44
oracle 2552 1 0 03:30 ? 00:00:01 mono /usr/lib64/tomboy/Tomboy.exe --panel-applet --oaf-activate-iid=OAFIID:TomboyApplet_Factory --oaf-ior-fd=52
oracle 2556 1 0 03:30 ? 00:00:00 /usr/libexec/gvfsd-cdda --spawner :1.4 /org/gtk/gvfs/exec_spaw/3
oracle 2588 2226 0 03:30 ? 00:00:00 imsettings-applet --disable-xsettings
oracle 2598 2226 0 03:30 ? 00:00:00 nm-applet --sm-disable
oracle 2601 2226 0 03:30 ? 00:00:00 kerneloops-applet
oracle 2602 2226 0 03:30 ? 00:00:00 bluetooth-applet
oracle 2603 2226 0 03:30 ? 00:00:00 gpk-update-icon
oracle 2604 1 0 03:30 ? 00:00:00 /usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay
oracle 2605 2418 0 03:30 ? 00:00:00 /usr/lib64/scim-1.0/scim-launcher -c socket -e socket -f x11
oracle 2606 2226 0 03:30 ? 00:00:00 python /usr/share/system-config-printer/applet.py
oracle 2609 1 0 03:30 ? 00:00:00 gnome-power-manager
oracle 2625 1 0 03:30 ? 00:00:00 /usr/bin/python -E /usr/bin/sealert -s
oracle 2646 1 0 03:30 ? 00:00:00 /usr/lib64/scim-1.0/scim-helper-manager
oracle 2647 1 0 03:30 ? 00:00:03 /usr/lib64/scim-1.0/scim-panel-gtk --display :0.0 -c socket -d --no-stay
oracle 2673 1 0 03:30 ? 00:00:04 gnome-terminal
oracle 2687 1 0 03:30 ? 00:00:01 scim-bridge
oracle 2688 2673 0 03:30 ? 00:00:00 gnome-pty-helper
oracle 2689 2673 0 03:30 pts/0 00:00:00 bash
oracle 2732 1 0 03:31 ? 00:00:00 /bin/sh /usr/lib64/firefox-3.0.4/run-mozilla.sh /usr/lib64/firefox-3.0.4/firefox -UILocale zh-CN
oracle 2749 2732 8 03:31 ? 00:04:27 /usr/lib64/firefox-3.0.4/firefox -UILocale zh-CN
oracle 3616 1 0 04:02 ? 00:00:00 /usr/libexec/notification-daemon
oracle 4017 1 0 04:15 ? 00:00:00 /usr/libexec/gvfsd-computer --spawner :1.4 /org/gtk/gvfs/exec_spaw/4
oracle 4229 2689 6 04:26 pts/0 00:00:00 ps -ef
oracle 4230 2689 0 04:26 pts/0 00:00:00 grep ora
[oracle@yellow bin]$
[oracle@yellow bin]$ ll
總計 97324
-r-xr-xr-x 1 oracle dba 13093 2006-01-30 adapters
-r-xr-xr-x 1 oracle dba 40340 2006-02-20 agtctl
-rwxr-xr-x 1 oracle dba 8440 2006-01-30 createdb.sh
-r-xr-xr-x 1 oracle dba 417644 2006-02-20 ctxkbtc
-r-xr-xr-x 1 oracle dba 384752 2006-02-20 ctxlc
-r-xr-xr-x 1 oracle dba 135244 2006-02-20 ctxload
-r-xr-xr-x 1 oracle dba 22336 2006-02-20 cursize
-r-xr-xr-x 1 oracle dba 6672 2006-02-20 dbfsize
-r-xr-xr-x 1 oracle dba 281840 2006-02-20 dbv
-r-xr-xr-x 1 oracle dba 1564544 2006-02-20 dgmgrl
-r-xr-xr-x 1 oracle dba 7652 2006-02-20 dumpsga
-r-xr-xr-x 1 oracle dba 519664 2006-02-20 exp
-r-xr-xr-x 1 oracle dba 153344 2006-02-20 expdp
-r-xr-xr-x 1 oracle dba 32068 2006-02-20 extjob
-r-xr-xr-x 1 oracle dba 19496 2006-02-20 extproc
-r-xr-xr-x 1 oracle dba 470176 2006-02-20 fmputl
-r-xr-xr-x 1 oracle dba 6800 2006-02-20 fmputlhp
-r-xr-xr-x 1 oracle dba 327828 2006-02-20 genksms
-r-xr-xr-x 1 oracle dba 2893 2006-01-30 gennfgt
-r-xr-xr-x 1 oracle dba 4902 2006-01-30 gennttab
-r-xr-xr-x 1 oracle dba 488436 2006-02-20 grdcscan
-r-xr-xr-x 1 oracle dba 102144 2006-02-20 hsalloci
-r-xr-xr-x 1 oracle dba 25036 2006-02-20 hsdepxa
-r-xr-xr-x 1 oracle dba 1102900 2006-02-20 hsodbc
-r-xr-xr-x 1 oracle dba 24080 2006-02-20 hsots
-r-xr-xr-x 1 oracle dba 249232 2006-02-20 imp
-r-xr-xr-x 1 oracle dba 156356 2006-02-20 impdp
-r-xr-xr-x 1 oracle dba 283408 2006-02-20 kgmgr
-r-xr-xr-x 1 oracle dba 2533300 2006-02-20 kgpmon
-r-xr-xr-x 1 oracle dba 9932 2006-02-20 loadpsp
-r-xr-xr-x 1 oracle dba 68948 2006-02-20 lsnrctl
-r-xr-xr-x 1 oracle dba 389920 2006-02-20 lxchknlb
-r-xr-xr-x 1 oracle dba 7984 2006-02-20 mapsga
-r-xr-xr-x 1 oracle dba 6696 2006-02-20 maxmem
-r-xr-xr-x 1 oracle dba 103748 2006-02-20 nid
-rwxr-xr-x 1 oracle dba 16691 2006-01-30 nls_lang.sh
-r-xr-xr-x 1 oracle dba 866972 2006-02-20 ons
-rwsr-s--x 1 oracle dba 74016852 2006-02-20 oracle
-rwxr-xr-x 1 oracle dba 314 2006-01-30 oracle_env.csh
-rwxr-xr-x 1 oracle dba 360 2006-01-30 oracle_env.sh
-r-xr-xr-x 1 oracle dba 8480 2006-02-20 oradism
-r-xr-xr-x 1 oracle dba 2947 2006-01-30 oraenv
-r-xr-xr-x 1 oracle dba 11600 2006-02-20 orapwd
-r-xr-xr-x 1 oracle dba 4416 2006-02-20 osdbagrp
-r-xr-xr-x 1 oracle dba 5884 2006-02-20 osh
-r-xr-xr-x 1 oracle dba 773 2006-01-30 ott
-r-xr-xr-x 1 oracle dba 8911600 2006-02-20 rman
-r-xr-xr-x 1 oracle dba 79904 2006-02-20 sbttest
-r-xr-xr-x 1 oracle dba 557908 2006-02-20 sqlldr
-rwxr-xr-x 1 oracle dba 4304 2006-02-20 sqlplus
-r-xr-xr-x 1 oracle dba 11924 2006-02-20 sysresv
-r-xr-xr-x 1 oracle dba 18896 2006-02-20 tg4pwd
-r-xr-xr-x 1 oracle dba 98552 2006-02-20 tkprof
-r-xr-xr-x 1 oracle dba 270888 2006-02-20 tnslsnr
-r-xr-xr-x 1 oracle dba 8272 2006-02-20 tnsping
-r-xr-xr-x 1 oracle dba 82592 2006-02-20 trcldr
-r-xr-xr-x 1 oracle dba 14060 2006-02-20 trcroute
-r-xr-xr-x 1 oracle dba 14080 2006-02-20 tstshm
-r-xr-xr-x 1 oracle dba 100624 2006-02-20 unzip
-r-xr-xr-x 1 oracle dba 4176688 2006-02-20 wrap
-r-xr-xr-x 1 oracle dba 62720 2006-02-20 zip
[oracle@yellow bin]$
e@yellow ~]$ ps axl | grep ora
4 0 1811 1658 20 0 19996 1000 - S ? 0:00 hald-addon-storage: polling /dev/sr0 (every 2 sec)
1 501 2357 1 20 0 70616 2404 futex_ Ssl ? 0:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
0 501 2699 2671 20 0 85004 788 pipe_w S+ pts/0 0:00 grep ora
[oracle@yellow ~]$ ps axl | grep ora
4 0 1811 1658 20 0 19996 1000 - S ? 0:00 hald-addon-storage: polling /dev/sr0 (every 2 sec)
1 501 2357 1 20 0 70616 2404 futex_ Ssl ? 0:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
0 501 2701 2671 20 0 85004 784 - R+ pts/0 0:00 grep ora
[oracle@yellow ~]$ ps aux | grep ora
root 1811 0.0 0.0 19996 1000 ? S 17:04 0:00 hald-addon-storage: polling /dev/sr0 (every 2 sec)
oracle 2225 0.0 0.1 58940 2016 ? S 17:04 0:00 /usr/bin/gnome-keyring-daemon -d --login
oracle 2227 0.4 0.3 304408 7784 ? Ssl 17:04 0:00 gnome-session
oracle 2243 0.0 0.0 21616 560 ? S 17:04 0:00 dbus-launch --sh-syntax --exit-with-session
oracle 2244 0.3 0.0 29904 1560 ? Ssl 17:04 0:00 /bin/dbus-daemon --fork --print-pid 7 --print-address 9 --session
oracle 2287 0.0 0.1 42516 2156 ? S 17:04 0:00 /usr/libexec/im-settings-daemon
oracle 2289 0.0 0.1 43848 2736 ? S 17:04 0:00 /usr/libexec/im-info-daemon
oracle 2291 0.0 0.1 116004 2040 ? S 17:04 0:00 /usr/libexec/gvfsd
oracle 2357 0.0 0.1 70616 2404 ? Ssl 17:04 0:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
oracle 2419 0.0 0.0 97692 1332 ? S 17:04 0:00 /usr/bin/scim
oracle 2421 0.0 0.1 39880 2136 ? S 17:04 0:00 /usr/libexec/gconf-im-settings-daemon
oracle 2423 1.2 0.3 120536 6712 ? S 17:04 0:00 /usr/libexec/gconfd-2
oracle 2425 0.0 0.0 0 0 ? Z 17:04 0:00 [Xsession]
oracle 2476 0.0 0.1 185052 3132 ? S 17:04 0:00 /usr/lib64/gnome-session/helpers/gnome-keyring-daemon-wrapper
oracle 2477 0.8 0.7 401644 15364 ? Ssl 17:04 0:00 /usr/libexec/gnome-settings-daemon
oracle 2479 0.3 0.6 235152 13400 ? S 17:04 0:00 metacity
oracle 2482 1.1 0.9 318564 19352 ? S 17:04 0:00 gnome-panel
oracle 2483 2.2 1.6 512880 32532 ? S 17:04 0:01 nautilus --no-desktop --browser
oracle 2488 0.3 0.1 223756 3348 ? Ssl 17:04 0:00 /usr/libexec/bonobo-activation-server --ac-activate --ior-output-fd=17
oracle 2498 0.3 0.2 378168 5016 ? Ssl 17:04 0:00 /usr/bin/pulseaudio --start --log-target=syslog
oracle 2515 0.0 0.1 59676 2176 ? S 17:04 0:00 /usr/libexec/pulse/gconf-helper
oracle 2516 0.2 0.1 316820 3168 ? Ss 17:04 0:00 gnome-screensaver
oracle 2522 0.0 0.1 128884 2960 ? Sl 17:04 0:00 /usr/libexec/gvfs-hal-volume-monitor
oracle 2524 0.0 0.1 114152 2140 ? S 17:04 0:00 /usr/libexec/gvfs-gphoto2-volume-monitor
oracle 2526 0.0 0.1 128640 2716 ? S 17:04 0:00 /usr/libexec/gvfsd-trash --spawner :1.4 /org/gtk/gvfs/exec_spaw/0
oracle 2533 0.0 0.4 302984 9872 ? S 17:04 0:00 /usr/libexec/trashapplet --oaf-activate-iid=OAFIID:GNOME_Panel_TrashApplet_Factory --oaf-ior-fd=26
oracle 2534 0.3 0.9 318792 18172 ? S 17:04 0:00 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:GNOME_Wncklet_Factory --oaf-ior-fd=20
oracle 2539 0.0 0.1 116048 2080 ? S 17:04 0:00 /usr/libexec/gvfsd-burn --spawner :1.4 /org/gtk/gvfs/exec_spaw/1
oracle 2542 0.0 0.1 135268 2188 ? S 17:04 0:00 /usr/libexec/gvfsd-cdda --spawner :1.4 /org/gtk/gvfs/exec_spaw/2
oracle 2559 0.5 0.9 364796 18332 ? Sl 17:05 0:00 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID:GNOME_MixerApplet_Factory --oaf-ior-fd=24
oracle 2562 0.5 0.7 370200 15368 ? S 17:05 0:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:GNOME_ClockApplet_Factory --oaf-ior-fd=30
oracle 2566 0.4 0.7 309556 15700 ? S 17:05 0:00 /usr/libexec/gdm-user-switch-applet --oaf-activate-iid=OAFIID:GNOME_FastUserSwitchApplet_Factory --oaf-ior-fd=36
oracle 2568 0.2 0.4 294120 8740 ? S 17:05 0:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-ior-fd=42
oracle 2571 2.8 1.4 429824 29828 ? Sl 17:05 0:01 mono /usr/lib64/tomboy/Tomboy.exe --panel-applet --oaf-activate-iid=OAFIID:TomboyApplet_Factory --oaf-ior-fd=48
oracle 2596 0.1 0.3 228024 7068 ? S 17:05 0:00 imsettings-applet --disable-xsettings
oracle 2602 0.2 0.5 277500 11464 ? S 17:05 0:00 nm-applet --sm-disable
oracle 2607 0.1 0.2 213728 5824 ? S 17:05 0:00 kerneloops-applet
oracle 2609 0.1 0.3 218740 7508 ? S 17:05 0:00 bluetooth-applet
oracle 2610 0.1 0.4 244696 8648 ? S 17:05 0:00 gpk-update-icon
oracle 2612 0.4 0.9 307132 18452 ? S 17:05 0:00 python /usr/share/system-config-printer/applet.py
oracle 2613 0.1 0.4 319808 9172 ? Ss 17:05 0:00 gnome-power-manager
oracle 2624 0.1 2.5 311964 50100 ? Ss 17:05 0:00 /usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay
oracle 2625 0.2 0.1 118144 3476 ? S 17:05 0:00 /usr/lib64/scim-1.0/scim-launcher -c socket -e socket -f x11
oracle 2632 1.0 1.7 444372 34020 ? S 17:05 0:00 /usr/bin/python -E /usr/bin/sealert -s
oracle 2651 0.0 0.1 194132 3012 ? Ss 17:05 0:00 /usr/lib64/scim-1.0/scim-helper-manager
oracle 2652 0.1 0.4 230336 9032 ? Ssl 17:05 0:00 /usr/lib64/scim-1.0/scim-panel-gtk --display :0.0 -c socket -d --no-stay
oracle 2656 1.6 1.5 398600 30692 ? Sl 17:05 0:00 gnome-terminal
oracle 2669 0.0 2.5 311860 50032 ? S 17:05 0:00 scim-bridge
oracle 2670 0.0 0.0 11024 668 ? S 17:05 0:00 gnome-pty-helper
oracle 2671 0.0 0.0 89992 1688 pts/0 Ss 17:05 0:00 bash
oracle 2702 0.0 0.0 89812 1036 pts/0 R+ 17:05 0:00 ps aux
oracle 2703 0.0 0.0 85004 780 pts/0 R+ 17:05 0:00 grep ora
[oracle@yellow ~]$ sqlplus
bash: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus: /lib/ld-linux.so.2: bad ELF interpreter: 沒有那個檔案或目錄
[oracle@yellow ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:10:55 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱: sys
輸入口令:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
SP2-0157: 在 3 次嘗試之後無法連線到 ORACLE, 退出 SQL*Plus
[oracle@yellow ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:11:36
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
[oracle@yellow ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:12:07
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
[oracle@yellow ~]$ cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
[oracle@yellow server]$ ls
bin ctx demo jdbc ldap network odbc oracore precomp slax xdk
config dbs hs jlib lib nls opmn plsql rdbms sqlplus
[oracle@yellow server]$ cd network
[oracle@yellow network]$ ls
admin install lib log mesg trace
[oracle@yellow network]$ cd admin
[oracle@yellow admin]$ ll
總計 12
-r--r--r-- 1 oracle dba 456 2006-01-30 listener.ora
drwxr-xr-x 2 oracle dba 4096 08-16 11:57 samples
-r--r--r-- 1 oracle dba 597 08-18 05:12 tnsnames.ora
[oracle@yellow admin]$ vi tnsnames.ora
[已修改但尚未儲存]
請按 ENTER 或其它命令繼續
[oracle@yellow admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:14:57
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
e@yellow ~]$ sqlplus
bash: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus: /lib/ld-linux.so.2: bad ELF interpreter: 沒有那個檔案或目錄
[oracle@yellow ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:10:55 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱: sys
輸入口令:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
SP2-0157: 在 3 次嘗試之後無法連線到 ORACLE, 退出 SQL*Plus
[oracle@yellow ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:11:36
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
[oracle@yellow ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:12:07
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
[oracle@yellow ~]$ cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
[oracle@yellow server]$ ls
bin ctx demo jdbc ldap network odbc oracore precomp slax xdk
config dbs hs jlib lib nls opmn plsql rdbms sqlplus
[oracle@yellow server]$ cd network
[oracle@yellow network]$ ls
admin install lib log mesg trace
[oracle@yellow network]$ cd admin
[oracle@yellow admin]$ ll
總計 12
-r--r--r-- 1 oracle dba 456 2006-01-30 listener.ora
drwxr-xr-x 2 oracle dba 4096 08-16 11:57 samples
-r--r--r-- 1 oracle dba 597 08-18 05:12 tnsnames.ora
[oracle@yellow admin]$ vi tnsnames.ora
[已修改但尚未儲存]
請按 ENTER 或其它命令繼續
[oracle@yellow admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:14:57
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
[oracle@yellow admin]$ vi tnsnames.ora
[oracle@yellow admin]$ vi linsener.ora
[oracle@yellow admin]$ vi listener.ora
[oracle@yellow admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:18:23
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
正在連線到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
LISTENER 的 STATUS
------------------------
別名 LISTENER
版本 TNSLSNR for Linux: Version 10.2.0.1.0 - Production
啟動日期 22-8月 -2009 17:18:23
正常執行時間 0 天 0 小時 0 分 0 秒
跟蹤級別 off
安全性 ON: Local OS Authentication
SNMP OFF
預設服務 XE
監聽程式引數檔案 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
監聽程式日誌檔案 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
監聽端點概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
服務摘要..
服務 "PLSExtProc" 包含 1 個例程。
例程 "PLSExtProc", 狀態 UNKNOWN, 包含此服務的 1 個處理程式...
命令執行成功
[oracle@yellow admin]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:18:29 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
SP2-0157: 在 3 次嘗試之後無法連線到 ORACLE, 退出 SQL*Plus
[oracle@yellow admin]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:19:52 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
SP2-0157: 在 3 次嘗試之後無法連線到 ORACLE, 退出 SQL*Plus
[oracle@yellow admin]$ ll
總計 20
-r--r--r-- 1 oracle dba 453 08-22 17:18 listener.ora
drwxr-xr-x 2 oracle dba 4096 08-16 11:57 samples
-rw-r--r-- 1 oracle oinstall 5288 08-22 17:24 sqlnet.log
-r--r--r-- 1 oracle dba 594 08-22 17:14 tnsnames.ora
[oracle@yellow admin]$ vi sqlnet.log
[oracle@yellow admin]$ vi listener.ora
[oracle@yellow admin]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:33:16 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱: sys/sys as sysdba
已連線到空閒例程。
SQL> select * from dua;
select * from dua
*
第 1 行出現錯誤:
ORA-01034: ORACLE not available
SQL> select * from dual;
select * from dual
*
第 1 行出現錯誤:
ORA-01034: ORACLE not available
SQL> alter database open;
alter database open
*
第 1 行出現錯誤:
ORA-01034: ORACLE not available
SQL> select * from dual;
select * from dual
*
第 1 行出現錯誤:
ORA-01034: ORACLE not available
SQL> quit
已斷開連線
[oracle@yellow admin]$ ps - ef |grep ora
ERROR: Garbage option.
********* simple selection ********* ********* selection by list *********
-A all processes -C by command name
-N negate selection -G by real group ID (supports names)
-a all w/ tty except session leaders -U by real user ID (supports names)
-d all except session leaders -g by session OR by effective group name
-e all processes -p by process ID
T all processes on this terminal -s processes in the sessions given
a all w/ tty, including other users -t by tty
g OBSOLETE -- DO NOT USE -u by effective user ID (supports names)
r only running processes U processes for specified users
x processes w/o controlling ttys t by tty
*********** output format ********** *********** long options ***********
-o,o user-defined -f full --Group --User --pid --cols --ppid
-j,j job control s signal --group --user --sid --rows --info
-O,O preloaded -o v virtual memory --cumulative --format --deselect
-l,l long u user-oriented --sort --tty --forest --version
-F extra full X registers --heading --no-heading --context
********* misc options *********
-V,V show version L list format codes f ASCII art forest
-m,m,-L,-T,H threads S children in sum -y change -l format
-M,Z security data c true command name -c scheduling class
-w,w wide output n numeric WCHAN,UID -H process hierarchy
[oracle@yellow admin]$ ps -ef |grep ora
root 1811 1658 0 17:04 ? 00:00:00 hald-addon-storage: polling /dev/sr0 (every 2 sec)
oracle 2225 1 0 17:04 ? 00:00:00 /usr/bin/gnome-keyring-daemon -d --login
oracle 2227 2189 0 17:04 ? 00:00:00 gnome-session
oracle 2243 1 0 17:04 ? 00:00:00 dbus-launch --sh-syntax --exit-with-session
oracle 2244 1 0 17:04 ? 00:00:00 /bin/dbus-daemon --fork --print-pid 7 --print-address 9 --session
oracle 2287 1 0 17:04 ? 00:00:00 /usr/libexec/im-settings-daemon
oracle 2289 1 0 17:04 ? 00:00:00 /usr/libexec/im-info-daemon
oracle 2291 1 0 17:04 ? 00:00:00 /usr/libexec/gvfsd
oracle 2357 1 0 17:04 ? 00:00:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
oracle 2419 1 0 17:04 ? 00:00:00 /usr/bin/scim
oracle 2421 1 0 17:04 ? 00:00:00 /usr/libexec/gconf-im-settings-daemon
oracle 2423 1 0 17:04 ? 00:00:01 /usr/libexec/gconfd-2
oracle 2425 2227 0 17:04 ? 00:00:00 [Xsession]
oracle 2476 2227 0 17:04 ? 00:00:00 /usr/lib64/gnome-session/helpers/gnome-keyring-daemon-wrapper
oracle 2477 1 0 17:04 ? 00:00:01 /usr/libexec/gnome-settings-daemon
oracle 2479 2227 0 17:04 ? 00:00:04 metacity
oracle 2482 2227 0 17:04 ? 00:00:01 gnome-panel
oracle 2483 2227 0 17:04 ? 00:00:07 nautilus --no-desktop --browser
oracle 2488 1 0 17:04 ? 00:00:00 /usr/libexec/bonobo-activation-server --ac-activate --ior-output-fd=17
oracle 2498 1 0 17:04 ? 00:00:00 /usr/bin/pulseaudio --start --log-target=syslog
oracle 2515 2498 0 17:04 ? 00:00:00 /usr/libexec/pulse/gconf-helper
oracle 2516 1 0 17:04 ? 00:00:05 gnome-screensaver
oracle 2522 1 0 17:04 ? 00:00:00 /usr/libexec/gvfs-hal-volume-monitor
oracle 2524 1 0 17:04 ? 00:00:00 /usr/libexec/gvfs-gphoto2-volume-monitor
oracle 2526 1 0 17:04 ? 00:00:00 /usr/libexec/gvfsd-trash --spawner :1.4 /org/gtk/gvfs/exec_spaw/0
oracle 2533 1 0 17:04 ? 00:00:00 /usr/libexec/trashapplet --oaf-activate-iid=OAFIID:GNOME_Panel_TrashApplet_Factory --oaf-ior-fd=26
oracle 2534 1 0 17:04 ? 00:00:07 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:GNOME_Wncklet_Factory --oaf-ior-fd=20
oracle 2539 1 0 17:04 ? 00:00:00 /usr/libexec/gvfsd-burn --spawner :1.4 /org/gtk/gvfs/exec_spaw/1
oracle 2542 1 0 17:04 ? 00:00:00 /usr/libexec/gvfsd-cdda --spawner :1.4 /org/gtk/gvfs/exec_spaw/2
oracle 2559 1 0 17:05 ? 00:00:00 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID:GNOME_MixerApplet_Factory --oaf-ior-fd=24
oracle 2562 1 0 17:05 ? 00:00:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:GNOME_ClockApplet_Factory --oaf-ior-fd=30
oracle 2566 1 0 17:05 ? 00:00:00 /usr/libexec/gdm-user-switch-applet --oaf-activate-iid=OAFIID:GNOME_FastUserSwitchApplet_Factory --oaf-ior-fd=36
oracle 2568 1 0 17:05 ? 00:00:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-ior-fd=42
oracle 2571 1 0 17:05 ? 00:00:01 mono /usr/lib64/tomboy/Tomboy.exe --panel-applet --oaf-activate-iid=OAFIID:TomboyApplet_Factory --oaf-ior-fd=48
oracle 2596 2227 0 17:05 ? 00:00:00 imsettings-applet --disable-xsettings
oracle 2602 2227 0 17:05 ? 00:00:00 nm-applet --sm-disable
oracle 2607 2227 0 17:05 ? 00:00:00 kerneloops-applet
oracle 2609 2227 0 17:05 ? 00:00:00 bluetooth-applet
oracle 2610 2227 0 17:05 ? 00:00:00 gpk-update-icon
oracle 2612 2227 0 17:05 ? 00:00:00 python /usr/share/system-config-printer/applet.py
oracle 2613 1 0 17:05 ? 00:00:00 gnome-power-manager
oracle 2624 1 0 17:05 ? 00:00:00 /usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay
oracle 2625 2419 0 17:05 ? 00:00:00 /usr/lib64/scim-1.0/scim-launcher -c socket -e socket -f x11
oracle 2632 1 0 17:05 ? 00:00:00 /usr/bin/python -E /usr/bin/sealert -s
oracle 2651 1 0 17:05 ? 00:00:00 /usr/lib64/scim-1.0/scim-helper-manager
oracle 2652 1 0 17:05 ? 00:00:02 /usr/lib64/scim-1.0/scim-panel-gtk --display :0.0 -c socket -d --no-stay
oracle 2656 1 0 17:05 ? 00:00:12 gnome-terminal
oracle 2669 1 0 17:05 ? 00:00:01 scim-bridge
oracle 2670 2656 0 17:05 ? 00:00:00 gnome-pty-helper
oracle 2671 2656 0 17:05 pts/0 00:00:00 bash
oracle 2706 1 0 17:06 ? 00:00:00 /bin/sh /usr/lib64/firefox-3.0.4/run-mozilla.sh /usr/lib64/firefox-3.0.4/firefox -UILocale zh-CN
oracle 2723 2706 12 17:06 ? 00:03:57 /usr/lib64/firefox-3.0.4/firefox -UILocale zh-CN
oracle 2743 2656 0 17:06 pts/1 00:00:00 bash
oracle 3015 2656 0 17:15 pts/2 00:00:00 bash
oracle 3048 1 0 17:18 ? 00:00:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit
oracle 3073 1 0 17:26 ? 00:00:00 /usr/libexec/gvfsd-computer --spawner :1.4 /org/gtk/gvfs/exec_spaw/3
oracle 3113 1 0 17:27 ? 00:00:02 gedit /media/disk/oracle/product/10.2.0/db_1/NETWORK/ADMIN/listener.ora
oracle 3121 2656 0 17:29 pts/3 00:00:00 bash
root 3176 2939 0 17:36 pts/1 00:00:00 su - oracle
oracle 3178 3176 0 17:36 pts/1 00:00:00 -bash
root 3226 3178 0 17:36 pts/1 00:00:00 su - oracle
oracle 3231 3226 0 17:36 pts/1 00:00:00 -bash
root 3283 3231 0 17:37 pts/1 00:00:00 su - oracle
oracle 3288 3283 0 17:37 pts/1 00:00:00 -bash
oracle 3339 2671 0 17:38 pts/0 00:00:00 ps -ef
oracle 3340 2671 0 17:38 pts/0 00:00:00 grep ora
[oracle@yellow admin]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:38:52 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
已連線到空閒例程。
SQL> select * from dual;
select * from dual
*
第 1 行出現錯誤:
ORA-01034: ORACLE not available
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> shutdown
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> startup mount
ORA-01078: failure in processing system parameters
LRM-00109:
xe出來的時候好像正是快畢業了,想當年畢業設計居然是oracle有關的,以前從來沒有想過會從事這個行當,三年了,居然還是在原地,從來沒有離開過。。恨死電腦城那幫奸商了,當時下血本買了一張10快錢的oracle9i,結果少檔案,裝不上去,當時也只有256m記憶體,窮酸的。後來找同學勻了根256,總算有了512m記憶體。9i裝不了,就下了個最新的版本--xe。 (6人共用的網路,下下來還真廢了些功夫,網內有玩wow的。。。)當時的系統是redhat9,是另外一個兄弟話大價錢買的盤,可惜當時沒有大點的u盤,結果下的xe只在windows下裝了,而且還不會配置監聽和tns,最終還是沒有起來。後來畢業設計就抄抄混混過去了,sql都不會幾個(當時只會點mysql)。
總是不會想到後來會發生什麼的,年輕有太多的不確定了,以前是這樣,現在仍然是這樣,隨遇而安把(巨蟒拼音太爛了,這個詞打我半天,擦)。
fedora10下裝東西,就一個真理,少東西的時候,儘管用yum install。桌面版就是桌面版。
現在的2g記憶體也少了可憐,裝個vmware要跳樓。放棄了,只能在系統下裝了,公司的環境就是好阿,主機上直接虛擬了個紅帽,裝了個10g,很high,總算有了自己的系統和資料庫。
google上此類文章太少,或者不全,要知道一篇好的入門指引,有的時候對於一個求問的人來說太重要了,有時甚至會影響一個人的人生軌跡。。
我來個大合集把,完全按照下面的方法肯定會有問題,但是肯定都可以解決:
1,先建立oracle使用者和組
[root@yellow] su -
[root@yellow]# groupadd oinstall
[root@yellow]# groupadd dba
[root@yellow]# useradd -g oinstall -G dba oracle
[root@yellow]# passwd oracle
2,建立安裝目錄,mkdir,建立oracle的主目錄,根據個人來定。
完了之後不管三七二十一,先裝一把再說:
下到的rpm包的目錄,更改以下設定,或者位置,保證oracle使用者可以訪問即可。
然後在root下:rpm -ivh oraclexe.rpm(略寫)
然後看情況,少什麼yum 什麼,應該很快可以完成。
裝完之後會提示設定http的埠和監聽埠,預設是8080和1521,8080最好改以下,因為apache的預設埠也是8080,修改比如:8000
完了之後:
e@yellow bin]$ ps -ef | grep ora
root 1801 1656 0 03:29 ? 00:00:00 hald-addon-storage: polling /dev/sr0 (every 2 sec)
oracle 2224 1 0 03:29 ? 00:00:00 /usr/bin/gnome-keyring-daemon -d --login
oracle 2226 2188 0 03:29 ? 00:00:00 gnome-session
oracle 2242 1 0 03:29 ? 00:00:00 dbus-launch --sh-syntax --exit-with-session
oracle 2243 1 0 03:29 ? 00:00:00 /bin/dbus-daemon --fork --print-pid 7 --print-address 9 --session
oracle 2286 1 0 03:29 ? 00:00:00 /usr/libexec/im-settings-daemon
oracle 2288 1 0 03:29 ? 00:00:00 /usr/libexec/im-info-daemon
oracle 2290 1 0 03:29 ? 00:00:00 /usr/libexec/gvfsd
oracle 2334 1 0 03:29 ? 00:00:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
oracle 2418 1 0 03:29 ? 00:00:00 /usr/bin/scim
oracle 2420 1 0 03:29 ? 00:00:00 /usr/libexec/gconf-im-settings-daemon
oracle 2422 1 0 03:29 ? 00:00:01 /usr/libexec/gconfd-2
oracle 2424 2226 0 03:29 ? 00:00:00 [Xsession]
oracle 2469 2226 0 03:29 ? 00:00:00 /usr/lib64/gnome-session/helpers/gnome-keyring-daemon-wrapper
oracle 2471 1 0 03:29 ? 00:00:01 /usr/libexec/gnome-settings-daemon
oracle 2472 2226 0 03:29 ? 00:00:03 metacity
oracle 2473 2226 0 03:29 ? 00:00:02 gnome-panel
oracle 2476 2226 0 03:29 ? 00:00:22 nautilus --no-desktop --browser
oracle 2481 1 0 03:29 ? 00:00:00 /usr/libexec/bonobo-activation-server --ac-activate --ior-output-fd=17
oracle 2489 1 0 03:29 ? 00:00:00 /usr/bin/pulseaudio --start --log-target=syslog
oracle 2495 2489 0 03:29 ? 00:00:00 /usr/libexec/pulse/gconf-helper
oracle 2513 1 0 03:29 ? 00:00:05 gnome-screensaver
oracle 2515 1 0 03:29 ? 00:00:00 /usr/libexec/gvfs-hal-volume-monitor
oracle 2518 1 0 03:29 ? 00:00:04 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:GNOME_Wncklet_Factory --oaf-ior-fd=20
oracle 2522 1 0 03:29 ? 00:00:00 /usr/libexec/trashapplet --oaf-activate-iid=OAFIID:GNOME_Panel_TrashApplet_Factory --oaf-ior-fd=26
oracle 2525 1 0 03:29 ? 00:00:00 /usr/libexec/gvfs-gphoto2-volume-monitor
oracle 2530 1 0 03:29 ? 00:00:00 /usr/libexec/gvfsd-trash --spawner :1.4 /org/gtk/gvfs/exec_spaw/1
oracle 2534 1 0 03:29 ? 00:00:00 /usr/libexec/gvfsd-burn --spawner :1.4 /org/gtk/gvfs/exec_spaw/2
oracle 2543 1 0 03:30 ? 00:00:00 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID:GNOME_MixerApplet_Factory --oaf-ior-fd=24
oracle 2547 1 0 03:30 ? 00:00:00 /usr/libexec/gdm-user-switch-applet --oaf-activate-iid=OAFIID:GNOME_FastUserSwitchApplet_Factory --oaf-ior-fd=36
oracle 2548 1 0 03:30 ? 00:00:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:GNOME_ClockApplet_Factory --oaf-ior-fd=30
oracle 2551 1 0 03:30 ? 00:00:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-ior-fd=44
oracle 2552 1 0 03:30 ? 00:00:01 mono /usr/lib64/tomboy/Tomboy.exe --panel-applet --oaf-activate-iid=OAFIID:TomboyApplet_Factory --oaf-ior-fd=52
oracle 2556 1 0 03:30 ? 00:00:00 /usr/libexec/gvfsd-cdda --spawner :1.4 /org/gtk/gvfs/exec_spaw/3
oracle 2588 2226 0 03:30 ? 00:00:00 imsettings-applet --disable-xsettings
oracle 2598 2226 0 03:30 ? 00:00:00 nm-applet --sm-disable
oracle 2601 2226 0 03:30 ? 00:00:00 kerneloops-applet
oracle 2602 2226 0 03:30 ? 00:00:00 bluetooth-applet
oracle 2603 2226 0 03:30 ? 00:00:00 gpk-update-icon
oracle 2604 1 0 03:30 ? 00:00:00 /usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay
oracle 2605 2418 0 03:30 ? 00:00:00 /usr/lib64/scim-1.0/scim-launcher -c socket -e socket -f x11
oracle 2606 2226 0 03:30 ? 00:00:00 python /usr/share/system-config-printer/applet.py
oracle 2609 1 0 03:30 ? 00:00:00 gnome-power-manager
oracle 2625 1 0 03:30 ? 00:00:00 /usr/bin/python -E /usr/bin/sealert -s
oracle 2646 1 0 03:30 ? 00:00:00 /usr/lib64/scim-1.0/scim-helper-manager
oracle 2647 1 0 03:30 ? 00:00:03 /usr/lib64/scim-1.0/scim-panel-gtk --display :0.0 -c socket -d --no-stay
oracle 2673 1 0 03:30 ? 00:00:04 gnome-terminal
oracle 2687 1 0 03:30 ? 00:00:01 scim-bridge
oracle 2688 2673 0 03:30 ? 00:00:00 gnome-pty-helper
oracle 2689 2673 0 03:30 pts/0 00:00:00 bash
oracle 2732 1 0 03:31 ? 00:00:00 /bin/sh /usr/lib64/firefox-3.0.4/run-mozilla.sh /usr/lib64/firefox-3.0.4/firefox -UILocale zh-CN
oracle 2749 2732 8 03:31 ? 00:04:27 /usr/lib64/firefox-3.0.4/firefox -UILocale zh-CN
oracle 3616 1 0 04:02 ? 00:00:00 /usr/libexec/notification-daemon
oracle 4017 1 0 04:15 ? 00:00:00 /usr/libexec/gvfsd-computer --spawner :1.4 /org/gtk/gvfs/exec_spaw/4
oracle 4229 2689 6 04:26 pts/0 00:00:00 ps -ef
oracle 4230 2689 0 04:26 pts/0 00:00:00 grep ora
[oracle@yellow bin]$
[oracle@yellow bin]$ ll
總計 97324
-r-xr-xr-x 1 oracle dba 13093 2006-01-30 adapters
-r-xr-xr-x 1 oracle dba 40340 2006-02-20 agtctl
-rwxr-xr-x 1 oracle dba 8440 2006-01-30 createdb.sh
-r-xr-xr-x 1 oracle dba 417644 2006-02-20 ctxkbtc
-r-xr-xr-x 1 oracle dba 384752 2006-02-20 ctxlc
-r-xr-xr-x 1 oracle dba 135244 2006-02-20 ctxload
-r-xr-xr-x 1 oracle dba 22336 2006-02-20 cursize
-r-xr-xr-x 1 oracle dba 6672 2006-02-20 dbfsize
-r-xr-xr-x 1 oracle dba 281840 2006-02-20 dbv
-r-xr-xr-x 1 oracle dba 1564544 2006-02-20 dgmgrl
-r-xr-xr-x 1 oracle dba 7652 2006-02-20 dumpsga
-r-xr-xr-x 1 oracle dba 519664 2006-02-20 exp
-r-xr-xr-x 1 oracle dba 153344 2006-02-20 expdp
-r-xr-xr-x 1 oracle dba 32068 2006-02-20 extjob
-r-xr-xr-x 1 oracle dba 19496 2006-02-20 extproc
-r-xr-xr-x 1 oracle dba 470176 2006-02-20 fmputl
-r-xr-xr-x 1 oracle dba 6800 2006-02-20 fmputlhp
-r-xr-xr-x 1 oracle dba 327828 2006-02-20 genksms
-r-xr-xr-x 1 oracle dba 2893 2006-01-30 gennfgt
-r-xr-xr-x 1 oracle dba 4902 2006-01-30 gennttab
-r-xr-xr-x 1 oracle dba 488436 2006-02-20 grdcscan
-r-xr-xr-x 1 oracle dba 102144 2006-02-20 hsalloci
-r-xr-xr-x 1 oracle dba 25036 2006-02-20 hsdepxa
-r-xr-xr-x 1 oracle dba 1102900 2006-02-20 hsodbc
-r-xr-xr-x 1 oracle dba 24080 2006-02-20 hsots
-r-xr-xr-x 1 oracle dba 249232 2006-02-20 imp
-r-xr-xr-x 1 oracle dba 156356 2006-02-20 impdp
-r-xr-xr-x 1 oracle dba 283408 2006-02-20 kgmgr
-r-xr-xr-x 1 oracle dba 2533300 2006-02-20 kgpmon
-r-xr-xr-x 1 oracle dba 9932 2006-02-20 loadpsp
-r-xr-xr-x 1 oracle dba 68948 2006-02-20 lsnrctl
-r-xr-xr-x 1 oracle dba 389920 2006-02-20 lxchknlb
-r-xr-xr-x 1 oracle dba 7984 2006-02-20 mapsga
-r-xr-xr-x 1 oracle dba 6696 2006-02-20 maxmem
-r-xr-xr-x 1 oracle dba 103748 2006-02-20 nid
-rwxr-xr-x 1 oracle dba 16691 2006-01-30 nls_lang.sh
-r-xr-xr-x 1 oracle dba 866972 2006-02-20 ons
-rwsr-s--x 1 oracle dba 74016852 2006-02-20 oracle
-rwxr-xr-x 1 oracle dba 314 2006-01-30 oracle_env.csh
-rwxr-xr-x 1 oracle dba 360 2006-01-30 oracle_env.sh
-r-xr-xr-x 1 oracle dba 8480 2006-02-20 oradism
-r-xr-xr-x 1 oracle dba 2947 2006-01-30 oraenv
-r-xr-xr-x 1 oracle dba 11600 2006-02-20 orapwd
-r-xr-xr-x 1 oracle dba 4416 2006-02-20 osdbagrp
-r-xr-xr-x 1 oracle dba 5884 2006-02-20 osh
-r-xr-xr-x 1 oracle dba 773 2006-01-30 ott
-r-xr-xr-x 1 oracle dba 8911600 2006-02-20 rman
-r-xr-xr-x 1 oracle dba 79904 2006-02-20 sbttest
-r-xr-xr-x 1 oracle dba 557908 2006-02-20 sqlldr
-rwxr-xr-x 1 oracle dba 4304 2006-02-20 sqlplus
-r-xr-xr-x 1 oracle dba 11924 2006-02-20 sysresv
-r-xr-xr-x 1 oracle dba 18896 2006-02-20 tg4pwd
-r-xr-xr-x 1 oracle dba 98552 2006-02-20 tkprof
-r-xr-xr-x 1 oracle dba 270888 2006-02-20 tnslsnr
-r-xr-xr-x 1 oracle dba 8272 2006-02-20 tnsping
-r-xr-xr-x 1 oracle dba 82592 2006-02-20 trcldr
-r-xr-xr-x 1 oracle dba 14060 2006-02-20 trcroute
-r-xr-xr-x 1 oracle dba 14080 2006-02-20 tstshm
-r-xr-xr-x 1 oracle dba 100624 2006-02-20 unzip
-r-xr-xr-x 1 oracle dba 4176688 2006-02-20 wrap
-r-xr-xr-x 1 oracle dba 62720 2006-02-20 zip
[oracle@yellow bin]$
e@yellow ~]$ ps axl | grep ora
4 0 1811 1658 20 0 19996 1000 - S ? 0:00 hald-addon-storage: polling /dev/sr0 (every 2 sec)
1 501 2357 1 20 0 70616 2404 futex_ Ssl ? 0:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
0 501 2699 2671 20 0 85004 788 pipe_w S+ pts/0 0:00 grep ora
[oracle@yellow ~]$ ps axl | grep ora
4 0 1811 1658 20 0 19996 1000 - S ? 0:00 hald-addon-storage: polling /dev/sr0 (every 2 sec)
1 501 2357 1 20 0 70616 2404 futex_ Ssl ? 0:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
0 501 2701 2671 20 0 85004 784 - R+ pts/0 0:00 grep ora
[oracle@yellow ~]$ ps aux | grep ora
root 1811 0.0 0.0 19996 1000 ? S 17:04 0:00 hald-addon-storage: polling /dev/sr0 (every 2 sec)
oracle 2225 0.0 0.1 58940 2016 ? S 17:04 0:00 /usr/bin/gnome-keyring-daemon -d --login
oracle 2227 0.4 0.3 304408 7784 ? Ssl 17:04 0:00 gnome-session
oracle 2243 0.0 0.0 21616 560 ? S 17:04 0:00 dbus-launch --sh-syntax --exit-with-session
oracle 2244 0.3 0.0 29904 1560 ? Ssl 17:04 0:00 /bin/dbus-daemon --fork --print-pid 7 --print-address 9 --session
oracle 2287 0.0 0.1 42516 2156 ? S 17:04 0:00 /usr/libexec/im-settings-daemon
oracle 2289 0.0 0.1 43848 2736 ? S 17:04 0:00 /usr/libexec/im-info-daemon
oracle 2291 0.0 0.1 116004 2040 ? S 17:04 0:00 /usr/libexec/gvfsd
oracle 2357 0.0 0.1 70616 2404 ? Ssl 17:04 0:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
oracle 2419 0.0 0.0 97692 1332 ? S 17:04 0:00 /usr/bin/scim
oracle 2421 0.0 0.1 39880 2136 ? S 17:04 0:00 /usr/libexec/gconf-im-settings-daemon
oracle 2423 1.2 0.3 120536 6712 ? S 17:04 0:00 /usr/libexec/gconfd-2
oracle 2425 0.0 0.0 0 0 ? Z 17:04 0:00 [Xsession]
oracle 2476 0.0 0.1 185052 3132 ? S 17:04 0:00 /usr/lib64/gnome-session/helpers/gnome-keyring-daemon-wrapper
oracle 2477 0.8 0.7 401644 15364 ? Ssl 17:04 0:00 /usr/libexec/gnome-settings-daemon
oracle 2479 0.3 0.6 235152 13400 ? S 17:04 0:00 metacity
oracle 2482 1.1 0.9 318564 19352 ? S 17:04 0:00 gnome-panel
oracle 2483 2.2 1.6 512880 32532 ? S 17:04 0:01 nautilus --no-desktop --browser
oracle 2488 0.3 0.1 223756 3348 ? Ssl 17:04 0:00 /usr/libexec/bonobo-activation-server --ac-activate --ior-output-fd=17
oracle 2498 0.3 0.2 378168 5016 ? Ssl 17:04 0:00 /usr/bin/pulseaudio --start --log-target=syslog
oracle 2515 0.0 0.1 59676 2176 ? S 17:04 0:00 /usr/libexec/pulse/gconf-helper
oracle 2516 0.2 0.1 316820 3168 ? Ss 17:04 0:00 gnome-screensaver
oracle 2522 0.0 0.1 128884 2960 ? Sl 17:04 0:00 /usr/libexec/gvfs-hal-volume-monitor
oracle 2524 0.0 0.1 114152 2140 ? S 17:04 0:00 /usr/libexec/gvfs-gphoto2-volume-monitor
oracle 2526 0.0 0.1 128640 2716 ? S 17:04 0:00 /usr/libexec/gvfsd-trash --spawner :1.4 /org/gtk/gvfs/exec_spaw/0
oracle 2533 0.0 0.4 302984 9872 ? S 17:04 0:00 /usr/libexec/trashapplet --oaf-activate-iid=OAFIID:GNOME_Panel_TrashApplet_Factory --oaf-ior-fd=26
oracle 2534 0.3 0.9 318792 18172 ? S 17:04 0:00 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:GNOME_Wncklet_Factory --oaf-ior-fd=20
oracle 2539 0.0 0.1 116048 2080 ? S 17:04 0:00 /usr/libexec/gvfsd-burn --spawner :1.4 /org/gtk/gvfs/exec_spaw/1
oracle 2542 0.0 0.1 135268 2188 ? S 17:04 0:00 /usr/libexec/gvfsd-cdda --spawner :1.4 /org/gtk/gvfs/exec_spaw/2
oracle 2559 0.5 0.9 364796 18332 ? Sl 17:05 0:00 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID:GNOME_MixerApplet_Factory --oaf-ior-fd=24
oracle 2562 0.5 0.7 370200 15368 ? S 17:05 0:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:GNOME_ClockApplet_Factory --oaf-ior-fd=30
oracle 2566 0.4 0.7 309556 15700 ? S 17:05 0:00 /usr/libexec/gdm-user-switch-applet --oaf-activate-iid=OAFIID:GNOME_FastUserSwitchApplet_Factory --oaf-ior-fd=36
oracle 2568 0.2 0.4 294120 8740 ? S 17:05 0:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-ior-fd=42
oracle 2571 2.8 1.4 429824 29828 ? Sl 17:05 0:01 mono /usr/lib64/tomboy/Tomboy.exe --panel-applet --oaf-activate-iid=OAFIID:TomboyApplet_Factory --oaf-ior-fd=48
oracle 2596 0.1 0.3 228024 7068 ? S 17:05 0:00 imsettings-applet --disable-xsettings
oracle 2602 0.2 0.5 277500 11464 ? S 17:05 0:00 nm-applet --sm-disable
oracle 2607 0.1 0.2 213728 5824 ? S 17:05 0:00 kerneloops-applet
oracle 2609 0.1 0.3 218740 7508 ? S 17:05 0:00 bluetooth-applet
oracle 2610 0.1 0.4 244696 8648 ? S 17:05 0:00 gpk-update-icon
oracle 2612 0.4 0.9 307132 18452 ? S 17:05 0:00 python /usr/share/system-config-printer/applet.py
oracle 2613 0.1 0.4 319808 9172 ? Ss 17:05 0:00 gnome-power-manager
oracle 2624 0.1 2.5 311964 50100 ? Ss 17:05 0:00 /usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay
oracle 2625 0.2 0.1 118144 3476 ? S 17:05 0:00 /usr/lib64/scim-1.0/scim-launcher -c socket -e socket -f x11
oracle 2632 1.0 1.7 444372 34020 ? S 17:05 0:00 /usr/bin/python -E /usr/bin/sealert -s
oracle 2651 0.0 0.1 194132 3012 ? Ss 17:05 0:00 /usr/lib64/scim-1.0/scim-helper-manager
oracle 2652 0.1 0.4 230336 9032 ? Ssl 17:05 0:00 /usr/lib64/scim-1.0/scim-panel-gtk --display :0.0 -c socket -d --no-stay
oracle 2656 1.6 1.5 398600 30692 ? Sl 17:05 0:00 gnome-terminal
oracle 2669 0.0 2.5 311860 50032 ? S 17:05 0:00 scim-bridge
oracle 2670 0.0 0.0 11024 668 ? S 17:05 0:00 gnome-pty-helper
oracle 2671 0.0 0.0 89992 1688 pts/0 Ss 17:05 0:00 bash
oracle 2702 0.0 0.0 89812 1036 pts/0 R+ 17:05 0:00 ps aux
oracle 2703 0.0 0.0 85004 780 pts/0 R+ 17:05 0:00 grep ora
[oracle@yellow ~]$ sqlplus
bash: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus: /lib/ld-linux.so.2: bad ELF interpreter: 沒有那個檔案或目錄
[oracle@yellow ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:10:55 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱: sys
輸入口令:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
SP2-0157: 在 3 次嘗試之後無法連線到 ORACLE, 退出 SQL*Plus
[oracle@yellow ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:11:36
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
[oracle@yellow ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:12:07
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
[oracle@yellow ~]$ cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
[oracle@yellow server]$ ls
bin ctx demo jdbc ldap network odbc oracore precomp slax xdk
config dbs hs jlib lib nls opmn plsql rdbms sqlplus
[oracle@yellow server]$ cd network
[oracle@yellow network]$ ls
admin install lib log mesg trace
[oracle@yellow network]$ cd admin
[oracle@yellow admin]$ ll
總計 12
-r--r--r-- 1 oracle dba 456 2006-01-30 listener.ora
drwxr-xr-x 2 oracle dba 4096 08-16 11:57 samples
-r--r--r-- 1 oracle dba 597 08-18 05:12 tnsnames.ora
[oracle@yellow admin]$ vi tnsnames.ora
[已修改但尚未儲存]
請按 ENTER 或其它命令繼續
[oracle@yellow admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:14:57
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
e@yellow ~]$ sqlplus
bash: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus: /lib/ld-linux.so.2: bad ELF interpreter: 沒有那個檔案或目錄
[oracle@yellow ~]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:10:55 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱: sys
輸入口令:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
SP2-0157: 在 3 次嘗試之後無法連線到 ORACLE, 退出 SQL*Plus
[oracle@yellow ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:11:36
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
[oracle@yellow ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:12:07
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
[oracle@yellow ~]$ cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server
[oracle@yellow server]$ ls
bin ctx demo jdbc ldap network odbc oracore precomp slax xdk
config dbs hs jlib lib nls opmn plsql rdbms sqlplus
[oracle@yellow server]$ cd network
[oracle@yellow network]$ ls
admin install lib log mesg trace
[oracle@yellow network]$ cd admin
[oracle@yellow admin]$ ll
總計 12
-r--r--r-- 1 oracle dba 456 2006-01-30 listener.ora
drwxr-xr-x 2 oracle dba 4096 08-16 11:57 samples
-r--r--r-- 1 oracle dba 597 08-18 05:12 tnsnames.ora
[oracle@yellow admin]$ vi tnsnames.ora
[已修改但尚未儲存]
請按 ENTER 或其它命令繼續
[oracle@yellow admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:14:57
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
TNS-01150: 指定的監聽程式地址不正確
TNS-01153: 未能處理字串: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%hostname%)(PORT=%port%)))
監聽程式未能啟動。請參閱上面的錯誤訊息...
[oracle@yellow admin]$ vi tnsnames.ora
[oracle@yellow admin]$ vi linsener.ora
[oracle@yellow admin]$ vi listener.ora
[oracle@yellow admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-8月 -2009 17:18:23
Copyright (c) 1991, 2005, Oracle. All rights reserved.
啟動/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: 請稍候...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
系統引數檔案為/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
寫入/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的日誌資訊
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
監聽: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
正在連線到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
LISTENER 的 STATUS
------------------------
別名 LISTENER
版本 TNSLSNR for Linux: Version 10.2.0.1.0 - Production
啟動日期 22-8月 -2009 17:18:23
正常執行時間 0 天 0 小時 0 分 0 秒
跟蹤級別 off
安全性 ON: Local OS Authentication
SNMP OFF
預設服務 XE
監聽程式引數檔案 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
監聽程式日誌檔案 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
監聽端點概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
服務摘要..
服務 "PLSExtProc" 包含 1 個例程。
例程 "PLSExtProc", 狀態 UNKNOWN, 包含此服務的 1 個處理程式...
命令執行成功
[oracle@yellow admin]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:18:29 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
SP2-0157: 在 3 次嘗試之後無法連線到 ORACLE, 退出 SQL*Plus
[oracle@yellow admin]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:19:52 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱:
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
SP2-0157: 在 3 次嘗試之後無法連線到 ORACLE, 退出 SQL*Plus
[oracle@yellow admin]$ ll
總計 20
-r--r--r-- 1 oracle dba 453 08-22 17:18 listener.ora
drwxr-xr-x 2 oracle dba 4096 08-16 11:57 samples
-rw-r--r-- 1 oracle oinstall 5288 08-22 17:24 sqlnet.log
-r--r--r-- 1 oracle dba 594 08-22 17:14 tnsnames.ora
[oracle@yellow admin]$ vi sqlnet.log
[oracle@yellow admin]$ vi listener.ora
[oracle@yellow admin]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:33:16 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
oracleXE: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS: 丟失連線
請輸入使用者名稱: sys/sys as sysdba
已連線到空閒例程。
SQL> select * from dua;
select * from dua
*
第 1 行出現錯誤:
ORA-01034: ORACLE not available
SQL> select * from dual;
select * from dual
*
第 1 行出現錯誤:
ORA-01034: ORACLE not available
SQL> alter database open;
alter database open
*
第 1 行出現錯誤:
ORA-01034: ORACLE not available
SQL> select * from dual;
select * from dual
*
第 1 行出現錯誤:
ORA-01034: ORACLE not available
SQL> quit
已斷開連線
[oracle@yellow admin]$ ps - ef |grep ora
ERROR: Garbage option.
********* simple selection ********* ********* selection by list *********
-A all processes -C by command name
-N negate selection -G by real group ID (supports names)
-a all w/ tty except session leaders -U by real user ID (supports names)
-d all except session leaders -g by session OR by effective group name
-e all processes -p by process ID
T all processes on this terminal -s processes in the sessions given
a all w/ tty, including other users -t by tty
g OBSOLETE -- DO NOT USE -u by effective user ID (supports names)
r only running processes U processes for specified users
x processes w/o controlling ttys t by tty
*********** output format ********** *********** long options ***********
-o,o user-defined -f full --Group --User --pid --cols --ppid
-j,j job control s signal --group --user --sid --rows --info
-O,O preloaded -o v virtual memory --cumulative --format --deselect
-l,l long u user-oriented --sort --tty --forest --version
-F extra full X registers --heading --no-heading --context
********* misc options *********
-V,V show version L list format codes f ASCII art forest
-m,m,-L,-T,H threads S children in sum -y change -l format
-M,Z security data c true command name -c scheduling class
-w,w wide output n numeric WCHAN,UID -H process hierarchy
[oracle@yellow admin]$ ps -ef |grep ora
root 1811 1658 0 17:04 ? 00:00:00 hald-addon-storage: polling /dev/sr0 (every 2 sec)
oracle 2225 1 0 17:04 ? 00:00:00 /usr/bin/gnome-keyring-daemon -d --login
oracle 2227 2189 0 17:04 ? 00:00:00 gnome-session
oracle 2243 1 0 17:04 ? 00:00:00 dbus-launch --sh-syntax --exit-with-session
oracle 2244 1 0 17:04 ? 00:00:00 /bin/dbus-daemon --fork --print-pid 7 --print-address 9 --session
oracle 2287 1 0 17:04 ? 00:00:00 /usr/libexec/im-settings-daemon
oracle 2289 1 0 17:04 ? 00:00:00 /usr/libexec/im-info-daemon
oracle 2291 1 0 17:04 ? 00:00:00 /usr/libexec/gvfsd
oracle 2357 1 0 17:04 ? 00:00:00 /usr/libexec//gvfs-fuse-daemon /home/oracle/.gvfs
oracle 2419 1 0 17:04 ? 00:00:00 /usr/bin/scim
oracle 2421 1 0 17:04 ? 00:00:00 /usr/libexec/gconf-im-settings-daemon
oracle 2423 1 0 17:04 ? 00:00:01 /usr/libexec/gconfd-2
oracle 2425 2227 0 17:04 ? 00:00:00 [Xsession]
oracle 2476 2227 0 17:04 ? 00:00:00 /usr/lib64/gnome-session/helpers/gnome-keyring-daemon-wrapper
oracle 2477 1 0 17:04 ? 00:00:01 /usr/libexec/gnome-settings-daemon
oracle 2479 2227 0 17:04 ? 00:00:04 metacity
oracle 2482 2227 0 17:04 ? 00:00:01 gnome-panel
oracle 2483 2227 0 17:04 ? 00:00:07 nautilus --no-desktop --browser
oracle 2488 1 0 17:04 ? 00:00:00 /usr/libexec/bonobo-activation-server --ac-activate --ior-output-fd=17
oracle 2498 1 0 17:04 ? 00:00:00 /usr/bin/pulseaudio --start --log-target=syslog
oracle 2515 2498 0 17:04 ? 00:00:00 /usr/libexec/pulse/gconf-helper
oracle 2516 1 0 17:04 ? 00:00:05 gnome-screensaver
oracle 2522 1 0 17:04 ? 00:00:00 /usr/libexec/gvfs-hal-volume-monitor
oracle 2524 1 0 17:04 ? 00:00:00 /usr/libexec/gvfs-gphoto2-volume-monitor
oracle 2526 1 0 17:04 ? 00:00:00 /usr/libexec/gvfsd-trash --spawner :1.4 /org/gtk/gvfs/exec_spaw/0
oracle 2533 1 0 17:04 ? 00:00:00 /usr/libexec/trashapplet --oaf-activate-iid=OAFIID:GNOME_Panel_TrashApplet_Factory --oaf-ior-fd=26
oracle 2534 1 0 17:04 ? 00:00:07 /usr/libexec/wnck-applet --oaf-activate-iid=OAFIID:GNOME_Wncklet_Factory --oaf-ior-fd=20
oracle 2539 1 0 17:04 ? 00:00:00 /usr/libexec/gvfsd-burn --spawner :1.4 /org/gtk/gvfs/exec_spaw/1
oracle 2542 1 0 17:04 ? 00:00:00 /usr/libexec/gvfsd-cdda --spawner :1.4 /org/gtk/gvfs/exec_spaw/2
oracle 2559 1 0 17:05 ? 00:00:00 /usr/libexec/mixer_applet2 --oaf-activate-iid=OAFIID:GNOME_MixerApplet_Factory --oaf-ior-fd=24
oracle 2562 1 0 17:05 ? 00:00:00 /usr/libexec/clock-applet --oaf-activate-iid=OAFIID:GNOME_ClockApplet_Factory --oaf-ior-fd=30
oracle 2566 1 0 17:05 ? 00:00:00 /usr/libexec/gdm-user-switch-applet --oaf-activate-iid=OAFIID:GNOME_FastUserSwitchApplet_Factory --oaf-ior-fd=36
oracle 2568 1 0 17:05 ? 00:00:00 /usr/libexec/notification-area-applet --oaf-activate-iid=OAFIID:GNOME_NotificationAreaApplet_Factory --oaf-ior-fd=42
oracle 2571 1 0 17:05 ? 00:00:01 mono /usr/lib64/tomboy/Tomboy.exe --panel-applet --oaf-activate-iid=OAFIID:TomboyApplet_Factory --oaf-ior-fd=48
oracle 2596 2227 0 17:05 ? 00:00:00 imsettings-applet --disable-xsettings
oracle 2602 2227 0 17:05 ? 00:00:00 nm-applet --sm-disable
oracle 2607 2227 0 17:05 ? 00:00:00 kerneloops-applet
oracle 2609 2227 0 17:05 ? 00:00:00 bluetooth-applet
oracle 2610 2227 0 17:05 ? 00:00:00 gpk-update-icon
oracle 2612 2227 0 17:05 ? 00:00:00 python /usr/share/system-config-printer/applet.py
oracle 2613 1 0 17:05 ? 00:00:00 gnome-power-manager
oracle 2624 1 0 17:05 ? 00:00:00 /usr/lib64/scim-1.0/scim-launcher -d -c simple -e all -f socket --no-stay
oracle 2625 2419 0 17:05 ? 00:00:00 /usr/lib64/scim-1.0/scim-launcher -c socket -e socket -f x11
oracle 2632 1 0 17:05 ? 00:00:00 /usr/bin/python -E /usr/bin/sealert -s
oracle 2651 1 0 17:05 ? 00:00:00 /usr/lib64/scim-1.0/scim-helper-manager
oracle 2652 1 0 17:05 ? 00:00:02 /usr/lib64/scim-1.0/scim-panel-gtk --display :0.0 -c socket -d --no-stay
oracle 2656 1 0 17:05 ? 00:00:12 gnome-terminal
oracle 2669 1 0 17:05 ? 00:00:01 scim-bridge
oracle 2670 2656 0 17:05 ? 00:00:00 gnome-pty-helper
oracle 2671 2656 0 17:05 pts/0 00:00:00 bash
oracle 2706 1 0 17:06 ? 00:00:00 /bin/sh /usr/lib64/firefox-3.0.4/run-mozilla.sh /usr/lib64/firefox-3.0.4/firefox -UILocale zh-CN
oracle 2723 2706 12 17:06 ? 00:03:57 /usr/lib64/firefox-3.0.4/firefox -UILocale zh-CN
oracle 2743 2656 0 17:06 pts/1 00:00:00 bash
oracle 3015 2656 0 17:15 pts/2 00:00:00 bash
oracle 3048 1 0 17:18 ? 00:00:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit
oracle 3073 1 0 17:26 ? 00:00:00 /usr/libexec/gvfsd-computer --spawner :1.4 /org/gtk/gvfs/exec_spaw/3
oracle 3113 1 0 17:27 ? 00:00:02 gedit /media/disk/oracle/product/10.2.0/db_1/NETWORK/ADMIN/listener.ora
oracle 3121 2656 0 17:29 pts/3 00:00:00 bash
root 3176 2939 0 17:36 pts/1 00:00:00 su - oracle
oracle 3178 3176 0 17:36 pts/1 00:00:00 -bash
root 3226 3178 0 17:36 pts/1 00:00:00 su - oracle
oracle 3231 3226 0 17:36 pts/1 00:00:00 -bash
root 3283 3231 0 17:37 pts/1 00:00:00 su - oracle
oracle 3288 3283 0 17:37 pts/1 00:00:00 -bash
oracle 3339 2671 0 17:38 pts/0 00:00:00 ps -ef
oracle 3340 2671 0 17:38 pts/0 00:00:00 grep ora
[oracle@yellow admin]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:38:52 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
已連線到空閒例程。
SQL> select * from dual;
select * from dual
*
第 1 行出現錯誤:
ORA-01034: ORACLE not available
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> shutdown
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> startup mount
ORA-01078: failure in processing system parameters
LRM-00109:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16179598/viewspace-612968/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- fedora10 下安裝 oracle xe(續)Oracle
- 【筆記】fedora10 硬碟安裝筆記硬碟
- centos7.3上安裝oracle xe 11gCentOSOracle
- XE2安裝JVCL
- XE2再次安裝JVCL
- Ubuntu x86_64安裝oracle 11gR2 XEUbuntuOracle
- [XE] oracle xe 11g beta釋出了Oracle
- ubuntu下安裝oracleUbuntuOracle
- centos下安裝oracleCentOSOracle
- solaris下安裝oracleOracle
- windows下oracle安裝WindowsOracle
- oracleLinux下安裝oracleOracleLinux
- ubuntu下安裝oracle JDKUbuntuOracleJDK
- Windows下解除安裝OracleWindowsOracle
- oracle下載和安裝Oracle
- Windows下Oracle的下載與安裝WindowsOracle
- linux下解除安裝oracleLinuxOracle
- Oracle安裝程式下載大全Oracle
- Solaris下安裝Oracle817Oracle
- linux 下oracle的安裝LinuxOracle
- 【RAC安裝】 AIX下安裝Oracle 11gR2 RACAIOracle
- 【安裝】Windows下Oracle安裝圖解----oracle-win-64-11g 詳細安裝步驟WindowsOracle圖解
- Ubuntu下安裝oracle 12cUbuntuOracle
- redhatas下安裝oracle10gRedhatOracle
- solaris下-silent方式安裝oracle clientOracleclient
- Windows下ORACLE的完全解除安裝WindowsOracle
- linux 下 sysben for oracle 的安裝LinuxOracle
- Windows下徹底解除安裝ORACLEWindowsOracle
- 在linux下安裝oracle bbedLinuxOracle
- oracle安裝:OUI安裝Oracle(圖形介面安裝)OracleUI
- Oracle Linux 7.5下載和安裝OracleLinux
- Oracle 19C 下載和安裝Oracle
- Solaris下Oracle RAC 11.2.0.4 安裝方法Oracle
- Oracle 21C下載和安裝Oracle
- oracle11g安裝和下載Oracle
- Windows下把Oracle解除安裝乾淨WindowsOracle
- linux下安裝oracle10gLinuxOracle
- linux下安裝oracle 11gLinuxOracle