₦airaland Forum

we should be gisting about oracle related stuff not buzzes lol

alexis

you are the man,

hey guys it's really good to hear positive stuff about the open university, i on my own part am a very optimistic person, i intend to do a degree in computer science, so i just wanted to find out how much the total fee will cost and the duration of the programme, thanks

orapwd file=password_file_name password=the_secret_password
orapwd file=password_file_name password=the_secret_password entries=n

There is a default location and name for password files. When a password file is created, it should be created in that location.
n specifies the maximum number of distinct DBAs and OPERs that can be stored in the password file.
orapwd is a command line tool to create password files.


no all you have to do now is grant the neccessary privilege

larry

no it's ok boo

it a good thing that someone concurs with me


larry

|vikiviko

YOU WAN ARRANGE JOB ABI, NO FORGET ME OH WHEN YOU DONE COLLECT THE CHEESE


LOL

JOB MAN YOU STIILL DEH HERE


MAKE UNA NO LET AM DECIEVE YOU OH

CCNA GINI FIVE DAY, YE YE

thanks for accepting the truth,

GUI VS CMD

the fact is that you can even do more using the command prompt than using the GUI, you don't always have to type all your script when you need them,you could always make them down b4 using them and allyou need to do b4 execution is edit some things thats all. but oracle 10g still recommends us to use the em cdbconsole when creating a database but i guess am just being stubborn. but really its for you own goo to learn how touse the cmd.


larry

well i don't think where you study matters, what matters is if you know what you are doing, although people who don't have any idea of what oracle is should be at a place like NIIT, but still NIIT certificate is not what i am after, am after the real stuff and knowlege.


larry

i hope you computer meets specifications for oracle 10g installation, well you know it's definately hard to help you from out here, it will have to be a hand-on-lab stuff and since no errors are generated that even makes it more difficult to troubleshoot the problem.



larry

THANK YOU EVERYONE AT LEAST WE NOW KNOW WHAT NIIT IS ALL ABOUT (exploitation AND money making schemes)

thats the only reason that they are here for.


thank GOD say i no pay my last inststallment because most of the things that i can say that i am good at today i learnt them on my own, i downloaded, books, artiicles, listened to others peoples views. NIIT is just read read read most of the lecturers there now nothing.


because i proved one of his theory wrong and he was trying to cover up with unneccessary excuses.


larry

thank ya, sir b like say you no want make we hear word again oh,

what do you know about ASM and DRM


sub

no it's not that the yahoo boys can't be traced the fact is that we don't just have the resources ok,

and am sure you must have heard of NAT, yeah thats the reason we haven't ran out of IPv4 addresses, which makes it even harder to locate the machine, but the fact is that we don't have the resources for such things, but we have the money to implement them.

so whats gives you the impression that i don't have ccna materials, ignorance

hey which of our dba's here love PL/SQL

do you really think that PL/SQL should be a developer thing or it's something that we can always handle ??



larry

hey to all my DBA gees and gurls out there, pls try as much as possible to always use you CMD, a dba just got fired in one of south africa's biggest it organisations for voilating his service level agreements (SLA) his max MTTR was 25 minutes i guess the OEM failed him and he couldn't use the black box, so instead of him using all his time to recover the DB, half or rather of his time was used trying to invoke. http//127.0.0.1:550/em


thanks

the prince of persia

well let me tell you guys something,


if your GUI fails you, then you cmd will not, (black box)

but as for me i prefer using the cmd, i don't see the gui as a means to make administration more easy i see it as making us more lazy, but there are some cases where you are recommended to use the gui, like when creating a database and executing pl/sql codes but i always love doing it the hard way, sorry guys maybe am just being stubborn.


but you must know that you gui will fail you someday, so be warned.


larry

sbucareer:


from you point of view, let me have a clear definition and examples of what an API is


thanks

larry

well you will just have to respect the fact that when it come to RDBMS

oracle rules ,lol

larry

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

ok two databases running on the same system, well it depends on the database that you want to log into

for example you have two databases on a system ORA1 and ORA2


if you want to log into ORA1 then you have to change the enviromental variable ORACLE_SID

here's how you do it when you are on the command prompt make sure you have logged out.

so your prompt should look something like ]


C:/Documents amd Setting/oracle

now just type in this command to change the enviromental variable


C:/Documents amd Setting/ set oracle_sid=ORA1

then you can now log in

sqlplus

sys as sysdba

e.t.c

if you do not set the variable a TNS Protocol adaptar error will be generated


the anytime you want to log into the ORA2 database you will have to change the enviromental variable again

set oracle_sid=ORA2


i hope you understood


p.s


larry

there's always one thing that matters when it lcome to networking, and that is bandwidth,


so it's either you have your dedicated connection or you are connecting thru a teleco, that is company that are willing to offer you bandwidth for money, hope you get the point, it all involves hardware and software,

routers importantly cannot make remote connections there are also different protocols involved in wide area networking, for example a dedicated T1 or E1 connection is going to cost you more money beacsue you will have more bandwidth to your disposal, this is also what we call PPP (point to point) in a router configuration, but if you can't affored so much money the n you could use frame relay or ISDN any one of this become cheaper because you plan on consuming less bandwidth.


larry

THE FUTURE IS BRIGHT FOR ORACLE DATABASE ADMINISTRATORS, THATS ALL I CAN SAY FOR NOW.


CBN IS RUNNING ON ORACLE RIGHT NOW.


LARRY

basically i have all the materials you would need to pass the ccna objectives, ccna study guides from different authours, router simulators, and sysbex text engine which carries about 500 questions, so mail me or call


giandorof@yahoo.com


08026322254

larry

NIIT ha ha ha ha, if you are planning on using scholarship then pls don't ok,

no mind the guy na job man

IP addressing,
intorduction to cisco routers,
configuring ip access-list
managing cisco routers
WAN
layer 2 switching
ip routing e.t.c so you mean say you wan teah me all this one for five days, thank God say i be CCNA na people like una for job me, for all those who want to do ccna please try and study on your own first ok but if you can't don't let any body tell you that you can get you ccna in five days ok.

you done see mugu ba

subcarrer i totally understnd what you are trying to say, but you must be aware that in a country like Nigeria or system have not been fully integrated, yeah for example now you where able to the person name thru the site he logged into, and if the so called person isn't in the cafe his name can be runed thru a central database that can provide more info on whom this person is, like his name, address e,t.c but in a place like nigeria even if i used my real name and you found that out thru the site that i logged in, you wouldn't still be able to round me up becasue you have no idea on how you can locate me right, more or less we have no database so how do you know who i am,

i hope you get my point, thses things work in developed countries,

by the way i would like to talk to you, personally so i was kinda wondering if i could have your email addy.

thanks

p.s


larry

DETERMINED:

i do not really agree on you with that on ok, if i where to give anyone an advice on any database course to hold onto it would be oracle becasue we both know that when it come to RDBMS it ORACle for now. i am very well into databses i have done my oca and studied my ocp, designed database's for a few people. the fact is for some one who really understand oracle, you can work with any other database, don't you agree with me,.



larry