XManager远程Linux如何安装Oracle图形化界面

51次阅读
没有评论

共计 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

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 #启动数据库

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

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 远程 Linux 如何安装 Oracle 图形化界面”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注丸趣 TV 行业资讯频道!

正文完
 
丸趣
版权声明:本站原创文章,由 丸趣 2023-07-24发表,共计7567字。
转载说明:除特殊说明外本站除技术相关以外文章皆由网络搜集发布,转载请注明出处。
评论(没有评论)