Sundaramurthy Blog

April 29, 2010

Importing oracle trusted certificate into oracle wallets

Filed under: Oracle commands — sundar5 @ 10:10 pm

I am assuming user is created trusted certificate and hand over to you. As a oracle dba
you have to import the trusted certificate in the oracle database server.

How to import user trusted certificate into oracle wallets

1. Create wallet

Syntax: orapki wallet create -wallet <wallet_location>

$orapki wallet create -wallet ‘/home/oracle/admin/WALLETS’
Enter password:
Enter password again:

2. copy/ftp the user trusted certificate to database server temp location

/tmp/testwallet_ssl.cer

3. To add a trusted certificate to an Oracle wallet:

Syntax:  orapki wallet add -wallet <wallet_location> -trusted_cert -cert <certificate_location>

$orapki wallet add -wallet ‘/home/oracle/admin/WALLETS’ -trusted_cert -cert ‘/tmp/testwallet_ssl.cer’

4. To view an Oracle wallet:
Syntax:  orapki wallet display -wallet <wallet_location>

$orapki wallet display -wallet ‘/home/oracle/product/WALLETS/oracle’

Advertisements

February 24, 2010

Find the OS of the server the database is running on

Filed under: Oracle commands — sundar5 @ 12:48 am

SQL> set serveroutput on
SQL> begin
dbms_output.put_line(dbms_utility.port_string);
end;
/
x86_64/Linux 2.4.xx

PL/SQL procedure successfully completed.

February 23, 2010

CRS is enabled for auto start

Filed under: cluster commands,Oracle commands — sundar5 @ 5:15 am

$GRID_HOME/bin/crsctl enable crs

February 12, 2010

BIG Tablespace resize

Filed under: Oracle commands — sundar5 @ 7:11 am

alter database datafile ‘+DATA/test/datafile/data01.4537.692245113’ autoextend on next 64m maxsize 7000G;

Find oracle binary 32bits or 64 bits

Filed under: Oracle commands — sundar5 @ 7:09 am

oracle 32bits

SQL> select length(SADDR) from v$session where rownum=1;

LENGTH(SADDR)
————-
8

oracle 64 bits

sql > select length(SADDR) from v$session where rownum=1;

LENGTH(SADDR)
————-
16

setting underscore parameter

Filed under: Oracle commands — sundar5 @ 7:05 am

SQL> alter system set “_bloom_filter_enabled”=FALSE scope=BOTH sid=’*’;

System altered.

February 1, 2010

writing to alert log

Filed under: Oracle commands — sundar5 @ 8:17 pm

SQL>  exec sys.dbms_system.ksdwrt(2, ‘Testing writting to alert log‘);

PL/SQL procedure successfully completed.

SQL>

$tail -f alert_turn2.log

Mon Feb  1 12:11:12 2010
Thread 1 advanced to log sequence 267582 (LGWR switch)
Current log# 1 seq# 267582 mem# 0: /turndb2/01/turn2/database/redo01.log
Current log# 1 seq# 267582 mem# 1: /turndb2/01/turn2/database/redo01b.log
Mon Feb  1 12:11:21 2010

Testing writting to alert log

exec sys.dbms_system.ksdwrt(2, ‘Testing writting to alert log‘);

where

* 1 – Write to trace file.
* 2 – Write to alertlog.
* 3 – Write to both.

Create a free website or blog at WordPress.com.