Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Installing Oracle 11G RAC on Linux 6

2025-01-15 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Vi / etc/hosts

10.254.28.11jwdb01

10.254.28.12jwdb02

10.254.28.13 jwdb01-vip

10.254.28.14jwdb02-vip

6.6.7.101jwdb01-priv

6.6.7.102jwdb02-priv

10.254.28.15jwdb-scan

Vi / etc/sysctl.conf

# oracle rac config parameter

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

# kernel.shmall = 2097152

# kernel.shmmax = 1054504960

Kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

Kernel.sem = 250 32000 100 128

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

[root@jwdb01 ~] # vi / etc/pam.d/login

#% PAM-1.0

Auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so

Auth include system-auth

Account required pam_nologin.so

Account include system-auth

Password include system-auth

# pam_selinux.so close should be the first session rule

Session required pam_selinux.so close

Session required pam_loginuid.so

Session optional pam_console.so

# pam_selinux.so open should only be followed by sessions to be executed in the user context

Session required pam_selinux.so open

Session required pam_namespace.so

Session optional pam_keyinit.so force revoke

Session include system-auth

-session optional pam_ck_connector.so

Session required pam_limits.so

# End of file

Vi / etc/security/limits.conf

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 4096

Oracle hard nofile 65536

Oracle soft stack 10240

Grid soft nproc 2047

Grid hard nproc 16384

Grid soft nofile 4096

Grid hard nofile 65536

Grid soft stack 10240

[root@jwdb01 ~] #

[root@jwdb01 ~] #

[root@jwdb01 ~] # groupadd-g 500oinstall

Groupadd-g 501 dba

Useradd-u 501-g oinstall-G dba oracle

Passwd oracle [root@jwdb01 ~] # groupadd-g 501 dba

[root@jwdb01] # useradd-u 501-g oinstall-G dba oracle

[root@jwdb01 ~] # passwd oracle

Changing password for user oracle.

New password:

BAD PASSWORD: it is based ona dictionary word

BAD PASSWORD: is too simple

Retype new password:

Passwd: all authentication tokens updated successfully.

[root@jwdb01 ~] #

[root@jwdb01 ~] #

[root@jwdb01 ~] #

[root@jwdb01] # useradd-u 500-g oinstall-G dba grid

Passwd grid [root@jwdb01 ~] # passwd grid

Changing password for user grid.

New password:

BAD PASSWORD: it is too short

BAD PASSWORD: is too simple

Retype new password:

Passwd: all authentication tokens updated successfully.

[root@jwdb01 ~] #

[root@jwdb01 ~] # id grid

Uid=500 (grid) gid=500 (oinstall) groups=500 (oinstall), 501 (dba)

[root@jwdb01 ~] # id oracle

Uid=501 (oracle) gid=500 (oinstall) groups=500 (oinstall), 501 (dba)

Vi / etc/security/limits.d/90-nproc.conf

# Change this

* soft nproc 1024

# To this

*-nproc 16384

Chown-R oracle.dba / oracle

Mkdir-p / home/oracle/app/grid

Mkdir-p / home/oracle/app/asm

Mkdir-p / home/oracle/app/product/db

Chown-R grid:dba / home/oracle/app

Chown-R grid:dba / home/oracle/app/asm

Chown-R grid:dba / home/oracle/app/grid

Chown-R oracle:dba / home/oracle/app/db/product/11.2

Chmod-R 775 / home/oracle/app

Grid

Export ORACLE_BASE=/home/oracle/app/grid

Export ORACLE_HOME=/home/oracle/app/asm

Export ORACLE_SID=+ASM1

Export NLS_LANG=AMERICAN_AMERICA.UTF8

Export NLS_DATE_FORMAT= "yyyy-mm-dd hh34:mi:ss"

Export PATH=.:$ {PATH}: $ORACLE_HOME/bin

Export PATH=$ {PATH}: / usr/bin:/bin:/usr/bin/X11:/usr/local/bin

Export PATH=$ {PATH}: $ORACLE_BASE/common/oracle/bin

Export ORACLE_PATH=$ {PATH}: $ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

Umask 022

Mkdir-p / home/u01/app/grid

Mkdir-p / home/u01/app/asm

Mkdir-p / home/u01/db/product/11.2

Chown-R grid:oinstall / home/u01/app

Chown-R grid:oinstall / home/u01/app/asm

Chown-R grid:oinstall / home/u01/app/grid

Chown-R oracle:oinstall / home/u01/db/product/11.2

Chmod-R 775 / home/u01/app

Grid

Export ORACLE_BASE=/home/u01/app/grid

Export ORACLE_HOME=/home/u01/app/asm

Export ORACLE_SID=+ASM1

Export NLS_LANG=AMERICAN_AMERICA.UTF8

Export NLS_DATE_FORMAT= "yyyy-mm-dd hh34:mi:ss"

