Sabin Shrestha's Personal Site

Check the configuration parameters of Rman. Connect to Rman without catalog. Controlfile is used to store Rman metadata: You need to set the environment before invoking Rman: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1 ORA_CRS_HOME=/u01/app/crs ORACLE_PATH= $ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin ORACLE_SID=mars1 $rman target / nocatalog RMAN> show all; RMAN>exit; ———————————– rmanbackupconf.sh rman target / nocatalog <<EOF CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # [...]

Orac is the creation of a dedicated group of volunteer programmers led by Andy J. Duncan. Some of the major contributors include Kevin Brannen and Thomas Lowery, but many others too numerous to mention have contributed as well. A list of most of the contributors is included in the README file that accompanies the program. [...]

http://www.materialdreams.com/oracle/ http://www.orafaq.com/ http://www.orafaq.com/scripts/ http://www.idevelopment.info/data/Oracle/DBA_tips/Sun_Solaris/SUNSOLARIS_5.shtml http://www.dbasupport.com/oracle/scripts/ The OracleResourceStop Script Archive Mark Lang’s Script collection OraMag’s Code Depot Material Dreams’ DBA Scripts Biju’s Oracle tips and scripts page Steve Rea’s Oracle Tips, Tricks, and Scripts Tracing the Sessions(s) of a Given User In a case where you cannot (because you don’t have enough time, for example) query [...]

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/orabackup/rman/%F’; CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO [...]

http://www.oracle.com/technology/oramag/code/tips2005/010305.html select substr(a.sid,1,10) sid, substr(nvl(b.program,machine),1,30) program, count(*) from v$open_cursor a, v$session b where a.saddr=b.saddr group by substr(a.sid,1,10), substr(nvl(b.program,machine),1,30) order by 3 desc ; Track and Monitor Resources This tip comes from Luis Adalberto, DBA at Universidad Autonoma de Coahuila, in Saltillo, Coahuila, Mexico. Running this query will produce a list of database statements and objects [...]

Oracle question bank Oracle Concepts and Architecture Database Structures. 1. What are the components of Physical database structure of Oracle Database?. ORACLE database is comprised of three types of files. One or more Data files, two are more Redo Log files, and one or more Control files. 2. What are the components of Logical database [...]

1. Create necessary directories mkdir D:\oracle\product\10.2.0\admin\arcl\adump mkdir D:\oracle\product\10.2.0\admin\arcl\bdump mkdir D:\oracle\product\10.2.0\admin\arcl\cdump mkdir D:\oracle\product\10.2.0\admin\arcl\dpdump mkdir D:\oracle\product\10.2.0\admin\arcl\pfile mkdir D:\oracle\product\10.2.0\admin\arcl\udump mkdir D:\oracle\product\10.2.0\db_1\cfgtoollogs\dbca\arcl mkdir D:\oracle\product\10.2.0\db_1\database mkdir D:\oracle\product\10.2.0\flash_recovery_area mkdir D:\oracle\product\10.2.0\oradata\arcl 2. Make necessary files 2.1.    first make pfile and save it at the location D:\oracle\product\10.2.0\db_1\database 2.2.    then make password file using following cmd orapwd file=D:\oracle\product\10.2.0\db_1\database\PWDarcl.ora                 password=<password> force=y [...]

This document describes some of the ways to leverage the high availability features of Oracle Real Application Cluster (RAC) databases by moving the load balancing functionality from the Oracle server/Oracle driver to your application. In this article, I discuss the ways to achieve load balancing of connections across RAC nodes and yet maintain the sticky [...]

http://broersa.wordpress.com/ exec dbms_network_acl_admin.create_acl(acl => ‘resolve.xml’,description => ‘resolve acl’, principal => ‘ABACUS’, is_grant => true, privilege => ‘resolve’); exec dbms_network_acl_admin.assign_acl(acl => ‘resolve.xml’, host => ‘*’); select utl_inaddr.get_host_name(’116.90.226.210′) from dual; select utl_inaddr.get_host_name(‘mail.abacusnepal.com’) from dual; select utl_inaddr.get_host_name(’127.0.0.1′) from dual; http://www.liberidu.com/blog/?p=246 DECLARE acl_path VARCHAR2(4000); BEGIN SELECT acl INTO acl_path FROM dba_network_acls WHERE host = ‘host_name’ AND lower_port IS NULL [...]

yum install mysql mysql-devel mysql-server chkconfig –levels 235 mysqld on /etc/init.d/mysqld start netstat -tap | grep mysql It should show a line like this: [root@server1 named]# netstat -tap | grep mysql tcp 0 0 *:mysql *:* LISTEN 2470/mysqld [root@server1 named]# mysqladmin -u root password yourrootsqlpassword mysqladmin -h server1.example.com -u root password yourrootsqlpassword GRANT ALL ON [...]