Shulou(Shulou.com)05/31 Report--

Editor to share with you how to install XManager remote Linux Oracle graphical interface, I believe that most people do not understand, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

First, install Oracle_11g_R2

1. Install the necessary software packages: (CentOS)

Refer to the official documentation

-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. Add users, user groups

Groupadd oinstall;groupadd dba;useradd-g oinstall-G dba oracle

3. Set kernel parameters (add to the end of the file)

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

IP hostname mapping in configuration / etc/hosts file

IP hostname Hostnam

4. Set the file limit (add to the end of the file)

Vi / etc/security/limits.conf

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

5. Set bash (add to the end of the file)

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. Create Oracle product catalog

Mkdir-p / u01/app/oracle/product/11.2.0.3/db_1

7. Modify the ownership and users of the Oracle product catalog

Chown-R oracle:oinstall / U01

8. Set the Oracle user environment variable (add to the end of the file)

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"

Extract the Oracle installation package

[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. Install Oracle

If you do not have a graphical interface installed, you need to install it first.

# yum grouplist

# yum groupinstall "X Window System"

# yum groupinstall Desktop

Yum install xterm

Yum install xclock

Configure xmanager

Open xstart

Enter the host host, protocol protocal,ssh, enter the login user name; authentication, click Settings, enter the password; command click the triangle symbol, select the third: xterm (Linux:Type 2) as shown in the following figure:

Click run after completion, as shown in the following figure:

You can now enter commands in the remote connection window, as shown in the following figure:

Only the Oracle software is installed during installation.

Oracle user

Netca configuration snooping

Dbca creates a database

Export ORACLE_SID=prod

[oracle@node133 database] $lsnrctl start # start listening

[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 # start the database

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

-

one

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

Super user unlocks ordinary user

The default scott user is locked and can be logged in after being unlocked. Unlock the scott using the following statement:

[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

twenty

7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300

thirty

7521 WARD SALESMAN 7698 22-FEB-81 1250 500

thirty

EMPNO ENAME JOB MGR HIREDATE SAL COMM

DEPTNO

-

7566 JONES MANAGER 7839 02-APR-81 2975

twenty

7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400

thirty

7698 BLAKE MANAGER 7839 01-MAY-81 2850

thirty

EMPNO ENAME JOB MGR HIREDATE SAL COMM

DEPTNO

-

7782 CLARK MANAGER 7839 09-JUN-81 2450

ten

7788 SCOTT ANALYST 7566 19-APR-87 3000

twenty

7839 KING PRESIDENT 17-NOV-81 5000

ten

EMPNO ENAME JOB MGR HIREDATE SAL COMM

DEPTNO

-

7844 TURNER SALESMAN 7698 08-SEP-81 1500 0

thirty

7876 ADAMS CLERK 7788 23-MAY-87 1100

twenty

7900 JAMES CLERK 7698 03-DEC-81 950

thirty

EMPNO ENAME JOB MGR HIREDATE SAL COMM

DEPTNO

-

7902 FORD ANALYST 7566 03-DEC-81 3000

twenty

7934 MILLER CLERK 7782 23-JAN-82 1300

ten

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'

Lock user

[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

-

one

The above is all the contents of the article "how to install the Oracle graphical interface for XManager remote Linux". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.