Export PATH=.:$ {PATH}: $ORACLE_HOME/bin

Export PATH=$ {PATH}: / usr/bin:/bin:/usr/bin/X11:/usr/local/bin

Export PATH=$ {PATH}: $ORACLE_BASE/common/oracle/bin

Export ORACLE_PATH=$ {PATH}: $ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

Umask 022

Oracle

Export ORACLE_BASE=/home/u01/db

Export ORACLE_HOME=$ORACLE_BASE/product/11.2

Export ORACLE_SID=dzxjdb1

Export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

Export NLS_DATE_FORMAT= "yyyy-mm-dd hh34:mi:ss"

Export PATH=.:$ {PATH}: $HOME/bin:$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:$ORACLE_BASE/common/oracle/bin

Export ORACLE_PATH=$ {PATH}: $ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

Umask=022

Useradd-g tellin-d / home/uportal-m-s / usr/bin/csh uportal

Usermod-d / U01 grid

Usermod-d / U01 grid

Switch to the root user and use the usermod command, such as usermod-d / tmp test (test is your user name). Use this command to make sure there is no software or process running under the user.

Ntp

Ntp time synchronization

202.112.128.33

[root@jwsysdb02 etc] # mv ntp.conf ntp.conf.bak

[root@jwsysdb02 etc] # vi ntp.conf

Server 202.112.128.33 prefer

Driftfile / var/lib/ntp/drift

Broadcastdelay 0.008

/ etc/init.d/ntpd start

Stored device processing steps:

Root@jwdb01 by-path] # sfdisk-s

/ dev/sdc: 209715200

/ dev/sdd: 2097152

/ dev/sde: 2097152

/ dev/sdb: 209715200

/ dev/sda: 292935982

/ dev/sdi: 2097152

/ dev/sdg: 209715200

/ dev/sdh: 2097152

/ dev/sdf: 209715200

/ dev/mapper/vg_jwdb01-lv_root: 52428800

/ dev/mapper/vg_jwdb01-lv_swap: 4194304

/ dev/sdj: 209715200

/ dev/sdk: 209715200

/ dev/sdl: 2097152

/ dev/sdm: 2097152

/ dev/sdn: 209715200

/ dev/sdo: 209715200

/ dev/sdp: 2097152

/ dev/sdq: 2097152

/ dev/mapper/vg_jwdb01-lv_home: 235798528

/ dev/mapper/data2: 209715200

/ dev/mapper/ocr2: 2097152

/ dev/mapper/ocr1: 2097152

/ dev/mapper/data1: 209715200

/ dev/mapper/data1p1: 209712478

/ dev/mapper/ocr1p1: 2096451

/ dev/mapper/data2p1: 209712478

/ dev/mapper/ocr2p1: 2096451

Total: 3127098992 blocks

[root@jwdb01 by-path] #

[root@jwdb01 by-path] #

[root@jwdb01 by-path] # chmod 0660 / dev/mapper/ocr1

Ocr1 ocr1p1

[root@jwdb01 by-path] # chmod 0660 / dev/mapper/ocr1p1

[root@jwdb01 by-path] # chmod 0660 / dev/mapper/ocr2p1

[root@jwdb01 by-path] #

[root@jwdb01 by-path] #

[root@jwdb01 by-path] # raw/ dev/mapper/ocr1p1 / dev/raw/raw1

Usage:

Raw/ dev/raw/rawN

Raw/ dev/raw/rawN / dev/

Raw-Q / dev/raw/rawN

Raw-qa

[root@jwdb01 by-path] # raw/ dev/raw/raw1 / dev/mapper/ocr1p1

/ dev/raw/raw1: bound to major 253, minor 7

[root@jwdb01 by-path] # raw/ dev/raw/raw2 / dev/mapper/ocr2p1

/ dev/raw/raw2: bound to major 253, minor 9

[root@jwdb01 by-path] # raw-qa

/ dev/raw/raw1: bound to major 253, minor 7

/ dev/raw/raw2: bound to major 253, minor 9

[root@jwdb01 by-path] # cd / dev/raw

[root@jwdb01 raw] # ls-lrt

Total 0

Crw-rw----. 1 root disk 162, 0 Mar 9 15:36 rawctl

Crw-rw----. 1 root disk 162, 1 Mar 9 19:33 raw1

Crw-rw----. 1 root disk 162, 2 Mar 9 19:33 raw2

[root@jwdb01 raw] # / sbin/scsi_id-g-u-d / dev/mapper/ocr1p1

[root@jwdb01 raw] # / sbin/scsi_id-g-u-d / dev/mapper/ocr1

3600b342212af8cad3666d6158d0000da

[root@jwdb01 raw] # / sbin/scsi_id-g-u-d / dev/mapper/ocr2

3600b342ea1bc4eddbcfbd001cd0000d4

