XE :: Minimal Lightweight Configuration On Linux?

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


ADVERTISEMENT

Backup & Recovery :: RMAN Configuration On Linux Using Tape Drive?

Oct 8, 2011

I want to configure rman backup for oracle 9i database on hp tape drive. Db is running in RHEL.

View 6 Replies View Related

Moving Schema From One Database To Another Of Different Unix Flavour With Minimal Downtime

Aug 14, 2013

Oracle version : 10g, 11g (applicable to both) Consider a schema named 'UNIVERSE' present in the database A running on Linux platform where this schema needs to be moved to another database B running on  windows platform or AIX platform with no downtime provided and data needs to be consistent.  Is this practically possible?

View 13 Replies View Related

OEM Configuration In 11g?

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

Reg The Configuration Of Listener On OEM?

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

Oracle 10G R2 RAC - CRS Configuration

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

OLE DB :: Configuration For VS 2012

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

Oracle RAC And DR Node Configuration?

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

Oracle RAC Listener Configuration

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

RAC & Failsafe :: ASM Configuration For Servers?

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

SQL & PL/SQL :: Smtp Mail Configuration?

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

Configuration Duplicate Session ID

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

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 View Related

How To Collect Oracle 11g DB Configuration

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

Standard Configuration That Uses Built-in Apache

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

Listener Configuration Terminates Abruptly

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

Enterprise Manager Configuration Failed

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

Windows :: Stuck At Configuration Process?

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

Data Guard :: Configuration For New Server?

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

Client Tools :: Listener Configuration?

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

XE :: Database Configuration Failed Error?

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

Application Express :: 4.2 Configuration With Oracle EBS R12

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

Stress Test Of A Database In 2 Configuration

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

Uploading Configuration Data To The Repository

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

Forms :: Icons Not Appearing In 10g After Webutil Configuration On OAS

Mar 5, 2012

I want to open word document on client machine and to do this I have configured webutil and Its working fine. before configure the webutil icons are appearing on forms and after webutil icons are disappeared I have found that when I comment

baseHTMLjinitiator=webutiljpi.htm

icons appears but word document not open and the following error shows

oracle.forms.webutil.ole. Ole functions beans not found
CLIENT_OLE2.Create_Obj will not work.

View 6 Replies View Related

ORA 16009 - Data Guard Configuration Seems To Be Working

Apr 26, 2007

just realised the data guard configuration seems to be workin but the error kepps appearing on the alert log of both primary and physical standby that i configured. below is my primary and standby pfiles.

primary
*.db_unique_name='CPASPRD'
*.service_names='CPASPRD'
*.log_archive_dest_1='LOCATION=/Oracle/archivelog/'
*.log_archive_format='%t_%s_%r.dbf'
[code]....

View 11 Replies View Related

Windows :: Oracle 10g Installation - No Configuration Setup

Feb 6, 2013

I have installed oracle 10g in D drive . The installation says it is successful, without asking the database name or the password . I have followed the steps given in the attached file .

However it is not asking the database name or password ( no configuration set up is appearing for the user to interact with the system ) . So, after installation I can not give the username and password .

View 4 Replies View Related

Data Guard :: Physical Standby Configuration

Mar 10, 2011

I did the all necessary steps required for the physical standby configuration. My standby db is mounted but not able to open.

Below are the steps.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1845493760 bytes

Fixed Size 2021568 bytes
Variable Size 452986688 bytes
Database Buffers 1375731712 bytes
Redo Buffers 14753792 bytes
Database mounted.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=demodb' scope=both;

System altered.

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE SCOPE=BOTH;

System altered.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u002/app/OraDB10g/stdemo/oradata/system01.dbf'

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
*
ERROR at line 1:

ORA-00600: internal error code, arguments: [kcrfrsetnab_found], [1], [136], [],
[], [], [], []
ORA-00600: internal error code, arguments: [kcrfrgv_scn7], [], [], [], [], [],
[], []

SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kccocx_01], [], [], [], [], [], [],
[]

View 3 Replies View Related

RAC & Failsafe :: Two Node - Configuration On Oracle Virtual Box

Mar 27, 2013

I am configuring two node RAC on oracle virtual box. Did its mandatory to configure DNS on both nodes before Rac installation? Whats the purpose of DNS in RAC. And if its mandatory did i have to configure DNS on each node separately?

View 1 Replies View Related

Data Guard :: EM (DB Console) Configuration After Switchover?

Dec 20, 2012

I have this scenario:

- Oracle 11.2.0.3
- RHEL 4.6 64 bits
- Active Data Guard
- Broker configured
- DBconsole configured on primary server

Now, I have server PRIM with the primary database, and server STB with the standby server. For now, the dbconsole is configured in the PRIM server.When I do a switchover (to the standby on STB), EM is not configured, so I use RepManager.sh to clean the sysman user, and I use emca to recreate the dbconsole. After this, everything works.

Once I switch back, the EM is no longer configured on PRIM, so I repeat the previous steps (repManager and emca). Everything is ok after this. I can access the EM on the primary normaly, and this gets information from the broker to provide basic information on the STB (like db status, apply, and so forth).

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved