Search This Blog

Friday, July 10, 2015

Change Oracle APEX Admin Pasword

To change Oracle APEX Admin Password, please follow the following steps.

1. First login as SYS user

 SQL> conn sys as sysdba

2. @C:\apex_4.2.2\apex\apxxepwd.sql

Now, you will be promoted to enter your password three times. Set your password three times which is Oracle APEX Admin New Password.

You can use below screen shot for your reference:



Export empty table in Oracle 11G database


If you create any schema in your database, you should  set "deferred_segment_creation" parameter to "False". Login by using Sys user and use following command from SQL.

        "alter database set deferred_segment_creation=false ; scope=both;"

Now, you can export all tables either it's empty or not.


If you find that some table already created before executing above command, then you should use below way:

1. use "select 'alter table '||table_name||' allocate extent;' from user_tables
where segment_created = 'NO
' " query to get the script of empty tables which needs to create segment.


Copy the output and execute it. Now, segment will be created and you can easily export your database or schema.

Oracle database Job Creation

Here is a simple job creating in Oracle database.

SQL> create table temp_data (id varchar2(10));

Table created.

SQL> create or replace procedure dpr_temp_data as
    begin
        insert into temp_data values ('Akter');
      commit;
  end;
 

Procedure created.

SQL>
So the first thing is to submit it with both the start time and interval correctly specified. If you cannot remember how many minutes there are in a day (1440) it is a good idea to use brackets. Let's compare submitting the job with your date specifications.

SQL> var job_no number
SQL> BEGIN
        DBMS_JOB.SUBMIT
         (
         job =>:job_no,
         WHAT=>'dpr_temp_data;',--Procedure
         next_date=>sysdate+1/24*60,
       interval=>'sysdate+1/24*60'
       );
       commit;
    END;
   

 PL/SQL procedure successfully completed.

 SQL> print job_no

     JOB_NO
 ----------
         71
Now, job will be executed every single minute

Thursday, July 9, 2015

REP-52262: Diagnostic output is disabled.

For error " REP-52262: Diagnostic output is disabled  ", please change the configuration file from given location
-----------------------------------------------
 *** Edit the file rwservlet.properties located on
<DomainHome>\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.1.2.1.0\configuration

*** Add the following parameter below the <inprocess> parameter:
<webcommandaccess>L2</webcommandaccess>


< WE CAN FIND THE REPORT SERVER NAME IN THIS rwservlet.properties file >

Step by step Oracle 11G developer configuration

**---formsweb.cfg configuration (with webutil) ( Path In the path, C:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\AdminServer\applications\formsapp_11.1.2\config)

we have to add following key:

[recon]

# System parameter: default base HTML file
baseHTML=webutilbase.htm
# System parameter: base HTML file for use with Sun's Java Plug-In
baseHTMLjpi=webutiljpi.htm
# System parameter: file setting environment variables for the Forms runtime processes
envFile=default.env

WebUtilArchive=frmwebutil.jar,jacob.jar
WebUtilLogging=off
WebUtilLoggingDetail=normal
WebUtilErrorMode=Alert
WebUtilDispatchMonitorInterval=5
WebUtilTrustInternal=true
WebUtilMaxTransferSize=16384


** Change the several parameters of "formsweb.cfg" file as below:

# Forms runtime argument: which form module to run
form=D:/nano/nano_login.fmx
# Forms runtime argument: database connection details
userid=nano/nanopass@live
# Other Forms runtime arguments: grouped together as one parameter.
# These settings support running and debugging a form from the Builder:
otherparams=obr=%obr% record=%record% tracegroup=%tracegroup% log=%log% term=%term% ssoProxyConnect=%ssoProxyConnect% useSDI=YES

pageTitle=Nano

# HTML attributes for the BODY tag
HTMLbodyAttrs=
# HTML to add before the form
HTMLbeforeForm=
# HTML to add after the form
HTMLafterForm=

# Forms applet parameter
codebase=/forms/java
# Forms applet parameter
imageBase=codebase
# Forms applet parameter
width=100%
# Forms applet parameter
height=100%
# Forms applet parameter
separateFrame=false
# Forms applet parameter
splashScreen=None
# Forms applet parameter
allowAlertClipboard=true
# Forms applet parameter
background=none
# Forms applet parameter --Oracle
lookAndFeel=Oracle
# Forms applet parameter --teal
colorScheme=teal
# Forms applet parameter
logo=none
# Forms applet parameter
restrictedURLparams=pageTitle,HTMLbodyAttrs,HTMLbeforeForm,HTMLafterForm,log
# Forms applet parameter
serverApp=default
# Forms applet archive setting for other clients (Sun Java Plugin, Appletviewer, etc)
archive=frmall.jar;iStelarIcon.jar