[root@jwdb01 raw] # / sbin/scsi_id-g-u-d / dev/mapper/data1

3600b342513d1ae1d508dd7034d0000d7

[root@jwdb01 raw] # / sbin/scsi_id-g-u-d / dev/mapper/data2

3600b34292a10124d90fcdec9bd0000dc

[root@jwdb01 raw] # chown-R grid:oinstall / dev/raw/raw1

[root@jwdb01 raw] # chown-R grid:oinstall / dev/raw/raw2

[root@jwdb01 raw] # chmod 660 / dev/raw/raw1

[root@jwdb01 raw] # chmod 660 / dev/raw/raw2

[root@jwdb01 raw] # raw-qa

/ dev/raw/raw1: bound to major 253, minor 7

/ dev/raw/raw2: bound to major 253, minor 9

[root@jwdb01 raw] #

[root@jwdb01 ~] #

[root@jwdb01 ~] # / home/u01/app/oraInventory/orainstRoot.sh

Changing permissions of / home/u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of / home/u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@jwdb01 ~] #

[root@jwdb01 ~] #

[root@jwdb01 ~] #

[root@jwdb01 ~] # / home/u01/app/asm/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= grid

ORACLE_HOME= / home/u01/app/asm

Enter the full pathname of the local bin directory: [/ usr/local/bin]:

Copying dbhome to / usr/local/bin...

Copying oraenv to / usr/local/bin...

Copying coraenv to / usr/local/bin...

Creating / etc/oratab file...

Entries will be added to the / etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: / home/u01/app/asm/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization-successful

Root wallet

Root wallet cert

Root cert export

Peer wallet

Profile reader wallet

Pa wallet

Peer wallet keys

Pa wallet keys

Peer cert request

Pa cert request

Peer cert

Pa cert

Peer root cert TP

Profile reader root cert TP

Pa root cert TP

Peer pa cert TP

Pa peer cert TP

Profile reader pa cert TP

Profile reader peer cert TP

Peer user cert

Pa user cert

Adding Clusterware entries to upstart

CRS-2672: Attempting to start 'ora.mdnsd' on' jwdb01'

CRS-2676: Start of 'ora.mdnsd' on' jwdb01' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on' jwdb01'

CRS-2676: Start of 'ora.gpnpd' on' jwdb01' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on' jwdb01'

CRS-2672: Attempting to start 'ora.gipcd' on' jwdb01'

CRS-2676: Start of 'ora.cssdmonitor' on' jwdb01' succeeded

CRS-2676: Start of 'ora.gipcd' on' jwdb01' succeeded

CRS-2672: Attempting to start 'ora.cssd' on' jwdb01'

CRS-2672: Attempting to start 'ora.diskmon' on' jwdb01'

CRS-2676: Start of 'ora.diskmon' on' jwdb01' succeeded

CRS-2676: Start of 'ora.cssd' on' jwdb01' succeeded

ASM created and started successfully.

Disk Group CRSDG created successfully.

Clscfg:-install mode specified

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp' root'..

Operation successful.

CRS-4256: Updating the profile

Successful addition of voting disk 51f01ae0711a4fa1bfb2edf48a5e7e7d.

Successfully replaced voting disk group with + CRSDG.

CRS-4256: Updating the profile

CRS-4266: Voting file (s) successfully replaced

# # STATE File Universal Id File Name Disk group

1. ONLINE 51f01ae0711a4fa1bfb2edf48a5e7e7d (/ dev/raw/raw1) [CRSDG]

Located 1 voting disk (s).

CRS-2672: Attempting to start 'ora.asm' on' jwdb01'

CRS-2676: Start of 'ora.asm' on' jwdb01' succeeded

CRS-2672: Attempting to start 'ora.CRSDG.dg' on' jwdb01'

CRS-2676: Start of 'ora.CRSDG.dg' on' jwdb01' succeeded

Configure Oracle Grid Infrastructure for a Cluster... Succeeded

[root@jwdb02 ~] # / home/u01/app/oraInventory/orainstRoot.sh

Changing permissions of / home/u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of / home/u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@jwdb02 ~] #

[root@jwdb02 ~] #

[root@jwdb02 ~] #

[root@jwdb02 ~] #

[root@jwdb02 ~] #

[root@jwdb02 ~] #

[root@jwdb02 ~] #

[root@jwdb02 ~] #

[root@jwdb02 ~] # / home/u01/app/asm/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= grid

ORACLE_HOME= / home/u01/app/asm

Enter the full pathname of the local bin directory: [/ usr/local/bin]:

Copying dbhome to / usr/local/bin...

Copying oraenv to / usr/local/bin...

Copying coraenv to / usr/local/bin...

Creating / etc/oratab file...

Entries will be added to the / etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: / home/u01/app/asm/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization-successful

Adding Clusterware entries to upstart

CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node jwdb01, number 1, and is terminating

An active cluster was found during exclusive startup, restarting to join the cluster

Configure Oracle Grid Infrastructure for a Cluster... Succeeded

[root@jwdb02 ~] # su-grid

[grid@jwdb02 ~] $

[grid@jwdb02 ~] $

[grid@jwdb02] $crs_stat-t

Name Type Target State Host

Ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora.asm ora.asm.type ONLINE ONLINE jwdb01

Ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora....SM1.asm application ONLINE ONLINE jwdb01

Ora.jwdb01.gsd application OFFLINE OFFLINE

Ora.jwdb01.ons application ONLINE ONLINE jwdb01

Ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

Ora....SM2.asm application ONLINE ONLINE jwdb02

Ora.jwdb02.gsd application OFFLINE OFFLINE

Ora.jwdb02.ons application ONLINE ONLINE jwdb02

Ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

Ora....network ora....rk.type ONLINE ONLINE jwdb01

Ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

Ora.ons ora.ons.type ONLINE ONLINE jwdb01

Ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

Ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

Vi / etc/rc.local

Chown-R grid:oinstall / dev/mapper/ocr1p1

Chown-R grid:oinstall / dev/mapper/ocr2p1

Chown-R grid:oinstall / dev/mapper/data1p1

Chown-R grid:oinstall / dev/mapper/data2p1

Sleep 3

Chmod 660 / dev/mapper/ocr1p1

Chmod 660 / dev/mapper/ocr2p1

Chmod 660 / dev/mapper/data1p1

Chmod 660 / dev/mapper/data2p1

Sleep 3

Raw/ dev/raw/raw1 / dev/mapper/ocr1p1

Raw/ dev/raw/raw2 / dev/mapper/ocr2p1

Raw/ dev/raw/raw3 / dev/mapper/data1p1

Raw/ dev/raw/raw4 / dev/mapper/data2p1

Sleep 3

Chown-R grid:oinstall / dev/raw/raw1

Chown-R grid:oinstall / dev/raw/raw2

Chown-R grid:oinstall / dev/raw/raw3

Chown-R grid:oinstall / dev/raw/raw4

Chmod 660 / dev/raw/raw1

Chmod 660 / dev/raw/raw2

Chmod 660 / dev/raw/raw3

Chmod 660 / dev/raw/raw4

Apply connection configuration connection IP

10.254.28.15

That is scan-ip

Virtual IP--vip

10.254.28.13

10.254.28.14

Port: 1521

First node (28.11)

Execute under root user

1. Stop 11g rac

Su-oracle-c "srvctl stop instance-d orcl-I orcl1"

Su-root-c "/ home/u01/app/asm/bin/crsctl stop crs"

two。 Start 11g rac

Su-root-c "/ home/u01/app/asm/bin/crsctl start crs"

Sleep 120

Su-oracle-c "srvctl start instance-d orcl-I orcl1"

Second node (28.12)

Execute under root user

1. Stop 11g rac

Su-oracle-c "srvctl stop instance-d orcl-I orcl2"

Su-root-c "/ home/u01/app/asm/bin/crsctl stop crs"

two。 Start 11g rac

Su-root-c "/ home/u01/app/asm/bin/crsctl start crs"

Sleep 120

Su-oracle-c "srvctl start instance-d orcl-I orcl2"

The usage of crs_stat-t

Under the grid user, execute

Crs_stat-t

[grid@jwdb01] $crs_stat-t

Name Type Target State Host

Ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

Ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora.asm ora.asm.type ONLINE ONLINE jwdb01

Ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora....SM1.asm application ONLINE ONLINE jwdb01

Ora....01.lsnr application ONLINE ONLINE jwdb01

Ora.jwdb01.gsd application OFFLINE OFFLINE

Ora.jwdb01.ons application ONLINE ONLINE jwdb01

Ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

Ora....SM2.asm application ONLINE ONLINE jwdb02

Ora....02.lsnr application ONLINE ONLINE jwdb02

Ora.jwdb02.gsd application OFFLINE OFFLINE

Ora.jwdb02.ons application ONLINE ONLINE jwdb02

Ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

Ora....network ora....rk.type ONLINE ONLINE jwdb01

Ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

Ora.ons ora.ons.type ONLINE ONLINE jwdb01

Ora.orcl.db ora....se.type ONLINE ONLINE jwdb01

Ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

Ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

Marked: gsd

Ora.jwdb01.gsd

Ora.jwdb02.gsd

Ora.gsd

It's been abandoned. Uh, offline is normal.

All other items, target online,state (status) online

If offline occurs, there is a problem with 11g grid rac and needs to be checked.

Shutdown immediate

Incon/incon connect,dba,resource incon.dbf

Orcl bhjw/bhjw connect,dba,resource bhjw.dbf

Create tablespace incon

Datafile'+ DATADG'

Autoextend on

