ODBC Patch 8.1.5.7 where to download
Title: ODBC Patch 8.1.5.7 where to download Hi list, I need Oracle Patch 8.1.5.7 for ODBC Driver. I haven't found it on metalink. Could someone please send me a mail with this patch or direct me to a download location? TIA regards Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
Q: about x$kglob
Title: Q: about x$kglob Hi List, I've created a view create view sys.x_$kglob as select * from sys.x$kglob; This view shows the actual running sql, include procs, functions... Q: How can I find out which session calls the SQL? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
Oracle 9.2 on Windows .NET Server
Title: Oracle 9.2 on Windows .NET Server Hi List, I have to install a Oracle 9.2 database on a Windows .NET Server (Windows 2003 Server). Anybody did this before, is it possible, are there some things I have to look for? A lot of questions, every comment is welcome. regards Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
AW: Change NLS variables in logon trigger...
Title: Nachricht Hi Helmut, did you grant "ALTER SESSION" to your database users? regards Volker Schoen INPLAN RUHR Informationstechnik GmbH Tel.: +49 208 / 65 91 - 950 Fax: +49 208 / 65 91 - 980 E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht-Von: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 30. Januar 2003 08:39An: Multiple recipients of list ORACLE-LBetreff: Change NLS variables in logon trigger... Hi there! I' having a logon trigger on 9.2.0.2 which sets DBMS_SESSION.set_nls('nls_language','''GERMAN'''); DBMS_SESSION.set_nls('nls_territory','''GERMANY'''); But I'm getting the following error message: ORA-00604: error occurred at recursive SQL level 1 ORA-04092: cannot SET NLS in a trigger ORA-06512: at "SYS.DBMS_SESSION", line 141 ORA-06512: at line 2 This trigger works perfectly fine on 7.3.4 and 8.x.x Error ORA-4092 just says that I can't do a commit or rollback in a trigger... This 9.2.0.2 on HP-UX. Any ideas? Thanks, Helmut
AW: Installer does not run on Win 2k Service Pack 3
Hi Rick, maybe you are running in the P4 bug, if your server has a P4 processor, here is the worarround: 1. Create a temporary directory on your server. 2. Copy the entire contents of the Oracle RDBMS Server CD to the temporary directory created in step 1. 3. Search the directory structure created in Step 1 for the existence of the filename symcjit.dll. 4. Rename each copy of the symcjit.dll to symcjit.old. 5. Run the setup.exe from the \install\win32 directory and install Oracle 8.1.x and related products. HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 16. Januar 2003 15:09 An: Multiple recipients of list ORACLE-L Betreff: Installer does not run on Win 2k Service Pack 3 Hi DBAs, Has anyone had trouble installing Oracle 8.x on Win 2k Service Pack 3?. When I tried installing 8.1.6 and 8.1.7 the installer does not start. Oracle 9.x installs fine. I do not know if it related to SP3 or not as I was able to install on similar server with SP 2. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: 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).
AW: Info about running procs
Thanks, this is what I'm looking for. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Reardon, Bruce (CALBBAY) [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 15. Januar 2003 02:54 An: Multiple recipients of list ORACLE-L Betreff: RE: Info about running procs Take a look at Steve Adam's http://www.ixora.com.au/scripts/sql/executing_packages.sql This script lists the packages (and other stored code objects) that are currently being executed, and the SIDs of the executing sessions. It is listed as for 8.0 / 8.1 Remember to check out the prerequisites at http://www.ixora.com.au/scripts/prereq.htm HTH, Bruce Reardon -Original Message- Sent: Wednesday, 15 January 2003 7:29 AM [EMAIL PROTECTED] wrote: Hi list, I'm looking for a Oracle system view or table where I can see all actual running procedures. Where can I find this info. TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de I think that a join between v$session (where status = 'ACTIVE') and x$kglrd should do it (join SQL_ADDRESS + SQL_HASH_VALUE to kglrdhdl + kglnadhv). You need to be SYS of course, so perhaps you'll want to create a view. Author: Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) 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: 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).
Info about running procs
Title: Info about running procs Hi list, I'm looking for a Oracle system view or table where I can see all actual running procedures. Where can I find this info. TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
AW: Sql problem
Try following: Select t.*,t.RowId , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding , CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare ,CONTRACT_SHARE_FIXED OtherShareFixed ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED /100 OtherSharePercentage ,(CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100)*2 AgentShare2 From Contract_Rows T,Contract Where Contract.Contract_Unique = t.contr_rows_contract_unique Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Zsolt Csillag [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 19. Dezember 2002 14:44 An: Multiple recipients of list ORACLE-L Betreff: Sql problem Hi, The following select does not work, I get ORA-00904 error message that the AgentShare column does not exists. It would be painful to write down every calculation many times because I can't make a reference to a previous calculated colunm. Select t.*,t.RowId , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding , CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare ,CONTRACT_SHARE_FIXED OtherShareFixed ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED /100 OtherSharePercentage ,AgentShare *2 From Contract_Rows T,Contract Where Contract.Contract_Unique = t.contr_rows_contract_unique Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag 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: 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).
OEM 9.2 and TNS_ADMIN
Title: OEM 9.2 and TNS_ADMIN Hi list, today I've installed OEM 9.2.0.2 on W2K client. When I start my OEM he recognizes path of TNS_ADMIN variable, which I've set in registry, but OEM doesn't revognize my services. If I delete TNS_ADMIN from registry and copy TNSNAMES.ORA to $ORACLE_HOME\Network\Admin everthing works fine. I have searched metalink, but couldn't find a solution. BTW SQLPlus recoginzes the TNS_ADMIN varibale. Every tip is welcome. regards Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
AW: oraperf.dll issue
Look at following site: http://www.eventid.net HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: O'Neill, Sean [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 2. Dezember 2002 12:39 An: Multiple recipients of list ORACLE-L Betreff: oraperf.dll issue 8.1.7.1.1 - W2K SP2 we're getting warning messages in the Event Viewer as follows. The data buffer created for the Oracle8 service in the C:\WINNT\system32\oraperf.dll library is not aligned on an 8-byte boundary. This may cause problems for applications that are trying to read the performance data buffer. Contact the manufacturer of this library or service to have this problem corrected or to get a newer version of this library. It's related to the Windows performance monitor but aside from that I have no idea what it is or how to address it. Does anybody have idea what this is, or the effect of it on the system if any? Can we ignore this warning or should we act on it? Any answers or suggestions are greatly appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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.com -- Author: 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).
AW: Problem installing Oracle 8.1.7 on Windows 2000
Check if a Listener Service is installed and running, if not, try to create a Listener Service with the Net8 Configuration Assistant. This doesn't solve the jrew problem, but you get your database running. HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Bishop Lewis [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 16. Oktober 2002 17:55 An: Multiple recipients of list ORACLE-L Betreff: RE: Problem installing Oracle 8.1.7 on Windows 2000 I know you're getting loads of small tips and hints rather than solutions but here's another - I've only seen jrew go to 100% cpu when there was insufficient memory available... Lewis Bishop --- Barclays Enable - ISS - E-NTRUST/Bexleyheath NT Oracle Database Consultant Watling Street, Bexleyheath, Kent, DA6 7RR (Mail Van R) Phone : 020 8298 3418 Mobile: 07950 380857 Email : [EMAIL PROTECTED] Enabling Competitive Advantage for Barclays in IT and Business Processing -Original Message- Sent: 16 October 2002 16:19 To: Multiple recipients of list ORACLE-L This header confirms that this email message has been swept for the presence of computer viruses. Corporate IT THE WOOLWICH -- Are you installing from the console? Trying to install from a terminal server session can give those kinds of problems on 2000. HTH, Beth -Original Message- Sent: Wednesday, October 16, 2002 10:34 AM To: Multiple recipients of list ORACLE-L Hi, I am installing Oracle 8.1.7 on a MS Windows 2000 SP 3 system. When I get to the Net8 Configuration assistant, process jrew.exe goes to 100% of the CPU. I have let it run for over 15 minutes before stopping it from the Oracle installer. The process stops using the CPU but the Oracle installer hangs. I have to cancel the installer. If I try to create a database, I get a TNS adapter error. I have installed 8.1.7 on Windows NT without a problem. I have opened a TAR. Anyone experience this problem? Any help will be greatly appreciated. Thanks. Larry Noble DBA Medrad Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Noble, Larry H. 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.com -- Author: Seefelt, Beth 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.com -- Author: Bishop Lewis 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.com -- Author: 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).
AW: Drop snapshot ORA-03113
Create user x, drop objects, drop user x Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Vladimir Barac [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 16. Oktober 2002 17:49 An: Multiple recipients of list ORACLE-L Betreff: Drop snapshot ORA-03113 Good day to all 8.1.7.4 Ent. edition on Windows NT4/SP5 I have performed fromuser = X / touser = Y import and (at a first glance) everything is fine, as it is supposed to be. But... I have noticed that there are some snapshots and one refresh group in database now, that belong to the user X - but user X does not exit in db where import is performed. Since I don't need those snapshots, I try to drop (as sys user) those snapshots and group and then I get ORA-03113. What is going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac 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.com -- Author: 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).
AW: LMT's and DMT's in same database?
Yes Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Farnsworth, Dave [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 9. Oktober 2002 15:54 An: Multiple recipients of list ORACLE-L Betreff: LMT's and DMT's in same database? I am going to start playing with Locally Managed Tablespaces in an existing database that has Dictionary Managed Tablespaces. Can I have both of these two tablespace types in the same database? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave 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.com -- Author: 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).
AW: Orace setting on NT
On NT you have two ways: 1. set Environment Varibale TNS_ADMIN 2. set registry value TNS_AMDIN (HKLM\Software\Oracle\HomeX) regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Gurelei [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 7. Oktober 2002 18:36 An: Multiple recipients of list ORACLE-L Betreff: Orace setting on NT Hi . This is a very easy question. I'm usually working with Oracle on UNIX, but today I need to connect to a remote instance from my NT desktop. Is there an equivalent to TNS_ADMIN varaiable in NT? ( I'm trying to force Oracle to use a specific tnsnames.ora file on my machine adn TNS_ADMIN variable is the way to do it on UNIX.) thanks for any help Gene __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei 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.com -- Author: 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).
Need Oracle education material
Title: Need Oracle education material Hi List, I have to make a Oracle training for some sysadmins, which want to administrate a Oracle database. The have neither database nor oracle specific knowledge. The main focus in this training should be, make them fit for recovering a oracle database (I know sounds like a nice joke). I have two days to train them in oracle fundamentals. What I like to show them is the structure of a oracle database (internal like SGA, PGA... and external OFA). After that I want to explain them the oracle backup and recovery concept, but only cold backup cause they use this method. Then I want to explain them some typical crash / recovery scenarios (only for Windows systems, cause their database runs on W2K). On the second day I will create some crashes, so that they have to recover the database. So, what I want to know is, is there someone on the list, who has a short documentation for such a training environment, or has some links where I can get somethng like this. Oracle documentation and training documents are a little bit to voluminous. Any help is welcome. Regards Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
AW: MS Access from Oracle
No, but the other way round is possible. Open Access MDB and link your needed oracle tables via ODBC. Then you can query both, Access and Oracle tables. Volker Schoen INPLAN RUHR Informationstechnik GmbH Tel.: +49 208 / 65 91 - 950 Fax: +49 208 / 65 91 - 980 E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Eberhard, Jeff [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 3. September 2002 22:39 An: Multiple recipients of list ORACLE-L Betreff: MS Access from Oracle Can someone tell me where to start to find out how to access an MS Access table from Oracle. Basically what I want to do is be connected to an Oracle database in SQL*Plus and execute a query against an MS-Access table. Is this possible? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
AW: Why it picks the same PFile for both the DBs
Before starting svrmgr set the oracle_sid to test or prod In command window: SET ORACLE_SID=TEST HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Naveen Nahata [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 2. September 2002 19:08 An: Multiple recipients of list ORACLE-L Betreff: Why it picks the same PFile for both the DBs Hi All, I know the problem is on NT machine, whereas most of the people in the list are working on UNIX based systems. Still any pointers will be appreciated. I have a system with 2 databases, both running on the same server. DB - 8.0.5. OS - Windows NT When i connect thru server manager to TEST, and then issue STARTUP, it starts up the PROD database using the initPROD.ora file. On querying V$instance it shows INSTANCE_NAME = TEST On querying V$database it shows NAME=PROD. So the TEST instance is mounting PROD DB using initPROD.ora When i connect to PROD and STARTUP, it starts PROD using initPROD.ora On querying V$instance it shows INSTANCE_NAME = PROD On querying V$database it shows NAME=PROD. So the PROD instance is mounting the PROD DB using initPROD.ora Why is it picking up only initPROD.ora? The following registry parameters are set... ORA_TEST_PFILE - Pointing to initTEST.ora ORA_PROD_PFILE - Pointing to initPROD.ora ORA_TEST_PWFILE - Pointing to PWDTEST.ora ORA_PROD_PWFILE - Pointing to PWDPROD.ora ORACLE_SID - PROD Though I can start the DBs easily using STARTUP pfile = 'respective_pfile', but that is not the thing. The thing is that I'm missing something, and also that I cannot start it directly through the services. What am i possibly missing?? Regards, Naveen Naveen Nahata Associate IS Email: [EMAIL PROTECTED] MindTree Consulting Pvt. Ltd. #42, Block 'A', 27th Cross, 2nd Stage, Banashankari, Bangalore - 560070 Ph: 91 (80) 6711777/6712777 Ext. 1614 Fax: 91 (80) 6714000 Web: http://www.mindtree.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
AW: Why it picks the same PFile for both the DBs
Did you check the registry settings for HKLM\Software\Oracle and HKLM\System\currentcontrolset\services? Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Naveen Nahata [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 3. September 2002 12:23 An: Multiple recipients of list ORACLE-L Betreff: RE: Why it picks the same PFile for both the DBs Hi Volker, That is OK. I can even start with STARTUP PFILE = 'appropriate_pfile'; But in this case I am unable to start it using NT Services. That is the problem. How do I get both the DBs to start by starting the services. I don't know why suddenly the problem has started coming. All registry parameters seem OK. I'm clueless. I know I'm missing something very obvious, but what is it? Regards Naveen -Original Message- Sent: Tuesday, September 03, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Before starting svrmgr set the oracle_sid to test or prod In command window: SET ORACLE_SID=TEST HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Naveen Nahata [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 2. September 2002 19:08 An: Multiple recipients of list ORACLE-L Betreff: Why it picks the same PFile for both the DBs Hi All, I know the problem is on NT machine, whereas most of the people in the list are working on UNIX based systems. Still any pointers will be appreciated. I have a system with 2 databases, both running on the same server. DB - 8.0.5. OS - Windows NT When i connect thru server manager to TEST, and then issue STARTUP, it starts up the PROD database using the initPROD.ora file. On querying V$instance it shows INSTANCE_NAME = TEST On querying V$database it shows NAME=PROD. So the TEST instance is mounting PROD DB using initPROD.ora When i connect to PROD and STARTUP, it starts PROD using initPROD.ora On querying V$instance it shows INSTANCE_NAME = PROD On querying V$database it shows NAME=PROD. So the PROD instance is mounting the PROD DB using initPROD.ora Why is it picking up only initPROD.ora? The following registry parameters are set... ORA_TEST_PFILE - Pointing to initTEST.ora ORA_PROD_PFILE - Pointing to initPROD.ora ORA_TEST_PWFILE - Pointing to PWDTEST.ora ORA_PROD_PWFILE - Pointing to PWDPROD.ora ORACLE_SID - PROD Though I can start the DBs easily using STARTUP pfile = 'respective_pfile', but that is not the thing. The thing is that I'm missing something, and also that I cannot start it directly through the services. What am i possibly missing?? Regards, Naveen Naveen Nahata Associate IS Email: [EMAIL PROTECTED] MindTree Consulting Pvt. Ltd. #42, Block 'A', 27th Cross, 2nd Stage, Banashankari, Bangalore - 560070 Ph: 91 (80) 6711777/6712777 Ext. 1614 Fax: 91 (80) 6714000 Web: http://www.mindtree.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
Oracle 8.0.5 Stand by database possible?
Title: Oracle 8.0.5 Stand by database possible? Hi list, Can I create in Oracle 8.0.5 (Windows) a Stand by database or is this option only available in Oracle 8i? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
AW: Amount of redo
You can estimate the amount of space by following formula: Number of log switches per week * size of Redo logs Number of log switches you can see in sys.v_$log_history. HTH regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Pawan Dalmia [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 14. August 2002 14:09 An: Multiple recipients of list ORACLE-L Betreff: Amount of redo Hi List, I want to put my databse in archive mode(Presently it is non archive mode).I want to estimate space that will be required for archive log taking we will be keeping one week archive on disk. How can i find out amount of redo generated in a week. Regards Pawan Dalmia Extn -5259 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
AW: It took more than an hour to update 10,000 records
What's about creating a index on columns nxx_id, npa_id ? Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 14. August 2002 15:14 An: Multiple recipients of list ORACLE-L Betreff: RE: It took more than an hour to update 10,000 records It's tough trying to help someone when they don't provide the answers to the questions from the people trying to help! -Original Message- Sent: Tuesday, August 13, 2002 11:48 PM To: Multiple recipients of list ORACLE-L Is the instance running in archive log mode? If so, Was the archiver stuck? We run into similar 'slow' response issues once in a while, when the automated archived log directory maintenance job falls behind the rate of archive log generation. - Kirti -Original Message- Sent: Tuesday, August 13, 2002 8:43 PM To: Multiple recipients of list ORACLE-L His problem is not reducing 60 sec to 20 seconds but why an hour or more was taken to update 10,000 rows. It's obvious there are other things (which I indicated in my email) that need to be sorted out to reduce the hour to few minutes. Regards, Waleed -Original Message- Sent: Tuesday, August 13, 2002 9:08 PM To: Multiple recipients of list ORACLE-L David, You don't yet know why it's slow. Why not turn tracing on for the session doing the inserts and then run tkprof on the trace file? Since the inserts seem to be taking so long, you should also be able to join v$session_wait with v$session to catch the waits in action and determine exactly what they are. You should also join v$session and v$session_event while the insert job is running. Actually, using bind variables will probably help. The insert statements will be less resource intensive and run much faster, and this will result in less contention for other sessions. My tests of insert statements with and without bind variables show that using bind variables resulted in an insert job of 27k rows running in 15 seconds and 1/100 sec of parse time. Not using bind variables required 60 seconds, 20 of which were CPU parse time. The increased run time also resulted in 3x as many buffer busy waits for other sessions trying to hit the same table. HTH Jared Nguyen, David M [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/13/2002 01:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: It took more than an hour to update 10,000 records Is there a parameter that I can tune in init.ora file to improve this process? Thanks, David -Original Message- Sent: Tuesday, August 13, 2002 2:00 PM To: Multiple recipients of list ORACLE-L Bind variables will not buy you anything. The time taken is mainly dependent on the execution plan and the cardinality of the indexes being used. Also any overhead like updating a column that's part of an index, triggers, referential constraints, etc. Waleed -Original Message- Sent: Tuesday, August 13, 2002 2:35 PM To: Multiple recipients of list ORACLE-L I run it on the server. How do I use bind variables? Thanks, David -Original Message- Sent: Tuesday, August 13, 2002 1:13 PM To: Multiple recipients of list ORACLE-L From the look of your sql statements it seems that each statement will be hard parsed because the values are different. If you will use bind variables you can save a lot of time. Is the script runs on the server or from another computer? If you run the script from another computer you also have the network time added. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 6:24 PM Hi all, I write a script to update 10,000 records in my database and noticed it took more than an hour to update 10,000 records. The script just includes 10,000 SQL update commands as shown below. Is the time too long to update 10,000 records? Is it a way to improve the update task to run faster. Please advise. *** A portion of my update script is shown below: update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 206 and npa_id = 201 and lata_id = 224; update dbimpl.npa_nxx set ported_flag = 1 where nxx_id = 207 and npa_id = 201 and lata_id = 224; Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
Virus Warning (WORM_FRETHEM.K)
Title: Virus Warning (WORM_FRETHEM.K) Hi list, I got a mail from [EMAIL PROTECTED] with subject: Re: Your password!. This mail contains a decrypt-password.exe which is infected with virus WORM_FRETHEM.K. DON'T open the exe. Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
AW: Installing an app on a French configured server
I think in 8i there is a command for altering characterset. Look in docu for alter database or alter instance. You should be careful when doing this. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Jack van Zanen [mailto:[EMAIL PROTECTED]] Gesendet: Thursday, May 23, 2002 2:38 PM An: Multiple recipients of list ORACLE-L Betreff: RE: Installing an app on a French configured server Hi Character set is choosen at database creation time (create database statement). It can not be changed later unless export recreate import is an option Jack John Dunn john.dunn@sefas.To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] co.uk cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Installing an app on a French configured server [EMAIL PROTECTED] 23-05-2002 13:28 Please respond to ORACLE-L Stephane How do we make the character set French?(WE8ISO8859P15) on our test database? (Oracle 8.1.7 Enterprise Edition running on AIX 4.3.3?). Is this something that has to be done when installing Oracle, or when creating the database(SID)? If so, how do we specify that we want this character set? Or can we change an existing installation or database? Any assistance appreciated John Dunn -Original Message- From:Stephane Faroult [SMTP:[EMAIL PROTECTED]] Sent:16 May 2002 21:24 To:Multiple recipients of list ORACLE-L Subject: Re: Installing an app on a French configured server Barry Deevey wrote: Hello all, There is a requirement to install our application at a site that will have both Oracle (8.1.7) Unix (AIX 5.1) configured in the French language. Can anybody please advise me of anything that I need to be aware of in relation to the differences between an English French configuration?? Any help is greatly appreciated. Best Regards, Barry. o Character sets (likely to be WE8ISO8859P15 in France - accents plus euro character) o Beware of tests on dates, especially if the day matters o Subtle but annoying, numbers. The default decimal character is a comma in France, and you sometimes (although rarely) meet a dot as separator for thousands. Can be a big problem when loading data from external sources - or generating files to be loaded say into Excel. And Oracle error messages in French are totally ununderstandable, even to the French. HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de
AW: OSUSER in V$SESSION capture in procedure?
Hi Eva, 1. If there is always the same osuser, why don't you use a default value. 2. Your proc couldn't work, because Select uid from dual; UID Gives you the USER_ID (number) from all_users. Then you compare OSUSER (char) with UID(number)? This should work: CREATE OR REPLACE PROCEDURE TEST(TST_HIST IN TEST_TBL%ROWTYPE) IS V_UID NUMBER; V_OSUSER BEGIN BEGIN SELECT UID INTO V_UID FROM DUAL; END; BEGIN SELECT USERNAME INTO V_OSUSER FROM ALL_USERS WHERE USER_ID := V_UID; END rest of procedure.Includes insert etc END TEST HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Denham Eva [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. Mai 2002 17:34 An: Multiple recipients of list ORACLE-L Betreff: OSUSER in V$SESSION capture in procedure? Hello Listers, I have what I hope is challenging problem. I am trying to create a procedure that execs from a trigger on a table. Simple enough. But I want to capture the OSUSER value from v$session so that the there is a history of changes to the table and by whom. Problem with using USER function is that all the users access the server via a third party app and therefore have one username. Pretty pointless for this effort then, as I could update the column in the history table with that user and be done with it. But the use of UID also does not work because that brings back a whole list of all the OSUSER value. ie CREATE OR REPLACE PROCEDURE TEST(TST_HIST IN TEST_TBL%ROWTYPE) IS V_UID NUMBER; V_OSUSER BEGIN BEGIN SELECT UID INTO V_UID FROM DUAL; END; BEGIN SELECT OSUSER INTO V_OSUSER FROM V$SESSION WHERE OSUSER := V_UID; END rest of procedure.Includes insert etc END TEST Now obviously this returns more than one row as all the users use the same username through the app. Any suggestion? Many TIA Denham Eva Oracle DBA In UNIX Land On a quiet Night, you can hear the Windows machines reboot. # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com # -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Strange problem with charactersets
Title: Strange problem with charactersets Hi list, I have a strange problem with charctersets, character display. I have a oracle 8.0.5 on HPUX, database characterset is WE8ISO8859P1. On clients we have NT 4.0 with Oracle 8.1.5 client. Everything is fine. Now I've installed a Windows 2000 PC with Oracle 8.1.7 client and here a the strange behaviours. Oracle 8.1.7 client shows instead of öäüß (german special characters) oau?. I've never seen this. Normally the special characters would be shown as unreadable signs. On client we tried these different NLS settings, but nothing works: NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 Windows 2000 territory settings are all to german. All infos are welcome. Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
AW: Strange problem with charactersets
Title: Nachricht I've executed this query, database parameters are the same on client and server. Data in the database is correct. Problem only occurs with Oracle 8.1.7 Client on Windows 2000 (on NT 4 I've haven't tested). regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht-Von: Szecsy Tamas [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 15. Mai 2002 14:58An: [EMAIL PROTECTED]; Schoen VolkerBetreff: RE: Strange problem with charactersets Execute the following query: select substr(parameter,1,30),substr(value,1,30) from sys.v_$nls_parameters order by 1; This way you will know the database`s nls settings. If the client has the same settings as the database, there will be no character conversion between the client and the database. If the characters are still displayed in a bad fashon on the client side, then data in the database is not correct andyou have to reloadit. HTH, Tamas Szecsy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 15, 2002 3:13 PMTo: Multiple recipients of list ORACLE-LSubject: Strange problem with charactersets Hi list, I have a strange problem with charctersets, character display. I have a oracle 8.0.5 on HPUX, database characterset is WE8ISO8859P1. On clients we have NT 4.0 with Oracle 8.1.5 client. Everything is fine. Now I've installed a Windows 2000 PC with Oracle 8.1.7 client and here a the strange behaviours. Oracle 8.1.7 client shows instead of öäüß (german special characters) oau?. I've never seen this. Normally the special characters would be shown as unreadable signs. On client we tried these different NLS settings, but nothing works: NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 Windows 2000 territory settings are all to german. All infos are welcome. Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
AW: Strange problem with charactersets
Title: Nachricht My problem is, that everything works fine with Oracle 8.1.5 clients, but not with oracle 8.1.7 clients using same registry and NLS settings. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht-Von: Nicolai Tufar [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 15. Mai 2002 16:03An: Multiple recipients of list ORACLE-LBetreff: Re: Strange problem with charactersets Unfortunately the only solution is to recreate the database in German character set. Oracle is very strict in this respect. Database character set once chosen can not be changed. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 15, 2002 4:13 PM Subject: Strange problem with charactersets Hi list, I have a strange problem with charctersets, character display. I have a oracle 8.0.5 on HPUX, database characterset is WE8ISO8859P1. On clients we have NT 4.0 with Oracle 8.1.5 client. Everything is fine. Now I've installed a Windows 2000 PC with Oracle 8.1.7 client and here a the strange behaviours. Oracle 8.1.7 client shows instead of öäüß (german special characters) oau?. I've never seen this. Normally the special characters would be shown as unreadable signs. On client we tried these different NLS settings, but nothing works: NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1 NLS_LANG=GERMAN_GERMANY.WE8ISO8859P15 NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15 Windows 2000 territory settings are all to german. All infos are welcome. Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
AW: pl/sql
Hi Roland, You can implent something like this: sERROR_TEXT := 'execute P1 failed'; exec P1; --- IF SQLCODE != 0 THEN sERROR_CODE := -20005; sERROR_TEXT := 'execute P1 failed. Oracle Error Number:: ORA' || SQLCODE || '-' || SQLERRM; raise DATA_ERROR; END IF; --- --- error handling --- EXCEPTION WHEN DATA_ERROR THEN --- INSERT INTO ERRORS ( ERROR_CODE, ERROR_TEXT, ADD_DATE) VALUES (sERROR_CODE, sERROR_TEXT,SYSDATE); --- WHEN OTHERS THEN --- Oracle Erros sERROR_CODE := 'ORA' || SQLCODE; sERROR_TEXT := sERROR_TEXT || ' ' || SQLERRM; --- INSERT INTO ERRORS ( ERROR_CODE, ERROR_TEXT, ADD_DATE) VALUES (sERROR_CODE, sERROR_TEXT, SYSDATE); --- HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 29. April 2002 16:54 An: Multiple recipients of list ORACLE-L Betreff: pl/sql Hallo, I have a package which includes 5 different procedures. I would like an exception which tells me an error message if any of the procedures fail. So if procedure 1 fails I would get an error message or if procedure number 2 would fail, or proc number 3 e tc then I would get an error message, which tells me which procedure that fails. I tried this, but didnt work. Just give me an easy example on this. I tried to look it up in the manual but didnt get it work. Should I put the exception after each procedureis finished. Like this: And should I name the exceptions in different ways, for instance givethem the names EXCEPTIONS1, EXCEPTIONS2 etc. p1 exception p2 exeption p3 exception p4 exception p5 exception Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
AW: SQL question
Select * from all_users Volker Schoen INPLAN RUHR E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Nguyen, David M [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 24. April 2002 18:24 An: Multiple recipients of list ORACLE-L Betreff: SQL question How do I list all user accounts created in a database? And how do I list all user table indexes? Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
AW: Using two TNSNAMES.ORA or some other solution.
Use TNS_ADMIN variable in your shell profile. Let TNS_ADMIN point to the tnsnames.ora you want to use. I don't know if it works on unix, it works on Windows. regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. April 2002 20:13 An: Multiple recipients of list ORACLE-L Betreff: Re: Using two TNSNAMES.ORA or some other solution. Just put all of the databases into every server and pc where you have a database and/or want to connect from. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 1:28 PM Hey all, In my work place, usually I do the development of Oracle database running on HP-UX platform. But I also have an Oracle server(PC) running on my PC running Windows NT. To connect to Oracle server running on my PC from Unix box, I do the following on Unix box. $export DB_LOGIN=dkumar/dkumarl@(DESCRIPTION=(ADDRESS_LIST=ADDRESS=COMMUNITY=tcp.wor ld)(PROTOCOL=TCP)(Host=10.110.1 44.73)(Port=1521)))(CONNECT_DATA=(SID=DHARM))) $ sqlplus $DB_LOGIN and I am able to connect to sqlplus session without any problem. The reason I do this because I do not have permission to changes the tnsnames.ora file on the Unix box.. So the access to oracle server (PC) works fine using client sqlplus from Unix box. But the problem is that if use the utilities like sqlloader, import and export and tries to connect Oracle Server (PC), this approach does not work as the following lines show it. $sqlldr userid=$DB_LOGIN LRM-00116: syntax error at 'dkumar/dkumar@(D' following '=' SQL*Loader: Release 8.1.6.2.0 - Production on Tue Apr 16 12:18:24 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. SQL*Loader-100: Syntax error on command-line So let me know if there is a way by which I can use two tnsnames.ora on Unix box and if that is possible then I can set description for Oracle server (PC) in the second file because I have tested that if DB_LOGIN is set to dkumar/dkumar@corpdb where corpdb is the entry in tnsnames.ora then all the utilities work fine. If somebody has some other ideas, let me know. Thanks. Dharminder Kumar FONT SIZE = 1** 1 ** This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the author and are not endorsed by the author's employer./FONT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumar, Dharminder INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
AW: two listeners problem ???
What's about PORT 2481 for GIOP, I think you also have to use different ports for GIOP (2481 für LISTENER817 and 2482 for LISTENER816). regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Janet Linsy [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 6. April 2002 08:08 An: Multiple recipients of list ORACLE-L Betreff: two listeners problem ??? Hi, I have two databases ORCL817 and ORCL816 in version 817, 816 on the same machine Sun 5.7. I'd like to configure seperate listener for each database. I used different port, listener name (1521 and LISTENER817 for ORCL817 , 1522 and LISTENER816 for ORCL816), but somehow the listener on 1522 cannot be started. Why??? Here is the listener.ora and tnsnames.ora for both database: listener.ora for 816 = LISTENER816 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 1522)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL816) (ORACLE_HOME = /export/apps/oracle/admin/product/8.1.6) (SID_NAME = ORCL816) ) tnsnames.ora for 816 = ORCL816 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL816) ) ) listener.ora for 817 = LISTENER817 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL817) (ORACLE_HOME = /export/apps/oracle/admin/product/8.1.7) (SID_NAME = ORCL817) ) ) tnsnames.ora = ORCL817 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL817) ) ) Anyone knows what went wrong? Thank you! Janet __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
AW: Net 8 installation on a server rather than client question
Title: Nachricht Hi Ron, to use Oracle Clients from network share, copy an existing oracle client to a network share. Then edit the registry and set all parameters in HKLM/Software/Oracle to this network share. Export these settings and copy it to all your Clients which should use this oracle client.Then you have to set the path variable to oracle\bin of your network share. Also take a look at ODBC settings in the registry HKLM/Software/ODBC, there could be some links to oracle DLL's. Change the path to this DLL's to your network share. This procedure works for me with 50 Clients since 3 years. HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht-Von: Ron Cetnar [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 26. März 2002 16:18An: Multiple recipients of list ORACLE-LBetreff: Net 8 installation on a server rather than client question Question to the list. Is there was way to install Net 8 on a nt server and have client pc's execute the Net 8 from the server instead of loading Net 8 on the client's pc. To avoid installation of Net 8 on the clients. I already have the tnsnames.ora file on the server and with a bat file that updates the registry on the client to point to the server to get the tnsnames file. Currently using Net 8 ver 8.1.6 Thanks Ron *** Ron Cetnar Supervising Programmer/Analyst/DBA State University of New York at Albany MSC 100 1400 Washington Ave Albany, NY 1 Email: [EMAIL PROTECTED] Work: (518) 437-4535 Fax: (518) 437-4540 ***
AW: How Could I identify the OS user name?
Look at view v$session select username, osuser from v$session; regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 26. März 2002 14:54 An: Multiple recipients of list ORACLE-L Betreff: How Could I identify the OS user name? Hello list, I want to know how could I identify the OS user name of a user acceding an application. Is there any view/parameter that shows it?? A lot of thanks, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Direct Import of XML file
Title: Direct Import of XML file Hi list, Is there any tool in Oracle to import a xml-file direct to a database table? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
Revoke alter password frm user
Title: Revoke alter password frm user Hi list, Is it possible to revoke a oracle user the right to alter his password? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
SOLVED: URGENT: need help by point in time recovery
Hi Ray, the instance has only one data and one index tablespace. Hole database is only 1.5 gig. I solved my problem. I restored a cold backup to another instance and then I recreated my controlfile and recoverd my database in time. Then I've exported my lost table and imported it to production. Everything works fine. Thanks to all who replied Regards Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Ray Stell [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 14. Februar 2002 14:14 An: Multiple recipients of list ORACLE-L Betreff: Re: URGENT: need help by point in time recovery This reminds me of something I always wanted to try to work out. It seems like you should be able to rebuild part of a db, so that the recovery of a certain tables data would be faster. That way you don't spend the time reading all the datafiles for all the TS you don't need to recover. Could you just edit the trace control file to change the structure of the db, so that the only user TS is the one of interest? On Wed, Feb 13, 2002 at 12:32:09PM -0800, [EMAIL PROTECTED] wrote: Hi list, I have a urgent problem. One of our developers has deleted all rows of a table on production database (database of a customer from us). We have a nightly cold backup and database is running in archivelog mode. On same server we have a test instance which has same structure as prod instance, only the folders are others. What I like to do is: 1. go to production and backup controlfile to trace 2. copy the cold backup (production) from last night into this test instance folders (datafiles, controlfiles...) 3. copy archive logs of production to archive log folders from test 4. startup testinstance nomaount 5. create new controlfile with backuped controlfile from trace 6. recover database until '-dd-mm hh: 7. export deleted table and import it in production database My question is, if I make a clone of a database from a nightly cold backup, can I recover the database with newer archivelogs. Or is there any other method to get my data back (I don't have a actual export of database)? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.inplan.de http://www.inplan.de -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
URGENT: need help by point in time recovery
Title: URGENT: need help by point in time recovery Hi list, I have a urgent problem. One of our developers has deleted all rows of a table on production database (database of a customer from us). We have a nightly cold backup and database is running in archivelog mode. On same server we have a test instance which has same structure as prod instance, only the folders are others. What I like to do is: 1. go to production and backup controlfile to trace 2. copy the cold backup (production) from last night into this test instance folders (datafiles, controlfiles...) 3. copy archive logs of production to archive log folders from test 4. startup testinstance nomaount 5. create new controlfile with backuped controlfile from trace 6. recover database until '-dd-mm hh: 7. export deleted table and import it in production database My question is, if I make a clone of a database from a nightly cold backup, can I recover the database with newer archivelogs. Or is there any other method to get my data back (I don't have a actual export of database)? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de