25
Mar
08

How to choose a good name and why “The Tendjee” is a bad name

I was reading an article on Guy kawazaki’s blog a few months ago (back then when I was in Bangkok), and it was really useful tips. Here are those I remember:

1)  Choose a name which allows growth of the business: If you are a travel agency, don’t pick a name which would categorize it. If you are creating a travel agency don’t pick the name: hotel booking. You might do flight booking as well… The same applies for location (Paris networking for a cable company won’t fit if you go global)

2) Pick a name easy to pronounce in every language and which won’t sound like a swear word in another country. It’s not easy to make sure but a name like Itili is quite sure to be fine in any country.

I’m discussing Oracle and opening up to the whole Oracle world. I was developing Oracle 10g RDBMS in all our business units in Asia and decided to create The Tendjee which back then sounded like a pretty clever move. Problem is: databases live about 2-3 years only in the Oracle world. So this name should be obsolete in the coming years. The new DB is 11i already…

I suppose this name will remain like a milestone, witness of the time where I started writing about Oracle. But I’ll have to make it clear by one way or another that this blog name doesn’t state what’s being discussed here…

25
Mar
08

French speaking Oracle User group

I am now a member of the AUFO (Association des Utilisateurs Francophone d’Oracle) which is the user group of Oracle Products.

So from time to time I will keep then english world in touch on this blog with thoughts and changes occuring in Paris with Oracle.

This is really great because our discussion and presentations are then sent to Oracle for new ideas. This is new for me and it’s really cool.

I have been to a meeting last friday discussing archiving of data, its problematic and some solution. I haven’t push the idea further but I think there’s even more to discuss about on this subject.

The next post will be about archiving : )

16
Nov
07

I’m moving to Paris

Hi fellow Thetendjee readers.

Today, no 10g stuff but a personal news.

I’m leaving Bangkok, Thailand to go to Paris, France.
I will be landing there on 23rd of December.

The position is Senior DBA at Mondial Assistance Group.
I will be working with much more databases on different versions (9i and 10g) and with different systems.
It will be primarily SUN.
I’m really happy and excited about this new position.
I will have the chance to move around Europe as well because I’m in charge of Oracle databases for our Business Units in Europe.
More databases, more systems, more responsabilities and more experience –> Ultimately more to write on this blog!

I will have the opportunity to polish my *nix scripting skills.

I have had a great time in Thailand and I want to stress to anybody reading this that working in Thailand is an awesome experience.
If you ever got a chance to go work there, don’t think twice.

01
Nov
07

Where are we?

I’ve added a new feature to this blog.

If you don’t mind scrolling down a little bit, you will find a map in the right column.

My readers are now able to tell me where they are reading me.

The map starts in Bangkok, Thailand by default because that’s where I am right now.
I will change it to Paris next month when I will move  there.

Feel free to click on this map, add yourself.

I will be happy to know who is reading me and from where.

31
Oct
07

Oracle Database 10g Utilities

I was going through Oracle Techology Network (otn) and found this:  Oracle Database 10g Utilities.

That is a great ressource for everything new in Oracle 10g. I think I know what I’m going to do this week-end.

I mean… Over than installing Linux Kubuntu Gutsy Gibbon on my new hard disk after the previous disk failed.

31
Oct
07

The world was shouting out loud for some explanations on ORA-12514

I was having a look at my blog stats today and it seems that most of the traffic I got from search engines are triggered by ORA-12514…

Just a simple look at the following table, coming straight from the stats:

ORA-12514 23
ora-12514 13
ORA-12514: TNS:listener does not current 5
dbsnmp password 3
TNS:listener does not currently know of 3
DG_BROKER_START=true scope=both; 2

That’s 78% of the search on this blog.

So what I’m going to do, instead of just a solution to ORA-12514, is a detailed explanation of how connectivity works with Oracle: Listener, sqlnet.ora and tnsnames.ora

I’ll also include some basic best practices as well. All that with as few difficult words as possible and as many simple words as possible.

I don’t pretend to be an Oracle guru but I would be really happy to provide my small piece of work to the greatest community online.

Soon. On this blog…

30
Oct
07

Configuring dataguard to manage the standby database

It’s possible to have dataguard configured using a grid controller but today I will explain how to configure using command lines.

To anyone using this how-to, I strongly suggest reading this post.
You will find a list of parameters which have a big impact on the smoothness of the configuration of dataguard client (DGMGRL)

pre-requisites are:

1) You got a standby database synchronizing with you primary DB without any problem.
2) The parameters listed in the link above are specified.

Create dataguard configuration

