ALL Scripts Which Automatically Get Run By DBCA In ORACLE 11G Enterprise Edition

Jan 19, 2013

which are ALL the scripts which automatically get run by DBCA in ORACLE 11G Enterprise Edition.

View 2 Replies


ADVERTISEMENT

Enterprise Manager :: Oracle 9i Enterprise Edition Installation Error / End Header Not Found

Feb 18, 2011

My problem is i install Oracle 9i enterprise edition 9.0.1.1.1 in windows xp professional but at the time of oracle database confiuration assistent it show me following errors it show:

Not a zip file(End header not found)

View 1 Replies View Related

Server Administration :: Convert Enterprise Edition DB To Standard Edition?

Nov 4, 2011

The only supported technique for converting an EE database to SE is export-inport, as documented in note 139642.1. Our client is reluctant to do this because of the downtime involved. It is however possible to open the EE database from an SE home, no problem.

The note says only Quote:When you just install the Standard Edition software, you will end up with Data Dictionary objects which are of no use (or perhaps even invalid) and possibly create problems when maintaining the database.

View 2 Replies View Related

Performance Tuning :: Oracle Database 10g Enterprise Edition 10.2.0.4.0 - 64bi

Sep 2, 2011

I am querying v$sga and getting variable size : 211337216 bytes.when querying v$sgastat then getting

java Pool : 16777216
Large Pool : 41943040
Shared pool : 398560392

But as per my knowledge following condition should satisfy,but not getting

[code]

Variable sga = java pool + large pool + shared pool
select pool,name,sum(bytes)
from v$sgastat
where pool in ('shared pool','java pool','large pool')
group by pool,name;

Here variable size using v$sga : 211337216 bytes

and java pool + large pool + shared pool : 211302536 bytes.

[/code]
but it should match?

View 5 Replies View Related

RAC/ASM Clusterware Installation :: Difference Between Enterprise And Standard Edition For Oracle

Mar 18, 2013

In our current setup we have RAC on standard edition and client is now planning to go for Enterprise Edition but not yet decide because of cost. Is there any difference between Grid Infrastructure 11gR3 Enterprise edition and Standard Edition ?

They told me to first install Enterprise Edition and then will move to Standard Edition if they can't get the EE license so in that case do i have to re-install Grid infrastructure for standard edition?

View 6 Replies View Related

Enterprise Manager :: Oracle 11g Console Not Starting Automatically And Manually?

Jun 10, 2011

When I am trying to enter to the enterprise manager of oracle 11g, but it is not working. In my services list the 'oracledbconsoleorcl' is assigned as automatically to start with windows. But it is not starting. When I tried to start it manually the following message is displayed repeatedly even after restarting the pc.

'Windows could not start the oracledbconsoleorcl on Local computer. For more information, view the system event log. If this is a non-Microsoft services, contact the service vendor, and refer to service-specific error code 2.'
In the event log the following error messages are displayed:The OracleDBConsoleorcl service terminated with service-specific error 2 (0x2). and

The OracleCSService service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.

View 4 Replies View Related

Enterprise Manager :: DBCA Does Not Recognize Database

Mar 28, 2010

On our test database server, we restore a copy of the production database from the rman backup. The process worked well and we could connect and do the processing with sqlplus, or any other third party tools like Toad.

Strange enough, Database Configuration Assistant (DBCA) does not recognize it. So if we like to drop the database from the DBCA, it is not there. Also we could not get the DBCONSOLE to work with.

The all powerful command: emca -repos recreate generates a list of errors.

View 3 Replies View Related

Enterprise Manager :: DBCA Shows No Agents Found?

Jun 8, 2010

I have EM Agent 10g installed in its own Oracle Home (c:oracleagent10g) and Oracle 11g installed in its own Oracle Home (c:oracle11.2.0) The Server shows in EM console but the only target is the EM Agent,.. neither the Listener or the Database show under the targets tab in EM. Also, when DBCA is ran and we get to step 4 it shows NO AGENTS FOUND.

Have installed patch: 8825226 and 8968580 for EM Grid Control (Windows 2003 R2 32Bit) And 9138201 for 10g Agent on Server 2008 R2 (64bit)

View 3 Replies View Related

Enterprise To Standard Edition

Sep 12, 2012

Recently we have downgraded our database from enterprise to standard edition.....our sga size before downgrade was 11 gb and now it is 11gb and there is no as such problem in database..I have read somewhere that standard edition doesn't support sga size more than 2 gb .

View 1 Replies View Related

Downgrade From Enterprise Edition To Standard

Feb 10, 2011

I am checking out licenses. We all know that EE is much more expensive than SE. But many customers do have EE installed - unsure if they need all the features at all. After several years of production, a downgrade is considered 'risky' and we continue to pay the full EE.

How can we check and be sure that a downgrade to SE would not be any problem?

Some checks include:
* partitioning used in user schemas? --> no downgrade to EE
* bitmap indexes in user schemas? --> no downgrade to EE

