hello guys looooooogest time! hey A-40 and Le-moor how r u guys?hope all is well, sorry i havent been on in a long time now,but will sonn be posting on a regular basis sotill then, stay blessed and keep the database up and running

jimblaze:

hello guys looooooogest time! hey A-40 and Le-moor how r u guys?hope all is well, sorry i havent been on in a long time now,but will sonn be posting on a regular basis sotill then, stay blessed and keep the database up and running

I am alright Chief what have you been up to? Lol we would do just that

Hey everyone. Is there anyone on 11g just yet? and where the hell is sleek?

Well i am not! still grappling with 10G and its features are you on 11G now?

pls can any help?

i need cbt nugget videos for oracle DB 10g

Hello guys! Longest time,hey Le-moor and A-40 wats good?have u guys tried out 11g yet?i havent been on for a while

@Jimblaze
Merry Christmas to all them DBA's in the house.I had a chance to sample 11G temporarily till i started having installation problems anyways what are the new features and are there any noticeable performance enhancements?
10G is still pretty cool though i don't have any reason to rush to 11g just yet

merry christmas everyone, i have just been reading on the topics here and just seem to hear everyone asking about oracle, 11g , dumps etc, if we want to make it work well, i am expecting people to ask questions on things like tables writing sql queries, create procedures , functions, creating triggers(PL/SQL) then we bring our heads together and help, lets make this thread a one we'll always want to visit, ask tough questions and we will try and answer, expecially questions you'll meet at the workplace. and also there's documentation on all versions of oracle, at oracle.com, if anyone wants to download them. they arent big files so a slow connection will still be good.

Been a while,
I attended 2 Oracle organized workshops for 11g New featurs, and I can sey the database has been greatly improved. Oracle is really moving towards and intellgent self managing database. The flashback feature has been greatly improved and recovery should now be a breeze.

I will look through my notes and post some improvements 11g has over 10g on here ASAP.

@gidigidi
That was a nice post i guess most of us on here are still learners grappling with trying to pass exams and stuff first as for me my biggest issue is PL/SQL for sure knowing when to use cursors and triggers and when not to use them

Hi all,

Thanks to all those who set this up. Just happen to stumble on this forum while searching for Oracle DBA related info in Nigeria.
I am new here, but definitely not new in Oracle. Would love to share whatever little knowledge i know with all.
Feel free to ask and i will gladly respond as soon as time permits.

Let me include in this my first post a bit of advice for those pursuing a career as an Oracle DBA.
Have it behind your mind that to be an Oracle DBA implies being a "jack of all trade and a master of one". Dont be scared. Not only are you required to be a master in Oracle Database Administration which believe you me is complex, you're also required to have more than a basic or passing knowledge in the following:

1. application development - if you dont how can you tune another person's application.
2. various operating systems: windows, various flavours of unix(Solaris, AIX, HP-UX, Linux,Open VMS, etc).
3. Networks
4. etc

Trust me, as a DBA, there will be many occasions when a deep knowledge in these other areas will save your neck. So if you're starting out, be ready to learn the areas mentioned above alongside mastering your Oracle knowledge. The good thing here is that there are so many free materials available online, so access to internet is very crucial, to help guide one through his journey of life as an Oracle DBA. Oracle Corporation has a host of these materials available at the following:

1. http://www.oracle.com/technology/index.html : free registration is required. You can also download free oracle software for practice. Many articles are also available here to help you.

2.http://www.oracle.com/technology/obe/start/index.html: This is the page of Oracle by Example training.

However, at the end of the day, the reward is great for those who persevere. Oracle DBA jobs are in high demand the world over.

Like i said, i will be more than glad to share my little knowledge with all. Its part of my giving back to Nigeria, a country i am very proud of, for the sound education i got. So feel free to ask me any questions both online and offline.

So once again, kindly welcome me to this enlightened group. Its a pleasure to be here and i do hope we will all learn from each other. For no one is an island of knowledge.

By the way, dont you guys think it will be wise to have an "Oracle DBA Mentoring Corner" or something of sort we can all help mentor each other? Just a though that came to my mind after my earlier post.

sbucarrer :

just to let you know, it isn't possible to have to instances on the same machine, running at the same time ok.

each oracle database has it's own instance, so when you change the enviromental variable to another database the instance of that database becomes stale while the one for the open database starts running.

The only case where you have multiple instances on different nodes opening a single database is when you use RAC(real application clusters) in this case you can have like 9 instances opening one database so that if one of the instances should go down you database can still be open beacsue you have other instances working onbehalf of that database. RAC is used for database availabilty, in an oragnisation where downtime cannot be tollorated RAC can be very useful