jpi_download_page=/forms/java/javadl.sun.com#Version=1,7,0,06

jpi_classid=clsid:CAFEEFAC-0017-0000-FFFF-ABCDEFFEDCBA
# Parameter related to the version of the Java Plugin

jpi_codebase=/forms/java/javadl.sun.com#Version=1,7,0,06
# Parameter related to the version of the Java Plugin
jpi_mimetype=application/x-java-applet;jpi-version=1.7.0_06

# Parameter which determines whether new Forms sessions are allowed.
# This is also read by the Forms EM Overview page to show the
# current Forms status.
allowNewConnections=true



*** WebUtil Config
Please change the parameter in webutil.cfg from given path:

( File:C:\Oracle\Middleware\asinst_1\config\FormsComponent\forms\server\webutil.CFG)

#NOTE: By default the file transfer is disabled as a security measure
transfer.database.enabled=TRUE
transfer.appsrv.enabled=TRUE
transfer.appsrv.workAreaRoot=c:\temp
transfer.appsrv.accessControl=TRUE
#List transfer.appsrv.read.<n> directories
transfer.appsrv.read.1=c:\temp
#List transfer.appsrv.write.<n> directories
transfer.appsrv.write.1=c:\temp


** Place all jar files into C:\Oracle\Middleware\Oracle_FRHome1\forms\java\
  ( download Jar)

** Create database package create_webutil_db located in C:\Oracle\Middleware\Oracle_FRHome1\forms


** Place jacob.dll into G:\Oracle11g\Oracle_FRHome1\forms\webutil



** Signing all jar files

First edit the file (sign_webutil.bat) first from following location [C:\Oracle\Middleware\asinst_1\bin\sign_webutil.bat]

SET KEYSTORE_PASSWORD=welcome1
SET JAR_KEY_PASSWORD=welcome1

For signing the jar file, use Commands:
C:\Oracle\Middleware\asinst_1\bin>sign_webutil.bat
C:\Oracle\Middleware\asinst_1\bin>sign_webutil.bat C:\Oracle\Middleware\Oracle_FRHome1\forms\java\jacob.jar
.................
.................


** Report config (cgicmd.dat)
--------------------------
C:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.1.2\configuration


** Tns Location (tnsnames.ora)
---------------------------
C:\Oracle\Middleware\asinst_1\config


** apex config (dads.conf)
-----------------------------
C:\Oracle\Middleware\asinst_1\config\OHS\ohs1\mod_plsql

rep_adminserver_it-manager_asinst_1

Salary Certificate Format

May 01, 2000


TO WHOMSOEVER IT MAY CONCERN

CERTIFICATE


This is to certify that Mr. EFG, Employee Code -ABC, is working with us since 01/01/1990 and his salary details are as under :-

Particulars                             Amount (Tk.)

Basic                                                 10000.00
Medical Allowance                                  2000.00
Leave Travel Allowance                          1000.00
Education Allowance                               1000.00
Conveyance Allowance                            3000.00
HRA                                                          3000.00 or Quarter
                                                            -----------------          

Total                                   25000.00 

                                                           ------------------
(Tk. Twenty five thousand  only)

Provident Fund – 10% of Basic = Tk. 1625/-

This certificate is being issued to him on request for the purpose of getting loan.

for ABCD LLC



ABCD

MANAGER (HRD) 

HR Metrics/calculations

      
              Ø  Absence Rate
[(Number of days absent in month) ÷ (Average number of employees during month) × (number of workdays)] × 100

             Ø  Cost per Hire
(Advertising + Agency Fees + Employee Referrals + Travel cost of applicants and staff + Relocation costs + Recruiter pay and benefits) ÷ Number of Hires

              Ø  Health Care Costs per Employee
Total cost of health care ÷ Total Employees

              Ø  HR Expense Factor
HR expense ÷ Total operating expense

              Ø  Human Capital ROI
Revenue − (Operating Expense − [Compensation cost + Benefit cost]) ÷ (Compensation cost + Benefit cost)

              Ø  Human Capital Value Added