How can we complete this list, or is there some script to make this easy?

View 7 Replies View Related

Cursor Pin S Wait For X In 11g Enterprise Edition Release 11.2.0.2.0

Sep 4, 2013

Ours is Oracle 11.2.0.2.0 Db 4 instances RAC on Unix AIX OS.Since long we are facing problem that CPU utilization reached 100% and reboot is required alteast once or twice a month.On seeing the Events Logs we find that the Event "CURSOR PIN S WAIT FOR X" is consuming a lot of waits.

On analyzing i came to know that we are firing same query from Application 15 to 20 lack times for which a lot of Mutex keeps spining for getting Shared Mode and consumes a large amount of CPU.

View 3 Replies View Related

Import - Moving Data From 10g Enterprise Edition To 11g?

Sep 23, 2013

Am moving data from 10g enterprise edition to 11g standard edition using normal import commandafter completing i just go through the Log.i found a thing which makes me confusing

in some tables alone a row is not inserted stating the ORA-12899 while checking with the database it shows the column is varchar(100)in the log the error showing it tries to insert 101 character. how it happening to a single row

how can i solve it

View 3 Replies View Related

Enterprise Manage Console Closing Automatically?

Jul 25, 2013

I have successfully installed the Oracle 10g standerd version with a sample database on Windows server 2008 standard server. Then I installed the client so that I could use the Enterprise manage console that comes with it. Once installed, I was able to successfully configured the Net service. Now when I use either Enterprise manage console or SQL plus to login to the service that I created, once I enter the user id and password and click ok, system automatically closes both applications. I am not sure what is missing. I installed the same client on a windows XP pc and the enterprise manage console is working perfect.

View 1 Replies View Related

Install / Use Enterprise Manager Grid Control If Only Have Standard Edition Licenses?

Jul 27, 2011

can I install/use Oracle 10g Enterprise Manager Grid Control if my organization has only Oracle 10g Standard Edition Licences.

View 2 Replies View Related

Windows :: Oracle 10g - Creating New Database / DBCA?

Jun 15, 2011

when i am trying to create a new database in oracle 10 g in my local system when creating database error shows a number 146 no other error is showing what must be the reason.

View 14 Replies View Related

Oracle 11g Installation Dbca Command Not Found?

Feb 17, 2013

I installed oracle 11g on fedora 14 64 bit. i followed the instructions from the oracle docs. successfully installed. even the scripts ran. but when i try to execute dbca command. it says command not found. im in the oracle user acc.

View 10 Replies View Related

Server Administration :: Error Creating Database Using DBCA Oracle 11g R2?

Nov 18, 2010

This is on a vmware virtual server on Windows 2008R2 using ORACLE 11g R2 with patch set 6

I installed ORACLE (software only) and applied patch set 6 and tried to create a new database.

during the database creation I got an error as the system was adding the JVM that read:-

ORA-01927:cannot REVOKE privileges you did not grant.

I was given the options to ignore or abort

I chose to ignore the error and continue.

After the database creation completed I looked in the jserver log copied below and found two errors

I did not get the same error before installing patch set 6

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
No errors.
alter system flush shared_pool
drop role javauserpriv

[Code].....

View 2 Replies View Related

Using Oracle XDB In 10.2.0.3.0 Standard Edition

Feb 20, 2013

I am using Oracle 10.2.0.3.0 standard edition. Now i want to use Oracle XDB in the same.

Can i use this directly or does this require license.

View 2 Replies View Related

Server Administration :: How To Avoid Clear Password In Checkpoint File With Oracle DBCA

Nov 15, 2011

I found there is clear password in the xml file in the process of Oracle instance creating. The process like below

1, when using the following process to create the instance

Login as user Oracle
/home/Oracle11home/bin/dbca -createDatabase -silent -templateName /home/Oracle11home/assistants/dbca/templates/Small.dbt -gdbName testDB -sid testSID -sysPassword [b]testpwd[/b] -systemPassword [b]testpwd[/b]

2. Found the file in $ORACLE_HOME/checkpoints/dbca/OraDb11g_home2_oracle_creation_checkpoint.xml , it listed the sys and system passwd (like testpwd for sys and system password) directly.

<CHECKPOINT LEVEL="MAJOR" NAME="db_oracle" DESC="db creation checkpoint" STATE="FAIL">
<PROPERTY_LIST>
<PROPERTY NAME="command" TYPE="STRING" VAL=" -silent -createDatabase -templateName Small.dbt -gdbName testDB -sid testpwd -sysPassword testpwd -systemPassword testpwd"/>
</PROPERTY_LIST>
</CHECKPOINT>

I hope to confirm :

1. what is the purpose for oracle to genate the checkpoint.

2, can we remove the file safely ?

3, if there is configuration that we can avoid to show clear password in checkpoint file?

View 1 Replies View Related

Express Edition (XE) :: Uninstalling Oracle XE?

Dec 10, 2012

I tried to uninstall Oracle XE 11g and i got 1402 error from Windows Error: [URL]...

