RIDVAN EKER Oracle

October 21, 2011

ORA-29024: Certificate validation failure becouse of server date

Filed under: Uncategorized — RIDVAN EKER @ 10:06 am

I setup ssl connection to test database.
After setup I cannot make connection to remote database from my client.
At server everything was ok.
I put client certificate to server it works. But when I copy it to my client I get 29024 error.

I put below parameter to my 11g client’s sqlnet.ora.
ADR_BASE=C:\oracle\product\11.2.0\client_32\network\admin
And I realize that my serfiticate is not valid before
Validity:
not before: Fri Jan 28 13:47:12 2011
But time is 13:00
Finally I look at database machine time it is wrong 2 hour fast.
When I create wallet with orapki it put time value to not valid before.

November 6, 2007

Failed to allocate port(s) in the specified range(s) for the following process(es)

Filed under: sysman — RIDVAN EKER @ 2:37 pm

Create database control give error

$emca -config dbcontrol db

oracle.sysman.emcp.exception.EMConfigException: Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] | [1830-1849]

This error happen when your dns server or /etc/hosts show different ip address.

This error happen to me while creating database with dbca.

After error I only create db control with operating system. Database repository also created while creating database.

October 31, 2007

ORA-12638: Credential retrieval failed while install 11g

Filed under: 11g New Features — RIDVAN EKER @ 2:54 pm

ORA-12638: Credential retrieval failed while install 11g on windows xp on domain

I try to install 11g on my windows xp which is on domain, but I get error "ORA-12638: Credential retrieval failed" while running dbca.

This domain user also local administrator.

Then I create a local account give it to Administrator role. Now everything is ok.

October 30, 2007

11g available for windows

Filed under: 11g New Features — RIDVAN EKER @ 10:36 am

11g for windows available for download.

Oracle Database 11g Release 1 (11.1.0.6.0)
Standard Edition, Standard Edition One, and Enterprise Edition

Microsoft Windows (1.7 GB) | See All (Including Client, Examples, Gateways, and Clusterware)

October 29, 2007

11g New Features course

Filed under: 11g New Features — RIDVAN EKER @ 7:28 pm

Last week I was at course of 11g New features.
Course is given by Lutz Hartmann
http://sysdba.wordpress.com/
I will write about new features of 11g.

September 28, 2007

POST2BLOG desktop client

Filed under: Uncategorized — RIDVAN EKER @ 8:52 am
Today I start to use post2blog desktop client and i like to use it.
If you don’t have office 2007 it can be useful. I can advice.
It can also work behind proxy.

http://bytescout.com/index.php

September 27, 2007

Don’t give password to Listener in 10g

Filed under: Security — RIDVAN EKER @ 1:26 pm

As a security hole in 9i database we always give password to listener,

But this is chaged since 10g, if we give password to listener in 10g

this will become a security hole. Oracle solve this in 10g.

http://andrewfraser.wordpress.com/2007/05/24/listener-passwords-always-for-9i-never-for-10g/

September 26, 2007

Start Enterprise manager after activating standby database

Filed under: Standby,sysman — RIDVAN EKER @ 5:23 pm

After activating standby database we don’t have enterprice manager.

Because we do not have files on operating system,

and also most important one is we have repository with old server data.

Our repository contain data about old server hostname and ports,

But our new server hostname is different,

So we have to recreate repository, drop sysman, wmsys ..

To drop users and recreate repository below command work

emca -repos recreate

emctl stop dbconsole

emctl start dbconsole

TO create operating system files below command

emca -config dbcontrol db

emctl stop dbconsole

emctl start dbconsole

Thats all,

Ridvan Eker,

Drop Objects

Filed under: Datapump — RIDVAN EKER @ 5:00 pm

Drop ‘FUNCTION’,’PACKAGE’,

‘PROCEDURE’,’SEQUENCE’,’SYNONYM’,

‘VIEW’,’TRIGGER’,’TABLE’

 

To be able run this procedure, privilegtes must be given directly to STAGING_DROP_USER

CREATE OR REPLACE PROCEDURE STAGING_DROP_USER.test AS
hand NUMBER ;

cursor c1 is
select object_type, owner, object_name from dba_objects
where object_type in (‘FUNCTION’,’PACKAGE’,’PROCEDURE’,’SEQUENCE’,’SYNONYM’,’VIEW’,’TRIGGER’)
and owner in (select username from dba_users where profile=’SCHEMA’);
r1 c1%rowtype;

–we cannot drop nested tables

cursor c2 is
select owner, table_name from dba_tables where owner in (select username from dba_users where profile=’SCHEMA’)
and table_name not in (select table_name from dba_nested_tables
where owner in (select username from dba_users where profile = ‘SCHEMA’));
r2 c2%rowtype;

BEGIN
— first have to drop plsql and other objects that table_exists_action does not deal with
FOR r1 IN c1 LOOP
execute immediate ‘drop ‘||r1.object_type||’ ‘||r1.owner||’.”‘||r1.object_name||'”‘ ;
END LOOP ;

FOR r2 IN c2 loop
execute immediate ‘drop table ‘||r2.owner||’.”‘||r2.table_name||'” CASCADE CONSTRAINTS PURGE’ ;

END LOOP ;
END ;
/

September 25, 2007

Using 10g datapump and scheduler to copy schemas

Filed under: Datapump — RIDVAN EKER @ 12:27 pm

 

IMP does not owerwrite

‘FUNCTION’,’PACKAGE’,’PROCEDURE’,’SEQUENCE’,

‘SYNONYM’,’VIEW’,’TRIGGER’ (CODE DATABASE)

Import does not replace codes, to be able to create codes only way is to drop related objects or drop and recreate user then start import.

Link below show a way to to this.

P.S: if you have objects created like “object_name” you have to drop them with using quatations

because they are case sensitive.

 

http://andrewfraser.wordpress.com/2007/02/01/using-10g-datapump-and-scheduler-to-copy-schemas/

Create a free website or blog at WordPress.com.