Revenue − (Operating Expense − ([Compensation cost + Benefit Cost]) ÷ Total Number of FTE

              Ø  Revenue Factor
Revenue ÷ Total Number of FTE

              Ø  Time to fill
Total days elapsed to fill requisitions ÷ Number hired

              Ø  Training Investment Factor
Total training cost ÷ Headcount

              Ø  Turnover Costs
Cost to terminate + Cost per hire + Vacancy Cost + Learning curve loss

              Ø  Turnover Rate
[Number of separations during month ÷ Average number of employees during month] × 100

              Ø  Workers’ Compensation Cost per Employee
Total WC cost for Year ÷ Average number of employees


ORA-12729: invalid character class in regular expression

For using regular expression, we can use following format:

Here is the complete list of valid character classes:
[:alnum:] All alphanumeric characters
[:alpha:] All alphabetic characters
[:blank:] All blank space characters.
[:cntrl:] All control characters (nonprinting)
[:digit:] All numeric digits
[:graph:] All [:punct:], [:upper:], [:lower:], and [:digit:] characters.
[:lower:] All lowercase alphabetic characters
[:print:] All printable characters
[:punct:] All punctuation characters
[:space:] All space characters (nonprinting)
[:upper:] All uppercase alphabetic characters
[:xdigit:] All valid hexadecimal characters

Wednesday, July 8, 2015

Step by step Oracle installation on Linux ( Centos )

1.First login as root user

# cd /etc/yum.repos.d
# wget https://public-yum.oracle.com/public-yum-ol6.repo --no-check-certificate

2. Just copy and paste following lines one after another

# yum install oracle-rdbms-server-11gR2-preinstall
#yum install binutils glibc compat-libstdc++-33 glibc-common \
glibc-devel glibc-headers elfutils-libelf elfutils-libelf-devel \
elfutils gcc gcc-c++ ksh libaio libaio-devel libgcc libstdc++-devel \
make numactl-devel sysstat mksh

3.
# wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle --no-check-certificate
4.
# vi /etc/sysconfig/network

HOSTNAME=oracle.tecmint.com

5.
# vi /etc/hosts
  192.168.246.128 oracle.tecmint.com oracle
6.
# /etc/init.d/network restart

7.
**** Edit /etc/sysctl.conf file.
# nano /etc/sysctl.conf
   Add or amend the following lines

#### Oracle 11g Kernel Parameters ####
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586

Comment out these lines below that Gives an Error

#net.bridge.bridge-nf-call-ip6tables = 0
#net.bridge.bridge-nf-call-iptables = 0
#net.bridge.bridge-nf-call-arptables = 0

** Edit /etc/security/limits.conf file.
       #nano /etc/security/limits.conf

      Add the following lines

#### oracle User Settings 4 Oracle 11g ####
oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  1024
oracle              hard    nofile  65536
oracle              soft    stack   10240

** Disable SELINUX
nano /etc/selinux/config

**Disable Secure Linux by editing the /etc/selinux/config file, making sure the SELINUX flag is set as follows.

SELINUX=disabled

** Load the New Kernel Parameters.
/sbin/sysctl -p


# vi /etc/security/limits.d/90-nproc.conf

       # Default limit for number of user's processes to prevent
# accidental fork bombs.
# See rhbz #432903 for reasoning.

*          soft    nproc     1024
# To this
* - nproc 16384

8.

 # vi /etc/selinux/config
        ELINUX=disabled

9. Add Groups and User

#groupadd -g 502 oinstall
#groupadd -g 503 dba
#groupadd -g 504 oper
#groupadd -g 505 asmadmin
#useradd -u 502 -g oinstall -G dba,asmadmin,oper oracle
#passwd oracle

10. Make Target Directories
#mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
#chown -R oracle:oinstall /u01
#chmod -R 775 /u01

11.
# su oracle
# nano /home/oracle/.bashrc

    # Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=<b><HOSTNAME></b>; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=<b><DBSID></b>; export ORACLE_SID

PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

12.

    Last and Optional to Add Full Env-Integration edit also oracle’s .bash_profile
nano ~/.bash_profile

if [ -f ~/.bashrc ]; then
        source ~/.bashrc
fi


13.
    cd /tmp/database
     ./runInstaller


----------------PECL INSTALL------------------------
1. yum -y install php-devel

2. pecl install oci8


3. On CentOS

Open php.ini file and add the following extension:

extension=oci8.so

4. Checking the libraries installed
echo /u01/app/oracle/product/11.2.0/dbhome_1/lib/ >> /etc/ld.so.conf
ldconfig

-----------------------
alter system set SEC_CASE_SENSITIVE_LOGON=FALSE scope=both;
ALTER SYSTEM SET DEFERRED_SEGMENT_CREATION=FALSE scope=both;




CREATE TABLESPACE PLATFORM DATAFILE
  '/u01/app/oracle/oradata/orcl/PLATFORM01.DBF' SIZE 2048M AUTOEXTEND
ON NEXT 16M MAXSIZE 6144M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;



SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
    )
    (SID_DESC=
      (SID_NAME=dg4odbc)
      (ORACLE_HOME=D:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM=dg4odbc)
      (ENVS=LD_LIBRARY_PATH = D:\app\Administrator\product\11.2.0\dbhome_1)
    )
    (SID_DESC =
      (GLOBAL_DBNAME=ORCL)
      (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = ORCL)
    )
  )

