Technical Oracle Articles
Submitted by trantuananh24hg on Sun, 2016-10-16 23:24
- Msocial: Sparc Solaris 10
- STS_VMWare: x86_64 Solaris platform
2. Utility: RMAN
3. Task list details
3.1. On Source (MSocial)
3.1.1. Create test user schema & generate data in
sys@MSOCIAL> create user msocialtest identified by msocial
2 default tablespace users
3 temporary tablespace temp
4 quota unlimited on users
sys@MSOCIAL> grant connect, resource, create session, dba to msocialtest;
Submitted by trantuananh24hg on Wed, 2016-08-24 21:56
AIX is like an Unix environment awesome original, same to HP-Unix, and, if you have a plan to install Oracle RAC, you need to pay attention. I note some tips in this article to help.
1. Checking Operating System Packages
# lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.libperfstat \
bos.perf.perfstat bos.perf.proctools rsct.basic.rte rsct.compat.clients.rte \
If not, install on AIX source by smity. It's easy, but remember, some packaged requires your IBM's account to download.
Submitted by trantuananh24hg on Tue, 2016-08-23 04:34
In previous article, I described the task list of configuration software raid on Solaris. And here, I brief the task list of configuration hardware raid on Sun Sparc model T.
Ofcoruse, the first step is connection to the server with serial console cable, assume the new server.
data bit = 8
baud rate = 9600
Recommend tool: Sercure CRT, Putty.
Submitted by trantuananh24hg on Tue, 2016-08-23 04:02
I worked on Unix many years ago, however, Solaris, AIX and HP-Unix are the platforms I often did with. I'm DBA, but there are not any System Administrator in my company, and I .. do the System's business at all.
Before ZFS becomes popular, UFS was always the best choice for Solaris, especially in M's series, example: Sun M-3000, M-4000, M-5000 ...etc. The M series does not support Hardware Raid, but only software, and this article do the brief of creating the software raid in. It's one of task list before configuration and installation Oracle in Solaris 10.
Submitted by trantuananh24hg on Tue, 2016-08-23 03:50
There are some tips when I finished the installation Oracle 11gr2 on RHEL6.
Full documents exits in Oracle documents library, so you can read them first
1. Install the requirement pacakges
[root@spsdev ~]#yum install local compat-libstdc++-33*
[root@spsdev ~]#yum install local libaio-devel-0.*
[root@spsdev ~]#yum install local pdksh-5.*
[root@spsdev ~]#yum install local unixODBC-devel-2.*
[root@spsdev ~]#yum install local sysstat-7.*
Submitted by trantuananh24hg on Tue, 2016-08-23 03:37
I'm new on Orafaq, this is my first blog. Thank you Sir John Watson promoted and supported me, and I'm sorry, I usually wrote bad English language.
Submitted by jeetendra.kappala on Mon, 2016-04-11 14:23
Performing a 32 bit to 64 bit migration using the Transportable Database RMAN feature
This note describes the procedure used to perform a 32 bit to 64 bit conversion of an 220.127.116.11 database on the Linux platform.
The RMAN CONVERT DATABASE command is used to automate the movement of an entire database from one platform (the source platform) to another (the destination platform).
This is provided that the source and destination platforms are of the same endian format.
For example between Linux X86 32 bit and Linux X86 64 bit.
Note the following:
Submitted by John Watson on Sat, 2016-03-05 06:04
DB Time is the time spent by the database server executing user calls. What is this composed of? CPU time, waiting time, and IO time.
Submitted by sramawat on Thu, 2015-06-18 02:12
This paper provides best practices for rapid deployment of Oracle Database Vault protections to
secure sensitive application data inside the database. Oracle Database Vault enables you to restrict administrative access to an Oracle
database. This helps you address the most difficult security problems remaining
today: protecting against insider threats, meeting regulatory compliance
requirements, and enforcing separation of duty. It covers the following main topics:
Submitted by Peter.VanderWoude on Tue, 2015-02-03 12:21
This post shows you details about a specific case where 'hash anti join' is defeated by 'nested loop anti join'.
The initial problem came to light in a very large BW system running on Oracle 18.104.22.168 when several BW loads (making use of older data in the BW system) reported missing dimension ids in the dimension tables.