By using rdist command, one can copy Oracle's password file from primary site to physical standby site. Even if the SYS password is same on both the servers, you must copy the password file from primary to standby.

Step 1
install rsh-server package on both the servers.

Step 2
#vi /etc/xinetd.d/rlogin
disable=no

Step 3
#service xinetd restart

Step 4
$cd $ORACLE_HOME/dbs
$rdist -c orapwcoretest oracle@:/opt/app/oracle/product/11.2.0/dbhome_1/dbs/orapwcoretest

---Succeffull message----

Last week I migrated some schemas from 11g database (11.1.0.6) to 9i database (9.2.0.8).

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

Note:

I exported the 11g schema’s using 10g binary and imported into 10g database
successfully.

Last week, I worked on schema refresh in 11g database from one box to another box using data pump.

Schema size: around 90 GB.
Version: 11.1.0.7

Method 1:

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.

Note:
I have sufficient space in file system, so I am using method 1.

Method 2:

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

E:\>mkdir e:\oracle\ORA11G

Before commencing to read this article, I would suggest you to go through the Oracle Database Architecture ( Oracle Database Architecture ) Article to gain insight about the oracle various structures.

The following example describes the most basic level of operations that Oracle performs.

Oracle PL/SQL Server Pages (PSP) is Oracle's PL/SQL dynamic server-side scripting solution for Web application development. Oracle PSP includes the PL/SQL Server Pages Compiler and the PL/SQL Web Toolkit. Oracle PSP enables PL/SQL users to develop Web pages with dynamic content by embedding PL/SQL scripts in HTML. PSPs separate application logic (embedded PL/SQL scripts) from the layout logic (HTML) making the development and maintenance of PL/SQL Server Pages easy.

Well, just for a briefing, since 1966, most of the United States has observed Daylight Saving Time from at 2:00 a.m. on the first Sunday of April to 2:00 a.m. on the last Sunday of October. But in 2007, most of the U.S. will begin Daylight Saving Time at 2:00 a.m. on the second Sunday in March and revert to standard time on the first Sunday in November.

So, Oracle has released patches to adapt these Daylight saving time changes. The databases that are using the following will be impacted…

1. Databases using TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE data types and TZ_OFFSET function as they take their time zone information from Oracle's time zone files.

Recently Performance Tuning compared Oracle 10gR2 RAC on Windows Server 2003 x64 vs. RHEL. You can download the paper from microsoft-oracle.com

The following behavior was observed during testing of the Oracle RAC databases on Red
Hat Enterprise Linux x86_64 and Microsoft Windows Server 2003 Enter:
Oracle RAC Stress Test
o Transactions Per Minute were roughly equivalent for 2 - 150 user sessions.
o Transactions Per Minute were up to 16% higher for MS Windows for 150
- 250 users.
o CPU usage was above 90% for all of these tests for both Linux and MS
Windows Server.
o The response times for the “New Company Registration” test component