₦airaland Forum

you can try by commiting it to God first, then looking for all the companies that use Oracle, submitting Cv's, reading and practising, reading and more practising, i would advice you become proficient in PL/SQL too as this would give you an edge, and by the way @moderator or seun, how come you guys keep on reducing the number of replies on this post?this should be around one of the longest running post here on nairaland and if am not mistaken it has been downsized about thrice!

God has been really faithfull, i gave my life to Christ on the 3rd Feb 2008. Looking at me now, you would think i was born and raised in the church but my friends it was not so. i was heavilly into sin as a young man,smoking, drinking, fornicating, keeping several galfriends cos i taught it was the macho thing to do. Also being overseas for 7 yrs did not help as i was practically running amok! its was an indian guy that witnessed to me in 2001 and forward to 2008 i went to church and just decided that enough was enough. That same minute i got baptized with the Holy Spirit and started speaking in tongues, and also the spirit that was tormenting me for years had no option but to go! As if that was not enough i got my dream job right down to the job title exactly as i prayed on to God! i even failed all the interviews but God kept His word in Isaiah 3;10 "say ye to the righteous that it shall be well with him for they shall eat the fruit of their doings"! and guess what? i got my dream I.T. job without a degree and what is even more profound is that my salary is a graduates salary! no begging or lobbying of "seeing" anybody. can you imagine having a car accident that somesaulted 3 times and i came out without a single scratch?even my white shirt did not even tear! i give God alll the glory! today i teach people that have degrees in computer science! acccording to a prophecy "those that dont have certificate will teach those that have" that went out of the mouth of my spiritual father Bishop David Abioye.

@azum thanks, that would be great, @babyface12 it can happen to you too!

dont mind my typos i meant you need! anyway i got my dream job as a DBA in 2009 with no experience whatsoever! heck i even failed the written, oral and practical exams!but because of a simple prayer i said "Lord let your favour be on me, so that when they see me they will see you"! that was it and i got it!

interesting post!truth of the matter is Oracle Database and any other RDBMS can not lose its demand in Nigeria as it just gathering full steam! and if you want to be a core DBA, why not?as azum said most big companies usually have Oracle DBA's for specific roles like application dev, backup and recov, security, network etc whereas a DBA in a smaller company does virtually everything. In the I.T. industry, you should be "Jack of all trades and master of one" eg you can be a very good DBA and have good skills in either virtualization, networking or any other part of I.T., i would never discourage anyone from going into Oracle, u just a lot of determination, hardwork, practice and the most important, God, because with Him all things are possible, and by the way i happen to be an Oracle DBA working in construction company in Abuja! so i think i should know a thing or two.

Hello, does anybody have any idea if any I.T. training outfit here in Abuja provide training for Vmware certifications? New horizons provide corporate training only.

@A-40, basically data entry forms for users using oracle forms developer 6i, it requires little code though knowing PL/SQL will give it more functionality

Mac is way better than windows, there are fewer viruses for mac than any other O/S and besides viruses cant really affect it though it can transmitt to windows based O/S's, MAC O/S is unix based hence its more secure than windows, only thing though is the price which is quite steep compared to other lappy's, as an IT. professional i would take mac any day to windows

@A-40 well my boss who is a pakastani Oracle Developer told me to develop o! so i have no choice, but am enjoying it though its something i wanted to get into as it gives me an edge, the line between Dba's and Developers is getting even more blurred nowadays

hello people. wats happening?been a while, getting deep into application development now using oracle 6i forms for work

Go to the oracle website www.oracle.com and downloa it, you will need to register first though as it will ask you for a username and password, registratioin is free!

Cabali were are you?

The Blessings of God shall abound in this house! hello guys and ladies, were are you?A-40?, Azum?, Le-moor? etc
dont let this thread die o! its been one of the longest running thread and the amount of posts is actually higher than what is shown!well apart from Oracle @ work been getting into Django which is a free web framework for developing websites written in python, also got my hands into Oracle development using oracle forms 6i @ work, my boss gave me a project to develop a forms based application for out IT department which i was able to do by the grace of the Almighty, having a good knowledge of PL/SQL is a plus, anyway i hope all your guys are well and i look forward to sharing ideas, networking etc, have a blessed day!
ps Jesus love you and me!

@ A-40 the Lord bless you my brother, Virtualization is here to stay o! most IT departments and companies the world over are using it for hardware and software consolidation and for the huge savings it brings in IT budgets, i suggest u check out the vmware website as they are the market leader in virtualization technology. Sun Solaris has virtualization inbuilt into their O/S with solaris zones where you can create zones ( virtualized environments) within the o/s and run different applications, they had this feature before vitualization became big sha

@ A-40 goodluck with serving, work is great currently running oracle on RHEL on VMware, I.T. is heading towards virtualization and its already big in the western world @olaadegbu really? how do we contact?cant seem to find PM here on nairaland

The Lord bless you guys!wats happening long time, wats happening? Lemoor were are@? A-40?Cabal?