Next 5m maxsize 20480m

Extent management local

Create user incon identified by incon

Default tablespace incon

Create tablespace bhjw

Datafile'+ DATADG'

Size 5000m

Autoextend on

Next 5m maxsize 20480m

Extent management local

Create user bhjw identified by bhjw

Default tablespace bhjw

Grant connect,dba to incon

Grant connect,dba to bhjw

test

[root@jwdb01 ~] # su-oracle

[oracle@jwdb01 ~] $

[oracle@jwdb01 ~] $

[oracle@jwdb01 ~] $sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:25:00 2015

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP

Data Mining and Real Application Testing options

SQL >

SQL >

SQL >

SQL >

SQL > create tablespace incon

2 datafile'+ DATADG'

3 autoextend on

4 next 5m maxsize 20480m

5 extent management local

Tablespace created.

SQL > create user incon identified by incon

2 default tablespace incon

three

SQL >

SQL > create user incon identified by incon

2 default tablespace incon

User created.

SQL >

SQL >

SQL > grant connect,dba to incon

Grant succeeded.

SQL >

SQL >

SQL > create tablespace bhjw

2 datafile'+ DATADG'

3 size 5000m

4 autoextend on

5 next 5m maxsize 20480m

6 extent management local

Tablespace created.

SQL >

SQL > create user bhjw identified by bhjw

2 default tablespace bhjw

User created.

SQL >

SQL >

SQL > grant connect,dba to bhjw

Grant succeeded.

SQL > show paramater name

SP2-0158: unknown SHOW option "paramater"

SP2-0158: unknown SHOW option "name"

SQL > show parameter name

NAME TYPE VALUE

-

Cell_offloadgroup_name string

Db_file_name_convert string

Db_name string orcl

Db_unique_name string orcl

Global_names boolean FALSE

Instance_name string orcl1

Lock_name_space string

Log_file_name_convert string

Processor_group_name string

Service_names string orcl

SQL >!

[oracle@jwdb01 ~] $ps-ef | grep LOCAL

[grid@jwdb01] $crs_stat-t

Name Type Target State Host

Ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

Ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora.asm ora.asm.type ONLINE ONLINE jwdb01

Ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora....SM1.asm application ONLINE ONLINE jwdb01

Ora....01.lsnr application ONLINE ONLINE jwdb01

Ora.jwdb01.gsd application OFFLINE OFFLINE

Ora.jwdb01.ons application ONLINE ONLINE jwdb01

Ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

Ora....SM2.asm application ONLINE ONLINE jwdb02

Ora....02.lsnr application ONLINE ONLINE jwdb02

Ora.jwdb02.gsd application OFFLINE OFFLINE

Ora.jwdb02.ons application ONLINE ONLINE jwdb02

Ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

Ora....network ora....rk.type ONLINE ONLINE jwdb01

Ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

Ora.ons ora.ons.type ONLINE ONLINE jwdb01

Ora.orcl.db ora....se.type ONLINE ONLINE jwdb01

Ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

Ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

[grid@jwdb01 ~] $

[grid@jwdb01 ~] $

[oracle@jwdb01 ~] $sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:48:39 2015

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP

Data Mining and Real Application Testing options

SQL >

SQL >

SQL > shutdown abort

ORACLE instance shut down.

SQL > exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP

Data Mining and Real Application Testing options

[oracle@jwdb01 ~] $

[oracle@jwdb01 ~] $

[oracle@jwdb01 ~] $ps-ef | grep smon

Oracle 51634 51102 0 21:49 pts/3 00:00:00 grep smon

Root 62097 1 620: 04? 00:06:24 / home/u01/app/asm/bin/osysmond.bin

Grid 62240 1 0 20:04? 00:00:00 asm_smon_+ASM1

[oracle@jwdb01 ~] $

[grid@jwdb01 ~] $

[grid@jwdb01] $crs_stat-t

Name Type Target State Host

Ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

Ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora.asm ora.asm.type ONLINE ONLINE jwdb01

Ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora....SM1.asm application ONLINE ONLINE jwdb01

Ora....01.lsnr application ONLINE ONLINE jwdb01

Ora.jwdb01.gsd application OFFLINE OFFLINE

Ora.jwdb01.ons application ONLINE ONLINE jwdb01

Ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

Ora....SM2.asm application ONLINE ONLINE jwdb02

Ora....02.lsnr application ONLINE ONLINE jwdb02

Ora.jwdb02.gsd application OFFLINE OFFLINE

Ora.jwdb02.ons application ONLINE ONLINE jwdb02

Ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

Ora....network ora....rk.type ONLINE ONLINE jwdb01

Ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

Ora.ons ora.ons.type ONLINE ONLINE jwdb01

Ora.orcl.db ora....se.type ONLINE ONLINE jwdb02

Ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

Ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

[oracle@jwdb01 ~] $sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:50:08 2015

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

Connected to an idle instance.