thanks


larry

Going through past posts i came across this. Yes it is so old, but for all it is worth let me address this and share my experiences.

Yes you can have as many instances as you want running on the same server be it Unix, Windows or Linux. The only requirements being you must have enough resources available. By resources i mean memory hard disk space etc. On Unix it is very easy once you configure your kernel parameters properly. And believe you me this is not THEORY but rather hands-on experience.

Right now on a AIX 5.3L Server, i have two instances of Oracle 9.2.0.6 running successfully without any hindrance. These two instances have their own binaries. However they share the same listener which runs on port 1527. They could as well have their own listeners if need be.

Also as i type this on a Microsoft Windows 2003 server box with 12 GB RAM, i have two instances of Oracle 10.2.0.4.0 running without any hitch. One is production and the other development. Each of these databases have their own binaries and listener. One runs on 1525 and the other on 1527. But note that the OS in this case is a 64 bits Windows 2003 server. It does not really matter cause at a point in time i had running on my Windows XP Dell Latitude Laptop with 4 GB RAM (seen by the OS is 3.25GB since it is a 32 bits OS) the following: Oracle 9.2.0.5, Oracle 10.2.0.3 and an Oracle 10.2.0.4 EM Grid Control with its own separate database. The two databases of 10.2.0.3 and 10.2.0.4 all using the Automatic Storage Management feature. YES IT IS POSSIBLE TO SIMULATE an ASM FEATURE ON A WINDOWS ENVIRONMENT FOR TEST AND PRACTICE PURPOSE THOUGH ORACLE DOES NOT RECOMMEND IT FOR PRODUCTION PURPOSES.

Another thing it is also easy to have two instances running using the same binaries. The only drawback here being you cannot independently patch one instance. These things are easy really to implement. For any one who wants to have two instances running on the same server here are the basic steps.

1. configure your kernel parameters properly on unix to be able to accomodate two instances.
2. layout your file systems (unix) and directories (windows) properly as you want them for the two instances
3. install the first instance and create the database for it and perform all the necessary configurations you require.
4. BEFORE YOU START INSTALLING THE 2nd INSTANCE. REMEMBER TO CHANGE THE ORACLE_SID AND ORACLE_HOME (if you dont want to share binaries) variables TO THE NEW INSTANCE OTHERWISE YOU WILL OVERWRITE YOUR INSTALLED INSTALLED. THIS IS THE KEY TO HAVING TWO INSTANCES RUNNING.
5. Optional: On both UNIX and WINDOWS you may need to reduce the memory consumption by the first instance to the minimum so as to be able to have the second instance running if you dont have enough RAM on the box.

To simulate ASM on windows, there are many articles out there on the net that is useful. Anyone interested can contact for a step by step instruction to achieve this.

need a guide on how to install oracle db 10g on ubuntu 8.04,

peace

@ a wizzy:

Hope these helps:

http://vanbortel..com/2008/09/10g-database-on-ubuntu-804-hardy-heron.html

http://www.pythian.com/blogs/968/installing-oracle-11g-on-ubuntu-804-lts-hardy-heron

http://kangleay.yo2.cn/articles/troubleshooting-on-installing-oracle-database-10g-in-ubuntu-hardy.html

cool man, thanks

Hello house; some1 pls tell me hw to set my ORACLE_SID while attempting to start my em

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\janus>emctl start dbconsole
Environment variable ORACLE_SID not defined. Please define it.

C:\Documents and Settings\janus>

@jabbok

from your posting i assume you're on a windows environment. open a command prompt window and issue the following command:

set ORACLE_SID=sid ------------------------------where sid is your Oracle SID .

verify by issuing the following:

set ORACLE_SID

you should get the following:

ORACLE_SID=sid

@azum

Thanks, I did as u said but am still having issues as shown below:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\janus>set ORACLE_SID=orcl

C:\Documents and Settings\janus>set ORACLE_SID
ORACLE_SID=orcl

C:\Documents and Settings\janus>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://dcc7cbb1b8344df:5500/em/console/aboutApplication
Agent Version : 10.1.0.2.0
OMS Version : Unknown
Protocol Version : 10.1.0.2.0
Agent Home : C:\oracle\product\10.1.0\db_2\dcc7cbb1b8344df_orcl
Agent binaries : C:\oracle\product\10.1.0\db_2
Agent Process ID : 3512
Agent Process ID : 3512
Agent URL : http://dcc7cbb1b8344df:1830/emd/main
Started at : 2009-01-27 09:06:42
Started by user : SYSTEM
Last Reload : 2009-01-27 09:06:42
Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 419
Size of XML files pending upload(MB) : 5.02
Available disk space on upload filesystem : 41.53%
Agent is already started. Will restart the agent
System error 1060 has occurred.