Automatic Oracle stop start in Linux ( Centos ) script (dbora) example

#!/bin/sh
# chkconfig: 345 99 10

# description: Oracle auto start-stop script.
#

# Set ORA_HOME to be equivalent to the $ORACLE_HOME


# from which you wish to execute dbstart and dbshut;

#

# Set ORA_OWNER to the user id of the owner of the

# Oracle database in ORA_HOME.

ORA_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]

then

echo "Oracle startup: cannot start"

exit

fi

case "$1" in

'start')

# Start the Oracle databases:

# The following command assumes that the oracle login

# will not prompt the user for any values

su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole"

su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"

su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
;;

'stop')

# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c "$ORA_HOME/bin/emctl stop dbconsole"
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
;;

esac
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
/etc/init.d/httpd stop
/etc/init.d/httpd start
route add default gw 202.51.176.169 em1
exit $?

Brief Business Plan Example – At a Glance

               


 Brief Business Plan – At a Glance



                                            






23-June-2015












Executive Summary
ABCD is a start-up organization under XYZ Group whose vision is to create the finest business/education/entertainment software for small medium enterprise, banks, apparels industry, e-commerce based organizations. The software product will be designed and developed by in-house programmers, consortium companies, to meet the needs of this special customer segment. ABCD is formed as ABCD by founder Ms./Mr………..., based in Dhaka.
The Market
ABCD has identified four distinct market segments that will be interested in the software product. These segments are the most likely consumers of the software. The segments are as follows:
  • Small Medium Business- There are thousands of small medium business industry in Bangladesh as well many parts in the world; very few companies under automation but they will be automated if they are provided reasonable price based software.
  • Complete Garments solution – To automate full garments factory from Yarn sourcing to Finish garments production.
  • Banks- All banks must be under central core banking system but except this, many small level software’s are mostly needed like MICR, EFT, RGDS, documents management system etc.
  • Education sector- Thousands of schools and colleges, even universities are run without automation.
  • E-Commerce Portal- A complete portal can be strategic product for company.
  • Necessary mobile apps- Many mobile apps can be developed by getting ideas from several idea generating point.
  • Outsourcing - we can have a strong outsourcing team to get job and done the job.
The Product
SME-Solution, fully web based business solution where Sales and Marketing, Production, inventory, Commercial, Accounts and Finance, Talent Management, Payroll management etc. included. This is almost ready product and need small customization only.
MICR Cheque processing system, Electronic Fund transfer system (BEFTN) can be almost ready product and can be developed within short time and can be marketed. Other small modules of Banking solution can be developed. For Core Banking Solution, we can make memorandum of understanding agreement or partnership agreement with other software firm who have this full large scale solution.
School, College or university management system can be developed within few months as I have this software by own.
Garments Solution can be developed within 6/8 months by using my core knowledge though I am currently working and implementing a complete Garments solution.
We will have a smart Web Portal which is fully online store. Anyone can purchase from online and we will have our own distribution team.

Competitive Edge
There are several companies on the market selling these types of software products. ABCD will strength their marketing team who will visit many clients either in private sector or government sector by using the brand name XYZ Group. By visiting several educational institute, garments industry, small medium business industry, we can get our job order by beating our competitors.
Management
ABCDwill run under direct supervision of an advisory board who can sit every 15 days about last progress of company and put their knowledge to develop market and product. Several COO’s from other company of XYZ group can be the members of this advisory board.