what is happening. I can not uninstall or repair either.

View 5 Replies View Related

SQL & PL/SQL :: Horizontal Fragmentation In Oracle 10g Express Edition?

Feb 28, 2012

I want to do horizontal fragmentation of a table say employee. But fragmentation is often related to distributed databases. So i want to ask how can i do this on my single home computer? list out the steps that should be performed. I saw the concept of link but really failed to understand that.

View 14 Replies View Related

Forms :: Oracle 10g Express Edition Can Support 6i

Mar 2, 2007

I have downloaded oracle 10g express edition. I have tried to connect forms 6i in that in windows xp environment but when i tried to connect it is not connecting and giving "don't send" error.

If there is any patch to connect forms 6i into oracle 10g express edition.

View 3 Replies View Related

Express Edition (XE) :: Oracle 11g R2 Doesn't Start?

Sep 3, 2013

I am running Ubuntu 13.04. I am attempting to install Oracle XE 11g R2. It seems that everything was fine until I got to configuration of the database as root I ran /etc/init.d/oracle-xe configure command. I have received the following output 
Starting Oracle Net Listener...Done
Configuring database...

Database Configuration failed.  Look into /u01/app/oracle/product/11.2.0/xe/config/log for details

When I look at the logs I get the following error ORA-01034: ORACLE not available.  After receiving this error I have attempted to start Oracle manually.

sqlplus "/as sysdba"
 
SQL*Plus: Release 11.2.0.2.0 Production on Tue Sep 3 11:34:07 2013
 
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORA-00845: MEMORY_TARGET not supported on this system
 
As you can see I got

ORA-00845: MEMORY_TARGET not supported on this system error. Ok let's see what's going on with my partitions 

/u01/app/oracle/product/11.2.0/xe/config/log# df -h
Filesystem               Size  Used Avail Use% Mounted on
/dev/sda1                 46G  9.7G   34G  23% /
none                     4.0K     0  4.0K   0% /sys/fs/cgroup

[code]...

View 4 Replies View Related

Express Edition (XE) :: Not Connecting To Oracle Homepage?

Sep 28, 2012

i am using windows xp home edition (with oracle 11g r2). oracle installed with out any problems but when i click get started internet explorer it says(internet explorer cannot display the webpage) this is the address get started open up to [URL]...but does not work.

View 7 Replies View Related

Express Edition (XE) :: Unable To Install Oracle 9i

Oct 10, 2013

could i no longer install oracle 9i.2. should i install other version of oracle as 11g XE.  What possible steps should I take than Q.

View 8 Replies View Related

Oracle 11g Personal Edition With Visual Basic?

Oct 30, 2012

my issue in oracle database 11g.

1. I installed Oracle 11g Personal Edition, Release 11.2.0.10, 64bits,
2. Test connection(oracle in oradb11g_home1) is successed in data source, odbc,
2. Then, I tried to connect this with Visual Basic(Visual Studio 2010), data connections, add connections, .net framework data provider for oracle,
3. but I received an error message as "Attempt to load Oracle client libraries threw BadImageFormatException."
4. Then, I download the ODAC(11.2.0.3.0) for 64bits, and installed,
5. I tried to test the connection, but failed with error message as stated above,
"Unable to connect SQLState=08004 Oracle ODBC Ora-12154: TNS:could not resolve the connect identifier specified"

I need to install ODAC for 11g Personal Edition ?

View 36 Replies View Related

XE :: Use Oracle DB 11g Express Edition With Atomikos Transactions

Jul 16, 2012

I'm able to use Oracle 11g Standard/Enterprise Edition with Atomikos for XA transactions.(XADMS).

My question is Can I Use Oracle DB 11g Express Edition with Atomikos for XA Transactions.

View 4 Replies View Related

XE :: Oracle 10G Express Edition Account Locked

Aug 16, 2012

My Oracle 10G Expression Edition Account locked gets locked, where to raise the request to unlocking my account.as my user name:system

View 4 Replies View Related

11g Oracle Express Edition - Destination Host Unreachable?

Jan 11, 2013

I installed Oracle 11g Express edition in my local Machine(Windows 7).listener.ora, tnsnames.ora files seems fine. Service and listener are running; While trying to connect to the my db sqlplus>connect sys/oracle as sysdba

I am getting "ora - 12543 TNS: destination host unreachable."

what could be the issue. Find below listener.ora, sqlnet.ora, tnsnames.ora files:=

listener.ora file:=
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)

[code]....

View 1 Replies View Related

Way To Start Oracle Database 10g Express Edition On Fedora

Sep 29, 2007

am having problems starting Oracle Database 10g Express Edition on Fedora. Here is what I did in order to start it:

[root@x1-6-00-c0-9f-bb-ba-57 ~]# /etc/init.d/oracle-xe start
[root@x1-6-00-c0-9f-bb-ba-57 ~]# xhost +
access control disabled, clients can connect from any host

Not sure what I am doing wrong here.

View 2 Replies View Related







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