vipin's blog

I was trying to install oracle soa server, but there was a lot of issues, I faced and then decide to write this blog. There is a lot of help available but the problem is its spread across a number of sites and documents. A developer with some basic knowledge and if want to learn Oracle Soa will be in the net of all these sites and documents to install a basic SOA server. So I am trying to point out the basic steps which need to configure a Oracle SOA server. Prerequisite There are number of pieces you need to download before starting the installation. my advice is first download all these files because these are quite large files and in the installation process you need all these files, which will make installation task 10-20 job once you have all these files. Another prerequisite is oracle database. That is must for SOA installation, if you don't have oracle database installed you may need to install oracle database too. I would advice to go for oracle xe, a small light weight...

Today I need to migrate my schema from oracle xe in my system to another system which is a Linux box. I had to revisit a number of command, which is quite helpful. I used the export import utility provided by oracle. Its quite easy and straight forward. Step 1 Exporting schema to a dump file D:\Oracle\db\app\oracle\product\10.2.0\server\BIN>expdp system/**** schemas= hr directory=C:\Temp dumpfile=hrdump.dmp logfile=rexp.log Export: Release 10.2.0.1.0 - Production on Monday, 31 January, 2011 5:51:24 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Productio n ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-39087: directory name C:\TEMP is invalid Then l reliesed that oracle does not know my directory. Then create this directory by login to database with user name and password system/****** sqlplus> create directory hrdump as 'C:\Te...