The command can be run on either the primary or the standby server because the parameter files for dataguard will then be transfered to the standby database’s host.
I’ve choosed to perform it on the primary server.

C:\>set oracle_sid=<SID>
C:\>DGMGRL /
DGMGRL>
Connected.

DGMGRL>create configuration ‘somename’ as
primary database is ‘primary’
connect identifier is primary.world;

In this command, the word ‘primary’ is the db_unique_name value specified in your parameter file.
If you are not sure about it, you can connect to sqlplus as sysdba and type:

SQL>show parameter db_unique_name;
note: If you are not sure about the exact parameter name, type only a part of it. It will display any parameter featuring that piece of string typed.

DGMGRL>show configuration;
This command will display the configuration of dataguard for the specified primary DB. Obviously the status is “DISABLED”

Adding the standby to the configuration

DGMGRL>add database ‘standby’ as
connect identifier is standby.world
maintained as physical;

Database “standby” added.

DGMGRL>show configuration;
The configuration will now display both the primary and standby databases in your configuration but the status is still disabled.
It’s now time to enable the configuration.

DGMGRL>enable configuration;
Enabled.

DGMGRL> Show configuration;
The status is now turned to SUCCESS.

But this is a perfect world…

How to configure dataguard again if the first try fails

In a world where your first trial fails for some reason, returning to the initial state (a primary, a standby, no dataguard configuration) is required and it’s not easy.
If you are trying to enable the configuration and the command hangs, then you have a problem.

All the previous steps, including the modification of parameters in the SPFILE don’t require a shutdown of the DB.
But to reset the configuration, a shutdown of the DB will be required.
If you are working on a critical system, a shutdown will have to be scheduled off peak hours etc… etc…

What the command “enable configuration” did is the generation of configuration files, located in ORACLE_HOME\database. It’s the same folder as the SPFILE.
It will also transfer those files to the standby host. The reason is simple, when the production server fails, I would love to be able to still use what is left.
And what is left is my standby database and server.

The files are named as follow:
DR1<INSTANCE>.DAT
DR2<INSTANCE>.DAT
hc_<instance>.dat

Deleting those files would mess up with a dataguard configuration at best but will not harm a critical system.
But as it turns out, they are not easy to delete because they are accessed by oracle services.
DR1 and DR2 are easily removed.

To remove this hc_ file:

connect to SQLplus:

C:\>sqlplus / as sysdba
SQL>alter system set dg_broker_start=false scope=both;

When this is done, shutdown the database and delete all the .dat files specified above.
The same process must be performed on the standby server and database.

When the files are deleted:
Connect to sqlplus again and set the parameter back to “TRUE”
SQL>alter system set dg_broker_start=true scope=both;
Perform the same on the standby.
It is now possible to try again to enable the configuration.

To complete this explanation on the configuration of DGMGRL, here is a list of parameters which were very important to the success of the configuration

*.db_unique_name=’TESTDG’
*.local_listener=’(ADDRESS=(PROTOCOL=tcp)(HOST=standbyserver)(PORT=1911))’
*.log_archive_config=’dg_config=(TEST10,TESTDG)’
*.LOG_ARCHIVE_DEST_1=’location=g:\oradata\TEST10\arch VALID_FOR=(ALL_LOGFILES, ALL_ROLES)db_unique_name=TESTDG

*.log_archive_dest_2=’SERVICE=TEST10 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=THTEST10
*.dg_broker_start=TRUE
*.standby_file_management=’AUTO’
*.fal_server=’TEST10.WORLD’
*.fal_client=’TESTDG.WORLD’

On my first configuration, all the parts marked in Orange were absent of my parameter files. That was all I had in the how-to I used.
The synchronization of the primary and the standby worked that way.
But when it comes to configuring Dataguard, it was a complete failure.
As it turns out, the primary cause of all my problems were the missing parameters and options.

Adding the databases to the Grid controller

If later on , for more control a grid controller is installed (makes sense isnt it ^^). All that will be needed is to install the controller agent on the primary and the standby server.
The grid controller will detect right away that there is a standby database managed by dataguard and it will be possible to view it through the grid controller.

Enjoy! It has been a great project. I’ve enjoyed a lot going through this.
There has been a lot of frustration on the way due to the difficulty of getting information on how to do this. Particularly after it failed the first time.
I sincerely hope that this document will be useful to a lot of people.
Succeeding gave a great feeling of achievement.

If there’s anything wrong or unclear, just let me know in the comments. Let me know as well how it went for you too.




Follow

Get every new post delivered to your Inbox.