Hey, I don't read much on oracle in the forum. I am preparing for OCA certificate and i sure do need some help on it since I am studying at home with almost no external help; I presume there could be others like me hence this zone, you can share views, ideas, experience at this corner no matter what your level is ( in-view, OCA, OCP, OCM and so forth)

I will appreciate your every posts! and bear in mind it is educative! someone might need that idea of yours.

I want to start by asking how to add users to a database; open a password file for the database with which one can access the database without having to set 'oracle SID=' Any ideas?

Hi cabali.thanx 4 making d interest of some of us known.i think d dba's should also have a meeting point. moderator pls take note. to add a user to user to a database u just need to create d user using d CREATE USER username IDENTIFIED BY password.this statement creates a user & d user will be authenticated by d password each time he wants to log on to d oracle server thru d sqlplus.

I expected to have pple talk on this cos i know there are pple with oracle knowledge here

thanx for ur idea sesal! i think u r right about a meeting point.
But I actually know about creating a user;

My issue is adding a user to a password file. for instance if u have two databases already created and one of them is accessed using conn sys/change_on_instal as sysdba. and the other conn sys/different_password as sysdba(for instance). one of the database opens by default over the other; while oracle sid=2nd db. now, even when oracle sid is set for the 2nd db, u cud still access using sys/change_on_instal which happens to be linked with the password file of the first db, now question is how can this be prevented entirely!

this is crazy, everyone is viewing this and no one can answere this question?

are there really dbas on this land or what, this is not encouraging

thanks for ur hurried reply i got it down but this wouldn't be entirely neccessary if the different databases are on the same system would it?

if it wouldnt then, what is applicable in the case of same system with 2 different databases

cabali:

I expected to have people talk on this because i know there are people with oracle knowledge here

yeah for sure there are people with Oracle knowledge

then do u have some to drop in this zone cos a lot of us would learn from this.

career has been incredible at this and it is completely admirable his pool of knowledge. thanks

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

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

hey, i thikk seun should provide a dba category and now!

about the instances, i've been used to running one instance except of course we're talking of startin,
whatever just expplain

Who brought this one here

larryoncol:

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

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

has cabali tried out larry's suggestion. I think that should do it.

hey cabali, seems like we've got some scores to settle

been lookin for u

u'll surely here fromme when i have ur time

Creating a user is very easy u can either do this via the sql*plus prompt by running this syntax:

sql> create user (username)
identified by ,

where username is the name u intend to give the user u are creating

, contains the password by which this user would be identified

or via the oem(oracle enterprise manager console) following these steps

launch oem>databases>specific database(where u want 2 create d user)>security>users>create user

there is no need to alter the sid (system identifier to do any of the aforementioned steps)
goodluck.

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

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 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 ??






Being a DBA does not put you totally out of the programming world!
Guys don't be scared of programming, its only a mind thing.
We can all do it.The much time we devote to DBA shows that we can do practically anything.I mean some of u guys have the database of large bluechip organisations at the tip of your hands-well at least you do in a way.So if we can do that then we can do anything.

i just saw this oracle dba corner. since i'm in the process of writing my exams, i shall try to participate as much as i can. i rushed thru your questions, see d best way to pass this exam is to get the dumps and master them. check out testking.com some info there. chao

I can assist you with the latest Actualtests dumps on Oracle and all other Certifications. Contact me on etagenius@gmail.com

hi.
Nice to knw there are many oracle geeks out dia.

@cabali,
U can actually have a password file created for identification of the users with sysdba power.
Now, depending on hw u configure your db, u can make it shareable by the other dbs on that machine by setting
remote_login_passwordfile = shared in the initialisation file.
Cud create a passwordfile by
using orapwd utility from the command prompt.

ORAPWD FILE=<filename> PASSWORD=<password> ENTRIES=<max_users>

U can add users to the passwordfile by granting sysdba to the user, for eg
if u want to make jide a dba,

GRANT sysdba to jide.

user jide automatically gets added to the password file.

Size of users in the passwordfile is dependent on the config used while creating the password file.

Hope i made some sense?

Was wondering what oracle version u training for? 10g i guess.
if u have qs on oracle db administration(8i,9i or 10g), just buzz me.
jidebello2001@yahoo.com

Yeah I tried that but i think am 'a' buzz like ya said aight!!!!!

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

@cabali,
cant remember calling u a buzz.
I said u can buzz me wen u gat any other p

we should be gisting about oracle related stuff not buzzes lol

@larrycool

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

This is not true. You can have as many ORACLE DBinstances runing on same host.

1. the host needs to be powerful as it will eat your resource

2. Better you install on different ORACLE_HOME = /u01/data/ora1 and /u02/data/ora2

3. Both must have diffrent ORACLE_SID, already above, ora1, ora2

4. You simply open another unix Session and start the next instance, making sure your ENV is set properly

5. Also you need to start each listener for connectivity

NOTE: For Serious firms ORACLE is best run on Solaris!

yeah i know, what i meant is that you either have to switch to the oracle sid that you intend to open, only one can run at a time, when you switch to a diffrent sid the other one becomes stale,

thanks

@ cabali, best of luck in your certification.

@everyone, you guys are quite good. i actually learnt a lot. Seems i'm the only female in the chat at the moment. I work with oracle on windows, but i want to start working on unix. I'm okay at linux. Suse to be precise. Is installing oracle on linux same as installing on windows and if not, what must i configure my system(the detailed process) I've already installed suse. Also, can i use the same oracle installation cd for windows and linux?

@sleek_chic,
Installing Oracle on Unix is different ball game, but very easy if your system meets basic config.

what version of Unix do you have?

what operating system: Unix on Solaris or intel?

follow this url:
http://www.dbspecialists.com/presentations/oracle920solaris.html

Any problem let me know.
Plus whats your motive for Oracle; play, learn or get real job?

@ babasin Thanks for the url. I just checked it out and it seems quite detailed. Presently, i have suse 9 or 10 on one system but i plan to install solaris 10 on another.

I'll install the oracle on both.

As per the motive, i'll pick all of the above. Play, learn and get a real . Hey bro, are you saying this sister doesn't have a real job . Okay, no offence taken. ;DI'm presently working with oracle but i believe no knowledge is useless. I work with oracle on windows but i heard oracle on unix is out of this world. I've played around with it for a day but i want to be a pro like you and several others on this thread.

I'll definitly let you know if i have any bottle necks. Meanwhile, how can i lay my hands on an oracle on unix cd. Can "otigba" do the trick?

Thanks once again