11gR1 Memory Configuration?
Oct 10, 2012
Specs are as follows:
Linux kernel 2.6.18-274.12.1.el5
Total physical memory - 96G
Oracle version:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production (Standard Edition)
I am having trouble making my spfile parameters take effect and would like to set them manually. Disk reads are very slow, so I thought I would look at the db_cache_size in the spfile:
<INSTANCE>.__db_cache_size=805306368
But, when I look at the parameter via 'show parameter cache':
db_cache_size big integer 0
Digging deeper, I noticed none of my <INSTANCE>.__ parameters match the values returned from 'show parameter'. Most of my concern is sga_target & pga_aggregate_target both being zero.
My memory targets:
memory_max_target big integer 49G
memory_target big integer 49G
I would like to increase the db_cache_size in an attempt to reduce the table scan time.
View 10 Replies
ADVERTISEMENT
May 2, 2011
I'm trying to install oracle grid control 11.1.0.1 on POWER AIX 6.1, is the software download is available?
View 2 Replies
View Related
Feb 20, 2013
I am trying to install oracle 11gr1 to my ubuntu 12.10 and when i run ./runInstaller.sh
It said that OS Kernel Parameter: ip_local_port_range failed and the installer create a script to fix it but every time i run the script on terminal, it gives me
'The upper limit of ip_local_port range in response file is not greater than value in /etc/sysctl.conf, hence not changing it.
net.ipv4.ip_local_port_range = 9000 65535
View 11 Replies
View Related
Jul 27, 2012
I 'm trying restore database 11GR1 on other host with 11GR2.Using this steps:
>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Jul 27 09:00:32 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys/password@PRD
Recovery Manager incompatible with TARGET database: RMAN 8.0.4.0 to 11.1.0.7 required
[code]...
QUestion:
Is posible do this?
View 6 Replies
View Related
May 19, 2011
I'm trying to install Enterprise Manager Grid Control 11gR1 - Windows2003 32. On the "Connect to Oracle Database" step 5 when installing a new Enterprise Manager System, I get an Error window that states:
"ERROR: SQLException null Resultset
Cause: Verifying whether database is valid for this install, using the given credentials has failed.
Possible Reasons:
1. Credentials provided may be incorrect
2. Listener may be down
3. Database may be down
View 16 Replies
View Related
Jul 25, 2012
I have the following setup
SQL> show parameter sga;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 3G
sga_target big integer 2G
from what I read I beleive this will initially grab 2GB of memory on startup and will grab up to to 3GB of memory total for the SGA. The "total" memory can be allocated to different peices of the SGA when needed but will never exceed 3GB. Is this correct or would these settings infringe on any available memory on a system that is already tight on memory?
Secondly, what happens if both these values are set to the same value?
View 8 Replies
View Related
May 23, 2013
Can i know the internal process of initialization of DB into memory in timesten , when a new connection is establishing? Will timesten create tables and indexes in RAM when first connection is established if the RAM policy is default?
want to know the internal functional flow of timesten when any command is fired against it.
View 3 Replies
View Related
Jan 15, 2011
I have a confusion with MEMORY_TARGET and MEMORY_MAX_TARGET parameter. if i set SGA_TARGET, SGA_MAX_SIZE along with MEMORY_TARGET and MEMORY_MAX_TARGET then how oracle will manage the memory? Because as per my understanding if we set MEM
View 3 Replies
View Related
Aug 24, 2012
We are using the 11.1.0.7 database, we implemented the Memory_Max_Target and Memory_target in the database.Here is the value of the memory parameters:
SQL> show parameter memory_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 3G
memory_target big integer 2G
shared_memory_address integer 0
We want to increase the value of the Memory_target=3G, means, I want to increase the value of the memory_target upto Memory_max_target by using below command:alter system set MEMORY_TARGET=3G scope=both SID='OLTP1'; but I am getting below error:
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00846: could not shrink MEMORY_TARGET to specified value
I tried to give the memory_target value less than the memory_max_target value like:alter system set MEMORY_TARGET=2900M scope=both SID='OLTP1'; but get the same error:
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00846: could not shrink MEMORY_TARGET to specified value
View 6 Replies
View Related
Apr 6, 2011
I installed oracle 11.2.0.1.0 in redhat linux 5 using silent installation(using response file). Then i created a database manualy. While configuring the OEM, iam getting below error messages..
[oracle@meldc1~]$ emca -config dbcontrol db
STARTED EMCA at Apr 6, 2011 11:36:43 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright © 2003, 2005, Oracle. All rights reserved.
[Code].....
I configured listner,tnsnames and sqlnet files and able to login to oracle database using listner.
before executing emca -config dbcontrol db, i have executed emca -repos create to create a oem repository and repository got created successfully.
View 2 Replies
View Related
Jul 24, 2012
We have a listener with the password set to it. We are trying to configure that listener to the OEM grid. However, its not getting configured. The status shows as down.
However, when we try to set up without the password, we are able to configure it on the OEM console.
Need to understand, that if passwords are set to the listener; then won't that get configured over the OEM. or is there something where we are lacking.
View 4 Replies
View Related
Aug 11, 2010
ISSUE : I have to create ORACLE 10G R2 RAC. This cluster will host two databases pre-prod and prod. Both databases will be on different networks. pre-prod on 10.88.119 and prod on 10.88.118. I just have two hosts forming the this cluster.
How can i configure my hosts file and during clusterware installation what entries should i make for hosts and interfaces. Can this be done in 10g or will have to switch to 11g.
View 2 Replies
View Related
Feb 18, 2013
Having below setup : (All this is testing environment)
1.One virtual Machine Guest OS is Windows 8 Pro 64 bit in Oracle Virtual Box
2.In the guest I have Microsoft Visual Studio 64 bit Ultimate Edition
3.Oracle 11.2.0.1 on same host machine windows 7 64 bit
In above Visual studio I wish to use Oracle 11.2.0.1 on same host machine. When I adds sql datasource control, Visual Studio is saying for installation of either one :
(A) Oracle Developer Tools for Visual Studio
(B) Oracle client software version 8.1.7 or greater.
So, I downloaded ODTwithODAC1120320_32bit.zip from below link:
[URL].........
and installation run successfully with a message regarding running installAllOracleASPNETProviders.sql after a new installation. My questions are :
1.When I opened command prompt and said sqlplus / as sysdba it is saying ORA-12560.
2.When I says sqlplus scott/tiger@orcl (I created tnsnames.ora) c:app
ishaproduct11.2.0client_1NetworkAdmin with like this :
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XXX.XXX.XXX)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
In above HOST = i am giving IP address of host machine on which this VM is installed and this is also oracle server database machine too, on which I am running Oracle database;
so, after few seconds I am getting, ORA-12154.
How do I connect my orcl database which is running on the same host machine by using above configurations. My virtual machine is visible from other machines as well as oracle database machine too i.e. ping to VM IP is working fine.
View 0 Replies
View Related
Jul 19, 2010
We are in the design phase of a project and wanting to implement a 4 node RAC with a DR site. However to get around some licensing costs, management are insisting that only 1 node be up accepting data at the DR site. In the event of a disaster, the remaining nodes will be switched on.
View 3 Replies
View Related
Dec 6, 2010
i have installed oracle 11g r2 rac with 2 nodes. i want to configure the client side load balancing and server side load balancing. For the client side load balancing the i have configured with the
(FAILOVER=ON) (CONNECT_TIMEOUT=5) (RETRY_COUNT =3).
and to configure server side load balancing i have modified the service as follows:
execute (DBMS_SERVICE.MODIFY_SERVICE (service_name=>'service_name', clb_goal=>DBMS_SERVICE.CLB_GOAL_SHORT);
now i have few questions:
1. for the server side load balancing do we have to configure the REMOTE_LISTENER on each node so that the instance on each node registers with the listeners on other node.
2. if we have 3 nodes does this mean that we have to configure the REMOTE_LISTENER on 3 nodes to register with the listeners on the other remaining 2 nodes.
3. does the listener have to be registered with the vip network address (where the clients usually use to connect).
View 2 Replies
View Related
Jul 8, 2011
I get following error when i'm configuring ASM.
I'm using Enterprise Linux and Oracle 11.1.0.6.0
[U]Note:[/U]
[root@RAC1 ~]# rpm -qa|grep asm
oracleasm-2.6.9-78.0.0.0.1.EL-2.0.3-2
oracleasm-support-2.0.3-2
only these two packages in my server. should i have to install oracleasmlib??
[root@RAC1 ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets ('[]'). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Fix permissions of Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: [ OK ]
[B]Loading module "oracleasm": Unable to load module "oracleasm"
[FAILED][/B]
I don't have this package in my installation cd, when i searched in the web i could not find
View 2 Replies
View Related
Nov 23, 2010
I have created a procedure and i am scheduling the procedure to run in dbms jobs. In the procedure, i am using UTL_SMTP connection to receive mail everything is working fine it. In the receipent if i give one email id it is working fine. if i give multiple email id in it am getting error.
View 13 Replies
View Related
Oct 29, 2012
I am getting a duplicate SID (ABC1 (2)) on UNIX. I have checked all the possibilities how to remove it but unable to find it. As you you see below:
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
ORATAB:
================================================
ABC1:/oraclehome/oracle10g:Y
================================================
/oraclehome/oracle10g/bin/tnslsnr LISTENER_ABC1 -inherit
================================================
SID_LIST_LISTENFCATDR =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /oraclehome/oracle10g)
[Code]...
Result:
ls -lad /orahome/ora10g/dbs/initABC1 (2).ora
ls -lad /orahome/ora10g/dbs/initABC1 (2).ora ; echo ;
/bin/sh: 0403-057 Syntax error: `(' is not expected.
--------------------------------------------------------------------------------------------------------------
what to need to do to avoid this duplication? Is it something wrong with Oracle Listener.ora as it have two listeners (ABC and ABC1) that might be causing duplication?
View 8 Replies
View Related
Oct 28, 2013
I newly joined Oracle 11g DB related project.That oracle environment own our customer and we have only limited time and access to that DB.
I could login that database by SQLPlus by sys user as sysdba but I do not know any DB configurations. How could I collect Oracle 11g DB configuration information from SQLPlus ?
View 0 Replies
View Related
Jul 1, 2010
This error occurs while trying to print a report in a PDF format using Oracle Application Express 3.0. I'm not sure what this means and how to fix it. I'm running Oracle 10g on Windows Vista.
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1186
ORA-12570: TNS: packet reader failure
This is the first time I'm attempting to print to a PDF. I did follow configuration according to the Oracle documentation. I selected the Standard configuration that uses the built-in Apache FOP or another standard XSL-FO processing engine.
View 6 Replies
View Related
Jan 6, 2010
We have an oracle server on windows. It was working fine till today but now it is giving an error. When i try to add a listener configuration using net configuration assistant, it terminates abruptly without givng the finish button. Why does this happen?
I am not able to open the link
[URL]......
It gives an error "Oops! This link appears to be broken"
How can we solve this?
View 3 Replies
View Related
Jul 29, 2013
when i install a db using the Assistant Configuartion Database i get no error exept this:
Enterprise manager configuration failed due to the following error - Listener is not up. Start the listener and run EM configuration again. Refer to the log file at C:\Oracle\cfgtoollogs\dbca\emConfig. Log for more details. You can retry configuring this database with Enterprise Manager later by manually running C:\Oracle\product\11.1.0\db_1\bin\emca script.
So I try lsnrctl start and i get:
C:\Windows\system32>lsnrctl start
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-LUG-2013 10:26:25
Copyright © 1991, 2010, Oracle. All rights reserved.
TNS-01106: Il listener con nome LISTENER � stato gi� avviato
So I try lsnrctl status and i get:
C:\Windows\system32>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 29-LUG-2013 10:23:34
Copyright © 1991, 2010, Oracle. All rights reserved.
Connessione a (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
[code]...
The file "server.xml" in E:\app\Andrea.Rimoldi\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole\config\ does not exist...
Is there any way to retrieve or recover this file?
View 11 Replies
View Related
Jul 20, 2012
The problem is, while installing the Oracle Form and Report 11G R2, my installation got stuck on step 15, i.e configuration progress. Waited for 3hrs and still no progress.
Installing on Win 7 64-Bit, with 4gb ram.
Installed Weblogic Server 10.3.5 64bit(using JDK).
View 6 Replies
View Related
Aug 23, 2011
tell me about data guard accommodate with 11g database standard additions or not if no,is there any way to make it working under this edition?one more thing may i have the steps of configuration data guard in real time for anew server.
View 5 Replies
View Related
Sep 5, 2012
i have added a new listner on new port on my window 7 system for oracle version 11.2.0.1 and registered some test databases to this new listner , then i am able to access my databases through the toad because i have changed port number in tns entry, but not able to login by sqlplus. is i am missing something? should i have to restart the system or restart the all databases?
View 1 Replies
View Related
Jun 27, 2013
Running a Dell x86_64 machine using CentOS 6.4 Install using the command: rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpmOracle XE installs without any errors.
However: When during database configuration we get the Database Configuration failed error The logs all show similar errors, here's a snippet: Create controlfile reuse set database "XE"*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 BEGIN dbms_backup_restore.zerodbid(0); END; *ERROR at line
1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directoryORA-00119: invalid specification for system parameter LOCAL_LISTENERORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=1q6xlf1.bcohome.bco.com)(PORT=1521))'Create controlfile reuse set database "XE"*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 alter system enable restricted session*ERROR at line 1:ORA-01034: ORACLE not availableProcess ID: 0Session ID: 0 Serial number: 0 alter database "XE" open resetlogs*ERROR at line 1:ORA-01034: ORACLE not available
View 2 Replies
View Related
May 21, 2013
Tried installing APEX 4.2 with Oracle EBS 12.1.3. I have installed APEX into the Oracle EBS database (11.2.0.3)
I am trying to install the APEX listener on the Web Tier however it starts the listener and gives the url as
[URL]........
Is there a way to set this with actual hostname of the server.
View 2 Replies
View Related
Sep 13, 2013
i've perform a stress test of a database in 2 configuration :
1) Single instance 11.2 with 8gb Sga e 4gb Pga on Linux, 6core with instance caging =4, resource_manager=defaut_plan
2) 2 Nodes Rac 11.2 with 8gb Sga e 4gb Pga in both nodes on Linux, 32core with instance caging =4, resource_manager=defaut_plan.
I've used Swingbench and the transaction per minute are equal, Avg transaction per s in rac are Greater then single instance (4ms vs 40ms).I know that rac is not for high performance.My question is: is rac config best than single instance and if yes what is the %?
View 0 Replies
View Related
Jan 25, 2013
I am running emca -config all db -repos recreate command and recreating the repository. Doing so I am getting error while uploading the repository. The Drop and Create is going fine. The exception that I am getting is :
CONFIG: Error uploading configuration data to the repository
oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions
at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:699)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:385)
[Code]..
And the emca config file is showing exception with i18N jar file.
oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance run
SEVERE: null
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[Code]...
Exception Occured during Execution of oracle.sysman.emdrep.util.TransxWrapper
why this exception is coming while uploading the reporsitory.
View 2 Replies
View Related
Feb 25, 2013
I have installed Oracle XE 10g on Linux (32-bit) with modest resources (i.e. 512MB RAM).Everything seems to run well.i use this installation to run very basic integration tests only.
So, it won't be used in multi-user or production environment.
I imagine, it should be possible to tweak the XE configuration and decrease its footprint even more,to instruct automatic resources management to not to be ready for 20 simultaneous connections (as I understand that's the default), but 5, and such.
1) Is it possible to decrease memory allocation? I have learned a bit about SGA and PGA settings, but I;m not sure what's a reasonable limit here.
2) Is it possible to disable number of connections , as explained above.
3) Is it possible to completely disable unused components, like some application servers, Java applications, and such. I have already tried to set the HTTP port to 0, but there may be is more aggressive policy possible.
4) Any chance to cut down the nubmer of spawned processes?
Currenly, I'm getting this:
# ps aux | grep oracle
oracle 14065 0.0 0.5 21652 5864 ? Ss 22:35 0:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit
oracle 14161 0.0 0.9 370360 10204 ? Ss 22:36 0:00 xe_pmon_XE
oracle 14163 0.0 0.8 369744 8828 ? Ss 22:36 0:00 xe_psp0_XE
oracle 14165 0.0 1.7 369744 18132 ? Ss 22:36 0:00 xe_mman_XE
oracle 14167 0.0 1.1 371812 12048 ? Ss 22:36 0:00 xe_dbw0_XE
[code]....
View 4 Replies
View Related
