In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.