STEP -1 ENTERPRISE LINUX SCREEN - PRESS NEXT
Contents
1. AA read ent EHHH following line for copying 10 days Archive Log files on TAPE EHHH find home3 archive name Archi_ dbf print gt x find home3 archive name Arch1_ mtime 10 print gt x sort x y tar cvf dev stO home oracle oradata EPFO controlO ctl home oracle oradata EPFO redo0 log home3 archive ctrlog cat y if gt 0 then echo AA echo echo Please Check the Tape it seems it is locked echo UNLOCK the tape and try again echo echo Wok 2K OK 2K K OK 2K 2K CK OK 2K OK CK 2K 2K OK 2K OK OK 2K 2K OK 2K 2K OK OK 2K 2K OK 2K OK OK CE PE CE CE OK OK OK 2K OK OK KOK KK OW else TEE dE Following line is to Delete Archive Logs which are older then 15 Days Uncomment following line to delete old log files echo echo Removing Old Files Please Wait echo rm x y find home3 archive name Archi_ dbf mtime 15 print exec rm V fi fi echo echo Press Enter to continue read ent 3 tput clear back echo Press ENTER To Continue i read ent 4 tput clear ping c 1 192 168 20 10 if gt O then echo 033 1m SHUTDOWN PROCESS STARTED PLEASE WAIT 033 0m sync halt exit else xabd2 ps ef grep ora wc l if ch eq 0 then echo 0332. 4 Wk yen gt pns 19 E oracieeDLCPM Amage SWioracle da I Oracle Universal Instater Configurat Database Configuration Assistant st Step 9 of 11 o Memory Select typical percentage 30 Applications Places System amp 12 52 PM ea Memory Siing VAA Character Sets Connection Model 5 Typical Allocate memory as a percentage of the total physical memory 8100 MB Percentage Shaw Memory Distribution C Custom Shared Memory Management Automatic C Manual SGA Size 2450 Memes PGA Size Total Memory for Orar Ry Total memory 4OMB of Oracle Process Size and the defaults for the empty parameters if any x Back Next gt Einisn e oracle DLCPM image SW oracle da ME Oracle Universal Installer Configurat 098 Database Configuration Assistant st Ln Select dedicated server in tab Connection Mode Step 10 of 11 Press NEXT Step 11 of 11 Select Create Database df Apprcatons maces system YA 12 54 nbi epi LB rectc ne meg oret racie Universatinstation Cen eh Ul Batters Connguranon Aswatant L Sai SF Press FINISH Screen 11 Confirmation Press OK Screen 12 Database Configuration Assistant Press Exit Applications Places Syst
3. C Use option 2 to start the database Recover from tape Login as oracle J cd k tar xvzf dev stO Auto start of Database and Application Modify etc rc local Primary Server vi etc rc local modprobe mptscsih For Data Drive export JAVA_HOME opt java opt jboss bin run sh b 192 168 10 10 amp Su oracle lsnrctl start Su oracle dbstart Mounting NFS Slice home3 archive from Secondary Server mount BENE nome3 archive home3 archive i e ldldhl is your host name for example ztifbd for ZTI NZ Secondary Server vi etc rc local bin sh This script will be executed after all the other init scripts YOu can put your initialization stuff in here if you don t want to do the full Sys V Style initi stuff Touch var lock subsys local Mount home3 archive mount t nfs o rsize 32768 wsize 32768 timeo 300 nointr hard ldldh02 home3 archive home3 archive Virtual IP ifconfig eth0 1 192 168 10 11 up ifconfig eth0 1 192 168 10 11 up Start JBOSS xport JAVA HOME opt java opt jboss bin run sh b 192 168 10 10 amp u oracle l1snrctl start su oracle dbstart Zt End of rc local file Q NO sb vi etc exports home3 archive 192 168 11 10 rw sync no wdelay insecure locks no root squash DATA FOR APPLICATION SERVER STEP 1 after installation of EPFO database login as oracle create a directory image install cd image
4. Save the file 2 4 5 vi h Create back the server parameter file sqlplus nolog SQL gt conn as sysdba SQL gt create spfile from pfile Exit Sometimes connection will not take place stating Auditing not possible Linux Err Then NIC had done netca and dbca and said to Deselect specify flash recovery area and archieving as in Step7 or 11 dbstart spfile server parameter file is to be created corrected as per the requirement But spfile can not edited directly For this copy spfile as pfile after dbshut and edit the pfile and copy back to spfile Pfile has the name like initDLCPM ora ome oracle OraHome network admin listener ora listener ora Network Configuration File home oracle OraHome network admin listener ora Generated by Oracle configuration tools SID LIST LISTENER SID_LIST SID DESC SID NAME PLSExtProc ORACLE HOME home oracle OraHome PROGRAM extproc SID DESC SID NAME EPFO ORACLE HOME home oracle OraHome LISTENER DESCRIPTION LIST DI ESCRIPTION ADDRESS PROTOCOL IPC KEY EXTPROC1 ADDRESS PROTOCOL TCP HOST 192 168 10 10 PORT 1521 ADDRESS PROTOCOL TCP HOST 127 0 0 1 PORT 1522 3 Jboss Installation Make sure the file j boss 4 2 3 GA zip is available in the directory image S
5. Browse Flash Recovery Area Size 2048 Mmes Enable Archiving Edit Archive Mode Parameters TV Automatic Archiving Archive Log File Format abr M you have specified Flash Recovery Area archive logs will go there If you other archive log destinations they wit be used Instead of Flash Recovery Aree recommended archiva 00 fes be wren to locations spread across different disks Archive Log Destinations 1 home3 arche Mmea B toracie oucem i Database Conniguraten Assistant st JEMEN E Press NEXT Step 8 of 11 Deselect all options including the items inside the standard database components Press NEXT Applications Places System 12 52 PM Omponants you wara to configure for use in your database Provide the IN ich you want the Component 10 exi Components which appear disabled are either mt installed or depend on components which not selected Core owa wana Dorae Text SYSALK Dove oue JOracie Spanar mwx Dorazio Utra Search JOracie Lavel Security SYSTEM Select the standard database components you wars to configure for use in database Oracie recommends thal you aways Ihese components your database Deselecting 1 Fas rm contu wu 0280 ders page Fra ma TGraciexMC OG z T Oratie Intermedia Sangara Owabese Components
6. gt refer 2 2 If you do not do the step 2 1 1 installer will fail in the beginning The installation will continue through the following screens Screen 1 Screen 2 Screen 3 Screen 4 Screen 5 Screen 6 Select Installation Method Choose Advanced Installation Press NEXT Specify Inventory directory and credentials Inventory directory home oracle oraInventory OS group Name dba Press NEXT If the directory name appeared is different it may be because you have not done the step 2 1 13 bash profile Select Installation Type Select Custom Press NEXT Specify Home details Select default values Press NEXT Available Product components Select all the following e Oracle Database o Enterprise Edition Options 10 2 Oracle Partitioning o Oracle Net Services Oracle Net listener o Oracle Enterprise Manager Console o Oracle Call Interface o Oracle Programmer Product Specific prerequisite checks if any error comes check whether all prerequisites in comparison with the error log have been carried out After that press RETRY Screen 7 Screen 8 Press NEXT Previleged Operating System Groups DBA Group dba DB Operator Group dba Press NEXT Oracle Universal Installer Creat Database Select Create Database Press NEXT Screen 9 Summary Press INSTALL Screen 10 Oracle Net Config Assistant Welcome Select Perform Typical Configuration Press NE
7. read echo case 1 Recover Data in Secondary Server 2 Take Daily Backup 3 Take Weekly Back up 4 Shut Down The System 0 Exit echo Enter The Option choice choice in 1 tput clear aa rsh 192 168 20 10 ps ef grep ora wc l if th aa eq 0 en echo Doing Recovery recover else echo echo echo echo echo echo lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt echo echo First Shut Down Oracle in PRIMARY machine j echo echo lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt echo fi echo Press ENTER To Continue M read ent 2 tput clear ad ps ef grep ora wc l ad rsh 192 168 20 10 ps ef grep ora wc l if ad gt 3 then echo KKK K K K K K K K K K K K K K K KK K K K KK K K K K K K K K K K OK K K K KK K KKK AA echo echo Please Shut Oracle On Primary Server then try echo echo AA else echo AA echo echo Insert Cartridge in DatDrive amp Press lt Enter gt c echo n echo
8. Use Ihe File System for Database storage Automatic Storage EUN storage opumizes database layout for 1 0 performance use this option you must specify set of disks to create ASM disk group or specify an dag ATH ik pro Raw Devices Raw partions oF provide the required shared storage for Real Application Clusters AC databases you do nef use toma Storage Management and a Cluster File System is not available You need ro have created one raw device for each daraffe fie and log file you are planning to create in the database F sperity Raw Manping hie Browse LETT 16 E fmage SWioracte da FE Oracle Universal instater Configurat Li Database Configuraton Assistant st 9 Step 6 of 11 Select use database location from template Press NEXT T 12 47 Pm do fs Applications Places System Speci locations for the Database files to be created 4 use Database file Locations from Tempiate Use Common Location for All Database Files Omabase Files Loca Use Oracie Managed Files Omabase Arex 7 Log wr Contra Flies If you wani to specify different locations for database filer pick either of the Above Options aed ute the Storage page to specify each location E oracle DLCPM mage SWioracie da I Oracle Universal installer Configurat D
9. clear echo echo WELCOME TO EPFO OFFICE echo echo echo DAILY ROUTINE START UP PROGRAM echo lt lt lt lt lt lt PRIMARY SERVER gt gt gt gt gt gt gt gt cat lt lt END 1 Mount with Secondary amp Start 2 Start From Primary In Case Secondary Not Working 3 Shut Down The Oracle 4 Take Daily Backup 5 Take Weekly Backup 6 Shut Down The System 7 Jboss Server Restart Exit END echo echo echo Enter The Option 0 7 read choice echo case choice in 1 tput clear aa ps ef grep ora wc l if aa gt 3 then echo lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt echo n echo Oracle Database is already running echo Can t start it again echo echo lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt echo else check mount mm df grep 192 168 20 11 wc l if mm eq 0 then mount t nfs o rsize 32768 wsize 32768 timeo 300 nointr hard 192 168 20 11 home3 archive home3 archive sudo bin mount t nfs o rsize 32768 wsize 32768 timeo 300 nointr hard 192 168 20 11 home3 a
10. 168 10 101 to 192 168 10 254 STEP 14 ROOT PASSWORD root123 CONFIRM PASSWO root123 STEP 15 SELECT CUSTOMISE NOW STEP 16 SELECT SOFTWARE DEVELOPMENT Package Selection Desktops Gnome Desktop Environment Applications Editor Graphical Internet Text Base Internet Development Development libraries Development tools Legacy S w Development Server FTP server Legacy Network Server Select Telnet and rsh Service from this in addition to Network Servers Printing Support Server Configuration tools Windows file server Base System Administrator tools Base Java Legacy software support System tools X window system Note all installed packages information are stored in root install log Next After completion of Linux installation Reboot the system Forward Firewall forward SELinux forward Kdump forward STEP 17 CLICK CONTINUE STEP 18 On successful installation system will prompt you to reboot Click Reboot button STEP 18 a Stop unwanted System Services chkconfig sendmail off chkconfig audit off chkconfig bluetooth off chkconfig firstboot off Share file system on Secondery system login in to root on secondary server edit ete exports and put following entries vi etc exports home3 archive 192 168 11 10 rw sync no root squash save the file and restart nfs service nfs restart exportfs a STEP 19 MOUNTING OF home3 archive OF SECONDARY SERVER T
11. 1m SHUTDOWN PROCESS STARTED PLEASE WAIT 033 0m sync sync halt echo I am halting2 exit else echo echo echo echo echo echo lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt echo echo First Shut Down PRIMARY Machine echo echo lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt echo R fi echo Press lt ENTER gt To Continue read ent 0 tput clear echo Bye Bye Mr XN033 1m LOGNAME from uname 033 0m exit echo Only 5 Options Are Available Try These Only O K Press lt Enter gt read ent esac done Please send your comments or suggestions to mahavirrai yahoo co in
12. O PRIMARY SERVER mount t nfs 192 168 11 11 home3 archive STEP 20 Add the following lines export JAVA HOME opt java opt jboss bin run sh b 192 168 10 10 amp su oracle l1snrctl start su oracle dbstart End of Linux Installation ORACLE INSTALLATION GUIDE This manual is mainly in intented to help Oracle installation NIC document has many other guideslines which may also be referred 2 Oracle Installation 2 1 Oracle Pre installation 2 1 1 Install the following package also From RedHat AS5 Disk 3 media mkdir cdrom mount dev cdrom media cdrom cd media cdrom Server rpm ivh libXp 1 umount media 2 1 2 Check that gcc rpms are installed using the command rpm q gcc If not mount the 2 Linux CD go into Server directory of cdrom and install all gcc rpm using rpm i gcc rpm 2 1 3 The etc hosts file must contain a fully qualified name for the server IP address lt fully qualified machine name gt lt machine name gt e g 192 168 10 10 ididh 127 0 0 1 localhost localdomain localhost 2 1 4 Tune the kernel parameters Setting the Semaphore Variable used in oracle installation Add the following lines to the 535686011 file See annuxer A Kernel sysctl configuration file for Oracle Enterprise Linux For binary values 0 is disabled 1 is enabled S sysctl 8 sysctl conf 5 for more details and Controls IP packet forwarding ne
13. OME bin ORACLE HOME Apache Apache bin Oracle Java Environment export JAVA_HOME opt java 2 2 oracle media preparation for installation 2 2 1copy oracle cds to harddisk location image SW oracle cd image mkdir SW cd SW cp R mnt cdrom cp R mnt cdrom 10201_database_linux32 zip 2 2 2 Unzip the files Unzip 10201_database_linux32 zip 2 2 3 Change the owner and group chown oracle dba image SW find depth print exec chown oracle dba image SW cd home3 mkdir archive chown oracle dba archive 2 3 If Oracle RE INSTALLATION additional pre requisites 2 3 1 Remove all old files no uninstaller is there in linux rm etc oratab rm etc oraInst loc cd home oracle rm rf rm rf home oracle Oradata rm rf home oracle OraInventory rm rf make sure that you are in home oracle It is assumed that your earlier oracle installation was in home oracle Check this by seeing the directory home oracle cd tmp rm rf ora make sure that you are in tmp rm rf Ora make sure that you are in tmp 2 4 Oracle Installation Login as Oracle in GUI Cntrl AlIt F7 Open a terminal Applicaton gt accessories Terminal OR RightClick gt Terminal cd image SW oracle database runInstaller this file and oracle database dir are generated when we unzipped 10201 database linux32 zip
14. STEP 1 ENTERPRISE LINUX SCREEN PRESS NEXT BUTTON STEP 2 WHAT LANGUAGE YOU WOULD LIKE TO USE DURING INSTALLATION PROCESS CHOOSE ENGLISH ENGLISH AND PRESS NEXT BUTTON STEP 3 SELECT APPROPRIATE KEY BOARD U S ENGLISH AND PRESS NEXT BUTTON STEP 4 SELECT NSTALL ENTERPRISE LINUX OPTION AND PRESS NEXT BUTTON STEP 5 SELECT CREATE CUSTOM LAYOUT AND PRESS NEXT STEP 6 IF ANY PARTION IS THERE AND YOU WANT TO DELETE THEM SELECT THE PARTION AND CLICK DELETE BUTTON STEP 6 CREATE PARTIONS AS FOLLOWS Partitions Create following Partitions PARTITION SIZE FILE TYPE ADDL SIZE boot 500 MB EXT3 FIXED swap 4096 MB Double of RAM 2GB SWAP FIXED 20000 MB EXT3 FIXED home 50000 MB EXT3 FIXED home2 80000 MB EXT3 FIXED home3 50000 MB EXT3 FIXED image 200 GB Leftout space should be in this filesystem Fill to Free Size STEP 7 PRESS NEXT BUTTON STEP 8 INSTALLING NETWORK DEVICES SELECT ETHO AND CLICK EDIT STEP9 SELECT MANUAL CONFIGURATION STEP 10 DESELECT IPV6 SUPPORT AND SEEECTJPVA SUPPORT STEP 11 SELECT MANUAL CONFIGURATION IP ADDRESS 192 168 10 10 PREFIX NETMASK 255 255 255 0 STEP 12 CLICK OK STEP 13 HOSTNAME Idldh STEP 14 MISC SETTINGS GATEWAY 192 168 10 10 PRIMARY DNS 192 168 10 10 Primary System Node Ididh Ididhl ip Address 192 168 10 10 192 168 11 10 Secondary system Idldh Ididh1 192 168 10 10 192 168 11 11 IP Address rage for Clients 192
15. W Then proceed with the following commands home unzip image SW jboss 4 2 3 GA zip s home jboss 4 2 3 GA opt jboss 1 s home jboss 4 2 3 GA jboss 4 Java SDK Installation Make sure the file jdk 1 5 14 linux i586 bin is available in the directory image SW Then proceed with the following commands cd home sh image SW jdk 1 5 O 14 linux i586 bin In s home jdk1 5 0 14 opt java In s home jdk1 5 0 14 java 5 Copy Application file EPFOWEB war to opt jboss server default deploy Make the following directory with owner group as oracle dba home2 EPFODATA Oracle datafiles are stored here home3 archieve Archieve log files are stored here 6 1 Start_ amp Stop JBOSS Login as root export JAVA_HOME opt java opt jboss bin run sh b 192 168 10 10 8 pl check the ip address using ifconfig a more This will run jboss in the background 6 2 Stop JBOSS opt jboss bin run sh b 192 168 10 10 c nodel TO START JBOSS FROM LOGIN Add following line vi etc rc local export JAVA_HOME opt java opt jboss bin run sh b 192 168 10 10 amp b Test the EPFO application Load mozilla firefox Browse to the URL http 192 168 10 10 8080 EPFOWEB FAIL OVER 1 Both servers are fine O login to primary server option 3 to escape to shell check home3 archive for archive logs if files older than 30 days remove them Check the export files at image DBexports if fi
16. XT you may use netca to Netconfig outside from the installer Screen 11 Database Configuration Assistant you may use dbca to create delete database outside from the installer Step 1 of 11 Select General Purpose not as shown in screen shot Press NEXT Applications Faces System 12 42 PM 4o Select template from the following list to create a database Select Template Data Warehouse General Purpose 4 back Mes gt 8 AmagessWioracie da Oracle Universal installer Configurat f Database Configuration assistant st gt Step 2 of 11 Global DB Name EPFO SID EPFO f Applications Places System 1243 4 dos An Oracle database i uniquely kdertihed by a Global Database Name Typically of the form name domaier Global Database Name o ce A Garabase i referenced Dy at least one instance which is uniquely identified from any other instance on this computer by an Oracte System Identifier CaO 20 E Ml oracte oucem FE Oracte Uneversat mstaner Conngurat LA Database Conngurabon Assistant St EEEE The war file s working is depending on SID So you may set above as EPFO Step 3 of 11 Deselect all options Press NEXT fs Applications Places system 1244 PM ya Database Configuration Assistant Step 3 of 11 Management Op
17. atabase Configuration Assistant St 9 Step 7 of 11 Select specify flash recovery area Area Oracle Size 2048 Deselect enable archieving Applications Places System 12 48 PM ya Choose the recovery options for the database F Specify Flash Recovery Area This is used as the default for all backup and recovery operations and is also required for automatic backup using Enterprise Manager Oracle recommends that the database fies and recovery files be located on physically different disks for data protection and Flash Recovery Area ORACLE BASE nach recoverv Browse J Flash Recovery Area Size 2048 I Enable Archiving Edit Archive Mode Parameters 18 E oracieDLCPM Amage SWioracle da E Oracle Universal Installer Configurat OEE OR Select Enable Archiving Click on Edit Archive Mode Parameters Add 1 Archive log desitination as home3 archive if archieving selected Archive will be written at after transactions of about 100 MB or when all redo log files are full ifs Appacovions Places System CS Choose the recovery options for the database Mspecity Flash Recovery Area This is used as the default for backup and recovery operations and is also required for automatic backup using Enterprise IEEE E E et fias ands recor fer be located on pica ire is for protection Flash Recovery Area ORACLE DASE fiash recovery
18. em 106PM do Select the database creation options Database Configuration Assistant Database Configuration Assistant Database creation complete Check the logfiles at home oracie OraHome cfgtoollogs Goca DLCPM for details Database Informanon Global Database Name System Server Parameter Filename mome oracie OraHome dbs SpfieOLCPM ora Note database accounts except SYS and SYSTEM are locked Select the Password Management button to wew a complete list of locked accounts manage the database accounts From the Password Management window unlock only the accounts default passwords e eee FE Oracle Universal Instater Configurat LA Database Configuration Assistant S IET 9 Thereafter run the following shell scripts as root user gt sh home oracle oraInventory orainstRoot sh gt sh home oracle oraHome root sh Screen 13 End of Installation Press EXIT Don t reboot the machine 2 4 2 Change Oratab last parameter is set to Y to enable dbstart dbshut vi etc oratab Ididh home oracle OraHome Y And save it Esc wq 2 4 3 Creation of spfile sqlplus nolog SQL connect as sysdba SQL create pfile from spfile it will create initEPFO ora file in home oracle OraHome dbs exit dbshut 2 4 4 edit add in vi etc oratab initEPFO ora open cursors 1500 note 1000 is enough it depends on how many users process 900 UTL FILE DIR
19. install copy the files into install directory it is assumed that EPFODATA and DMDATA folders have been created in home2 sglplus nolog sqi conn as sysdba sqli gt start crdb create new tablespaces EPFODATA EPFOINDX DMDATA amp DMINDX sqi gt start crdb1 create new users NICEPFO amp EPFODM sqli gt start crdb2 grant permission sql gt exit STEP 2 imp epfodm epfodm Dump file name DMblank dmp Then press enter Give no Give yes Give yes Give yes Give yes imp nicepfo nicepfo Dump file name EPFOblank dmp Then press enter Give no Give yes Give yes Give yes Give yes imp nicepfo nicepfo DUMP file name HOMASTER dmp Then press enter Give no Give yes Give yes Give yes Give yes KK KK K K K K K K K K K K K CK K K CK K K K K K K K K K K K K K K K K K KKK KKK KKK KK KK Location image SW REL_1 98 Isnrctl stop sqlplus nolog sqi conn nicepfo nicepfo sqi gt start Install 30012010 dat Isnrcti start deploy the EPFOWEB war rel 1 version 1 98 go to the directory where EPFOWEB war file has been saved cp EPFOWEB war home jboss server default deploy STEP 3 START DMS amp DTMS Refer to Technical User Manual for DMS amp DTMS _ 0000644 0000764 0000764 00000013544 11257407534 012254 0 ustar oracle dba trap 1 23 15 while true do tput
20. le of type HRKNL lt date gt dmp these are the complete dumps of the db done daily through the crons home oracle expbackup cron This is called online backup Login to the Secondary Server Exit out of menu Check that data is being dumped to the tape with tar tvzf dev SstO this will show the listing of the files the files will have a timestamp from yesterday the timestamps should be the same for all database files oradata files Confirm from local Sys Admin that the last recovery went fine Ask about the daily backups 2 Primary Server has failed Th i During Business Hours Shutdown failed server Remove network cable from Primary Server and connect Network cable to Secondary server Start samba server service smb start Take the full backup on secondary server with archive log i e option 3 for Weekly backup Recover the Server from option recover secondary server Start the database if not starting see below i If database is not starting then do time based recovery with the help of an oracle DBA recover database until time cancel i Night Change the ip to 192 168 10 10 ifconfing ethO 1 192 168 10 10 Start Samba Sever service smb start Start on Secondary Server exit out of menu and do dbstart 2 Backup Server has failed Secondary Server a Take full backup on tape b Network cable network cable connecting to primary server should be disconnected for the primary server i e crossover cable
21. line to the te pamnd login file session required lib security pam_limits so 2 1 9 Disable secure linux by editing the 5811000009 file SELINUX disabled 2 1 10 Edit the etc redhat release file replacing the current release information Red Hat Enterprise Linux Server release 5 Tikanga with the following redhat 4 2 1 11 Create group dba and the userid oracle with both gid and uid having the ID 501 groupadd dba useradd oracle d home oracle g dba passwd oracle give newpassword for oracle 2 1 12 Login as oracle and make copy of bash profile login oracle or as the case may be su oracle passwd give the password and get the prompt cp bash profile bash profile org 2 1 13Make the following changes as per the setup of oracle user profile vi bash profile bash profile Get the aliases and functions if f bashre then bashre fi User specific environment and startup programs PATH SPATH SHOME bin export PATH unset USERNAME Oracle Environment export ORACLE HOME home oracle OraHome export ORACLE BASE home oracle export ORACLE SID EPFO export ORACLE TERM xterm export NLS LANG AMERICAN export ORA NLS33 S ORACLE HOME ocommon nls admin data export LD LIBRARY PATH SORACLE HOME lib lib usr lib usr local lib export PATH SPATH SORACLE HOME bin SORACLE HOME Apache Apache bin hi export PATH PATH ORACLE H
22. lt Enter gt to continue read ent else echo System Shutdown Process Started PLEASE WAIT umount home3 archive sync sync usr sbin init O 7 tput clear su c jkill echo Press lt Enter gt to continue read ent 0 tput clear echo echo echo Bye Bye Mr LOGNAME from uname exit echo Only 0 7 Options Are Available Try These Only O K Press lt Enter gt read ent esac done fullbackup 0000644 0000764 0000764 00000000774 11257413163 011731 0 ustar oracle dba clear tput echo e Please ensure oracle database is shutdown y n c read ans if ans y o Y then date dt date d m y echo Database backup for dt tar cvfz image db backup EPFO_Db dt tarz home oracle OraHome dbs home oracle oradata EPFO home3 archive ctrlog home2 DMDATA home2 EPFODATA home oracle bash_profile_10 tar cvfz image appl backup JBOSS WITH WAR dt tarz home jboss 4 2 3 GA home jdk1 5 0 14 home oracle bash profile 10 date else echo Backup failed fi Menu_secondary 0000644 0000764 0000764 00000010746 11257644435 012564 0 ustar oracle dba trap 123 15 while true do tput echo echo echo echo echo echo echo echo echo clear WELCOME OFFICE KARNAL lt lt lt lt lt lt lt lt lt Secondery Server gt gt gt gt gt gt gt gt gt gt cat lt lt END END echo echo echo echo
23. n be an user name a group name with group syntax the wildcard for default entry the wildcard can be also used with group syntax for maxlogin limit type can have the two values soft for enforcing the soft limits hard for enforcing hard limits lt item gt can be one of the following core limits the core file size KB data max data size KB fsize maximum filesize KB memlock max locked in memory address space KB nofile max number of open files rss max resident set siz KB stack max stack size KB cpu max CPU time MIN nproc max number of processes as address space limit maxlogins max number of logins for this user maxsyslogins max number of logins on the system priority the priority to run user process with locks max number of file locks the user can hold sigpending max number of pending signals msgqueue max memory used by POSIX message queues bytes nice max nice priority allowed to raise to rtprio max realtime priority domain type item value soft core 0 hard rss 10000 student hard nproc 20 faculty soft nproc 20 faculty hard nproc 50 ftp hard nproc 0 student maxlogins 4 soft nproc 2047 hard nproc 16384 soft nofile 1024 hard nofile 65536 Oracle soft memlock 2097152 Oracle hard memlock 2097152 End of file 2 1 8 Add Edit the following
24. rchive home3 archive fi check mount bb df grep 192 168 20 11 wc l if bb eq 1 then echo Please Wait while DataBase is Starting Ictrcp dbstart else echo echo lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt echo echo Secondary has not yet started echo Try after mounting Secondary echo echo lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt fi fi echo echo Press Enter to continue read ent 2 tput clear ac ps ef grep ora wc l bb df grep 192 168 20 11 wc l if ac gt 3 then echo echo GO GO GO echo echo Oracle is already running echo Can t start it again echo echo GO 0 0 elif bb eq 1 then echo lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt gt gt gt gt gt gt gt gt gt gt gt gt gt gt g
25. t gt gt gt gt gt gt gt gt gt gt echo n echo Secondery Surver is Mounted use echo Option 1 to start Oracle echo echo lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt lt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt gt else Ictrcp dbstart fi echo echo Press Enter to continue read ent 3 tput clear echo Really want to Shut Down Oracle Y N read yn if test z yn then echo Sorry Invalid Key Pressed read ent elif test yn N o Syn n then else echo Shutting Down Oracle Ikill dbshut fi echo echo Press lt Enter gt to continue i read ent 4 tput clear ad ef grep ora wc l if ad gt 3 then echo KKK K K K K K K K K K K K K K K K K K K K KK K K K K K K K K K K OK K K K KKK KKK AA echo echo Please Shut Oracle Then take Daily Backup echo echo AA AA echo echo Insert Cartridge in PRIMARY System amp Press Enter c Sat read ent 34 dE following line for copying 4 days Archive Log files on 3E 4E dE find home3 archive name Archi dbf print gt x find home3 archive name Arch1 mtime 10 print gt x sort o y tar cvf dev s
26. t ipv4 ip forward 0 Controls source route verification net ipv4 conf default rp filter 1 Do not accept source routing net ipv4 conf default accept source route 0 Controls the System Request debugging functionality of the kernel kernel sysrq 0 Controls whether core dumps will append the PID to the core filenam Useful for debugging multi threaded applications kernel core uses pid 1 Controls the use of TCP syncookies net ipv4 tcp syncookies 1 Controls the maximum size of a message in bytes kernel msgmnb 65536 Controls the default maxmimum size of a mesage queue kernel msgmax 65536 Controls the maximum shared segment size in bytes kernel shmmax 4294967295 kernel shmall 2097152 kernel shmmni 4096 kernel sem 250 32000 100 128 fs file max 65536 net ipv4 ip local port range 1024 65000 net core rmem default 262144 net core rmem max 262144 net core wmem default 262144 net core wmem max 262144 4 Controls the maximum number of shared memory segments in pages kernel shmall 268435456 2 1 5 Run the following command to change the current kernel parameters sbin sysctl p 2 1 6 ulimit a make memory size unlimited 2 1 7 Add the following lines to the te Security limitsicont file etc security limits conf Each line describes a limit for a user in the form domain type item value Where domain ca
27. tO home oracle oradata EPFO controlO ctl home oracle oradata EPFO redo0 log home3 archive ctrlog cat y if gt 0 then echo AA echo echo Please Check the Tape it seems it is locked echo UNLOCK the tape and try again echo echo AA else HEHH Following line is to Delete Archive Logs which are older then 5 Days Uncomment following line to delete old log files echo Removing Old Files Please Wait rm x y find home3 archive name Archi_ dbf mtime 10 print exec rm V fi fi echo echo Press lt Enter gt to continue read ent 5 tput clear ae ps ef grep ora wc l if ae gt 3 then echo KKK K K K K K K K K K K K K K K KK K K K K K K K K K K K K K K K OK K K K KK K KKK echo echo First shut Oracle Then Take Weekly Backup a rH else back fi echo echo Press Enter to continue read ent 6 tput clear ab ps ef grep ora wc l if ab gt 3 then echo echo echo KKK K gt K K K K K K K K K K K K K KK K K K KK K K K K K K K K K OK OK K K K KKK KKK AA echo echo First Shut Down Then Shut Down Machine echo H echo KKK K gt K K K K K K K K K K K K K KK K K K K K K K K K K K K K K OK K K K KKK KKK AA echo echo Press
28. tions Each Oracle database may be managed centrally using the Oracle Enterprise Manager Grid Control or loca using the Oracie Enterpnze Manager Database Control Choose the management option that you would like to use to manage this database T Configure ihe Database with Enterprise Manager Use God Control fer Database Management Managerner sence A Use Omabase Control for Database Management Enable Emal Notifications Outgoeg Mat I Emel Aures Enable Daily Backup Backup Starr Time a ow e rw 05 Username 19 E oracieDLCPM Amage SW oracle da Oracle Universal instater Configurat Database Configuration Assistant st Step 4 of 11 Select use the same password and give password Eg manager10 4 Applications Places system T 1245PM do For security reasons vou must specify passwords for the following user accounts in the new Use the Same Password for All Accounts Password Confirm Password f Use Different Passwords User Name Password Confirm Password e E oracie ou crs BE Oracle Universal instar Contra LA Database Contguraton assistant St HHH Press NEXT Step 5 of 11 Choose file system Press NEXT 4 Applications Paces system Q T 12 45 Pm do Select the storage mechanism you would Ike 10 use for the database S Fik System
Download Pdf Manuals
Related Search