Skip to content

Archive for

Solaris installation on Vmware

Step 1 : open your vmware, click new virtual machine and then new window will be appear.Choose typical and click next.

Step 2 : Here choose your operating system iso file.

Step 3: Here choose your path where your OS files will be store .So you must create one folder for new OS and name it solaris.The particular folder disk minimum 10gb enough space is better.

Step 4 : Here choose maximum disk space ,i choosed 50gb for solaris installation.

Step 5: Here Choose your hardware and memory size.

Step 6: After configuration, click power on this virtual machine , after clicked the solaris will be boot for installation, so you care fully do it your steps and most of the steps click default so i ignored some steps but you must choosed customized install for solaris because you should increase your swap space minimum 1024mb,it will be usefull for when you’re try to install Oracle on solaris and then your counting size will be equal.

Step 7 : hereafter some of the steps default select next what you want.

Step 8 : root password.

Step 9 : welcome screen

Step 10: Click default next but you  must choose customized install then only we can configure swap space and some space ,the spaces must be equal of your choosed disk space size.

Step 11 : Click Install Now.

Step 12: Solaris Installation will be progressing. It will take few minutes after installation,it automatically reboot and the welcome page will be appear.

Step 13 : Welcome to Solaris World and login root username and password.

VMWARE Installation On Windows 7

Step 1 :- Click vmware.exe setup file and then the vmware setup window will be appear.Click Next.

Step 2: Choose Typical and click Next.

Step 3:

Step 4: Ready for Install Click Install.

Step 5: Installation starting, it will take few minutes.

Step 6: VMWARE installation completed.

ORA-28365: wallet is not open

When i try to make export one table using datapump with encryption_password parameter , It shows following error.

ORA-39001: invalid argument value
ORA-39180: unable to encrypt ENCRYPTION_PASSWORD
ORA-28365: wallet is not open

So i try to fix this error,

Create folder for wallet in $ORACLE_BASE/admin/SID/wallet

and then go to add it this below statement to sqlnet.ora file.

WALLET_LOCATION = (SOURCE=
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY=D:\oracle\product\10.2.0\admin\ACE\wallet)
)))

then

SQL> alter system set key identified by test;

sytem altered.

Now you can able to using encryption_password parameter.

C:\Documents and Settings\Administrator>EXPDP SCOTT/TIGER@ace DIRECTORY=TEST ENC
RYPTION_PASSWORD=test tables=test

Export: Release 10.2.0.1.0 – 64bit Production on Sunday, 28 March, 2010 14:52:34
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit
Production
With the Partitioning, OLAP and Data Mining options
Starting “SCOTT”.”SYS_EXPORT_TABLE_01″:  SCOTT/********@ace DIRECTORY=TEST ENCRY
PTION_PASSWORD=********* tables=*********
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported “SCOTT”.”TEST”                              5.664 KB       4 rows
Master table “SCOTT”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  H:\TEST\EXPDAT.DMP
Job “SCOTT”.”SYS_EXPORT_TABLE_01″ successfully completed at 14:52:47.

RMAN: Create Catalog

How to create catalog for rman backup.I just provided here for step by step create catalog.