❶ linux怎麼查看oracle版本
[oracle@ceglnx01 bin]$ sqlplus -v
SQL*Plus: Release 10.2.0.4.0 - Proction
1:使用file命令查看32位還是64位客戶端。
Oracle Client 32 bit
[oracle@db-server-01 ~]$ which sqlplus
/u01/app/oracle/proct/10.2.0/db_1/bin/sqlplus
[oracle@db-server-01 ~]$ file /u01/app/oracle/proct/10.2.0/db_1/bin/sqlplus
/u01/app/oracle/proct/10.2.0/db_1/bin/sqlplus: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped
Oracle Client 64 bit
[oracle@db-server-02 ~]$ which sqlplus
/u01/app/oracle/proct/10.2.0/db_1/bin/sqlplus
[oracle@db-server-02 ~]$ file /u01/app/oracle/proct/10.2.0/db_1/bin/sqlplus
/u01/app/oracle/proct/10.2.0/db_1/bin/sqlplus: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped
或者
Oracle Client 32 bit
[oracle@db-server-01 logs]$ cd /u01/app/oracle/proct/10.2.0/db_1/bin
[oracle@db-server-01 bin]$ file oracle
oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped
Oracle Client 64 bit
[oracle@db-server-02 ~]$ cd /u01/app/oracle/proct/10.2.0/db_1/bin
[oracle@db-server-02 bin]$ file oracle
oracle: setuid setgid ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped
2: 通過查看$ORACLE_HOME下的lib或lib32目錄,如果兩個目錄都存成,則為64位,如果只有lib目錄.則為32位客戶端。
[oracle@db-server-01 db_1]$ ls -d lib
lib
[oracle@db-server-01 db_1]$ ls -d lib*
lib lib32
❷ Linux下如何啟動、關閉Oracle以及打開關閉監聽
1、以oracle用戶登錄系統,如果是root用戶,使用su - oracle切換用戶。
❸ linux 下的oracle怎麼啟動
1、首先打開命令行窗口,切換到su - oracle,啟動資料庫監聽。