The specified service does not exist as an installed service.


C:\Documents and Settings\janus>

azum:

@jabbok

from your posting i assume you're on a windows environment. open a command prompt window and issue the following command:

set ORACLE_SID=sid ------------------------------where sid is your Oracle SID .

verify by issuing the following:

set ORACLE_SID

you should get the following:

ORACLE_SID=sid

@jabbok,

Simple then let's troubleshoot this together then. To help you will need to provide the following:

1. further information about this environment.
2. Also what exactly are you trying to achieve?
3. Check what Oracle services you have installed on this box. Go to services and see what services start with Oracle and list them all here. (The error message indicate the service is not installed). So we need to confirm what Oracle services you have installed.

am trying to open d enterprise manager and it wouldn't ,I have been opening EM b4 but it just refused to come on since 2 days ago. hw do I check for the Oracle services?

@Jabbok

Do the following: Go to Start, Control Panel, Performance and Maintenance, Administrative Tools and then Services which is at the bottom. Then click on Services. This opens a new window for you. Enlarge the window. All the services are listed in alphabetic order. You will see the oracle services. They all start with the keyword Oracle.

List all the services that start with Oracle and their Statuses.

@azum

The details r stated below:

OracleCSService Started Automatic Local System
OracleDBConsoleorcl Started Automatic Local System
OracleJobSchedulerORCL Disabled Local System
OracleOraDb10g_home1TNSListener Automatic Local System
OracleOraDb10g_home2iSQL*Plus iSQL*Plus Application Server Started Automatic Local System
OracleOraDb10g_home2SNMPPeerEncapsulator Manual Local System
OracleOraDb10g_home2SNMPPeerMasterAgent Manual Local System
OracleOraDb10g_home2TNSListener Started Automatic Local System
OracleServiceORCL Started Automatic Local System

OracleDBConsoleorcl Started Automatic Local System

From this line, your dbconsole is running and as such you do not need to manually start it.
Just open a browser and enter the address and you should have a logon screen.
the address is usually in the form of :

https://localhost:1158/em


localhost is the name of the host on which the service is running.

@azum,
I've tried that b4 and just tried it again now it wont start still. my isqlplus opens normally on d browser, but the em(http://localhost:5500/em) has refused to open. Listed below is d configuration info that comes @ d end of the installation:

listed below.Your database configuration files have been installed in C:\oracle\product\10.1.0 while other components selected for installation have been installed in C:\oracle\product\10.1.0\db_2. Be cautious not to accidentally delete these configuration files.Ultra Search URL:http://dcc7cbb1b8344df:5620/ultrasearchUltra Search Administration Tool URL:http://dcc7cbb1b8344df:5620/ultrasearch/adminiSQL*Plus URL:http://dcc7cbb1b8344df:5561/isqlplus
http://dcc7cbb1b8344df:5500/em

azum:

From this line, your dbconsole is running and as such you do not need to manually start it.
Just open a browser and enter the address and you should have a logon screen.
the address is usually in the form of :

https://localhost:1158/em


localhost is the name of the host on which the service is running.

There are so many possibilities why this is so. One possibility is that though the service shows as running, it is dead. This is common on windows. If you can reboot your system and check that the services are all running. Then open a browser or see if you can log on again.
If however you can not reboot your system then you will have to manually stop and restart the Oracle Services from the Services window.

Stop the following services in the order listed:

1. OracleDBConsoleorcl
2. OracleCSService
3. OracleServiceORCL
4. OracleOraDb10g_home2TNSListener

Start them all up in the reverse order listed above starting with the listener.


Meanwhile, looking closely at your services you posted earlier, you have two Oracle Homes: Home1 and Home2. Check and ensure that the oracle Home and the SId where the dbconsole resides is correctly set.

@jabbok,

If you open a browser and can still not log on, kindly post the screen shot of the error displayed by the browser.

@azum,

I tried to uninstall d oracle software n I re-installed it. when I issue "sqlplus /nolog on d command prompt I get d following:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\janus>sqlplus /nolog
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

C:\Documents and Settings\janus>

jabbok:

@azum,