SQL > startup

ORACLE instance started.

Total System Global Area 4.4896E+10 bytes

Fixed Size 2263296 bytes

Variable Size 7381976832 bytes

Database Buffers 3.7447E+10 bytes

Redo Buffers 64831488 bytes

Database mounted.

Database opened.

SQL > exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP

Data Mining and Real Application Testing options

[oracle@jwdb01 ~] $ps-ef | grep smon

Oracle 52029 1 0 21:50? 00:00:00 ora_smon_orcl1

Oracle 52216 51102 0 21:50 pts/3 00:00:00 grep smon

Root 62097 1 620: 04? 00:06:30 / home/u01/app/asm/bin/osysmond.bin

Grid 62240 1 0 20:04? 00:00:00 asm_smon_+ASM1

[grid@jwdb01] $crs_stat-t

Name Type Target State Host

Ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

Ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora.asm ora.asm.type ONLINE ONLINE jwdb01

Ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora....SM1.asm application ONLINE ONLINE jwdb01

Ora....01.lsnr application ONLINE ONLINE jwdb01

Ora.jwdb01.gsd application OFFLINE OFFLINE

Ora.jwdb01.ons application ONLINE ONLINE jwdb01

Ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

Ora....SM2.asm application ONLINE ONLINE jwdb02

Ora....02.lsnr application ONLINE ONLINE jwdb02

Ora.jwdb02.gsd application OFFLINE OFFLINE

Ora.jwdb02.ons application ONLINE ONLINE jwdb02

Ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

Ora....network ora....rk.type ONLINE ONLINE jwdb01

Ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

Ora.ons ora.ons.type ONLINE ONLINE jwdb01

Ora.orcl.db ora....se.type ONLINE ONLINE jwdb01

Ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

Ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

[root@jwdb02] # su-oracle-c "srvctl stop instance-d orcl-I orcl2"

[root@jwdb02 ~] #

[root@jwdb02 ~] #

[root@jwdb02 ~] # su-root-c "/ home/u01/app/asm/bin/crsctl stop crs"

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'jwdb02'

CRS-2673: Attempting to stop 'ora.crsd' on' jwdb02'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'jwdb02'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on' jwdb02'

CRS-2673: Attempting to stop 'ora.CRSDG.dg' on' jwdb02'

CRS-2673: Attempting to stop 'ora.registry.acfs' on' jwdb02'

CRS-2673: Attempting to stop 'ora.ARCHDG.dg' on' jwdb02'

CRS-2673: Attempting to stop 'ora.DATADG.dg' on' jwdb02'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on' jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.jwdb02.vip' on' jwdb02'

CRS-2677: Stop of 'ora.ARCHDG.dg' on' jwdb02' succeeded

CRS-2677: Stop of 'ora.DATADG.dg' on' jwdb02' succeeded

CRS-2677: Stop of 'ora.registry.acfs' on' jwdb02' succeeded

CRS-2677: Stop of 'ora.jwdb02.vip' on' jwdb02' succeeded

CRS-2672: Attempting to start 'ora.jwdb02.vip' on' jwdb01'

CRS-2676: Start of 'ora.jwdb02.vip' on' jwdb01' succeeded

CRS-2677: Stop of 'ora.CRSDG.dg' on' jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.asm' on' jwdb02'

CRS-2677: Stop of 'ora.asm' on' jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.ons' on' jwdb02'

CRS-2677: Stop of 'ora.ons' on' jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on' jwdb02'

CRS-2677: Stop of 'ora.net1.network' on' jwdb02' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'jwdb02' has completed

CRS-2677: Stop of 'ora.crsd' on' jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.crf' on' jwdb02'

CRS-2673: Attempting to stop 'ora.ctssd' on' jwdb02'

CRS-2673: Attempting to stop 'ora.evmd' on' jwdb02'

CRS-2673: Attempting to stop 'ora.asm' on' jwdb02'

CRS-2673: Attempting to stop 'ora.drivers.acfs' on' jwdb02'

CRS-2673: Attempting to stop 'ora.mdnsd' on' jwdb02'

CRS-2677: Stop of 'ora.evmd' on' jwdb02' succeeded

CRS-2677: Stop of 'ora.crf' on' jwdb02' succeeded

CRS-2677: Stop of 'ora.mdnsd' on' jwdb02' succeeded

CRS-2677: Stop of 'ora.asm' on' jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on' jwdb02'

CRS-2677: Stop of 'ora.drivers.acfs' on' jwdb02' succeeded

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on' jwdb02' succeeded

CRS-2677: Stop of 'ora.ctssd' on' jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on' jwdb02'

CRS-2677: Stop of 'ora.cssd' on' jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on' jwdb02'

CRS-2677: Stop of 'ora.gipcd' on' jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on' jwdb02'

CRS-2677: Stop of 'ora.gpnpd' on' jwdb02' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'jwdb02' has completed

