|
cabali (m)
|
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?
|
|
|
|
|
|
sesal
|
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.
|
|
|
|
|
|
cabali (m)
|
I expected to have pple talk on this cos i know there are pple with oracle knowledge here
thanx for your 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!
|
|
|
|
|
|
cabali (m)
|
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
|
|
|
|
|
|
sbucareer (f)
|
Sorry Cabali, I do not really understand your question. Can you rephrase it so I can manage and give you at least a reply if I can.
SID, Oracle System ID, used to identify a particular database instance. If you have many database running in your firm and want to develop a distributed application, using SID will allow you to see database instances as fragments. You can then use these fragment to produce data fragmentation and partition then into small elements like,
1. Horizontal fragmentation
2. Vertical fragmentation
3. Derived fragmentation
4. Mixed fragmentation
All these techniques are used to develop distributed application system. Like we have many banks, and they all have ATM machine we can withdraw money. It be nice if the banks share database so we can all withdraw from any bank ATM and still maintain real-time account transactions i.e. balance and issues of concurrent withdraws. We do not need to find our bank ATM we just use any bank and the changes to that account is cascaded through the use of database fragmentation and by using one global application like the (ATM)
To create a user, just use the command GUI interface and issue these command
[valentine@fedora.sql] GRANT CONNECT, RESOURCE TO scott;
[valentine@fedora.sql] GRANT DBA TO scott; -- Make user a DB Administrator
[valentine@fedora.sql] ALTER USER <username> IDENTIFIED BY <new_password>;
If you want more help using oracle PL/SQL visit there website and download the version of your oracle documentation.
I hope this helped.
|
|
|
|
|
|
cabali (m)
|
thanks for your 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
|
|
|
|
|
|
sbucareer (f)
|
Even if you installed one database on a machine and have many instances, all the SID would have different name to specifically identify them. But you can not have more than one same database installed on a machine.
You can have many instances of a database, which can run on it own port number and different URL and behaves like you have two same database installed in one machine.
I don't really understand your question and would like you to shed more light on it.
|
|
|
|
|
|
|
|
cabali (m)
|
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
|
|
|
|
|
|
larryoncol (m)
|
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
|
|
|
|
|
|
larryoncol (m)
|
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
|
|
|
|
|
|
segebee (m)
|
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
|
|
|
|
|
|
cabali (m)
|
Who brought this one here???  |
|
|
|
|
|
olawa20 (m)
|
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. |
|
|
|
|
|
segebee (m)
|
hey cabali, seems like we've got some scores to settle  been lookin for u u'll surely here fromme when i have your time |
|
|
|
|
|
ujem (m)
|
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.
|
|
|
|
|
|
larryoncol (m)
|
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
|
|
|
|
|
|
larryoncol (m)
|
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
|
|
|
|
|
|
pentiumix
|
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.  |
|
|
|
|
|
jereton (m)
|
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
|
|
|
|
|
|
etauso (m)
|
I can assist you with the latest Actualtests dumps on Oracle and all other Certifications. Contact me on etagenius@gmail.com |
|
|
|
|
|
theORAKU (m)
|
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 |
|
|
|
|
|
cabali (m)
|
Yeah I tried that but i think am 'a' buzz like ya said aight???!!!!!
|
|
|
|
|
|
larryoncol (m)
|
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
|
|
|
|
|
|
theORAKU (m)
|
@cabali,
cant remember calling u a buzz.
I said u can buzz me wen u gat any other p
|
|
|
|
|
|
larryoncol (m)
|
we should be gisting about oracle related stuff not buzzes lol
|
|
|
|
|
|
kitaun (m)
|
nice one guys 
@Cabali
why are you misconstruing theOrakus' statement? 
work stress? eyah kpele 
|
|
|
|
|
|
babasin (m)
|
@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! |
|
|
|
|
|
larryoncol (m)
|
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
|
|
|
|
|
|
SLEEK_CHIC (f)
|
@ 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?
|
|
|
|
|
|
babasin (m)
|
@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.htmlAny problem let me know. Plus whats your motive for Oracle; play, learn or get real job? |
|
|
|
|
|
SLEEK_CHIC (f)
|
@ 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  |
|
|
|
|
|
![Nairaland [Nigerian Forum] Home](http://www.nairaland.com/Themes/default/images/english/home.gif)
Author