I tried to uninstall d oracle software n I re-installed it. when I issue "sqlplus /nolog on d command prompt I get d following:

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\janus>sqlplus /nolog
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

C:\Documents and Settings\janus>

Yes you will get this message if you try to log on to Sqlplus without the Oracle Home variable being set. Moreso when you have two Oracle Homes as in your case. As such you will need to set it as follows at the command prompt:

C:\set ORACLE_HOME=your_oracle_software_directory

where your_oracle_software_directory is where you have Oracle binaries installed.

But come if all you want is to uninstall Oracle do that through the OUI gui. This is in the Installation folder inside the Oracle folder in Start->Program->Oracle. That will be the cleanest way to go about this. The OUI gui will do a clean uninstall and you can then do some cleanup later.
By the way, if you have access to Metalink, Oracle support website, there is a good article there on how to uninstall Oracle on Windows. if you dont have access let me know i will try and get the document to you.

Hi guyz,
What are the basics for one to follow in order to master Oracle. i see so much of pl/sql and java as if that is wat is all about.

please somebodi should give me a giude.

@arohcs,

u nd 2 start with SQL*plus 1st, then mv into oracle. Sql na d basic language 4 oracle n most databases. SQL*plus is oracle version of sql n pl/sql is d oracle xtension. 4 nw u nd nt worry urself much about PL/SQL unless u wanna be a developer ASAP. feel free 2 throw ur questions man

arohcs:

Hi guyz,
What are the basics for one to follow in order to master Oracle. i see so much of pl/sql and java as if that is wat is all about.

please somebodi should give me a giude.

Your first point of start is to decide what area of Oracle do you want to follow. There are so many areas in Oracle that a lot of people dont know about. So if you want to pursue a career in Oracle the first thing is to do a self assessment and see what one has a flair for. Broadly speaking in Oracle you could either be Technical or Functional. That for me is the basic starting point. Let me try to use this opportunity to break down the different career paths one can undertake in Oracle.

A. Technical: Now if you have a flair for the technical stuff you may then want to decide if you want to be a Developer or a Database Administrator. Being a Developer simply mean being a Programmer.
1. Developer: Even as a Developer you have two major areas:
   i. The Core Developer - those who basically Oracle Developers developing applications in Forms, Reports, HTML DB, Java etc
   ii. Oracle Apps Developer - Those with sound knowledge of the Oracle e-Business Suite and are thus involved in various customizations
        and development of other add-on functionalities to Oracle e-Business Suite as the client require.
If you decide to follow a Developer's path, then you definitely do need the following skills and Knowledge: SQL, PL-SQL, Forms, Reports, Sqlplus etc.

2. Oracle Database Administrator - this too is broken down into two major career paths.
   i. The Core DBA - these are those that manage the various Oracle Databases and have in-depth knowledge of the Oracle environment.
   ii. The Oracle Apps DBA - these are those who manage the Oracle e-Business Suite. These are involved with day-to-day management and administering
   of the Oracle e-Business Suite. This require having a sound technical knowledge of the Oracle e-Business Suite.
   As a DBA with time you graduate from being an ordinary DBA who are involved with just the basic day-to-day duties such as installation, migration, patching, upgrades, performance tuning, backup and recovery to the specialist DBA. These are the DBAs with specialist skills such as Disaster Recovery, High Availability etc. These are the top range DBAs with many implementations of RAC, ASM, DG etc in their belts and are always in high demand.

So either as a DBA you do need a sound knowledge of Sqlplus, SQL and PLSQL. Then as a DBA, you do need to have more than a passable knowledge of operating systems.

B. Functional - These are those with other degree or specialization who still want to pursue a career in IT, Oracle specifically as an add-on to their specialization. In this regards you have those specialists in the following fields: HR, Accounting, Customer Service etc. These people will thus leverage their experience towards a career in Oracle and as such could any of the following routes:
i. Oracle Financial - for those with financial background
ii. Oracle HR - those with HR background
iv. etc - implying there are so many other specialization available in this regard.
iii. Peoplesoft - remember Oracle bought peoplesoft and as such people can just special in this area.
Let me state here that these are the so called System Analyst that go on configuration projects during the implementation of Oracle Projects. So for those with other backgrounds or those who dont have a flair for technical stuff there is also a path for you to follow.
   
I have taken the time to break it down for you since a lot of discussions on this page are DBA related. Please note that the career paths available in Oracle are not limited to these alone. Now you have enough information for you to start. If you have further questions do post them here.

@jabbok,
How far with the de-installation / re-install of Oracle on Windows? Any updates?