CRS-4133: Oracle High Availability Services has been stopped.

[root@jwdb02 ~] #

[grid@jwdb01] $crs_stat-t

Name Type Target State Host

Ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

Ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora.asm ora.asm.type ONLINE ONLINE jwdb01

Ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora....SM1.asm application ONLINE ONLINE jwdb01

Ora....01.lsnr application ONLINE ONLINE jwdb01

Ora.jwdb01.gsd application OFFLINE OFFLINE

Ora.jwdb01.ons application ONLINE ONLINE jwdb01

Ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

Ora....SM2.asm application ONLINE ONLINE jwdb02

Ora....02.lsnr application ONLINE ONLINE jwdb02

Ora.jwdb02.gsd application OFFLINE OFFLINE

Ora.jwdb02.ons application ONLINE ONLINE jwdb02

Ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb02

Ora....network ora....rk.type ONLINE ONLINE jwdb01

Ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

Ora.ons ora.ons.type ONLINE ONLINE jwdb01

Ora.orcl.db ora....se.type ONLINE ONLINE jwdb01

Ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

[grid@jwdb01] $crs_stat-t

Name Type Target State Host

Ora.ARCHDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.CRSDG.dg ora....up.type ONLINE ONLINE jwdb01

Ora.DATADG.dg ora....up.type ONLINE ONLINE jwdb01

Ora....ER.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora....N1.lsnr ora....er.type ONLINE ONLINE jwdb01

Ora.asm ora.asm.type ONLINE ONLINE jwdb01

Ora.cvu ora.cvu.type ONLINE ONLINE jwdb01

Ora.gsd ora.gsd.type OFFLINE OFFLINE

Ora....SM1.asm application ONLINE ONLINE jwdb01

Ora....01.lsnr application ONLINE ONLINE jwdb01

Ora.jwdb01.gsd application OFFLINE OFFLINE

Ora.jwdb01.ons application ONLINE ONLINE jwdb01

Ora.jwdb01.vip ora....t1.type ONLINE ONLINE jwdb01

Ora.jwdb02.vip ora....t1.type ONLINE ONLINE jwdb01

Ora....network ora....rk.type ONLINE ONLINE jwdb01

Ora.oc4j ora.oc4j.type ONLINE ONLINE jwdb01

Ora.ons ora.ons.type ONLINE ONLINE jwdb01

Ora.orcl.db ora....se.type ONLINE ONLINE jwdb01

Ora....ry.acfs ora....fs.type ONLINE ONLINE jwdb01

Ora.scan1.vip ora....ip.type ONLINE ONLINE jwdb01

[grid@jwdb01 ~] $

Backup

Exp. If you are an oracle user who logs in to a Linux server, use the full library export full=y parameter, plus buffer=1000000, and use system/oracle

Archive cleanup, available later

11g storage

Multipath bare disk, partition build lvm, and then raw device binding.

Or multi-path bare disk udev binding

Base System > Base

Base System > Client management tools

Base System > Compatibility libraries

Base System > Hardware monitoring utilities

Base System > Large Systems Performance

Base System > Network file system client

Base System > Performance Tools

Base System > Perl Support

Servers > Server Platform

Servers > System administration tools

Desktops > Desktop

Desktops > Desktop Platform

Desktops > Fonts

Desktops > General Purpose Desktop

Desktops > Graphical Administration Tools

Desktops > Input Methods

Desktops > X Window System

Applications > Internet Browser

Development > Additional Development

Development > Development Tools

Rpm-Uvh binutils-2.*

Rpm-Uvh compat-libstdc++-33*

Rpm-Uvh elfutils-libelf-0.*

Rpm-Uvh libaio-0.*

Rpm-Uvh libaio-devel-0.*

Rpm-Uvh sysstat-9.*

Rpm-Uvh glibc-2.*

Rpm-Uvh glibc-common-2.*

Rpm-Uvh glibc-devel-2.* glibc-headers-2.*

Rpm-Uvh ksh-2*

Rpm-Uvh make-3.*

Rpm-Uvh libgcc-4.*

Rpm-Uvh libstdc++-4.*

Rpm-Uvh libstdc++-4.*.i686*

Rpm-Uvh libstdc++-devel-4.*

Rpm-Uvh gcc-4.*x86_64*

Rpm-Uvh gcc-c++-4.*x86_64*

Rpm-Uvh-- allfiles elfutils-libelf-0*x86_64* elfutils-libelf-devel-0*x86_64*

Rpm-Uvh elfutils-libelf-0*i686* elfutils-libelf-devel-0*i686*

Rpm-Uvh libtool-ltdl*i686*

Rpm-Uvh ncurses*i686*

Rpm-Uvh readline*i686*

Rpm-Uvh unixODBC*

Vi / etc/sysctl.conf

# oracle rac config parameter

Fs.aio-max-nr = 1048576

