Oracle Change Password

CHECK BIG FILES!!!!


export http_proxy=http://139.188.98.57:22

cd /etc/yum.repos.d

wget http://public-yum.oracle.com/public-yum-ol6.repo

yum install oracle-rdbms-server-11gR2-preinstall

mkdir /home/OraDB11g

Chown oracle:oinstall

su - oracle

cd /home/OraDB11g

unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip

cd /home/OraDB11g/database

export DISPLAY=oss-srv-lab-01:0.0

./runInstaller

139.188.98.111
139.188.98.114

139.188.98.110
139.188.98.113

oracle passwords are arsystem


yum install libaio-0*i686* libaio-devel-0*i686* libstdc++-4*i686* glib* compat-libstdc++* elfutils-libelf-devel-* libgcc-* libstdc++-* unixODBC-* unixODBC-devel-* binutils glibc compat-libstdc++-33 glibc-common

glibc-devel glibc-headers elfutils-libelf elfutils-libelf-devel elfutils gcc gcc-c++ ksh libaio libaio-devel libgcc libstdc++-devel make numactl-devel sysstat mksh

PATH=$PATH:$HOME/bin:/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin
TMP=/usr/local/oracle/app/tmp
TMPDIR=/home/oracle/app/tmp
export TMP TMPDIR
ORACLE_BASE=/home/oracle/app/oracle
ORACLE_SID=ars
ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
ORACLE_UNQNAME=ARS
export ORACLE_BASE ORACLE_SID ORACLE_HOME ORACLE_UNQNAME

export PATH LD_LIBRARY_PATH ORACLE_BASE ORACLE_SID ORACLE_HOME ORACLE_UNQNAME

Create DB:

CREATE TABLESPACE ARSYSTEM DATAFILE '/usr/local/ars_data/ars/ARSYS' size 8000M reuse AUTOEXTEND ON;
CREATE TEMPORARY TABLESPACE ARTMP TEMPFILE '/usr/local/ars_data/ars/ARTMP' SIZE 2000M REUSE AUTOEXTEND ON;
create user ARAdmin identified by "AR#Admin#" PROFILE "DEFAULT" TEMPORARY TABLESPACE "ARTMP" DEFAULT TABLESPACE "ARSYSTEM" QUOTA UNLIMITED on "ARSYSTEM";
CREATE ROLE ARADMINROLE NOT IDENTIFIED;
GRANT ARADMINROLE TO ARADMIN;
GRANT ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE TRIGGER, QUERY REWRITE TO ARADMINROLE;


Delete AR DB:

drop role aradminrole;
drop user aradmin cascade;
DROP TABLESPACE ARTMP INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE ARSYSTEM INCLUDING CONTENTS AND DATAFILES;


expdp system/ars@ars FULL=y DIRECTORY=DPUMP_DIR1 DUMPFILE=arsystem_patch5.dmp CONTENT=ALL

impdp system/ars@ars DIRECTORY=dpump_dir1 DUMPFILE=arsystem_patch5.dmp


expdp system/ars@ars schemas=ARADMIN directory=DPUMP_DIR1 dumpfile=aradmin.dmp logfile=expdparadmin.log

impdp system/ars@ars schemas=ARADMIN directory=dpump_dir1 dumpfile=aradmin.dmp logfile=impdparadmin.log


alter user ARAdmin identified by "AR#Admin#";

S5 Box

Login