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 […]
Create Database Manuly on Oracle 10g
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 […]
Using Global/Distributed Transactions in Java/JDBC with Oracle Real Application Clusters
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 […]
Oracle ora 24242 error
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 […]
MySQL Installing and Giving Permission
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 […]