Fs.file-max = 6815744

# kernel.shmall = 2097152

# kernel.shmmax = 1054504960

Kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

Kernel.sem = 250 32000 100 128

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

Vi / etc curity mits.conf

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 4096

Oracle hard nofile 65536

Oracle soft stack 10240

Grid soft nproc 2047

Grid hard nproc 16384

Grid soft nofile 4096

Grid hard nofile 65536

Grid soft stack 10240

Vi / etc/pam.d/login

Session required pam_limits.so

Groupadd-g 500 oinstall

Groupadd-g 501 dba

Useradd-u 501-g oinstall-G dba oracle

Passwd oracle

Useradd-u 500-g oinstall-G dba grid

Passwd grid

[root@oradb1 ~] # id oracle

Uid=501 (oracle) gid=500 (oinstall) groups=500 (oinstall), 501 (dba)

[root@oradb1 ~] # id grid

Uid=500 (grid) gid=500 (oinstall) groups=500 (oinstall), 501 (dba)

When unlocking the grid bag

Rpm-Uvh cvuqdisk*

Cat / etc/hosts

127.0.0.1 localhost

# rac 112 config

# scan-ip

192.168.56.30 racdb-scan

# public-ip

192.168.56.31 racdb1

192.168.56.33 racdb2

# private-ip

10.10.10.31 racdb1-priv

10.10.10.33 racdb2-priv

# virtual-ip

192.168.56.32 racdb1-vip

192.168.56.34 racdb2-vip

Vi / etc curity mits.d/90-nproc.conf

# Change this

* soft nproc 1024

# To this

*-nproc 16384

Cat / etc linux/config

# This file controls the state of SELinux on the system.

# SELINUX= can take one of these three values:

# enforcing-SELinux security policy is enforced.

# permissive-SELinux prints warnings instead of enforcing.

# disabled-No SELinux policy is loaded.

SELINUX=disabled

# SELINUXTYPE= can take one of these two values:

# targeted-Targeted processes are protected

# mls-Multi Level Security protection.

SELINUXTYPE=targeted

Service iptables stop

Chkconfig iptables off

/ oracle/grid

/ oracle/asm

/ oracle

# mkdir-p / u01/app/11.2.0/grid

# mkdir-p / u01/app/grid

# mkdir-p / u01/app/oracle

# chown grid:oinstall / u01/app/11.2.0/grid

# chown grid:oinstall / u01/app/grid

# chown oracle:oinstall / u01/app/oracle

# chmod-R 775 / u01 /

# chown-R grid:oinstall / U01

Yang Dong 22:24:18

Mkdir-p / u01/app/grid

Mkdir-p / u01/app/11.2/grid

Mkdir-p / u01/oracle/product/11.2

Chown-R oracle:oinstall / u01/oracle

Chown-R grid:oinstall / U01

Chmod-R 775 / U01

# grid

Export ORACLE_BASE=/u01/app/grid

Export ORACLE_HOME=/u01/app/11.2/grid

Export ORACLE_SID=+ASM1

Export NLS_LANG=AMERICAN_AMERICA.UTF8

Export NLS_DATE_FORMAT= "yyyy-mm-dd hh34:mi:ss"

Export ORACLE_TERM=xterm

Export PATH=.:$ {PATH}: $ORACLE_HOME/bin

Export PATH=$ {PATH}: / usr/bin:/bin:/usr/bin/X11:/usr/local/bin

Export PATH=$ {PATH}: $ORACLE_BASE/common/oracle/bin

Export ORACLE_PATH=$ {PATH}: $ORACLE_BASE/common/oracle l:.:$ORACLE_HOME/rdbms/admin

Export LD_LIBRARY_PATH=$ORACLE_HOME b:$ORACLE_HOME/oracm b: b:/usr b:/usr/local b

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

Echo ORACLE_SID=$ORACLE_SID

Echo ORACLE_BASE=$ORACLE_BASE

Echo ORACLE_HOME=$ORACLE_HOME

# oracle

Export ORACLE_BASE=/u01/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2

Export ORACLE_SID=oradb1

Export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

Export NLS_DATE_FORMAT= "yyyy-mm-dd hh34:mi:ss"

Export PATH=.:$ {PATH}: $HOME/bin:$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:$ORACLE_BASE/common/oracle/bin

Export ORACLE_PATH=$ {PATH}: $ORACLE_BASE/common/oracle l:.:$ORACLE_HOME/rdbms/admin

Export LD_LIBRARY_PATH=$ORACLE_HOME b:$ORACLE_HOME/oracm b: b:/usr b:/usr/local b

Export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

Export ORACLE_TERM=xterm

Echo ORACLE_SID=$ORACLE_SID

Echo ORACLE_BASE=$ORACLE_BASE

Echo ORACLE_HOME=$ORACLE_HOME

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report