New to Oracle Business Intelligence!!!! Start from here

1. http://www.oracle.com/technology/products/bi/enterprise-edition.html
2. http://www.oracle.com/appserver/business-intelligence/docs/OracleBIEE-wp.pdf
3. http://bic2g.oracle.com/1/Course_Technical_Prerequisites_Installation.pdf
4. http://bic2g.oracle.com/1/BIC2G_EE_Jump.htm

>>>> http://bic2g.oracle.com/1/BIC2G_EE_v10.1.3.2_Getting_Started.htm

Oracle by example

http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/index.html

OBI on Windows....
http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/install/installoraclebee.htm

Oracle Business Intelligence Documentation
http://download.oracle.com/docs/cd/E10415_01/welcome.html


The above URL's from ORACLE will give some in-sight of OBI.

SYBASE ASE 15.0.2 – Case Sensitive to Non-Case Sensitive

SYBASE ASE 15.0.2 – Case Sensitive to Non-Case Sensitive.

Sybase ASE database by default is case sensitive. But Oracle is not. We are testing one application with SYBASE ASE 15.0.2 developer edition where we will be having a data from Oracle RDBMS which needs to be replicated to ASE. That raw data is non-case and it's in various forms. To avoid more re-work as this is an immediate testing so we planned to test this.

I tried few sites which I could not able to get the resource and after browsing Google my search ended with infocenter.sysbase.com.

1; select @@version

2; go

----------------------------------------------------------------

Adaptive Server Enterprise/15.0.2/EBF 14336/P/x86_64/Enterprise

Linux/ase1502/2486/64-bit/FBO/Thu May 24 08:06:35 2007

I Here is the procedure I used to find the default sort order of the database which is 25, Binary ordering for UTF-16.

1; sp_helpsort

2; go

………………..

Sort Order Description

------------------------------------------------------------------

Character Set = 190, utf8

Unicode 3.1 UTF-8 Character Set

Class 2 Character Set

Sort Order = 25, binary

Binary ordering for UTF-16

(return status = 0)

The are two ways to approach this one is via server console on a Unix system with sqlloc or with sp_configure. I preferred to go with sp_configure as I will always have control of what I am doing. This is a test purpose and I did not bother to dump the database. So FULL DATABASE is must, whenever we do configuration changes, always makes us on safer sideJ.

2; select s1.value2

3; from syscurconfigs s1, sysconfigures s2

4; where s1.config = s2.config

5; and s2.name = 'configuration file'

6; go

value2

----------------------------------------------------

/u02/sybase/RAP/RAPCache/ASE-15_0/RAPCache.cfg

Take a copy of the Configuration file before you proceed further. It helps us to know what we have before system changes.

4; sp_configure "default sortorder id", 52

5; go

You have just reconfigured ASE's default sort order. System table indexes will be rebuilt when you reboot ASE.

Parameter Name Default Memory Used Config Value

Run Value Unit Type

------------------------------ ----------- ----------- ------------

------------ -------------------- ----------

default sortorder id 50 0 52

25 id static

(1 row affected)

Configuration option changed. Since the option is static, Adaptive Server must be rebooted in order for the change to take effect.

Changing the value of 'default sortorder id' does not increase the amount of memory Adaptive Server uses.

(return status = 0)

Shutdown the ASE Server…

1; shutdown

2; go

Server SHUTDOWN by request.

ASE is terminating this process.

Start the ASE Server

Once you bring the ASE server it will check for consistency and it will rebuild all the indexes.

00:00000:00001:2009/02/16 15:41:29.67 server Default Sort Order successfully changed.

00:00000:00001:2009/02/16 15:41:29.67 server *** Be sure to dump all databases after

00:00000:00001:2009/02/16 15:41:29.67 server ASE has booted with the new

00:00000:00001:2009/02/16 15:41:29.67 server *** sort order, since your old dumps will

00:00000:00001:2009/02/16 15:41:29.67 server *** be unusable with the new sort order.

00:00000:00001:2009/02/16 15:41:29.67 server ASE shutdown after verifying System Indexes.

00:00000:00001:2009/02/16 15:41:29.67 kernel ueshutdown: exiting

00:00000:00001:2009/02/16 15:41:29.67 kernel SySAM: Checked in license for 1 ASE_CORE (2009.09220/permanent/1623 DCB3 B018 5E2B).

[1]+ Done startserver -f RUN_RAPCache

Once you see the above message start the server and check the service.

3; sp_helpsort

4; go

Sort Order Description

------------------------------------------------------------------

Character Set = 190, utf8

Unicode 3.1 UTF-8 Character Set

Class 2 Character Set

Sort Order = 52, nocase

General-purpose case-insensitive dictionary ordering

(return status = 0)

Reference: http://manuals.sybase.com/onlinebooks/group-as/asg1250e/svrtsg/@ebt-link;pt=5693?target=%25N%14_5953_START_RESTART_N%25

RAVI PRAKASH ©

Oracle Applications 11i FAQ's

1. Why does 11i have an 8.0.6 and an 8.1.6 ORACLE_HOME?
Release 11i requires an Oracle8i (v8.1.6) database which is installed in the 8.1.6 ORACLE_HOME. The 8.0.6 ORACLE_HOME is required to host several other components of the Release 11i technology stack (such as Developer 6i and WebDB 2.2). The applications run in server partitioned mode, where the code is compiled and linked with the 8.0.6 ORACLE_HOME.

Oracle Applications DBA (Apps DBA)

Hmm as long from now being a core DBA from past 3 years I want move to Apps. Apps DBA is what Applications DBA is said to be. I want to assimilate my self for Application expertise and as well as with Oracle 10 G Rel 2.

In my searches I found this reliable site for Applications http://www.appsdba.com/ hope this will be very useful for Apps DBA.

I always found of increasing my errands and promoting myself with the market. But what Apps DBA does? Is this the question I always asks myself and hope this is the most common question for a core DBA who wants to upgrade for Apps? Yes! Hope so! :- )
I want to solve this in my blog – hope it helps to know the responsibilities of being an Apps DBA.

What duties, if any, are different for an Apps DBA versus those of an Oracle 8/9i DBA?

Oracle APPS DBA's duties are almost same as of Oracle DBA but your work will be more specific to the Architecture (or I should say Environment) and OFA of Oracle Application. Apart from that there are few more things you should know like applying patches or adadmin utility and some basic functionality of SYSADMIN responsibility of APPS.

An APPs DBA knows all that a regular DBA knows plus the following:

Application fundamentals such as concepts and architecture

Application Installation and configuration

Patching and Upgrades

Patch Management and Version Control

Customization Updates

Cloning requirements.

This can be frequent in an Apps environment- Concurrent Managers - Forms/Report Servers

Web Servers

all the "ad" utilities

all the database restrictions for the applications.

That is so that the installation is still supportable and conforms to all vendor (Oracle) requirements.

All special application related regular and maintenance functions. Such as month end and period end functions.

Understand any backup and recovery constraints. Such as for table imports (NOT) and partial recoveries.

Special requirements and restrictions for tuning, example optimizer and index requirements.

Printer Configuration

User Access AdministrationThis could be a matter for further discussion as it could be argued that all DBA's should be aware of the above or equivalent for any database application (Oracle or otherwise).

These are two core answers I found for being a Apps DBA.