Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,255 members, 7,953,954 topics. Date: Friday, 20 September 2024 at 09:41 AM |
Nairaland Forum / Science/Technology / Computers / Oracle DBA Corner (53442 Views)
Newbies Corner / Windows 8 Is Around The Corner / The Best Laptop Engineers Around The Corner (2) (3) (4)
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) ... (21) (Reply) (Go Down)
Oracle DBA Corner by cabali(m): 8:14pm On Feb 14, 2006 |
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? |
Re: Oracle DBA Corner by sesal: 8:25pm On Feb 17, 2006 |
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. |
Re: Oracle DBA Corner by cabali(m): 2:36pm On Feb 23, 2006 |
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! |
Re: Oracle DBA Corner by cabali(m): 7:41am On Mar 10, 2006 |
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 |
Re: Oracle DBA Corner by sbucareer(f): 3:15pm On Mar 10, 2006 |
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. |
Re: Oracle DBA Corner by cabali(m): 3:49pm On Mar 10, 2006 |
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 |
Re: Oracle DBA Corner by sbucareer(f): 6:10pm On Mar 10, 2006 |
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. |
Re: Oracle DBA Corner by Oracle(m): 11:32pm On Mar 13, 2006 |
cabali:yeah for sure there are people with Oracle knowledge |
Re: Oracle DBA Corner by cabali(m): 4:51pm On Mar 19, 2006 |
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 |
Re: Oracle DBA Corner by larryoncol(m): 6:16pm On Mar 26, 2007 |
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 |
Re: Oracle DBA Corner by larryoncol(m): 6:22pm On Mar 26, 2007 |
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 |
Re: Oracle DBA Corner by segebee(m): 8:15pm On Mar 26, 2007 |
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 |
Re: Oracle DBA Corner by cabali(m): 6:47pm On Mar 27, 2007 |
Who brought this one here |
Re: Oracle DBA Corner by olawa20(m): 12:40pm On Mar 28, 2007 |
larryoncol: has cabali tried out larry's suggestion. I think that should do it. |
Re: Oracle DBA Corner by segebee(m): 4:01pm On Mar 28, 2007 |
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 |
Re: Oracle DBA Corner by ujem(m): 12:12pm On Mar 29, 2007 |
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. |
Re: Oracle DBA Corner by larryoncol(m): 3:29pm On Mar 29, 2007 |
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 |
Re: Oracle DBA Corner by larryoncol(m): 3:34pm On Mar 29, 2007 |
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 |
Re: Oracle DBA Corner by pentiumix: 7:24pm On Mar 30, 2007 |
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. |
Re: Oracle DBA Corner by jereton(m): 7:54pm On Mar 31, 2007 |
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 |
Re: Oracle DBA Corner by etauso(m): 8:02pm On Mar 31, 2007 |
I can assist you with the latest Actualtests dumps on Oracle and all other Certifications. Contact me on etagenius@gmail.com |
Re: Oracle DBA Corner by theORAKU(m): 3:47pm On Apr 01, 2007 |
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 |
Re: Oracle DBA Corner by cabali(m): 5:16pm On Apr 01, 2007 |
Yeah I tried that but i think am 'a' buzz like ya said aight!!!!! |
Re: Oracle DBA Corner by larryoncol(m): 11:43am On Apr 03, 2007 |
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 |
Re: Oracle DBA Corner by theORAKU(m): 10:03am On Apr 04, 2007 |
@cabali, cant remember calling u a buzz. I said u can buzz me wen u gat any other p |
Re: Oracle DBA Corner by larryoncol(m): 12:24pm On Apr 06, 2007 |
we should be gisting about oracle related stuff not buzzes lol |
Re: Oracle DBA Corner by kitaun(m): 8:49pm On Apr 07, 2007 |
nice one guys @Cabali why are you misconstruing theOrakus' statement? work stress? eyah kpele |
Re: Oracle DBA Corner by babasin(m): 4:25pm On Apr 08, 2007 |
@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! |
Re: Oracle DBA Corner by larryoncol(m): 12:45pm On Apr 16, 2007 |
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 |
Re: Oracle DBA Corner by SLEEKCHIC2(f): 11:36am On Apr 17, 2007 |
@ 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? |
Re: Oracle DBA Corner by babasin(m): 10:13pm On Apr 18, 2007 |
@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? |
Re: Oracle DBA Corner by SLEEKCHIC2(f): 11:14am On Apr 19, 2007 |
@ 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 |
(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) ... (21) (Reply)
11 Reasons You Should Quit Facebook In 2014 / 15 Keyboard Shortcuts Every Computer Geek Should Know / Airtel 4gb Free For 1month 100naira 2015 Tweak
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 55 |