Oracle installation: Oracle Binary Cloning
Clone the oracle software between two server.
Please check the OS compatibility are same between source & destination server.
Tar the oracle home 10.2.0.1
$tar -cvf 10.2.0.1.tar 10.2.0.1
Copy the oracle binary tar file from source server to Destination server.
$mkdir -p /apps/oracle/product
DBA’s faced data fragmentation issues frequently. Data fragmentation affects the database performance.
In production database, we need to follow any one of the below method to solve the fragmentation issue.
1. Alter table
--- Also we need to rebuild the indexes associate with tables.
2. Export the table / truncate the table / import the table
3. Create table
4. Online Data Redefinition
Table is not accessible for during the reorganization of table using Method 1, 2 & 3.
RAC Background Processes:
1. Lock Monitor Processes ( LMON)
2. Lock Monitor Services (LMS)
3. Lock Monitor Daemon Process ( LMD)
4. LCKn ( Lock Process)
5. DIAG (Diagnostic Daemon)
Trasliteration - Conversion of double/triple byte characters to single byte characters for various requirementsSubmitted by ayush_anand on Mon, 2009-12-07 06:49
I recently came across a document where the requirement was to convert from triple/double byte characters to single byte characters to send it for export complaince check as the export compliance system can accept only single byte characters.
Basically the useful thing about this was they were using IBM ICU project(an open source project) for this process,so in a way making it more open to developers.
These were the pros and cons for IBM identified by them.
- No interface needed (written in Java, integrable in Oracle)
- High level of portability, flexibility and scalability
- No int
Error:Heartbeat failed to connect to standby Error 12541
By using rdist command, one can copy Oracle's password file from primary site to physical standby site.
import done in US7ASCII character set and AL16UTF16 NCHAR character setSegmentation Fault (coredump)Submitted by rajabaskar on Wed, 2009-09-30 19:25
Last week I migrated some schemas from 11g database (18.104.22.168) to 9i database (22.214.171.124).
I used to export the 11g schemas using oracle 9i binary & exported successfully.
While importing 11g schema’s into 9i database I faced below issues.
Error: import done in US7ASCII character set and AL16UTF16 NCHAR character setSegmentation Fault (coredump)
Operating system: Sun Solaris 10 / 64 bit processor
I exported the 11g schema’s using 10g binary and imported into 10g database
Last week, I worked on schema refresh in 11g database from one box to another box using data pump.
Schema size: around 90 GB.
Normally we follow below steps: (I have sufficient space in file system, so I am using below steps)
1.Export the schema using expdp/exp utility.
2.Compress the dump file.
3.Transfer the data through ftp to another box.
4.Just import it.
Step 2, depend upon dump size.
I have sufficient space in file system, so I am using method 1.
1.Export the schema using expdp/exp utility (during export they used
Answer: Although this may be a undervalued question, I got many a search for my blog with this question. This is where I wanted to address this question elaborately or rather in multiple ways.
XML: XML is an acronym for ‘Extensible Markup Language’. It is used for defining data
elements on a webpage and business to business document. XML uses a similar tag
structure as HTML; however, whereas HTML defines how the elements are displayed,
XML defines what those elements contain.
Manually database creation is one of the more frequently performed actions of a professional DBA. And, with Oracle 11g it only takes a few minutes to do :)
The procedure is same as previous which we are used for 9i and 10g.
In this database creation I used below features:
1. OMF (Oracle Managed File) for datafiles, redolog files & controlfiles
2. FRA (Flash Recovery Area) for Archivelog or backup files
3. ASM (Automatic Storage Mgmt) for Volume manager
1. Create Required Directories