XManager遠端Linux 安裝Oracle 圖形化介面xstart解決方法
一、安裝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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/196700/viewspace-2145863/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- xmanager xstart 連結linux 開啟圖形介面Linux
- Xmanager XDMCP遠端連線Linux圖形介面Linux
- 使用Xmanager軟體遠端呼叫圖形化安裝Oracle資料庫Oracle資料庫
- linux遠端工具xmanager--遠端圖形介面配置(redhat6.0)LinuxRedhat
- 用Xmanager遠端登入AIX圖形介面AI
- oracle linux 7 安裝圖形化介面OracleLinux
- Xmanager4遠端連線linux圖形介面(vsftpd配置)LinuxFTP
- Linux之 xstart呼叫 x11vnc遠端圖形化桌面LinuxVNC
- 配置vnc遠端連線Linux和unix伺服器圖形介面安裝OracleVNCLinux伺服器Oracle
- centos7安裝圖形化介面並使用Windows遠端連線,安裝xrdpCentOSWindows
- 使用xmanager訪問linux圖形介面Linux
- XManager:xshell顯示圖形化介面
- oracle 客戶端無圖形介面安裝方法&附加升級_解除安裝_刪除方法Oracle客戶端
- oracle安裝:OUI安裝Oracle(圖形介面安裝)OracleUI
- Linux 安裝圖形介面Linux
- Linux 圖形介面安裝解除安裝Linux
- 圖形化安裝OracleOracle
- Vultr(雲伺服器)安裝GUI圖形化介面(已解決)伺服器GUI
- Linux 非圖形介面安裝oracle資料庫LinuxOracle資料庫
- LINUX圖形化安裝ORACLE 前置條件LinuxOracle
- linux -- Ubuntu Server 安裝圖形介面LinuxUbuntuServer
- xmanager之linux 解決方法Linux
- Rhel7配置遠端圖形化介面登陸
- linux 5.4 開xmanager遠端Linux
- Centos7 系統安裝 Oracle 無法調出圖形安裝介面問題解決CentOSOracle
- 在Windwos系統中用Xmanager2.0連線遠端AIX系統顯示圖形介面AI
- LINUX的遠端圖形介面VNC配置以及調整LinuxVNC
- oracle客戶端安裝步驟—附圖形介面啟用失敗處理方法Oracle客戶端
- 阿里雲centos安裝圖形化介面阿里CentOS
- Xmanager遠端桌面
- xmanager登陸AIX遠端桌面故障解決-大全版AI
- Oracle Linux 6.2 無法切換到圖形介面 (VNC)處理 - yum 安裝圖形介面軟體 - 1OracleLinuxVNC
- Oracle Linux 6.2 無法切換到圖形介面 (VNC)處理 - yum 安裝圖形介面軟體 - 2OracleLinuxVNC
- 雲伺服器linux centos安裝圖形介面伺服器LinuxCentOS
- win10遠端登入Ubuntu14.04圖形化介面Win10Ubuntu
- nvidia圖形驅動程式安裝失敗解決方法
- xstart下遠端報錯"已拒絕X11轉移申請"的解決方法
- WSL安裝及配置圖形介面