I have only 9i OCP certification. What is the basic difference between the RAC and GRID.
Also I want to upgrade myself to Oracle 11g. Do I have to go thru 10g concepts to understand 11g.
(Oracle Grid & Real Application Clusters Oracle Grid Computing with RAC) from rampant tech press. I have already ordered it 3 months back and still have not received it as its not printed yet or as i am told is in press. I would be glad to have a copy soon if its published.
View 4 Replies View RelatedBasic difference between oracle 10g and oracle 11g
View 3 Replies View Related am not very experienced with SQL. I have two tables:
Class
-----
ID (int)
Teacher (nvarchar)
Subject (nvarchar)
Student
--------
ID (int)
ClassID (int)
Name (nvarchar)
I am trying to write a SQL query that will give me the total number of students in each class. I have tried the following:
SELECT
c.ID,
c.Teacher,
c.Subject
COUNT(s.ID)
FROM
Class c LEFT OUTER JOINT ON Student s c.ID=s.ClassID
Unfortunately, that gives me an error of:Column 'Class.Teacher' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
I'm afraid if I place everything in a GROUP BY clause, I will get some invalid results.
Any info source (a book, or other) for learning how to use Visual Basic 2010 to read/update an Oracle database schema?
View 2 Replies View Relatedmy 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 ?
Does windows 7 home basic support oracle 11g?
i am getting some error during installation.
understanding a redo/undo concept . Refer following data
create table t(n number);
insert into t values(10);
commit;
now I update as following
update t set n=20;
As per my understanding the before image i.e. n=10 is stored in undo (to be used for rollback, transaction recovery and even in instance recover but not in media recovery) and after image n=20 is stored in redo (to be used for various recovery purposes including media recovery in case of consistent backup).
So it is redo logs for rolling forward and undo for rolling back making transaction, db consistent . If my above understanding is true then what is meant by the term 'redo required for undo'?
Also, if there are 2 database db1 and db2 connected using database link where we are populating t1 table in db1 using t2 table in db2 using db link where redo and undo will be updated db1 or db2?
I have been tasked to look at a technology / frameworks that will allow our company to develop tools that is quick and easy to learn and easily supported. We use Oracle architecture extensively in the organization and also have APEX 4.2 installed for development purposes. We have two basic requirements or functionality that we need to implement and I and now looking at a proof of concept to determine whether we should adopt APEX or not.
1. Forms Based Tools
We have many databases with static content and users would like to have access to the data via a form. The form will allow the user to enter parameters (eg date) and on hitting a "Submit" Button, the database will be queried and a report generated and presented.
2. Diagnostics Tools
This is a bit more involved and we require a view of our static data in real time. If a specific KPI threshold is violated (eg MOC < 85%) we would like to present an alarm on a dashboard showing the alarm. For example if there are 5 entities that MOC < 85% we would like to show a "red" indicator. If no entities violate a threshold and are above MOC > 85% we want to show a green indicator. We also want a drill down function, where if the indicator is "red", a drill down will show the details of all the entities that have violated the threshold.
I have described our basic requirements, but if it can easily be done in APEX we will definitely motivate for its use.
I want to write one wiki page which covered basic performance Tuning(PT) details means by some command, some GUI which can be understand by engineer,QA and PS guy with less effort , obviously I am going to introduce them with all the PT labels like what is AWR, ADDM etc.
View 4 Replies View RelatedI'm looking for 3 simple things.
1) A reverse engineering tool that I can point to an Oracle schema and get a "baseline" script to re-create that schema from scratch, with decently formatted DDL files (1 per object) neatly organized in a directory tree (by object type) and called in the correct order. Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to populate (insert) those tables as part of the script.
2) a diff tool that I can point to a pair of Oracle instances (source and target) containing a given schema and get a "delta" script to alter the target schema so that it becomes identical to the source schema. If data loss occurs on the target instance (i.e. drop a column) I would like to find a warning comment inserted in the script (e.g. "-- Attention: data migration DML needed here?"). Icing on the cake would be an option to pass the tool a list of tables containing static data and get DMLs to update (delete, update and insert) the data in the target tables to become identical to the contents in the source tables *without* deleting and re-inserting all rows (or dropping, recreating and repopulating the table).
3) I would like the above two tools (that, as you will have recognized, are basic to putting your database design under version control) to be open-source, with a command-line interface and a vibrant community backing them.
Detail table will look like below:
Product_id issue_date action_date Force_date
1 10/10/2012 10/10/2012 10/10/2012
2 10/10/2012 10/10/2012 10/10/2012
3 10/10/2012 13/10/2012 15/10/2012
[code]....
Need the data like
Issue_date count_action_date count_Force_date (diff(action_date,force_date) 1 2 3 4 5 6(days since over)
10/10/2012 3 4 1 4 2 1 0 0
How to get the data like this? automatically how to get 123.... and how to calculate the difference by which day the count of difference is going?
I'm trying to test moving a single instance 11202 database to single instance w/ grid infra.
Here is what I've done:
1. Install a database (11202), single instance and create a database
2. Install Grid Software only (user: grid)
3. start the cluster
4. "srvctl add database -d orclsidb -o $ORACLE_HOME" to register the database with grid.
4.1> I was able to start/stop the database with srvctl command here onwards
5. configure disks using asmlib and start the asm
6. "srvctl add asm" to register asm with grid.
7. PROBLEM ... when I try to "backup as copy database format '+ASM_DATA_DG';" from oracle user it errors out as below:
RMAN> backup as copy database format '+ASM_DATA_DG';
Starting backup at 24-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/fs0/oracle/oradata/orclsidb/sjc883p_indx_large_01.dbf
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/24/2012 08:53:29
ORA-19504: failed to create file "+ASM_DATA_DG"
ORA-12547: TNS:lost contact
ORA-15001: diskgroup "ASM_DATA_DG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contactConsidering "TNS: lost contact" I tried to see if grid listener is aware of ASM instance:
[Code]....
All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usracdb03.rwcats.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 22-AUG-2012 06:08:53
Uptime 2 days 2 hr. 50 min. 48 sec
Trace Level off
[Code]....
I Had installed 11g grid on 32 bit machine. Grid was working fine till yesterday and was also able to monitor agents on 4 diff boxes. Agents installation was smooth using the pull method. But from yesterday onwards grid is not working. OMS service on windows is not getting started. node manager,listener,database service, web tier all services are running fine but for some reasons the Windows OMS service is not coming up .
I also tried to start manually oms_home/emctl start oms but the service doesn't come up.
I am using OEM Grid control 10g for monitoring/reporting purposes and a bit new to OEM.I am able to generate database alerts sent via email say for DB_abc1 and also generate reports.I installed Oracle 10g agent on a another box and lets say with DB_abc2 running on it,and did not realise that there was a database control already installed on that box, so I
1.Uninstalled database control on DB_abc2 box.
2.Uninstalled Oracle 10g agent and re-installed it on DB_abc2 box.
2.Was able to configure the DB_abc2 database from OEM Grid control gui ie the dbsnmp user password and was able to connect to it.
But when I put in alert for things like ORA-XXXX errors I am not getting any emails, also when I put in database usage reports(to be sent via emails) the reports are not picking up any data, they are empty.
I checked the agent on the box in question and the heart beat is OK, and I manually uploaded using "emctl upload" and it is sucessful.The only alerts I am getting for DB_abc1 is the agent up/down thats it.
DB_abc1 is a 9208 database and DB_abc2 is 10201 database.
I need to install the new Oracle Grid on a new virtual machine. Currently the new Grid VM server has a different name and IP. After it is setup and tested it will eventually take the place of the old production server using its original IP and name. If I install the new Grid now on this new VM with different name and IP address would I have to reinstall the agents on each of the target database servers?
View 1 Replies View RelatedCan we collect information(generate report) about user sessions connected, database hit ratios, memory usage and other system metrics of all target databases from OEM grid control repository database. Which tables/views in repository DB will be holding these information.
View 1 Replies View Relatedwhat is JTF GRID functionality,i have use that grid in custom form. how to proceed with that and what are steps to be taken to display JTF GRID Functionality ?
View 6 Replies View Relatedif I create manual database how to set threshold value? is there any other tool to set threshold value?
View 4 Replies View RelatedIs the 12c version of the Grid Control only for Oracle Cloud? Not completely sure of exactly what cloud computing is. Looks like a conglomeration of shared resources. Anyway we are converting all of our servers over to vmware virtual machines except the ones we manage in other states. I am upgrading each database to 11 r2 as we convert the servers. Anyway my Grid server is next to convert to a virtual machine. I am using Grid Control 10.2.0.5.0 now. I want to upgrade to the latest version of the Grid control. 12c seems to stress and boast about managing the "Oracle Cloud" to manage regular single node Oracle servers as well as vmware virtual machines?
View 3 Replies View Related*How can we generate the report of backup status,tablesapce(usedf,free space) for all the databases from OEM or RMAN*
1.)we need generate the report of tablespace used,free, archive...
2.)we also need we generate the Backup status report also
I'm trying to install Grid Infrastructure for Oracle RAC 11g. I followed each step of pre installation tasks, but when I run run Installer it blocks without any error message.
What I see on my shell is this:
./runInstaller
Avvio di Oracle Universal Installer in corso...
Verifica dello spazio Temp: deve essere maggiore di 120 MB. Effettivi 17276 MB Superato
Verifica dello spazio di swap: deve essere maggiore di 150 MB. Effettivi 23999 MB Superato
Verifica del monitor: deve essere configurato per visualizzare almeno 256 colori. Effettivo 16777216 Superato
Preparazione per l'avvio di Oracle Universal Installer da /tmp/OraInstall2012-01-11_03-35-57AM. Attendere...[oracle@ssts2cora1 grid]$
Everything seems ok. But the window of oracle installation does not appear. The java process is active:
[oracle@ssts2cora1 grid]$ ps -ef | grep java
oracle 4553 1 0 03:35 pts/0 00:00:00 /tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre/bin/java -Doracle.installer.library_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui/lib/linux -Doracle.installer.oui_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui -Doracle.installer.bootstrap=TRUE -Doracle.installer.startup_location=/home/software_ssts/grid/install -Doracle.installer.jre_loc=/tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre -Doracle.installer.nlsEnabled="TRUE" -Doracle.installer.prereqConfigLoc= -Doracle.installer.unixVersion=2.6.32-100.34.1.el6uek.x86_64 -mx150m -cp
[code]....
but it does nothing!! Nothing appears to me. I attach the log file generated by the installation process.
Using paramFile: /home/software_ssts/grid/install/oraparam.ini
Checking Temp space: must be greater than 120 MB. Actual 17276 MB Passed
Checking swap space: must be greater than 150 MB. Actual 23999 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
The commandline for unzip:
/home/software_ssts/grid/install/unzip -qqqo ../stage/Components/oracle.jdk/1.5.0.17.0/1/DataFiles/\*.jar -d /tmp/OraInstall2012-01-11_03-35-57AM
Verr� utilizzato il valore di umask '022' disponibile in oraparam.ini
Execvp of the child jre : the cmdline is /tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre/bin/java, and the argv is
/tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre/bin/java
-Doracle.installer.library_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui/lib/linux
-Doracle.installer.oui_loc=/tmp/OraInstall2012-01-11_03-35-57AM/oui
-Doracle.installer.bootstrap=TRUE
-Doracle.installer.startup_location=/home/software_ssts/grid/install
-Doracle.installer.jre_loc=/tmp/OraInstall2012-01-11_03-35-57AM/jdk/jre
[code].......
I got huge problem trying to install grid infrastructure and oracle db. Separately oracle db works fine and installation is going without any problems as for grid not so much.
i got vmware host 4.1 with several vm's on top. One of them i openfiler which gives 2 luns for installation. Two other vm's are host of windows 2008r2(comes only 64bits i know that many of you know but just to be clear). Those two windows should be connected in oracle cluster and should have one oracle db afterwards. I have already AD domain, free disks and all required staff arranged and prepared.
I wont bodder you ppl about previous problems but current one is that i have no clue what's going wrong. I got two logs file which i paste below but there's no error message just some warning which isn't described even properly as for me.
Attached File(s)
installtion_logs.zip ( 66.62K )
Number of downloads: 0
With just 1.95 GB RAM in windows xp, would it be recommendable to use Oracle 11g OEM Grid control? Will the performance be poor?
View 1 Replies View RelatedI am getting one error message while installing this OEM grid control in existing DB. this error come at last in configuration step. This is the error stack:
Getting temporary tablespace from database...
Found temporary tablespace: TEMP
Checking SYS Credentials ... OK.
Checking DB Init Parameters ... OK.
Checking for Repos User ... Does not Exist.
Loading necessary DB objects ...
Checking DB Object (DBMS_SHARED_POOL , PACKAGE) ... Exists.
DBMS POOL package exists.
Done Loading necessary DB objects
Creating repos user ... Done.
Creating EM Schema ... Failed.
Repository Creation failed. Failed to create repository schema.
Configuration assistant "Enterprise Manager Repository Creation Assistant" failed
--------
I am using oracle 10.1.0.3.0 on Windows XP.
what this error means? or any way that complete without it and later create manually.
We have some space constrain with the server and unfortunately the Specific Oracle file system is not extendible. Middleware/ gc_inst are also in the same mount point consist (28G). Would like to create a soft link to these directory to a newly mounted LUN and so to avoid this space issue which is currently 95%. if soft link works and releases 28G?
OEM grid control 11g
OS: Red Hat Enterprise Linux Server release 5.6 (Tikanga)
Linux corpoem.corp.idt.com 2.6.18-238.5.1.el5 #1 SMP Mon Feb 21 05:52:39 EST 2011 x86_64 x86_64 x86_64 GNU/Linux
Is it possible to use Data grid view in Forms6i just as in Visual Basic?
View 7 Replies View RelatedI've changed the ip address of the enterprise manager grid control server. But oms could not be started. I got the error below:
[oracle@YDFULGRID bin]$ ./emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright © 1996, 2010 Oracle Corporation. All rights reserved.
Starting WebTier...
WebTier Successfully Started
Starting Oracle Management Server...
Oracle Management Server Could Not Be Started
Oracle Management Server is not functioning because of the following reason:
Connection to the repository failed. Verify that the repository connection information provided is correct.
Please check /oracle/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log for error details
When i checked the log:
I am getting this error:
2012-09-13 16:23:56,602 [main] DEBUG oms.StatusOMSCmd processStatusOMS.155 - Using http port.
2012-09-13 16:23:56,602 [main] DEBUG oms.StatusOMSCmd processStatusOMS.195 - Attempting to connect to servername
2012-09-13 16:24:17,638 [main] DEBUG oms.StatusOMSCmd processStatusOMS.200 - page status code is 503
2012-09-13 16:24:17,638 [main] DEBUG oms.StatusOMSCmd processStatusOMS.202 - header is 3
2012-09-13 16:24:17,639 [main] INFO wls.OMSController statusOMS.950 - statusOMS finished with result: 3
I am able to generate (and email) built in database space usage report, I have a requirement where the report has to be in portuguese language and not in english.
View 1 Replies View Relatedi insall grid contrlol on r12(12.1.1) and it work very fine detect all target r12 database plus oracle application server all target...but my problem is when i connect it to another system r12(12.1.3) by installing agent silent installation...it detect oracle r12 database only but not detect any target related to oracle application server such as oracle ebusiness suit,http server or any target related to application server. os linux 5.4. acutally i want to configure plug in 4.0...i follow metalink doc 1224313.1 refer me any doc any blog or any thig by which i can detect oracle application target in grid control.
View 7 Replies View Related