- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: DBA and SYS Admin corelation
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2008 08:03 AM
тАО04-24-2008 08:03 AM
DBA and SYS Admin corelation
can any one corelate the following points like
in system admin work we are extending the vg by adding physcal disk . extending the FS by by increasing the LV.similar way what DBA is doing .corelate DBA task with system admin task. so it is easy to understand DB concepts for sysadmin .
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2008 08:41 AM
тАО04-24-2008 08:41 AM
Re: DBA and SYS Admin corelation
A DBA and sysadmin must be a team. There is some overlap required.
Oracle installs require root permissions for certain parts of the installation. DBA's do not need root access unless they are backing up the sysadmin.
If the task requires root access the task, even if its part of an oracle installation should be performed by a systems administrator.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2008 09:02 AM
тАО04-24-2008 09:02 AM
Re: DBA and SYS Admin corelation
The DBA and sysadmin often form part of the same team if not the same person does both.
The recent trends gives quite an independence to the DBA when it comes to the administration of the Database. Oracle ASM is in this same direction. Google for Oracle+ASM.
good luck!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2008 10:45 AM
тАО04-24-2008 10:45 AM
Re: DBA and SYS Admin corelation
Basically, system admin job and DBA jobs are different.
But they will work together to act like a team. and their jobs are correlated.
Without mutual of them, the systems will not perform perfectly.
Don't assign any jobs those who are not well knowledge or have experienced.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-24-2008 10:53 AM
тАО04-24-2008 10:53 AM
Re: DBA and SYS Admin corelation
In effect Oracle creates an operating environment on top of our O/S. So if you extended disk and they did NOT extend tablespace...they would hit tablespace full, until they extended and met up with the physical space we allocated.
So a DBA administrates the needs of the database (i.e. high end mgmt & monitor software) and allows for the running of programs/code (example SQL) to extract the information/data contained within it's tables and indexes.
We in HPUX SysAdmin manage and monitor & build operating systems to enable to ensure that all parties can process what they need. Be that DBA's, programmers with a variety of syntax languages, or third party vendor applications.
Hope this made some sense,
Rgrds,
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2008 03:46 AM
тАО04-26-2008 03:46 AM
Re: DBA and SYS Admin corelation
DBA job and sys admin their adminsitraion taks different but they are part of one team
dba team needs a lot things from unix team
file permissions, creating logical raw devices, cluster shutdown etc...creating oracle user etc....
but oracle team normally not get unix passwd and username. all the things related to unix are doing unix team itself in my examples i mentioned
oracle teams are using a lot of things to do by using from sql they are creating table space, extendign table space,
they are using sql queries etc...........
then if some files are using more space this will manage normally unix team, if it is related with oracle they wil tell u
for example
in swap case if swap is configured properly
by unix team and some oracle process consuming
more space then unix team will tell u regarding that process
it is for just an example
now i think u can understand oracle and unix peoples should be team!!!!!!!!!!!
thanks and regards
sajjad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2008 09:21 AM
тАО04-26-2008 09:21 AM
Re: DBA and SYS Admin corelation
From my side its OK to learn DB concept from UNIX , basics are pretty simialar.
FIlesystem from UNIX is similar to tablespaces.
Directories u can consider tables
and files u can see as data inside that table.
In case of performance issue in unix u check which process is taking lot of CPU,memory etc
In oracle u check query,its execution plan,physical reads(well concept is entirely different but u can corelate things if u know unix.
You have kernel parameters in unix and u have various parameters in init.ora in oracle to have certain behaviour of oracle.
There is no thumb rule for this go and learn DB and corelate things it would be quite simple.
BR,
Kapil