2010/07/22
ORA-00845: MEMORY_TARGET
I have installed Oracle11g on my laptop and have installed the database as well with mostly default parameters.
After installing the database, I started DBCA configure the database and as soon as I selected the database on DBA Config menu, I received the message "ORA-00845:MEMORY_TARGET Not supported on this system".
After googling for this error, came to know that this has something to do howmuch shared memory is allocated at OS level and the values set for MEMORY_TARGET at the database level for Automatic Memory Management.
when I checked for these two, my initial setting was like this -
[root@KirtiBIVM bin]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
38471112 15607268 20878104 43% /
/dev/sda1 101086 12112 83755 13% /boot
tmpfs 517552 270252 247300 53% /dev/shm
whereas my MEMORY_TARGET and MEMORY_MAX_TARGET are set as 404m.
I changed the shared memory at OS level by using the command -
[root@KirtiBIVM bin]# mount -t tmpfs shmfs -o size=3G /dev/shm
after which, the details are -
[oracle@KirtiBIVM bin]$ df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
38471112 15608440 20876932 43% /
/dev/sda1 101086 12112 83755 13% /boot
tmpfs 3145728 620932 2524796 20% /dev/shm
shmfs 3145728 620932 2524796 20% /dev/shm
[oracle@KirtiBIVM bin]$
After this, I have amended the parameters MEMORY_TARGET and MEMORY_MAX_TARGET giving following commands -
logged in as SYS
ALTER SYTSEM SET MEMORY_MAX_TARGET=2G SCOPE=SPFILE;
ALTER SYSTEM SET MEMORY_TARGET=1G SCOPE=SPFILE;
Restarted the database as -
SHUTDOWN IMMEDIATE;
STARTUP;
And this has resolved the issue.
After installing the database, I started DBCA configure the database and as soon as I selected the database on DBA Config menu, I received the message "ORA-00845:MEMORY_TARGET Not supported on this system".
After googling for this error, came to know that this has something to do howmuch shared memory is allocated at OS level and the values set for MEMORY_TARGET at the database level for Automatic Memory Management.
when I checked for these two, my initial setting was like this -
[root@KirtiBIVM bin]# df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
38471112 15607268 20878104 43% /
/dev/sda1 101086 12112 83755 13% /boot
tmpfs 517552 270252 247300 53% /dev/shm
whereas my MEMORY_TARGET and MEMORY_MAX_TARGET are set as 404m.
I changed the shared memory at OS level by using the command -
[root@KirtiBIVM bin]# mount -t tmpfs shmfs -o size=3G /dev/shm
after which, the details are -
[oracle@KirtiBIVM bin]$ df -k
Filesystem 1K-blocks Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
38471112 15608440 20876932 43% /
/dev/sda1 101086 12112 83755 13% /boot
tmpfs 3145728 620932 2524796 20% /dev/shm
shmfs 3145728 620932 2524796 20% /dev/shm
[oracle@KirtiBIVM bin]$
After this, I have amended the parameters MEMORY_TARGET and MEMORY_MAX_TARGET giving following commands -
logged in as SYS
ALTER SYTSEM SET MEMORY_MAX_TARGET=2G SCOPE=SPFILE;
ALTER SYSTEM SET MEMORY_TARGET=1G SCOPE=SPFILE;
Restarted the database as -
SHUTDOWN IMMEDIATE;
STARTUP;
And this has resolved the issue.
2010/07/07
Oracle BI Intelligence 11g ( OBI 11g) Launch 07/07/2010
I took time to-day to attend the launch event of much awaited OBIEE11g. After seeing the demos and presentations it is worth waiting for.
The OBI 11g release is total revamp of what we see currently on 10g release. For me, the most important bits are -
Server Adminstation
====================
- The OBI Server can be managed through the Enterprise Manager, systems management & deployment are much easier.
- Deployment to Production can be achieved from the Admin Tool ( GUI), I heard of version controlling as well. But not sure.
- Allows incremental deployments to Repository
- When OBI is installed it comes with preconfigured Scheduler (no need to do additional configurations as currently in 10g).
- Upgrade utility from 10g to 11g (Yes, really!!)
- Installation is much easier using OUI.
- Supports Relational modelling as well.
and much more.
Presentation Services
=====================
wow! where to start. the Dashboards are really Interactive, it really means.
- The Pivot Tables can be easily altered - drag and drops (like discoverer) to alter the view of the Pivot tables on the fly (not through design layer as in 10g)
- drilling ups and downs in the same page, similar to Discoverer
- The bit that stands out is " Chart Sliding" which provides a slider for Dashboard prompt values, and the user can travel through each value of the prompt and the chart changes accordingly. That was really cool.
- Chart Zooming (In / Out)
- Global filters, filters can be applied dynamically and if want for all the charts / reports on a single dashboard page.
Most of the interactive features are like as in Discoverer 10g, but the comparison just ends there, OBI 11g offers much more.
- ScoreCarding is really great! and is integrated into OBI.
Look & Feel
===========
- Look and feel is really good, much revamped and very intuitive.
- Search facility in the BI Catalog (Yes! it is).
- the presentation is much better
BI Publisher
============
The current version of BIP put me off, as the templates need to be designed from MS Office products and then use it in BIP etc etc.....
The new version allows to design the templates from BIP itself. I thought that is quite cool.
All in all, with the 11g release most of the bits can be achieved from single unitifed interface, rather than jumping back and forth between various interfaces.
Personally I can not wait to get my hands on the new version.
The OBI 11g release is total revamp of what we see currently on 10g release. For me, the most important bits are -
Server Adminstation
====================
- The OBI Server can be managed through the Enterprise Manager, systems management & deployment are much easier.
- Deployment to Production can be achieved from the Admin Tool ( GUI), I heard of version controlling as well. But not sure.
- Allows incremental deployments to Repository
- When OBI is installed it comes with preconfigured Scheduler (no need to do additional configurations as currently in 10g).
- Upgrade utility from 10g to 11g (Yes, really!!)
- Installation is much easier using OUI.
- Supports Relational modelling as well.
and much more.
Presentation Services
=====================
wow! where to start. the Dashboards are really Interactive, it really means.
- The Pivot Tables can be easily altered - drag and drops (like discoverer) to alter the view of the Pivot tables on the fly (not through design layer as in 10g)
- drilling ups and downs in the same page, similar to Discoverer
- The bit that stands out is " Chart Sliding" which provides a slider for Dashboard prompt values, and the user can travel through each value of the prompt and the chart changes accordingly. That was really cool.
- Chart Zooming (In / Out)
- Global filters, filters can be applied dynamically and if want for all the charts / reports on a single dashboard page.
Most of the interactive features are like as in Discoverer 10g, but the comparison just ends there, OBI 11g offers much more.
- ScoreCarding is really great! and is integrated into OBI.
Look & Feel
===========
- Look and feel is really good, much revamped and very intuitive.
- Search facility in the BI Catalog (Yes! it is).
- the presentation is much better
BI Publisher
============
The current version of BIP put me off, as the templates need to be designed from MS Office products and then use it in BIP etc etc.....
The new version allows to design the templates from BIP itself. I thought that is quite cool.
All in all, with the 11g release most of the bits can be achieved from single unitifed interface, rather than jumping back and forth between various interfaces.
Personally I can not wait to get my hands on the new version.
2010/06/24
OWB11gR2 - SQL Server Connection
After installing the Oracle11gR2 , started exploring the OWB11gR2. First thing I attempted is to establish a connection SQL Server as it was one of the requirements with my current client.
The steps that I have followed for this is -
1. Downloaded the SQL Server JDBC Driver from
here.
2. Install the ( unzip) the SQL Server JDBC Driver into/owb/lib/ext folder.
3. This will create sqljdbc_2.0 under the above directory.
4. I have manually copied the sqljdbc.jar from/owb/lib/ext/sqljdbc_2.0/enu folder onto /owb/lib/ext. do not ask why I did that? OWB11gR2 started recognising the driver only after I placed the jar file straight under "ext".
5. Shutdown the OWB services by running "ccashut".
6. Start the OWB services by running "ccastart".
7. Started OWB11gR2 client.
8. Created a new SQL Server Module as shown below -
Details
=======
Advanced
=========
Tested the connection successfully! There you go!!!! Bob's your uncle!!!!
The steps that I have followed for this is -
1. Downloaded the SQL Server JDBC Driver from
here.
2. Install the ( unzip) the SQL Server JDBC Driver into
3. This will create sqljdbc_2.0 under the above directory.
4. I have manually copied the sqljdbc.jar from
5. Shutdown the OWB services by running "ccashut".
6. Start the OWB services by running "ccastart".
7. Started OWB11gR2 client.
8. Created a new SQL Server Module as shown below -
Details
=======
Advanced
=========
Tested the connection successfully! There you go!!!! Bob's your uncle!!!!
2010/05/31
Oracle DB11gR2 Installation on Enterprise Linux 5 - missing RPMs
While I was trying to install Oracle 11gR2 on my laptop I stumbled across missing RPMs.
My environment
================
Dell Laptop with Windows Vista
Installation
==================
Downloaded and installed Enterprise Linux 5 from Oracle Edelivery site.
The initial attempt to install the Oracle DB11gR2 resulted in the warnings that some of the required RPMs are not installted.
I tried various google results to install missing RPMs. The best solution that I found required the following ( thanks to original post).
On Linux do the following -
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-el5.repo
The above will download the public-yum-el5.repo package into /etc/yum.repos.d
After this edit the file to set the enabled flag to 1 for the version of EL you are using.
Now using the above tool you can download and install any missing rpms.
# yum install unixODBC
# yum install unixODBC-devel
# yum install sysstat
# yum install libaio-0.3.106
# yum install libaio-devel-0.3.106
Using the above I had installed all the missing RPMs.
===============================================================================
Update 20/06/2010
=================
Post Installation:
==================
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2
export ORACLE_SID=orcl ( make sure this matches the SID otherwise you might get LRM-00109 error when attempt to startup the database)
export PATH=$ORACLE_HOME/bin:$PATH
If you do not perform the above tasks, the SQLPLUS would not start and any attempt would throw up the error -
"sqlplus can not execute binary file".
My environment
================
Dell Laptop with Windows Vista
Installation
==================
Downloaded and installed Enterprise Linux 5 from Oracle Edelivery site.
The initial attempt to install the Oracle DB11gR2 resulted in the warnings that some of the required RPMs are not installted.
I tried various google results to install missing RPMs. The best solution that I found required the following ( thanks to original post).
On Linux do the following -
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-el5.repo
The above will download the public-yum-el5.repo package into /etc/yum.repos.d
After this edit the file to set the enabled flag to 1 for the version of EL you are using.
Now using the above tool you can download and install any missing rpms.
# yum install unixODBC
# yum install unixODBC-devel
# yum install sysstat
# yum install libaio-0.3.106
# yum install libaio-devel-0.3.106
Using the above I had installed all the missing RPMs.
===============================================================================
Update 20/06/2010
=================
Post Installation:
==================
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2
export ORACLE_SID=orcl ( make sure this matches the SID otherwise you might get LRM-00109 error when attempt to startup the database)
export PATH=$ORACLE_HOME/bin:$PATH
If you do not perform the above tasks, the SQLPLUS would not start and any attempt would throw up the error -
"sqlplus can not execute binary file".
Subscribe to:
Posts (Atom)
