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

創(chuàng)新互聯(lián)公司執(zhí)著的堅持網(wǎng)站建設(shè)，小程序設(shè)計；我們不會轉(zhuǎn)行，已經(jīng)持續(xù)穩(wěn)定運營十余年。專業(yè)的技術(shù)，豐富的成功經(jīng)驗和創(chuàng)作思維，提供一站式互聯(lián)網(wǎng)解決方案，以客戶的口碑塑造品牌，攜手廣大客戶，共同發(fā)展進(jìn)步。

一、安裝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、設(shè)置內(nèi)核參數(shù)（添加到文件末尾）

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 主機名映射關(guān)系
IP hostname主機名
4、設(shè)置文件限制 （添加到文件末尾）
vi /etc/security/limits.conf

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

5、設(shè)置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、創(chuàng)建Oracle產(chǎn)品目錄
mkdir -p /u01/app/oracle/product/11.2.0.3/db_1

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

8、設(shè)置Oracle用戶環(huán)境變量 （添加到文件末尾）
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,協(xié)議protocal，ssh,輸入登陸的用戶名；身份驗證，點擊設(shè)置，輸入密碼；命令點擊三角符號，選擇第三個：xterm(Linux:Type 2)如下圖所示：

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

現(xiàn)在可以在遠(yuǎn)程連接窗口中輸入命令，如下圖所示：

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

oracle 用戶
netca 配置監(jiān)聽

dbca 創(chuàng)建數(shù)據(jù)庫

export ORACLE_SID=prod

[oracle@node133 database]$ lsnrctl start #啟動監(jiān)聽

[oracle@node130 database]$ sqlplus "/as sysdba"

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

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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 #啟動數(shù)據(jù)庫

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.

超級用戶解鎖普通用戶

默認(rèn)的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

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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遠(yuǎn)程Linux如何安裝Oracle圖形化界面”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對大家有所幫助，如果還想學(xué)習(xí)更多知識，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！

當(dāng)前標(biāo)題：XManager遠(yuǎn)程Linux如何安裝Oracle圖形化界面
URL鏈接：http://jinyejixie.com/article16/gpehdg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站設(shè)計、ChatGPT、定制開發(fā)、全網(wǎng)營銷推廣、微信小程序、外貿(mào)網(wǎng)站建設(shè)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)