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

Oracle 11g R2 installation and configuration

2025-02-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

-- = 0: XServer ready

Install XServer and configure XShell

-- Xming,Xmanager,Vcxsrv

-- = 1: disk partitioning and mounting

Cd / etc/yum.repos.d/

# # scp ol6.repo root:10.198.15.105:/etc/yum.repos.d/

Rm public-yum-ol6.repo

Df-lh

Lsblk

Lvm

Pv

Pvcreate / dev/sdb

Pvdisplay

Vgcreate vg_oracle / dev/sdb

Vgdisplay

Lvdisplay

# Total PE of vgdispaly

Lvcreate-l 127999-n oracle vg_oracle

Lvdisplay

Mkfs.ext4 / dev/vg_oracle/oracle

Mkdir / oracle

# # obtaining UUID

Ls-l / dev/disk/by-uuid/

# # or

Blkid / dev/vg_oracle/oracle

# # mounting UUID

Vi / etc/fstab

# # add one line

UUID=a75d1657-2609-494b-91e6-8d908a5218fa / oracle ext4 defaults 1 2

# # check

Mount-a

Df-lh

-- = 2: pre-installed

Yum list oracle

Yum search oracle

Yum list oracle-rdbms-server-11gR2-preinstall.x86_64

Yum install oracle-rdbms-server-11gR2-preinstall.x86_64

-- = 3: configuration

Passwd oracle

Chown-R oracle:oinstall / oracle

# # modifying Host name

Vi / etc/sysconfig/network

Reboot

# # add all ADG servers to resolution

Vi / etc/hosts

-= 4: install

# # Log in and install as oracle user

Ssh oracle@10.198.15.104

Cd / oracle/

Unzip p13390677_112040_Linux-x86-64_1of7.zip

Unzip p13390677_112040_Linux-x86-64_2of7.zip

Cd database/

. / runInstaller

# # switch to root to execute script

Su-

Cd / oracle/oraInventory/

. / orainstRoot.sh

Cd / oracle/product/11.2.0/

. / root.sh

# # switching back to execution under oracle

Exit

Cd ~

# # modify .bash _ profile file

Vi .bash _ profile

# Oracle Settings

ORACLE_BASE=/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOME

ORACLE_SID=DB11G; export ORACLE_SID

PATH=$ORACLE_HOME/bin:$PATH; export PATH

Source .bash _ profile

# # shutting down SELINUX

Getenforce

Setenforce 0

# # set SELINUX to disabled

Vi / etc/selinux/config

-- = 5: build a database

Mkdir / oracle/archive

Dbca

-- = 6: configuration

1) netca add listening

2) configure the archive directory log_archive_dest_1

One view the path location of the archive file

Show parameter log_archive_dest_1

2. Close the database

Alter database chenkpoint

Shutdown immediate

Three mount the database

Start mount

4. Modify the archive path

Alter system set log_archive_dest_1='LOCATION=/oracle/archive'

5. Start the database

Alter database open

6. Check whether it is effective.

Select archiver from v$instance

Alter system switch logfile

Ls / oracle/archive

3) configure delay segment creation to close

Alter system set deferred_segment_creation=false

4) modify the default password policy

Alter profile default limit password_life_time unlimited

-- = 7: test port

# # testing the availability of ports 1521 and 22

Yum-y install telnet

Telnet 10.1.1.74 1521

Ssh root@10.1.1.74

-- = 8: other configuration

1) modify / etc/oratab, which is used by Oracle utilities, such as dbstart, dbshut

$ORACLE_SID:$ORACLE_HOME:

Sicilybak:/oracle/product/11.2.0:Y

2) Oracle EM agent depends on / etc/oratab and the snooping created by netca.

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