In solaris, the oratab file is located in the varoptoracle directory. The book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of operatingsystem documentation. Every time when i login as other then oracle user and try to view this file it saying that i. Time to time, dba needs to check database backup status and see if its completed, failed, running etc. He has to locate various file, process, kill session,clear directories, schedule cron and various other activities. Oracle freeman 2229802 chapter 1 oracle solaris 11 cheat sheet general administration oracle solaris 11 administrators cheat sheet 1. Some unix commands are common to both linux and solaris whereas some commands differ. Oracle database administrators reference 12c release 1 12. Unixlinux commands for oracle dbas dba team revision history date revision. If no location is defined it acts on the current directory. Linux and solaris recipes for oracle dbas darl kuhn apress. Also, dba must be able to get the backup start time, end time and even the backup size for reference purpose. However other non oracle users which belongs to some other network groups need read only access to this file. When administrators create a zone, an application execution environment is produced in which processes are isolated from the rest of the system.
Apply to database administrator, administrator, senior database administrator and more. As a beginner dba and then, particularly, as an intermediate dba, i found that i knew what i needed to do. Below are some of the useful unixlinux commands which we use frequently. The create table privilege, for example, lets you create tables. Difference between linux and solaris blog for dba, rac. He has to locate various file, process, kill session,clear directories. I am in dilemma what to do after completion of the course. Linux and solaris recipes for oracle dbas ebook by darl. Quick howto ssh login without password ssh keys solaris.
Oracle solaris command casebook for linux users fujitsu. Pdf unixlinux commands for oracle dbas dba team vikram. Oracle database administrators reference for linux and. This solaris script is provided at oracle metalink article how to check the host memory usage on solaris via nmupm utility id 741004. Services can quickly and safely be developed, deployed and replicated. Click on document oracle solaris11 system administration commands. Dba commands users, roles and privileges an oracle role is a set of privileges or the type of access that each user needs depending on his or her status and responsibilities database system privileges let you execute specific sets of commands.
Understand and execute best practices when administering advanced features of oracle solaris 11. Deploying oracle database on the oracle solaris platform an. Actually i planned to do oracle dba, but many advised me to do solaris admin first and then do oracle dba. Unix file permissions explained sounds basic, but you may learn something new here.
Oracle corporation sun4us fujitsu primepower450 2x sparc64 v system clock frequency. The commands explained in this document are based on the following system environments. My oracle dba commands oracle recommended patches oracle database doc id 756671. Solaris is the form of unix customized by sun microsystems. Operating system checklist for oracle database on oracle. Solaris command reference for oracle dba oracle point. Master special features of oracle solaris 11 such as zfs objects, networking framework with rnc reactive network configuration, and get introduced to performance monitoring. Migrate an oracle solaris 10 global zone to oracle solaris 11 p2v 450 prepare an oracle solaris 10 global zone for migration 450 create a solaris 10 brand zone 450 back up a zone 453 recover a zone 454 delegated zone administration 455 summary 455 chapter 7 user and security administration 457 administering user accounts 457. Unix scripts for oracle dbas oracle 11g new features oracle performance tuning sql scripts for oracle dbas unix and linux for oracle dba vi editor commands windows os and oracle dba cron jobs unix file management dba tips and tricks greenplum postgresql quick ref pgpsql quick ref find command in unix. Oracle vm server for sparc is sometimes referred to as oracle vm or ovm. Top dba shell scripts for monitoring the database bmc blogs. This is another unix command frequently used by oracle dbas. Baisyet basic file navigation df command in linux provides disk space usage information of your file systems.
Administration and os commands are more or less similar on any flavor of unixlinux operating system i. Turn your manual and reactive oracle monitoring activities into. Install oracle 11g rac on solaris 10 oracle community. Over 50 advanced recipes to help you configure and administer oracle solaris systems. Far sync 6 sql 6 datapump 5 errors 5 managment 5 12c 4 active data guard 4 alert.
Oracle database administrators reference for linux. Linux and solaris recipes for oracle dbas in searchworks. Download linux and solaris recipes for oracle dbas pdf. Oracle dba need to operate on unix linux solaris aix operating system. Notes oracle solaris is sometimes referred to as solaris. Which is good in terms of future career prospectus i am ms graduate in 2011 dec. Further reference documentation about oracle and solaris 10 is detailed in the other references section below. To list the concurrent programs that run today,giving details about status and logs,dba scripts,to cancel specific concurrent request,to check running concurrent request,to check custom reports,to check object locked status,to check incompatibility between program,to check manager of running concurrent request,to check rdf file location,to check concurrent programs running currently with. This document is intended for oracle dbas who want to understand the. Oracle database administrators reference, 11 g release 2 11.
Oracle database release notes for solaris operating system. Commandline utilities like sqlplus as well as guis like oem are available on all the platforms oracle run on. The top command is probably the most useful one for an oracle dba managing a database on linux. Command execution of this document is an example of running in the solaris environment. Oracle dba need to operate on unixlinuxsolarisaix operating system. Handy solaris commands hw config, swap, patches etc. Im an experienced oracle applications dba architect with more than a decade of fulltime dbaarchitect experience.
Checking database backups are one of the main focus areas of a dba. Capturing server information with unix for the oracle dba who performs reporting functions on multiple servers, capturing the server name is very important. It is now being customized by many different companies like oracle corporation, red hat, suse, debian etc. I have gained a wide knowledge of the oracle and nonoracle software stack and have worked on several big projects for multi.
Oracle solaris zones provide isolated and secure virtual environments running on a single operating system instance, ideal for application deployment. If youre a developer, the difference is imperceptible. Solaris 11 cheat sheet and other oracle documentation. Note that unlike other commands, top does not produce an output and sits still. The script uses the same procedure as that followed by the oracle enterprise manager oem agent. The ls command lists all files and directories in the specified directory. Dba cheat sheet 9 oracle series tight portable dba.
Solaris, hpunix, ibm aix, red hat, fedora, ubuntu, etc. This command is used to change the password for current user. Here in this article i am trying to give some useful unix command for oracle dba to help them in daytoday activities. The oracle database deployment on the oracle solaris 10 platform provides. Oracle database administrators reference 11g release 2 11. The book is written for database administrators who need to get work done and lack the luxury of curling up fireside with. Oracle solaris command reference for linux users createddec 2016 linux. Many of these commands are used to automate oracle reporting and make oracle management simple. The chown command is used to reset the ownership of files after creation. If youre a dba, the major difference will be in how you interact with the database. The tight integration of installation, packaging and filesystem technologies in oracle solaris 11 radically simplifies software lifecycle management.
I will explain what is the srvctl and useful srvctl commands in oracle rac in this post. The instructions are carried out by a qualified dba, fully conversant with oracle. Basic linux commands for oracle dba ampersand academy. It refreshes the screen to display new information.
Realtime performance monitoring vmstat, iostat, mpstat etc. Install oracle 11g rac on solaris 10 ehtiram hasanov nov 15, 2010 5. Oracle database administrators reference, 11g release 2 11. For example, on solaris, the output from the df command uses the.
Linux and solaris recipes for oracle dbas, 2nd edition is an examplebased book on managing oracle database under linux and solaris. The documentation is available in adobe portable document format pdf. Translations and searching tr set1 set2 translates set1 to set2 sed powerful text manipulation tool grep pattern filename finds lines containing pattern in file grep v pattern filename finds lines not. The following oracle solaris on sparc 64bit kernels are supported. The actual oracle database is very similar on windows and unix. How to install oracle 10g on solaris oracle database.
Oracle database monitoring scripts for daily,weekly,monthly and quarterly dba checklist activity, shell script for oracle database health check,oracle dba daily activities with examples,oracle database monitoring shell scripts,shell script for oracle database health check,oracle dba scripts all in one,shell script to check oracle database status,shell scripting for oracle dba pdf,oracle. Oracle solaris will also be covered in a handson lab session on the first day in the afternoon, where we will demonstrate how to use rest to gather information about an oracle solaris instance here is a list of these sessions, with the list of presenters and when they will take place. Over time ive been adding more linuxrelated entries. This article contains a brief list of commands that most unix dbas will need on a regular basis. This entry was posted in my reference, oracle point and tagged commands, oracle, solaris by r. The below query gives answers to all the backup details in oracle.
405 390 484 2 1191 730 1138 760 486 1001 297 705 1224 715 1257 296 148 452 924 993 1275 1080 1621 339 1384 1188 959 495 24 613 932 85 1496 797 789 424 198 1192 364 942