XManager遠程Linux如何安裝Oracle圖形化界面

165次閱讀

共計 7567 個字符，預計需要花費 19 分鐘才能閱讀完成。

丸趣 TV 小編給大家分享一下 XManager 遠程 Linux 如何安裝 Oracle 圖形化界面，相信大部分人都還不怎么了解，因此分享這篇文章給大家參考一下，希望大家閱讀完這篇文章后大有收獲，下面讓我們一起去了解一下吧！

一、安裝 Oracle_11g_R2
1、安裝所必要的軟件包：（CentOS）
參見官方文檔
-rw-r–r–. 1 oracle oinstall 1358454646 Feb 5 22:57 p10404530_112030_Linux-x86-64_1of7.zip
-rw-r–r–. 1 oracle oinstall 1142195302 Feb 5 22:57 p10404530_112030_Linux-x86-64_2of7.zip
2、添加用戶，用戶組
groupadd oinstall;groupadd dba;useradd -g oinstall -G dba oracle

3、設置內核參數（添加到文件末尾）

vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.aio-max-nr = 1048576
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
配置 /etc/hosts 文件中 IP 主機名映射關系
IP hostname 主機名
4、設置文件限制（添加到文件末尾）
vi /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

5、設置 bash（添加到文件末尾）
vi /etc/profile

if [$USER = oracle]; then
if [$SHELL = /bin/ksh]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi

source /etc/profile

6、創建 Oracle 產品目錄
mkdir -p /u01/app/oracle/product/11.2.0.3/db_1

7、修改 Oracle 產品目錄的所屬和用戶
chown -R oracle:oinstall /u01

8、設置 Oracle 用戶環境變量（添加到文件末尾）
su – oracle

vi .bash_profile

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/db_1
export ORACLE_SID=masc
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export NLS_DATE_FORMAT= YYYY-MM-DD HH24:MI:SS
export NLS_LANG= SIMPLIFIED CHINESE_CHINA.ZHS16GBK

解壓 Oracle 安裝包
[oracle@node130 oracle]$ unzip p10404530_112030_Linux-x86-64_1of7.zip
[oracle@node130 oracle]$ unzip p10404530_112030_Linux-x86-64_2of7.zip
[oracle@node130 oracle]$ cd database/
[oracle@node130 database]$ ls
doc install readme.html response rpm runInstaller sshsetup stage welcome.html
[oracle@node130 ~]$ cd /opt/Oracle/database/

9、安裝 Oracle
– 如果沒有安裝圖形界面，則需要先安裝。
# yum grouplist

# yum groupinstall X Window System
# yum groupinstall Desktop

yum install xterm

yum install xclock

配置 xmanager

打開 xstart

輸入主機 host, 協議 protocal，ssh, 輸入登陸的用戶名；身份驗證，點擊設置，輸入密碼；命令點擊三角符號，選擇第三個：xterm(Linux:Type 2) 如下圖所示：

填好之后點擊運行即可；如下圖所示：

現在可以在遠程連接窗口中輸入命令，如下圖所示：

安裝過程中只安裝 Oracle 軟件。

oracle 用戶
netca 配置監聽

dbca 創建數據庫

export ORACLE_SID=prod

[oracle@node133 database]$ lsnrctl start #啟動監聽

[oracle@node130 database]$ sqlplus /as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 6 17:15:47 2017

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL startup #啟動數據庫

SQL create table test_tb(id int);

Table created.
SQL insert into test_tb values(1);

1 row created.

SQL select * from test_tb;

ID
———-
1

SQL shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

超級用戶解鎖普通用戶

默認的 scott 用戶是被鎖定的，先解鎖就能登陸上了。使用下面的語句解鎖 scott:

[oracle@node130 Desktop]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 13 18:39:38 2017

Connected to an idle instance.

SQL start;
SP2-1506: START, @ or @@ command has no arguments
SQL startup;
ORACLE instance started.

Total System Global Area 776646656 bytes
Fixed Size 2232392 bytes
Variable Size 545263544 bytes
Database Buffers 226492416 bytes
Redo Buffers 2658304 bytes
Database mounted.
Database opened.

SQL alter user scott account unlock;

User altered.

SQL alter user scott identified by 123456;

User altered.

SQL exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@node130 Desktop]$ sqlplus scott/123456@prod

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 13 18:59:02 2017

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL select * from bonus;

no rows selected

SQL select * from dept;

DEPTNO DNAME LOC
———- ————– ————-
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON

SQL select * from emp;

EMPNO ENAME JOB MGR HIREDATE SAL COMM
———- ———- ——— ———- ——— ———- ———-
DEPTNO
———-
7369 SMITH CLERK 7902 17-DEC-80 800
20

7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300
30

7521 WARD SALESMAN 7698 22-FEB-81 1250 500
30

EMPNO ENAME JOB MGR HIREDATE SAL COMM
———- ———- ——— ———- ——— ———- ———-
DEPTNO
———-
7566 JONES MANAGER 7839 02-APR-81 2975
20

7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400
30

7698 BLAKE MANAGER 7839 01-MAY-81 2850
30

EMPNO ENAME JOB MGR HIREDATE SAL COMM
———- ———- ——— ———- ——— ———- ———-
DEPTNO
———-
7782 CLARK MANAGER 7839 09-JUN-81 2450
10

7788 SCOTT ANALYST 7566 19-APR-87 3000
20

7839 KING PRESIDENT 17-NOV-81 5000
10

EMPNO ENAME JOB MGR HIREDATE SAL COMM
———- ———- ——— ———- ——— ———- ———-
DEPTNO
———-
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0
30

7876 ADAMS CLERK 7788 23-MAY-87 1100
20

7900 JAMES CLERK 7698 03-DEC-81 950
30

EMPNO ENAME JOB MGR HIREDATE SAL COMM
———- ———- ——— ———- ——— ———- ———-
DEPTNO
———-
7902 FORD ANALYST 7566 03-DEC-81 3000
20

7934 MILLER CLERK 7782 23-JAN-82 1300
10

14 rows selected.

SQL select * from salgrade;

GRADE LOSAL HISAL
———- ———- ———-
1 700 1200
2 1201 1400
3 1401 2000
4 2001 3000
5 3001 9999

QL create user test_user identified by 123456;

User created.

SQL grant create session to test_user;

Grant succeeded.

[oracle@node130 Desktop]$ sqlplus test_user/123456@prod

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 13 19:18:11 2017

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL create table test_table(id int);

Table created.
SQL insert into test_table values (1);
insert into test_table values (1)
*
ERROR at line 1:
ORA-01950: no privileges on tablespace USERS

鎖用戶

[oracle@node130 Desktop]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 13 19:20:44 2017

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL alter user test_user account lock;

User altered.

SQL exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node130 Desktop]$ sqlplus test_user/123456@prod

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 13 19:22:21 2017

ERROR:
ORA-28000: the account is locked

Enter user-name:

[oracle@node130 Desktop]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 13 19:23:07 2017

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL alter user test_user account unlock;

User altered.

SQL grant dba to test_user;

Grant succeeded.

SQL exit;
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@node130 Desktop]$ sqlplus test_user/123456@prod

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 13 19:23:50 2017

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL insert into test_table values(1);

1 row created.

SQL select * from test_table;

ID
———-
1

以上是“XManager 遠程 Linux 如何安裝 Oracle 圖形化界面”這篇文章的所有內容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內容對大家有所幫助，如果還想學習更多知識，歡迎關注丸趣 TV 行業資訊頻道！

正文完