Mission
To develop state of art modern software for all types of company. Our software will provide efficient solution for managing their business organizations real time basis. We exist to make products that the market demands and have a positive impact on society. 

Keys to Success
  • Develop any type of software that is constructive and efficient.
  • Implement a strong marketing campaign to develop awareness of the software and its benefits within all of the training centers, schools, colleges, universities, banks, small medium enterprise, apparel industry etc.
  • Design strict financial controls for the organization.

Objectives
  • Increase sales in every month after 46/ months of starting of business.
  •  Achieve significance market penetration by year three/ four.

Company Summary
ABCD is a start-up organization under XYZ Group.  The company is owned by its founder…………………………………..

Company Ownership
The company was founded and is owned by………………. He/Sue is a respected business figure in Bangladesh. He/ Sue will leverage her extensive knowledge and industry contacts to make ABCD a success software industry in Bangladesh.
Start-up Summary
ABCD is a start-up organization. The following assets and professional services will be needed for the formation and start of operations.
  • Legal services for company formation.
  • Accounting services to set up the accounting shell of the company Own Accounting software.
  • Junior and mid-level computer programmers (8) to rapidly develop the software. An individual programmer could complete the coding of this product however, ABCD is interested in launching the product fast therefore they will employ multiple programmers to speed the process up.
  • 2/3 senior level programmers and system analyst will be needed to analyze, direct and guide junior or mid-level programmers.
  • 3/4 persons for accounts, HR and marketing works.
  • Eight/Ten computer workstations, 3/4 laptops including one server. Two network based laser printers.
  • Small conference room for discussion and meeting.
  • A broadband Internet connection.
  • Office cubicle furniture for 15 / 20 employees.
  • 15/20 extension telephone system.
  • Copier and fax machine.
  • Lunch room furniture and appliances including a refrigerator and microwave.
  • Official materials including boxes, pencils, pens scales, etc.
  • Promotional materials.
Expenses
  • Salary
  • Bonus
  • Daily expenses like tea, snacks, lunches, conveyance allowance, travel allowance etc.
  • Internet line, telephone, office rent etc.
  • Marketing
Income
  • Advance payment received from selling software.
  • Selling products from web portal
  • Web hosting, domain name registration, web development etc.
  • Out sourcing job.

Conclusion:  Software market is very sensitive market and several types’ attractive marketing will be needed. Patience is the main part of success in this industry. No short cut way for success. Entrepreneur should have much patience to gain profit from this industry. Before start the business, should think about long term investment – income can be automatic outcome from business.



Step by step oracle heterogeneous (HS) configuration

To create db-link with other database from oracle, we will need oracle heterogeneous connection.We will clarify the Step by step oracle heterogeneous (HS)  configuration for oracle 11 G database.

1. Create an odbc from your computer where Oracle Installed. [ Like odbc name is "sqldb"]

2. Change the HS file (inithsodbc.ora (initdg4odbc.ora for 11G database)) from HS location  ( like my location is D:\oracle\product\10.2.0\db_1\hs\admin) and change the parameters as below


HS_FDS_CONNECT_INFO = sqldb
HS_FDS_TRACE_LEVEL = OFF
HS_FDS_SUPPORT_STATISTICS=FALSE

3. Add following lines in listener with existing lines [ Change the location as your settings]

   " (
       SID_DESC=
          (SID_NAME=hsodbc)
          (ORACLE_HOME=D:\oracle\product\10.2.0\db_1)
          (PROGRAM=hsodbc)
          (ENVS=LD_LIBRARY_PATH = D:\oracle\product\10.2.0\db_1)
      )  
  "

example
 SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC=
      (SID_NAME=hsodbc)
      (ORACLE_HOME=D:\oracle\product\10.2.0\db_1)
      (PROGRAM=hsodbc)
      (ENVS=LD_LIBRARY_PATH = D:\oracle\product\10.2.0\db_1)
    )  
  )


4. Add following TNS in your TNS file :

    hsodbc=
     (DESCRIPTION=
         (ADDRESS=(PROTOCOL=TCP)(HOST=10.11.201.198)(PORT=1521)
      )
      (CONNECT_DATA= (SID=hsodbc)
        )
        (HS=OK)
       )
5. Restart all listener, database and you can use your connected other platform database.