By default Oracle checks whether the data conforms to the constraint when the statement is executed.Oracle allows you to change this behavior if the constraint is created using the DEFERRABLE clause (NOT DEFERRABLE is the default).It specifies that the transaction can set the constraint-checking behavior.
INITIALLY IMMEDIATE specifies that the constraint should be checked for the conformance at the end of each SQL statement (this is the default) . INITIALLY DEFERRED specifies that the constraint should be checked for conformance at the end of the transaction.
The DEFERRABLE status of a constraint can not be changed using the ALTER TABLE MODIFY CONSTRAINT; you must drop and recreate the constraint . You can change the INITIALLY {DEFERRED | IMMEDIATE} clause using the ALTER TABLE.
If the constraint is DEFERRABLE, you can set the behavior by using the SET CONSTRAINTS command or by using the ALTER SESSION SET CONSTRAINT command. You can enable or disable deferred constraint checking by listing all the constraints or by specifying the ALL keyword. The SET CONSTRAINT command is used to set the constraint checking behavior of the current transaction, and the ALTER SESSION command is used to set the constraint checking behavior of the current session.
As an example, lets create a primary key constraint on the CUSTOMER table and a foreign key constraint on the ORDERS table as DEFERRABLE. Although the constraints are created as DEFERRABLE,they are not deferred because of the INITIALLY IMMEDIATE cla clause.
ALTER TABLE customer ADD CONSTRAINT pk_cust_id
PRIMARY KEY (cust_id) DEFERRABLE
INITIALLY IMMEDIATE;

ALTER TABLE orders ADD CONSTRAINT fk_cust_id
FOREIGN KEY (cust_id)
REFERENCES customer (cust_id)
ON DELETE CASCADE DEFERRABLE;
If you try to add a row to the ORDERS table with a CUST_ID value that is not available in the CUSTOMER table, Oracle returns an error immediately, even though you plan to add the CUSTOMER row soon. Since the constraints are verified for the conformance as each SQL statement is executed, you must insert the row in the CUSTOMER table first and then add it to the ORDERS table. Since the constraints are defined as DEFERRABLE, you can change this behavior by using this command:
SET CONSTRAINTS ALL DEFERRED;
Now you can insert rows to these tables in any order. Oracle checks the constraint conformance only at commit time
If you want deferred constraint checking as the default, create or modify the constraint by using INITIALLY DEFERRED, as in this example:
ALTER TABLE customer MODIFY CONSTRAINT pk_cust_id
INNITIALLY DEFERRED

Taken from page 327-328 of the book “OCA Oracle Database 11g Administrator Certified Associate STUDY GUIDE by Biju Thomas

welcome

then you should move on to Oracle Dba corner post

@dominique-well u can include it under professional cerifications- oracle cerified associate
and i would advise you to properly read and practice oracle instead of relying on dumps,so that you can defend your certifications

@dominique the Lord bless you and you are highly welcome to the DBA corner
@azum hey i finally solved the issue of not being able to login to Solaris 10 as the oracle user
whenever i created the user with /usr/sbin/useradd -g oinstall -G dba oracle , the home directory was not being created even after i specified it after running the command passwd -h oracle.
Solution: i had to manually create a directory in /export/home/oracle and after that i could login and now i have fininshed installing oracle 10gR2 on Solaris 10 which runs in a virtual machine ( sun virtual box) ontop of windows vista.I am really keen to work with oracle on solaris as our company only runs it on windows server, anyway i have some issues on the solaris machine which i will solve if not i can always post it here i think most of the issues arise from not having a service plan number and thereby not able to install the required O/S patches
@dominique-i would advise you to leave enterprise manager for now and concetrate on sqlplus, so as you dont have any issues when enterprise manager fails, as it has failed on me a couple of times and that was when my sqlplus/command line skills bailed me out

thanks alot azum, the problem is getting a service plan number which would enable me to install all the patches,that being said the kernel para's are configured correctly and YES i do need more memory and about the oracle user, he was created correctly even when i issue an SU command he comes up and i can even ID him and see his primary group and also see his default project

@azum, the Lord bless you, a few months ago i installed Solaris 10 on a virtual machine and prepared it for oracle 11g install.i ran into two problems
1. after creating the oracle user 'oracle', i could not log in, the log on process would hang and then start again so i had to login as root
2.the oracle installation completed prematurely after giving me some memory error, and i had 1024MB of physical memory as required by oracle for solaris 10.
the database was not created and when i tried to run DBCA it ran and gave some error which i cant remember now
anyway, i have installed Solaris 10 via a virtual image from Oracle/Sun and want to try it again
Do you think the problem is from the Solaris patch?when i try to install the required O/S patch as required by oracle it does not go cos i have to have a service plan number, we dont user Solaris O/S @ work, our 10g DB runs on Windows server but i really want to get my hands on oracle running on solaris

wow! its good to see this thread kicking again

hey jabbok i would love to have the solaris 10 videos

check your mail, just sent u the materials

No problem, drop ur email and with trigger creation, wat are u trying to do?

What always reboot? Your Oracle Database Installation or the Virtual machine?
Clarify.
@ azum i got it solved, i installed oracle 10g on solaris 10 running on a virtual machine and found out the OS was unstable as i had not yet updated it with all the necessary packages
@ A-40
Its not like that i guess there's just too few of us on here. Rockwise Cemis?? Never heard of it. Do you know any firms that run it or what?? I use Oracle mainly on Windows and sparingly on Linux so i don't know much about running it on Solaris you might need to go through a few technical articles or installation guides on Solaris
Rockwise cemis is an ERP software developed by a lebanese company called dynamesh and it runs ontop of oracle db 10g mainly for the construction industry, we are in the testing stages right now

alternatively, you can go to the oracle website @ www.oracle.com and get all the books you need in pdf

God has been good, this year He gave me my dream job as an oracle dba,
He gave me a two bedrom house fully furnished thus confirming His word and the word of His servant that i will inhabit houses i did not build,
He saved me from a fatal accident in which i came out with out a single scratch, even the white shirt i was wearing did not tear or stain,
The Lord is always faithful and i gave Him all the glory for the other numerous blessings this year!

Where are all the dba"s @?Lemoor, a-40, cabal etc, lets not let this thread die O!