Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Update with 2 different WHERE condition

AceNoviceJul 28 2010 — edited Jul 28 2010
I have 2 tables, Table1 contains only ID and table2 has id and indicator. Now i want to update the INDI field in Table2.
TABLE1
======
ID
-----
A123
A456
A678
A890


TABLE2
======
ID	INDI
-----	----
A123	
A456
A678
A890
A666
A898
If ID of TABLE2 matches with ID of TABLE1 then update INDI with 'MMM' else update INDI with 'OOO'. How can i achive this?

FInal result will be....
TABLE2
======
ID	INDI
-----	----
A123	MMM
A456	MMM
A678	MMM
A890	MMM
A666	OOO
A898	OOO
This post has been answered by 737905 on Jul 28 2010
Jump to Answer

Comments

Pl see MOS Doc 883714.1 ("Preparing to launch Oracle Universal Installer from /tmp/OraInstall... Please wait ...$ [SEVERE] - Email Address Not Specified" errors while installing Oracle database 11gR2 in silent mode) for a solution

HTH
Srini
450804
Hi,

I don't know exactly what is wrong but see:

http://oratoolkit.cvs.sourceforge.net/viewvc/oratoolkit/core/x.y/conf/installManager/response/

which contains valid response files for 10.2 to 11.2 installations (software only, without database creation).

Cheers,
David

OCP 9i
http://www.oratoolkit.ch/knowledge/howto/installation/otn.php

Edited by: David D'Acquisto on 09.01.2010 10:02
752336
Where I can find this 'MOS Doc 883714.1'? Can you provide url if possible?

I can't proceed with my installation because of this error.

Please help!!!

thanks!
Srini Chavali-Oracle
MOS = My Oracle Support at https://support.oracle.com

You will need a valid CSI (Customer Support Identifier) in order ro register/login - a CSI is given when you buy Support from Oracle.

Pl do not request folks to post the contents of the document here - it violates our Support contract :-)

HTH
Srini
752336
After playing with some of the parameters, turns out you need to set 'DECLINE_SECURITY_UPDATES=true' and that will get you pass this error.

Hope this helps.
Brumpf-Oracle
Hi,

Is there any more info on this issue. I'm trying this install and keep getting this error.

I've set the DECLINE_SECURITY_UPDATES to true.

I've added an email and password for the MYORACLESUPPORT_USERNAME and MYORACLESUPPORT_PASSWORD.

Regardless of what I set I still get this error message.

Can anyone point me in the right direction?

Thanks very much,

Beth
505664
Finally figured this one out.
It happens when oracle.install.db.config.starterdb.type is set to TRANSACTION_PROCESSING.
Apparently "TRANSACTION_PROCESSING" and "GENERAL_PURPOSE/TRANSACTION_PROCESSING" are not valid types, even though the response template file and the response file generated via OUI list the following:

Response template file included in the database package:
+#------------------------------------------------------------------------------+
+# Specify the type of database to create.+
+# It can be one of the following:+
+# - GENERAL_PURPOSE/TRANSACTION_PROCESSING+
+# - DATA_WAREHOUSE+
+#------------------------------------------------------------------------------+

Response file generated by OUI during an interactive install:
+#-------------------------------------------------------------------------------+
+# One of the following+
+# - GENERAL_PURPOSE+
+# - TRANSACTION_PROCESSING+
+# - DATAWAREHOUSE+
+#-------------------------------------------------------------------------------+


In order to install in silent mode I used the following settings:

oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false
oracle.install.db.config.starterdb.dbcontrol.emailAddress=
oracle.install.db.config.starterdb.dbcontrol.SMTPServer=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
505664
Deleted duplicate post.

Thank you for the suggestion David.

Edited by: user502661 on May 13, 2010 6:56 AM
505664
Deleted duplicate post.

Thank you for the suggestion David.

Edited by: user502661 on May 13, 2010 6:57 AM
505664
Please excuse the multiple posts. Forums was acting up when I posted the above. Hopefully a moderator can and will delete the duplicate posts.
450804
user502661 wrote:
Please excuse the multiple posts. Forums was acting up when I posted the above. Hopefully a moderator can and will delete the duplicate posts.
Why don't you just edit your duplicate posts? You can do this by your own. Just remove the content and write a small sentence or keep it empty! ;)
Heiko Kaschube
Got it...

NOT working:
./runInstaller -silent -responseFile*=*/mnt/db_iso/response/db_only_software.rsp

Working well:
./runInstaller -silent -responseFile /mnt/db_iso/response/db_only_software.rsp

Obviously not response file is used in the first case. What I'd expect is a hint that no response file is used for installation. I haven't found any. Neither on the screen nor in any log files.

Regards, Heiko
1 - 12
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 25 2010
Added on Jul 28 2010
8 comments
15,899 views