fedora10 下安裝 oracle xe(續)
前一篇沒顯示完,太長,本文續:
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: '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora'
SQL> vi /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora
SP2-0734: 未知的命令開頭 "vi /usr/li..." - 忽略了剩餘的行。
SQL> quit
已斷開連線
[oracle@yellow admin]$ cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora
bash: cd: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora: 沒
有那個檔案或目錄
[oracle@yellow admin]$ cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/
[oracle@yellow dbs]$ ls
init.ora
[oracle@yellow dbs]$ vi init.ora
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:44:20 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> startup
ORA-01078: failure in processing system parameters
LRM-00109: ������������������������ '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora'
SQL> quit
已斷開連線
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:44:20 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> startup
ORA-01078: failure in processing system parameters
LRM-00109: ������������������������ '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora'
SQL> quit
已斷開連線
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:46:37 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> startup
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes
SQL> quit
已斷開連線
[oracle@yellow dbs]$ ls
initXE.ora
[oracle@yellow dbs]$ vi initXE.ora
[oracle@yellow dbs]$ vi initXE.ora
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:48:35 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
已連線到空閒例程。
SQL> startup
ORACLE 例程已經啟動。
Total System Global Area 121634816 bytes
Fixed Size 1257476 bytes
Variable Size 109055996 bytes
Database Buffers 8388608 bytes
Redo Buffers 2932736 bytes
ORA-00205: ?????????, ??????, ???????
SQL> select * from dual
2 ;
ADDR INDX INST_ID DUM
-------- ---------- ---------- ---
0C0362D4 0 1 X
到這裡基本就ok了,其中注意幾個配置檔案的設定:
1,.bash_profile 一些環境變數:oracle_home等
[oracle@yellow admin]$ su - oracle
密碼:
[oracle@yellow ~]$ vi .bash_profile
[oracle@yellow ~]$
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_BASE=/usr/lib/oracle/xe/app
ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/server
ORACLE_SID=XE
LSNR=$ORACLE_HOME/bin/lsnrctl
SQLPLUS=$ORACLE_HOME/bin/sqlplus
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE
export ORACLE_HOME
export ORACLE_SID
export PATH
LD_LABRARY_PATH=$ORACLE_HOME/lib
export LD_LABRARY_PATH
source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
2,配置tns和監聽
[oracle@yellow ~]$ cd $oracle_home
[oracle@yellow ~]$ cd $ORACLE_HOME
[oracle@yellow server]$ cd network/admin
[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 6174 08-22 17:38 sqlnet.log
-r--r--r-- 1 oracle dba 424 08-22 17:32 tnsnames.ora
[oracle@yellow admin]$ vi tnsnames.ora
# tnsnames.ora Network Configuration File:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
配置監聽:
# listener.ora Network Configuration File:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
如果配置有問題的話,可能會有一些報錯:
[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: 丟失連線
3,配置 initXE.ora (XE是sid,根據需要重新命名)
如果不配置的話可能有如下錯誤:
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: ������������������������ '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora'
要做的是首先重新命名,然後修改其中的db_name:
[oracle@yellow admin]$ vi /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora
[oracle@yellow admin]$
# replace DEFAULT with your database name
db_name=XE
再試一下,還有可能有報錯:
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:46:37 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> startup
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes
SQL> quit
這個是說 shared pool memory設定的太小
回到上面的:
[oracle@yellow admin]$ vi /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora
[oracle@yellow admin]$
找到相應的設定:
shared_pool_size = 80000000 # SMALL
# shared_pool_size = 5000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
如果還有其他問題,則同樣的處理。
然後:
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:48:35 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
已連線到空閒例程。
SQL> startup
ORACLE 例程已經啟動。
Total System Global Area 121634816 bytes
Fixed Size 1257476 bytes
Variable Size 109055996 bytes
Database Buffers 8388608 bytes
Redo Buffers 2932736 bytes
ORA-00205: ?????????, ??????, ???????
SQL> select * from dual
2 ;
ADDR INDX INST_ID DUM
-------- ---------- ---------- ---
0C0362D4 0 1 X
到這裡就基本ok了。
---------------------------------------
很懷念在學校的日子,雖然那時候很茫然。
很多時候沒有堅持下去,不過嘗試很多。
花了很長的時間才明白:who am i,what i want,where am going.
所以一定要記得andy說過的話:
hope is a good thing ,maybe the best of all.
很多時候堅持一下,會有很大不同。
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: '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora'
SQL> vi /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora
SP2-0734: 未知的命令開頭 "vi /usr/li..." - 忽略了剩餘的行。
SQL> quit
已斷開連線
[oracle@yellow admin]$ cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora
bash: cd: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora: 沒
有那個檔案或目錄
[oracle@yellow admin]$ cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/
[oracle@yellow dbs]$ ls
init.ora
[oracle@yellow dbs]$ vi init.ora
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:44:20 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> startup
ORA-01078: failure in processing system parameters
LRM-00109: ������������������������ '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora'
SQL> quit
已斷開連線
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:44:20 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> startup
ORA-01078: failure in processing system parameters
LRM-00109: ������������������������ '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora'
SQL> quit
已斷開連線
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:46:37 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> startup
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes
SQL> quit
已斷開連線
[oracle@yellow dbs]$ ls
initXE.ora
[oracle@yellow dbs]$ vi initXE.ora
[oracle@yellow dbs]$ vi initXE.ora
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:48:35 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
已連線到空閒例程。
SQL> startup
ORACLE 例程已經啟動。
Total System Global Area 121634816 bytes
Fixed Size 1257476 bytes
Variable Size 109055996 bytes
Database Buffers 8388608 bytes
Redo Buffers 2932736 bytes
ORA-00205: ?????????, ??????, ???????
SQL> select * from dual
2 ;
ADDR INDX INST_ID DUM
-------- ---------- ---------- ---
0C0362D4 0 1 X
到這裡基本就ok了,其中注意幾個配置檔案的設定:
1,.bash_profile 一些環境變數:oracle_home等
[oracle@yellow admin]$ su - oracle
密碼:
[oracle@yellow ~]$ vi .bash_profile
[oracle@yellow ~]$
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_BASE=/usr/lib/oracle/xe/app
ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/server
ORACLE_SID=XE
LSNR=$ORACLE_HOME/bin/lsnrctl
SQLPLUS=$ORACLE_HOME/bin/sqlplus
PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_BASE
export ORACLE_HOME
export ORACLE_SID
export PATH
LD_LABRARY_PATH=$ORACLE_HOME/lib
export LD_LABRARY_PATH
source /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
2,配置tns和監聽
[oracle@yellow ~]$ cd $oracle_home
[oracle@yellow ~]$ cd $ORACLE_HOME
[oracle@yellow server]$ cd network/admin
[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 6174 08-22 17:38 sqlnet.log
-r--r--r-- 1 oracle dba 424 08-22 17:32 tnsnames.ora
[oracle@yellow admin]$ vi tnsnames.ora
# tnsnames.ora Network Configuration File:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
配置監聽:
# listener.ora Network Configuration File:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
如果配置有問題的話,可能會有一些報錯:
[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: 丟失連線
3,配置 initXE.ora (XE是sid,根據需要重新命名)
如果不配置的話可能有如下錯誤:
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: ������������������������ '/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora'
要做的是首先重新命名,然後修改其中的db_name:
[oracle@yellow admin]$ vi /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora
[oracle@yellow admin]$
# replace DEFAULT with your database name
db_name=XE
再試一下,還有可能有報錯:
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:46:37 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> startup
ORA-00371: not enough shared pool memory, should be atleast 62198988 bytes
SQL> quit
這個是說 shared pool memory設定的太小
回到上面的:
[oracle@yellow admin]$ vi /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/dbs/initXE.ora
[oracle@yellow admin]$
找到相應的設定:
shared_pool_size = 80000000 # SMALL
# shared_pool_size = 5000000 # MEDIUM
# shared_pool_size = 9000000 # LARGE
如果還有其他問題,則同樣的處理。
然後:
[oracle@yellow dbs]$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期六 8月 22 17:48:35 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
請輸入使用者名稱: sys/sys as sysdba
已連線到空閒例程。
SQL> startup
ORACLE 例程已經啟動。
Total System Global Area 121634816 bytes
Fixed Size 1257476 bytes
Variable Size 109055996 bytes
Database Buffers 8388608 bytes
Redo Buffers 2932736 bytes
ORA-00205: ?????????, ??????, ???????
SQL> select * from dual
2 ;
ADDR INDX INST_ID DUM
-------- ---------- ---------- ---
0C0362D4 0 1 X
到這裡就基本ok了。
---------------------------------------
很懷念在學校的日子,雖然那時候很茫然。
很多時候沒有堅持下去,不過嘗試很多。
花了很長的時間才明白:who am i,what i want,where am going.
所以一定要記得andy說過的話:
hope is a good thing ,maybe the best of all.
很多時候堅持一下,會有很大不同。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16179598/viewspace-612969/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- fedora10 下安裝 oracle xeOracle
- 【筆記】fedora10 硬碟安裝筆記硬碟
- centos7.3上安裝oracle xe 11gCentOSOracle
- XE2安裝JVCL
- XE2再次安裝JVCL
- Ubuntu x86_64安裝oracle 11gR2 XEUbuntuOracle
- oracle例項安裝到 4% 不能繼續安裝Oracle
- [XE] oracle xe 11g beta釋出了Oracle
- ubuntu下安裝oracleUbuntuOracle
- centos下安裝oracleCentOSOracle
- solaris下安裝oracleOracle
- oracleLinux下安裝oracleOracleLinux
- ubuntu下安裝oracle JDKUbuntuOracleJDK
- Windows下解除安裝OracleWindowsOracle
- oracle下載和安裝Oracle
- ubuntu下安裝python-opencv(待續)UbuntuPythonOpenCV
- Windows下Oracle的下載與安裝WindowsOracle
- linux下解除安裝oracleLinuxOracle
- Oracle安裝程式下載大全Oracle
- Solaris下安裝Oracle817Oracle
- linux 下oracle的安裝LinuxOracle
- OCFS安裝續2
- OCFS安裝續3
- 【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