Re: dbshut script - shutdown or shutdown immediate
Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? Well said. This topic has been circulating in many DBA forums for a long time. Shutdown immediate does rollback and will take time if no.of users is high. On the otherside, shutdown abort simply takes the db down and does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case. Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed. Though Oracle's recovery seems to be sturdy, double check your backup recovery strategies. Also, which option to use is influenced by how much downtime/shutdown time you can afford. HTH GovindanK -- |XXX| |You should treat others the way you want to be treated - Mahatma Gandhi| |XXX| __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbshut script - shutdown or shutdown immediate
This topic is getting interesting once more. Lets contribute. Multiplexing redo logs has nothing to do with the archive mode. Take a situation wherein the db is in NOARCH mode with only one member per group (default setup). The dba gives shutdown abort and upon starting for some reason the active log could not be read for recovery. How would one perform a complete recovery?. Let me know if you have a workaround. I am willing to learn. GovindanK -- |XXX| |You should treat others the way you want to be treated - Mahatma Gandhi| |XXX| Daniel W. Fink [EMAIL PROTECTED] wrote: Multiplexing redo logs has nothing to do with the archive mode. Logs are multiplexed so that an error writing to one of the members in a group does not cause the instance to terminate. Myth - If you use disk mirroring, you don't need to multiplex your redo logs. Reality - Mirroring only protects from hardware failure. It will not protect you from accidental deletion of the log (been there, had to fix it!). -- Daniel W. Fink http://www.optimaldba.com GovindanK wrote: Shutdown abort is pretty drastic, are you sure shutdown immediate didn't work? Well said. This topic has been circulating in many DBA forums for a long time. Shutdown immediate does rollback and will take time if no.of users is high. On the otherside, shutdown abort simply takes the db down and does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case. Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed. Though Oracle's recovery seems to be sturdy, double check your backup recovery strategies. Also, which option to use is influenced by how much downtime/shutdown time you can afford. HTH GovindanK __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbshut script - shutdown or shutdown immediate
http://download-west.oracle.com/docs/cd/A81042_01/DOC/server.816/a76956/onlinere.htm#3981 would be nice reference. What i was trying to communicate was this: If the log is not multiplexed and the only log member is not avbl for writing then LGWR cannot write and the db instance will go down. However, if it is multiplexed then an error will be logged to the alert.log but the db will continue to function. I agree this has nothing to do with the arch/noarch mode but one has to have the log files multiplexed to get out of such scenarios. HTH GovindanK -- |XXX| |You should treat others the way you want to be treated - Mahatma Gandhi| |XXX| Daniel W. Fink [EMAIL PROTECTED] wrote: The scenario you describe would occur regardless of the archive mode. An active log cannot be archived. This would require that the ARCH process read the log while LGWR is writing it. Once a log switch occurs (automatic or manual), the previously active log can be archived. In this scenario, you cannot perform a complete recovery. You can recover up to the last log that can be read. If the active log cannot be read, the previous log is the end point of your recovery. -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Thursday, May 1 1:00pm - 2:00pm - Automatic Undo Internals GovindanK wrote: This topic is getting interesting once more. Lets contribute. Multiplexing redo logs has nothing to do with the archive mode. Take a situation wherein the db is in NOARCH mode with only one member per group (default setup). The dba gives shutdown abort and upon starting for some reason the active log could not be read for recovery. How would one perform a complete recovery?. Let me know if you have a workaround. I am willing to learn. GovindanK __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbshut script - shutdown or shutdown immediate
Agreed. I admit my English needs some improvement. What i wanted to say was about rollback but used the words no.of.users. Thanks for pointing out. GovindanK Jeremiah Wilton [EMAIL PROTECTED] wrote: On Wed, 2 Apr 2003, GovindanK wrote: Shutdown immediate does rollback and will take time if no.of users is high. Number of users is not the largest contributing factor to shutdown immediate taking a long time. The longest poles in the tent are large transaction rollback and lazy temp segment deallocation. On the otherside, shutdown abort simply takes the db down and does not bother about anything else. As per manual, if you do a shutdown abort then you WILL need the online redo logs for recovery just in case. Do you know of anyone who does not have their online redologs? You pretty much need them or your database would have crashed a long time ago. Think twice if your db is in NOARCHIVELOG mode. If your db is in ARCHIVE mode make sure the logs are multiplexed. As has been pointed out, having multiplexed logs has nothing to do with archivelog mode. Furthermore there is no reason to be more careful about using abort if you are in noarchivelog mode. Crash recovery will not need any archived redologs, since it only needs those logs since the last checkpoint. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbshut script - shutdown or shutdown immediate
To me it seemed the same as turning off your computer with the power button instead of the shutdown command or using kill -9, sometimes you have to, but it's not what you do normally. Chris Berry Sounds practical. GovindanK -- |XXX| |You should treat others the way you want to be treated - Mahatma Gandhi| |XXX| __ Try AOL and get 1045 hours FREE for 45 days! http://free.aol.com/tryaolfree/index.adp?375380 Get AOL Instant Messenger 5.1 for FREE! Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: got EXP-00091 warning
My experience with this error: quote Add statistics=none during daily backup export command (if statistics are really not need to be exported) OR export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 prior to daily_export. (To avoid error during Export) * OTHERWISE YOU WILL GET THE FOLLOWING ERROR EXP-00091: Exporting questionable statistic * OTHER INFO: There are four parameter for STATISTICS parameter ALWAYS : Always imports database optimizer statistics regardless of whether or not they are questionable. NONE : Does not import or recalculate the database optimizer statistics. SAFE : Imports database optimizer statistics back only if they are not questionable. If they are questionable, recalculates the optimizer statistics. RECALCULATE : Does not import the database optimizer statistics. Instead, recalculates them on import. When do we get these errors, The precalculated optimizer statistics are flagged as questionable at export time if: 1)There are row errors while exporting 2)The client character set or NCHAR character set does not match the server character set or NCHAR character set 3)A QUERY clause is specified 4)Only certain partitions or subpartitions are exported. *** /quote HTH GovindanK Jin - Sounds good. Start with Google and with metalink.oracle.com. If as a result of your investigations you find that my simple-minded approach has overlooked a ghastly possibility, please post the results of your investigation. At some point I said this message was giving me too much information. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, June 21, 2003 8:19 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, I wonder if I can find whether or not there is any problem in that schema, because that could be any of those a row error occurred, client character set or NCHARSET does not match with the server, a query clause was specified on export, only certain partitions or subpartitions were exported, or a fatal error occurred while processing a table. Jin Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: Jin I cured this one with STATISTICS=NONE. Inelegant, but effective nonetheless. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 10:21 AM To: Multiple recipients of list ORACLE-L Greetings, When I export schema containing some tables, I got EXP-00091 warnings. The log is saying: .. JServer Release 9.2.0.1.0 - Production Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion) . exporting pre-schema procedural objects and actions . exporting foreign function library names for user XXX . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user XXX About to export XXX's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions . about to export XXX's tables via Conventional Path ... . . exporting table CHEMISTRY 0 rows exported EXP-00091: Exporting questionable statistics. . . exporting tableCHEMISTRY_ALIAS 0 rows exported EXP-00091: Exporting questionable statistics. . . exporting table DESTINATION_PLATE_WELL 0 rows exported EXP-00091: Exporting questionable statistics. ... I check oracle document and it says: EXP-00091 Exporting questionable statistics Cause: Export was able to export statistics, but the statistics may not be useable. The statistics are questionable because one or more of the following happened during export: a row error occurred, client character set or NCHARSET does not match with the server, a query clause was specified on export, only certain partitions or subpartitions were exported, or a fatal error occurred while processing a table. Action: To export non-questionable statistics, change the client character set or NCHARSET to match the server, export with no query clause, or export complete tables. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated. So I think the problem is chararter set not matching. So how can I change client character set? Thanks, Jin -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
Re: I must get ID session, help me !!
If 8i and above then take a look at v$mystat, v$session , v$transaction. Those should help. HTH GovindanK I can't get ID current session and others info: User Name, User ID, Date, Time of session transaction from Trigger. Please help me: [EMAIL PROTECTED] or [EMAIL PROTECTED] - Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN backup and recovery scenarios
Besides you may refer to Backup Recovery by Rama Velpuri (8/8i). A bit old but nevertheless good. All said and done, create a clone database and keep crashing it in all ways you can think of, and try to recover it. That should give you the confidence , letting you know how oracle handles the internals etc. Go thru Recovery principles, Case Studies by Rama Velpuri. (Add RF's book too). Try doing the same with Standby too. HTH GovindanK My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/4/2003 11:44 AM Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: latch free wait event
When you get wait seconds 0 use TKPROF and look for statements taking time. HTH GovindanK Ehresmann, David wrote: System-wide Wait Analysis for current wait events Average Event Total SecondsTotal Wait NameWaits Waiting Timeouts (in secs) - - - - --- latch free1,459 1,393 .000 After querying v$system_event my biggest concern is the latch free wait event. I understand that latch free is the process waits for a latch that is currently busy ( held by another process).How can I drill down and find the cause of this? I have a feeling it is about rollback or redo logs. thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 600-[25012] on delete of IOT table
Take a look at the Metalink Note:125149.1 ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index As per the note it affects 8.1.(5/6/7).x It has the relevant info. Also take a look at the Docid: 287936.999. HTH GovindanK Sun solaris 8/oracle 8.1.7.2 64bit. After some database defrag(via alter table xxx move and alter index xxx rebuild), I got 600-25012 from my delete session and alert file. SQL DELETE FROM EOI_PDTLIST WHERE ROWNUM=1; DELETE FROM EOI_PDTLIST WHERE ROWNUM=1 * ERROR at line 1: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] This is index organized table with overflow segment. Maybe I foget to move that overflow segment, after move overflow segment , delete is ok. But according to metalink ,maybe there is data corruption. So I ask here if friends in this list has also hit this nasty problem too. Fri Sep 5 04:29:58 2003 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] Fri Sep 5 04:30:33 2003 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] Fri Sep 5 04:36:08 2003 I dbved the datafiles of that tablespace , nothing wrong. My account in metalink cannot open Itar now:( Thanks Zhu Chao www.cnoug.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem querying remote table through a synonym
Enable Network Tracing and check. GovindanK I'm confused, has anyone ever seen something like this before? This query works as you can see: select count(*) from [EMAIL PROTECTED]; COUNT(*) -- 275375 We execute the following DDL: DROP SYNONYM MV_USER_ENABLED_DOC_TYPE_PRIVS; CREATE SYNONYM MV_USER_ENABLED_DOC_TYPE_PRIVS FOR [EMAIL PROTECTED]; We run the following query: select count(*) from mv_user_enabled_doc_type_privs; The query hangs for over an hour before being killed. When traced it shows it is waiting for the other side to respond. On the other hand, if I do this you can see it works! 1* select count(*) from [EMAIL PROTECTED] SQL / COUNT(*) -- 0 SQL create synonym mine for [EMAIL PROTECTED]; Synonym created. SQL select count(*) from mine; COUNT(*) -- 0 The hanging behavior is true for every table in the markview schema. Allan L. Nelson Oracle DBA M-I L.L.C. (832) 295-2238 office (832) 351-4180 fax [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
Damien Your gesture is appreciated. It is a must that such solutions are shared with the list members. GovindanK Thank you very mutch for your replys, Today I finally found the problem. The traceroute shows the good route, but a Ms Proxy Client installed on the server blocked the request apparently. Just disabling it resolve everything. Damien Damien wrote: I have to do netstat -a on the webserver or on the Oracle server? Listener.ora is on the oracle server or on the webserver? I don't have any access on the oracle server and nobody can help on this side. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:14 PM The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. To see if your Win2K server listens on port 1521 open MSDOS 'box' and type: C:\netstat -n Among (many) other things you should see something of this sort: Active Connections Proto Local Address Foreign AddressState TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED You could also check contents of LISTENER.ORA file as it should list host name, protocol and listening port. You've mentioned that your problem is inability to acces database from the web server. Normally web server should be sitting in insulated DMZ environmemt, and there *should* be a firewall betweeen database and your web server. May be that's the part you are not aware of and/or not under your control, or it might happen that somebody changed firewall rules leaving your SQL*Net sessions on dry. If you do have DMZ, you should either have SQL*Net aware firewall or you could force Oracle to use static port (look for Metalink Note: 66382.1) as normally SQL*Net ports are dynamically negotiated, and only initial connection negotiation starts on port 1521. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien Babilon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 600-[25012] on delete of IOT table
Earlier post did not reach. Hence Reposting. Take a look at the Metalink Note:125149.1 ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index As per the note it affects 8.1.(5/6/7).x It has the relevant info. Also take a look at the Docid: 287936.999. HTH GovindanK Sun solaris 8/oracle 8.1.7.2 64bit. After some database defrag(via alter table xxx move and alter index xxx rebuild), I got 600-25012 from my delete session and alert file. SQL DELETE FROM EOI_PDTLIST WHERE ROWNUM=1; DELETE FROM EOI_PDTLIST WHERE ROWNUM=1 * ERROR at line 1: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] This is index organized table with overflow segment. Maybe I foget to move that overflow segment, after move overflow segment , delete is ok. But according to metalink ,maybe there is data corruption. So I ask here if friends in this list has also hit this nasty problem too. Fri Sep 5 04:29:58 2003 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] Fri Sep 5 04:30:33 2003 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] Fri Sep 5 04:36:08 2003 I dbved the datafiles of that tablespace , nothing wrong. My account in metalink cannot open Itar now:( Thanks Zhu Chao www.cnoug.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: COBOL to Oracle
I wonder how the code generator is going to take care of Multiple Record Types , Redefines clauses , Renames clause, GO to statements, Perform Thru , Declaratives? That would be interesting. GovindanK Hi List, Does anyone know of tools, or have had experience using tools, that will quickly convert COBOL code to Oracle. Any information you can provide would be greatly appreciated. Thanks in advance. Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Masters exam
Congrats Tanel on becoming OCM. GovindanK Certified DBA(8,8i,Brainbench-Master) Thanks Patrice. Yes, the exam was challenging, I've never typed and thought that fast than 5 min before end of second testing day ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 08, 2003 3:29 PM Congratulations Taner, Scott Gossett told me the exam is very challenging. (And if Scott Gossett thinks the exam is challenging...) Patrice. -Original Message- Sent: Friday, September 05, 2003 8:24 PM To: Multiple recipients of list ORACLE-L Hi! I think the new certification is Oracle Certified Master, but the old one was just Oracle Master title. I personally spent over $6000 on OCM exam which I took last year (the first public exam). I had to fly to Chicago from other side of the world, because there were no exams available elsewhere. I believe Oracle is still having problems with setting up additional test environments in other locations... If you ask, was it worth to spend the money - my personal opinion is: yes it was. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Can't query through a synonym, the solution
Nice on your part to share. Hi List Well, we figured it out. Here was the sequence of events T1 - init ora parameter dblink_encrypt_login set to true in the target database T2 - synonym created T3 - init ora parameter dblink_encrypt_login set to false in the target database The synonym created at T2 will never work again. Further if you reference that synonym you will cerate a connection to the target database that will not let you drop that synonym. Evil. Another thing to know about dblink_encrypt_login is that the Oracle Gateway products will not work with that parameter set to true. All of this just in case you ever have to deal with peach_fuzz_cheeked, checklist_toting, dumb_as_a_post auditors who want you to turn that parameter on. Allan L. Nelson Oracle DBA M-I L.L.C. (832) 295-2238 office (832) 351-4180 fax [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 600-[25012] on delete of IOT table
Apologies for not replying immediately. Was tied up with something else. Searched again on metalink advanced option for quote 8.1.7.2 IOT [25012] /quote with MATCH all (AND(++)) option . Click on Doc ID: Note:165461.1 (ie) option 4 8.1.7.X Patch Sets - List of Bug Fixes by Problem Type Search for 25012 in that and you should get quote Bug 1527982 Abstract: ORA-600 [25012] Bitmap index-table mismatch after UPDATE of PARTITION KEY moves rows Details: If a partitioned table has LOCAL BITMAP INDEXES and the partition key is updated such that the row moves to a different partition then the bitmap index is not updated correctly causing subsequent errors (eg: ORA-600 [25012]) when accessing table data via the bitmap index. This bug is generic and reported on 8.1.6.2. It has been fixed in 9i and 8.1.7.2.0. A few backports to 8.1.6.3.0 are available. To reproduce: create table bmi_test (id number(5), val varchar(5)) partition by range (id) (partition low values less than (100) tablespace users, partition high values less than (200) tablespace users) enable row movement; insert into bmi_test values (1,'red'); commit; create bitmap index bmi_test_idx on bmi_test (val) local; update bmi_test set id=100 where id=1; commit; analyze table bmi_test validate structure cascade; The last command should result in Ora-1499. Ensure that you have run the utlvalid.sql from your $ORACLE_HOME/rdbms/admin directory or else you would get ORA-14508: specified VALIDATE INTO table not found instead of an ORA-1499. quote HTH GovindanK hi, GovindanK: I searched metalink and cannot find note:287936.999 you mentioned. And I did not move the IOT index segment and overflow segment online. I did those operation during system outage. Thanks. Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 05, 2003 9:54 AM Take a look at the Metalink Note:125149.1 ALERT: ONLINE Index Rebuild or IOT Table Move can Produce Corrupt Index As per the note it affects 8.1.(5/6/7).x It has the relevant info. Also take a look at the Docid: 287936.999. HTH GovindanK Sun solaris 8/oracle 8.1.7.2 64bit. After some database defrag(via alter table xxx move and alter index xxx rebuild), I got 600-25012 from my delete session and alert file. SQL DELETE FROM EOI_PDTLIST WHERE ROWNUM=1; DELETE FROM EOI_PDTLIST WHERE ROWNUM=1 * ERROR at line 1: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] This is index organized table with overflow segment. Maybe I foget to move that overflow segment, after move overflow segment , delete is ok. But according to metalink ,maybe there is data corruption. So I ask here if friends in this list has also hit this nasty problem too. Fri Sep 5 04:29:58 2003 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] Fri Sep 5 04:30:33 2003 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_3602.trc: ORA-00600: internal error code, arguments: [25012], [15], [32], [], [], [], [], [] Fri Sep 5 04:36:08 2003 I dbved the datafiles of that tablespace , nothing wrong. My account in metalink cannot open Itar now:( Thanks Zhu Chao www.cnoug.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to send an email from unix command line?
cat filename|mailx -s subject mailid HTH GovindanK Hi List I tried the following stuff but it says Service Unavailable. $mail -s Test Subject [EMAIL PROTECTED] body line1 body line2 Ctrl-D What should i do to make email stuff work? Thanks in advance Sami __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how can I see which database I am logged into without
How about SELECT ORA_DATABASE_NAME FROM DUAL;
HTH
GovindanK
select sys_context('USERENV','DB_NAME') from anytable;
At 10:49 AM 9/10/2003 -0800, you wrote:
hi.
I think there was a dbms package to get some of
the environment variables for a session, but I can't
remember anyhting specific. If someone know what I'm
talking about and has any details, please Email me or
post here
thanks
Gene
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: GovindanK
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQL help needed
You would require something like this: http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:504432994857 HTH GovindanK Hello Listers, I need some SQL help. Not sure if this is possible in plain SQL or not, but here it is: I have a table with two columns: EMPNBR LINENBR -- --- 100 1 200 4 300 8 400 9 50014 How would I find out the missing linenbrs (2,3,5,6,7) if I was given minlinenbr as 1 and maxlinenbr as 10 that would be passed as variables (using ). Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Configuring RMAN
If $OH/bin was in the PATH then which rman would have got you the result. I think that was not the case. That's exactly why it connected to rman when you typed $OH/bin/rman. Therefore include $ORACLE_HOME/bin in the path after :/bin:/usr/sbin etc. HTH GovindanK Hi list, Recalling the yesterday problem, here is my profile, what arrangement should I do To make RMAN work from the ORACLE_HOME/bin without to specify the path. Kind of new in UNIX/LINUX. TIA, export EDITOR=vi export TERM=xterm #* # Variables de Oracle | #* export ORACLE_SID=BDRP export ORACLE_BASE=/u01/oracle/product export ORACLE_HOME=/u01/oracle/product/8.1.7 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export TNS_ADMIN=$ORACLE_HOME/network/admin export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 export ORACLE_TERM=xterm #* # Variables de Linux| #* export LD_ASSUME_KERNEL=2.2.5 #source /usr/i386-glibc21-linux/bin/i386-glibc21-linux-env.sh export JAVA_HOME=/usr/local/java export CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip:$ORACLE_HOME/jlib:$ORACLE_ H OME/rdbms/jlib:$ORACLE_HOME/network/jlib:.:$ORACLE_HOME/JRE Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Joe Testa Sent: Tuesday, September 16, 2003 2:05 PM To: Multiple recipients of list ORACLE-L your path could still be pointing elsewhere first and not the current directory. $ORACLE_HOME/bin/rman joe Ramon E. Estevez wrote: Tks Joe and Per But the same results Red Hat Linux Advanced Server release 2.1AS/i686 (Pensacola) login: oracle Password: DELL-installed Red Hat Linux Mon Aug 25 09:59:40 CDT 2003 Profile ejecutado [EMAIL PROTECTED] oracle]$ cd $ORACLE_HOME/bin [EMAIL PROTECTED] bin]$ export ORACLE_SID=BDRP [EMAIL PROTECTED] bin]$ rman [EMAIL PROTECTED] bin]$ rman rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] [EMAIL PROTECTED] bin]$ Please any help would be appreciated. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Joe Testa Sent: Tuesday, September 16, 2003 12:05 PM To: Multiple recipients of list ORACLE-L only on some OS, like linux. joe Per Berghäll wrote: Try this instead: $ORACLE_HOME/bin/rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] If you don't use $ORACLE_HOME/bin it finds another rman that exists in the O/S. Med vänliga hälsningar/ Kind regards -- *Veriba AB* Per Berghäll Brigadgatan 10 581 31 Linköping Tele: +46 (0)13-362600 Fax: +46 (0)13-362625 mailto:[EMAIL PROTECTED] _http://www.veriba.se_ http://www.veriba.se/ -- -Ursprungligt meddelande- *Från:* Ramon E. Estevez [mailto:[EMAIL PROTECTED] *Skickat:* den 16 september 2003 16:19 *Till:* Multiple recipients of list ORACLE-L *Ämne:* RE: Configuring RMAN Thanks Ruth and Belinda, That's what I'm trying to do, connect to the DB to create the catalog and register the DB. This is what I get when trying to connect to rman [EMAIL PROTECTED] oracle]$ rman rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] rman: can't open rman/[EMAIL PROTECTED] mailto:rman/[EMAIL PROTECTED] [EMAIL PROTECTED] oracle]$ TIA *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ruth Gramolini *Sent:* Tuesday, September 16, 2003 8:54 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: Configuring RMAN You have to create the catalog. Check the docs to see how to do this. In 8.1.7 I think it is simply create catalog. Then you have to register the databases you want to use this catalog for, etc. The docs are quite good. HTH, Ruth -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of* Ramon E. Estevez *Sent:* Monday, September 15, 2003 7:24 PM *To:* Multiple recipients of list ORACLE-L *Subject:* Configuring RMAN Hi list, I am implementing RMAN in an RH AS 2.1 environment on Oracle 8.1.7 and at the prompt When using rman catalog rman/[EMAIL PROTECTED] I get rman: can't open catalog I recreated the password file and the same error. TIA, *Ramon E. Estevez* [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
RE: download metalink articles - save target as
You need to cut paste. HTH GovindanK -Original Message- [EMAIL PROTECTED] Sent: Monday, September 22, 2003 11:45 AM To: Multiple recipients of list ORACLE-L When I right click on a metalink article to try to save it to a local directory and use save target as - it only provides a blank file. What's the easiest way to save these files locally? I want to because sometimes the more useful ones go away. Thanks, Paula -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Stop using SYS, SYSTEM?
grant exp_full_database to user; grant imp_full_database to user; No need for system account/dba privs to be used. HTH GovindanK Oracle Certified Professional(8,8i) Brainbench Certified Master DBA(8) We still have to use SYS and SYSTEM for database creates, full exports, imports, etc...The only thing I can see creating a dummy SYSTEM account would do is to add one more userid and dozens of new passwords to the database and more work for an already short handed staff. Ron Smith -- http://www.fastmail.fm - Sent 0.02 seconds ago -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Stop using SYS, SYSTEM?
You would require SYS to carry out tasks like 1. grant execute on dbms_package to user 2. grant select on v_$view to user Whether to have these things granted to PUBLIC is always debatable. .. .. Tell this to your auditing. And what they suggest too does not seem to hold water. HTH GovindanK Oracle Certified Professional(8,8i) Brainbench Certified Master DBA(8) On Wed, 12 Nov 2003 12:04:35 -0800, Smith, Ron L. [EMAIL PROTECTED] said: We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- http://www.fastmail.fm - Access your email from home and the web -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i- User ANONYMOUS
$OH/rdbms/admin/catqm.sql . HTH GovindanK On Thu, 13 Nov 2003 06:59:37 -0800, Senthil Kumar [EMAIL PROTECTED] said: Hi Group, Recently I have installed oracle 9i (R2). I have seen a user called ANONYMOUS which is locked. There is no documentation about this user. I have used DBCA to create the database. For what reason this user is? TIA Senthil. -- http://www.fastmail.fm - The way an email service should be -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAC listserv
http://lists.gridapp.com/mailman/listinfo.cgi/oracle-rac HTH GovindanK On Thu, 13 Nov 2003 08:09:26 -0800, Browett, Darren [EMAIL PROTECTED] said: I am looking for a RAC listserv that is active. I have signed up for one, unfortunately I can't rememer what the address is and there has been no activity, but I think there was another one that mentioned a couple of weeks ago. Thanks Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- http://www.fastmail.fm - A fast, anti-spam email service. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Need A Split File Option
$ cat myfile.dat WI auto WI Auto NY auto ny Auto Junk auto $ cp /dev/null my_file.tmp $ for pattern in wi ny do cp /dev/null $pattern_auto grep -i $pattern auto myfile.dat $pattern_auto #Repeat above command and 'accumulate' to tmp file grep -i $pattern auto myfile.dat myfile.tmp done $ ls -l *auto* -rw-r--r-- 1 govindankappdev1 16 Nov 13 11:43 ny_auto -rw-r--r-- 1 govindankappdev1 16 Nov 13 11:43 wi_auto $ more myfile.dat WI auto WI Auto NY auto ny Auto Junk auto $ more wi_auto WI auto WI Auto $ more ny_auto NY auto ny Auto $ ls -lrt *myfile* -rw-r--r-- 1 govindankappdev1 42 Nov 13 11:40 myfile.dat -rw-r--r-- 1 govindankappdev1 32 Nov 13 11:43 myfile.tmp $ more myfile.tmp WI auto WI Auto NY auto ny Auto $ diff myfile.dat myfile.tmp 5d4 Junk auto $ HTH GovindanK On Thu, 13 Nov 2003 11:24:25 -0800, Tracy Rahmlow [EMAIL PROTECTED] said: A developer in our shop would like to read an input file and based on some field values for each record in the file split them into multiple files. The output files will be used by a 3rd party package for processing. (the package does not need the oracle database) For example: Input File: record a: WI auto ... record b: WI auto ... record c: NY auto ... record d: YY home ... Output file WI_AUTO: record a: WI auto ... record b: WI auto ... Output file NY_AUTO: record c: NY auto ... Error file: record d: YY home ... (no entry in the criteria lookup table to pick up this record therefore send it to an error file) Their solution is to load an oracle table with the input file. An additional table would contain the criteria and the name of the output file to write to. They would write a procedure to read the criteria and input table and utilize the utl_file package to create the output files. There may be 50+ output files initially and likely will grow over time. My gut tells me that this does not belong in the database, rather we should be able to split the file using C or a utility such as syncsort (which we do not have). We are currently at 8.1.7.4 on AIX 4.3.3. Is there a more elegant solution and what would it be??? Are there any open source unix utilities that may help? Thanks -- http://www.fastmail.fm - Or how I learned to stop worrying and love email again -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clean temporary tablespace
8.1.6.3 SQL select status,contents,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEMP'; Extent STATUSCONTENTS Management ALLOCATIO - - -- - ONLINETEMPORARY DICTIONARY USER SQL alter tablespace TEMP default storage(pctincrease 0); Tablespace altered. SQL This will force the SMON to wake up and coalesce those segments which have been used but not freed. This will work if you are using DICT.Managed temp tablespaces. I have been using it regularly with results. HTH GovindanK On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED] said: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit) Oracle 9i DBA beginner -- http://www.fastmail.fm - Sent 0.02 seconds ago -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Clean temporary tablespace
Jared Though manual says it, in reality the SMON does not really release the TEMP segments at periodic intervals. I agree with the fact that if pcti 0 then SMON is supposed to coalesce. But the frequency with which it does may not be acceptable when compared to the rate at which the TEMP segment is getting filled. Hence i suggested this. This is mentioned in Metalink too. HTH GovindanK On Thu, 13 Nov 2003 17:19:24 -0800, [EMAIL PROTECTED] said: Actually, you need to set the PCTINCREASE to a non zero value for automatic coalescing to take place. It isn't needed in any case. Oracle will do this automatically, if needed, when an object extends. It's all in the fine concepts manual. Jared GovindanK [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/13/2003 03:54 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L ORACLE- [EMAIL PROTECTED] cc: Subject:Re: Clean temporary tablespace 8.1.6.3 SQL select status,contents,extent_management,allocation_type from dba_tablespaces where tablespace_name='TEMP'; Extent STATUSCONTENTS Management ALLOCATIO - - -- - ONLINETEMPORARY DICTIONARY USER SQL alter tablespace TEMP default storage(pctincrease 0); Tablespace altered. SQL This will force the SMON to wake up and coalesce those segments which have been used but not freed. This will work if you are using DICT.Managed temp tablespaces. I have been using it regularly with results. HTH GovindanK On Tue, 11 Nov 2003 22:24:24 -0800, VirVit [EMAIL PROTECTED] said: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- pOCELUEW wITALIJ iGOREWI^ (VirVit) Oracle 9i DBA beginner -- http://www.fastmail.fm - The way an email service should be -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Create Rule
What you essentially need to do (without any additional programming effort) is implement VPD (Virtual Private Database). The link is here: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adgsec02.htm#1009919 HTH GovindanK On Fri, 14 Nov 2003 09:49:25 -0800, Hamid Alavi [EMAIL PROTECTED] said: List, I have 50 lookup tables and all of them have effective date end date I want to create a rule or some thing like this which any select statement select the data from these lookup where the sysdate between effective date end date. Example: select * from table1 ( always select those records where sysdate between effective date end date). Any Idea? Thanks, Hamid Alavi Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- http://www.fastmail.fm - Email service worth paying for. Try it for free -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LF and CR (chr(10)||chr(13)) problem -- problem solved
Kitty , it is nice on your part to share the solution with the list. For future : (On the lines of what Stefan said) May be dd if=inputfile of=outputfile conv=ebcdic/ebcdicb/ibm/ibmb might have helped. Check with man dd. The suggestion given by Raj is worth keeping in mind. HTH GovindanK On Fri, 14 Nov 2003 08:34:25 -0800, Kitty Luo [EMAIL PROTECTED] said: Hi List, Finally, I used HexCmp and found out the file generated by Oracle PLSQL or report writer only contains a CR (chr(13)) even if I had a chr(13) and chr(10) in the query. I re-wrote my export scripts in java, then resulting file is OK. Thanks to all of you who responded my problem. Have a great weekend! Kitty -Original Message- Sent: Friday, November 14, 2003 9:09 AM To: Multiple recipients of list ORACLE-L Kitty, when the file is written by pl/sql note its size. Then open and save in notepad and note its size. If both sizes are different, you know there is a CR/LF problem, else problems is somewhere else. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Friday, November 14, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Joze, It's not that simply. I already tried all the possible combination: chr(13)||chr(10) , chr(10)||chr(13), chr(13) , chr(10)||chr(10)... Thanks for your input anyway. Regards, Kitty -Original Message- Sent: Friday, November 14, 2003 6:09 AM To: Multiple recipients of list ORACLE-L The solution is simple. The correct sequence of characters is not chr(10)||chr(13) but rather chr(13)||chr(10). This is obviously changed by notepad. regards, Joze -Original Message- Sent: Friday, November 14, 2003 5:59 AM To: Multiple recipients of list ORACLE-L Hi, Currently I am working on a project that requires me to transfer Customer Master Record data into SAP R/3 system from my oracle database (9.2.0.4 running on Solaris 5.9). The text file (contains LF and CR) generated by PLSQL or Oracle reporter builder could not be loaded into the SAP database (running on the same version of oracle database on W2K). It breaks on the CR. However, when I open the text file by notepad, do nothing, just simply save the file, re-run the data load, then everything works fine. Does anyone know anything about this? Please help. Thanks in advance. Kitty Luo Oracle DBA, OCP Onlane Inc. www.onlane.com [EMAIL PROTECTED] -- http://www.fastmail.fm - Faster than the air-speed velocity of an unladen european swallow -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 10g new features (was: dc_used_extents ,dc_free_extents and d
Yes .. that is good. GovindanK On Wed, 10 Dec 2003 13:44:34 -0800, Freeman Robert - IL [EMAIL PROTECTED] said: Excellent slide show Tanel! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 3:34 PM dc_histogram_defs) Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g. I want only to learn the new features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my presentations from: http://integrid.info/Poder_10g_New_Features.ppt Tanel. -- -- http://www.fastmail.fm - A no graphics, no pop-ups email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OffTopic : sed : Alternate (2,4,6..) replacement
Hi List I need some help on this; How do i replace the 2nd,4th,6th occurances of a column (vertical) in a file. I know sed does it within a row $ cat swt 01:this is a file1 this 02:this is a file1 this 03:this is line3 04:this is line4 $ sed 's/this/that/2' swt 01:this is a file1 that 02:this is a file1 that 03:this is line3 04:this is line4 $ sed 's/this/that/1' swt 01:that is a file1 this 02:that is a file1 this 03:that is line3 04:that is line4 But i want 01:this is a file1 this 02:that is a file1 this 03:this is line3 04:that is line4 I tried awk but awk seems to be going one line at a time. Thanks in Advance. GovindanK -- http://www.fastmail.fm - The professional email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trigger Question
Ok. Here you go. http://osi.oracle.com/~tkyte/Mutate/index.html Let me know if you find this useful. HTH GovindanK OCP 8,8i Brainbench Certified Master DBA(8) On Thu, 08 Jan 2004 11:24:25 -0800, Nuala Cullen [EMAIL PROTECTED] said: Hi All, Firstly my apologies if this seems like a very *stupid* question but I'm a tad confused (and it's late in the evening) When an AFTER INSERT trigger is fired (row level) has the row been committed to the database at this stage? If so is it ok to call a package in the trigger that selects that row and changes some values in the row? Thanks, N. -- http://www.fastmail.fm - Or how I learned to stop worrying and love email again -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to hide oracle password from a unix ps -ef | grep?
Create a dummy user dummy with pw as dummy and only with create session priv. Execute a sql script which will connect to the username/pw and which does not have read privs at os level for others. May be someone on the list has a better idea. HTH GovindanK On Fri, 16 Jan 2004 10:04:35 -0800, Ryan [EMAIL PROTECTED] said: Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it? -- http://www.fastmail.fm - Same, same, but different -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT:Legato Network Port
Hi all We are trying to restore thru RMAN/LEGATO and we run into NetWorker: Cannot bind socket to connection port in configured port range on system server.domain A quick search in google and Legato provided the following: quote The message, Cannot bind socket to connection port range on system XXX, can be seen in the savegroup messages or in stdout during manual operations. You must increase the connection port range on system XXX. A corresponding change is also required in the firewall rules. /quote I don't see any port info in the error message i got. Any ideas? TIA GovindanK -- http://www.fastmail.fm - Same, same, but different -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: (Non)Unique Index Vs Unique Constraint
Add this to what Arup said: PK enables one to have References established in a schema. (Parent Child relationships i mean). That cannot be done just by having a unique and/or not null constraints set. You will get ORA-02270: no matching unique or primary key for this column-list HTH GovindanK On Sat, 17 Jan 2004 20:49:25 -0800, Arup Nanda [EMAIL PROTECTED] said: Jay, Remember, both UK and PK are enforced by unique indexes. The important difference between them is a null value is allowed in UK, not in PK. -- http://www.fastmail.fm - Access your email from home and the web -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
