RE: Anyone used Fail Safe for NT?

Earl I've just done it on a 2 node Win2k cluster but supporting a single database - and it REALLY was easy. Can't see any reason why it shouldn't be easy with more than one DB onthe cluster. Regards -Original Message- Sent: 05 March 2001 22:46 To: Multiple recipients of list ORACLE-L

RE:can not mount database Exclusive

Shut down the database first and startup in exclusiv mode Chhers Ganti --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are

RE: NUMBER datatype

99 This is an elementary q. If i have a col of NUMBER data type what is the last number that can be stored in this col. Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL

session commits when PC crashes

List, the oracle session will commit if the session is terminated by closing the window or re-booting the PC etc is there a way (parameter) to prevent this ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City

PLEASE HELP : Advanced replication question

Dear list ! Could not find this in the docs : itlooks like i can replicate tablesonly among schemas with same names in different DBs ( I.e i can only replicate SCOTT's objects into SCOTT schemas in remote DBs) Is this true ? If not , please advice what

RE: Oracle Licensing

As luck would have it I was evaluating the prices of Oracle and then SQL Server today. My question at this point is, what kind of prices does Microsoft charge for support, I was pretending to purchase SQL Server and noticed that no mention is made about product support. Using the "Power

Re: session commits when PC crashes

Hi Rahul ! I guess it is not like that. Unless you enable autocommit your session will not commits on PC-crash or reboots. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, March 06, 2001 3:55 PM List, the oracle session will commit

Re: Oracle Licensing

Oracle has been riding the concept of "we're oracle so you want to use our database" for a long while. I'll be one of the last to condone sql-server(as i've recently had to work with it for a client, and i talked up oracle for a while) but Mr Larry is losing market share, check out any of the

Re: Woohooo An ORA-600

As i sat around and read the kernel source code(hahaha just kidding, although some days it would be easier to do that than work with metalink), here is what metalblank came up with: Note:109595.1 ALERT: ORA-04045 and ORA-600 [4882]on startup after applying 8.1.6.1.x patch

RE: Old INACTIVE and KILLED sessions

Beware that SNIPED sessions could last forever when you limit the IDLE_TIME whether the users couldn't connect through the same connection. F.e. when you use sqlplus. Although the other profile limits work fine. Regards. -Mensaje original- De: Tim Onions [SMTP:[EMAIL PROTECTED]]

RE: Woohooo An ORA-600

Hi Joe, Thanks for this, it seems it is this exactly, as it is being reported in the alert log on every instance of a startup. Attached is the trace file for your review - looks like a complete load of rubbish to me:) Thanks for your help.. Regards Mark -Original Message- Testa Sent:

CDI-21600: A running generator or utility has failed...

Hi guys, I am getting the following (Designer 6.0, Win2000pro, 128MB RAM) generator error after generation tutorial module: CDI-21600: A running generator or utility has failed , It is Possible that the internal cache is now incosistant state. The message window after generation looks like

RE: 8.1.6.0 install problem - SOLVED! (maybe) - Follow-on

Follow-on question :: The libm module is used during the make command. Our security wonk wants to know if we only need this during install so he can delete it from the run-time system. My guess is yes we only need it for install - e.g. this is not dynamically linked at startup of either the

Re: Oracle Licensing

At 03:35 AM 3/6/01 -0800, you wrote: my .02 is the whole power unit thing is a good concept but the $$ per unit is way outta whack. the only reason i say that is its been hard for oracle to denote when people were using more than the licenses they bought were being used. I had always setup the

RE: Near-table/far-table join problem

Create a synonym for F1_V@FAR and reference the synonym in your query. Durinda -Original Message- Sent: Tuesday, March 06, 2001 6:46 AM To: Multiple recipients of list ORACLE-L We have a report running on database NEAR using table N1. This report does a join to a view in another

RE: Woohooo An ORA-600

Sorry list for the waste of bandwith there, I meant to send this direct to Joe, but forgot to change the address.. All this talk of ORA 600 's huh :0) -Original Message- Sent: Tuesday, March 06, 2001 12:21 To: Multiple recipients of list ORACLE-L Hi Joe, Thanks for this, it seems it

RE: Old INACTIVE and KILLED sessions

Yeah I saw that too, the upshot being that you cannot speed the process of scrubbing these entries from v$session as they may be doing a long running rollback, but they will no longer hold any locks.. In 8i anyway.. As PMON will pass this process on to SMON to clean the processes up.. I also

Oracle Masters program

Does it still exist? I can't find reference to it anywhere in the new www.oracle.com http://www.oracle.com layout. I am just curious - I had major problems with it when they informed me that taking Microsoft courses on NT wasn't good enough, to be certifiable as an Oracle on NT Master you had

RE: Woohooo An ORA-600

I have a similar sort of problem on 8.1.6 database which is Java enabled. Every time I startup or shutdown the database trace files are created and also errors in the alert log file. Trace file message is like this - although when I checked select * from dba_objects where object_name like

Re: Anyone used Fail Safe for NT?

This was for a single database on a Compaq cluster (active/passive) but I don't see any problems with multiple databases.. I didn't do the install of failsafe, but it looks pretty straightforward. I got called in because the database wasn't failing over to the other server in the cluster. I

bitmap index problem

Hi all, When I tried to build a bitmap index (8.1.5), I got this: ERROR at line 1: ORA-00439: feature not enabled: Bit-mapped indexes The error desc is: SQL !oerr ora 439 00439, 0, "feature not enabled: %s" // *Cause: The specified feature is not enabled. // *Action: Do not attempt to use

RE: exporting MDSYS schema from an Oracle Apps 11i database?

Somewhere in the rdbms stuff (I can't remember where anymore) there should be a script to create MDSYS and ORDSYS. These should be used instead of exp/imp. [EMAIL PROTECTED] 03/05/01 06:46PM -Original Message- From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: lundi, 5. mars

Re: bitmap index problem

Hi Leslie, What is your COMPATIBLE parameter set to in the init.ora file? -Rocky --- Leslie Lu [EMAIL PROTECTED] wrote: Hi all, When I tried to build a bitmap index (8.1.5), I got this: ERROR at line 1: ORA-00439: feature not enabled: Bit-mapped indexes The error desc is: SQL !oerr

RE: Oracle Licensing

At 04:36 PM 3/5/01 -0800, you wrote: You should be able to find it at: http://store.oracle.com Thanks. It was that simple. [sigh] Shoot me now. Dennis Taylor In any human endeavor, once you have exhausted all possibilities and have failed, there

RE: Oracle Masters program

As to whether or not it still exists...this should answer your question: http://education.oracle.com/masters/index.html -Original Message- Sent: Tuesday, 06 March, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Does it still exist? I can't find reference to it anywhere in the

RE: Oracle Licensing

At 03:00 AM 3/6/01 -0800, you wrote: As luck would have it I was evaluating the prices of Oracle and then SQL Server today. My question at this point is, what kind of prices does Microsoft charge for support, I was pretending to purchase SQL Server and noticed that no mention is made about

RE:CDI-21600: A running generator o

I faced the same problem. Just check the Oracle home in your registry. Otherwise Reinstall Designer on client machine. Cheers, -Anup -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re: Oracle Licensing

Ingres used to do that for expiration date... you had to enter an authorization string when you installed the database. It would check and refuse to come up if the software expired. Except they a) never warned you you were close to expiration b) usually shut you down around 10AM EST so

Oracle Long data type PROBLEM

Hi, I can't update or insert a table with long raw column. i have a error message : "ODBC Error Code = S1090 (buffer length) [Oracle][ODBC Oracle Driver] buffer length." thanx for your help :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: benajam lhoussain

RE: Oracle Masters program

Program still exists, although Masters requirements change somewhat frequently, and at times are misleading. For instance, I'm pursuing Enterprise Scalable Master certificate and was under the impression that only 3 Master courses were needed, including Data modeling one. To my surprise, Oracle

Hi-speed data link

Hello, For some reason, I was under the impression that it was not that unusual to achieve a data transfer rate of 100-200GB/hour over some sort of data link between separate machines. However, I am finding it hard to confirm this. There is an individual here who claims this is not practical

RE: bitmap index problem

Hi Leslie, It seems to be Standard Edition. You need EE for bitmap idx to be enabled. Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, March 06, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Hi all, When I tried to build a bitmap index (8.1.5), I got this: ERROR

What database can I migrate to for Des/2000?

I have a 7.3.4 Oracle database (called CASE) on my Sun Solaris 2.6 operating system that contains my Des/2000 R2.1 repository. I'd like to migrate the 7.3.4 CASE database to 8.1.5. My question is this: Can the Designer/2000 R2.1 repository be hosted in an 8.1.5 database? If yes, do I have to

RE: exporting MDSYS schema from an Oracle Apps 11i database?

MDSYS and the others were created automatically when I created a 8.1.7 rel 3 database on NT 4.0 sp6a. The user MDsys ownes the tables: CS_SRS, MD$ (various) OGIS_GEOMERTY_COLUMNS, OGIS_SPATIAL_REFERENCE_SYSTEMS, SDO_GEOM_METADATA_TABLE, SDO_INDEX_METADATA_TABLE, USER_CS_SYS I have not done any

RE: Oracle Licensing

Looking for a job in Oracle sales? This is a pretty convincing argument. Thanks for the additional info. Jeffery Stevenson - [EMAIL PROTECTED] on 3/6/2001 10:10 AM writes us: Well, if you don't want product updates/upgrades for Oracle then you can knock about $15K off of that $45K for

Startup / shutdown using SQLPLUS

Hi: I am trying to startup and shutdown a remote database on NT using SQLPLUS. I can shutdown alright but while attempting to startup I get ORA-12154. I am connecting as internal . What am I doing wrong? Manas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manas

Insert

Hi, What is the best way to Insert when we have '' as part of our string. I want to frame INSERT statements such as the one below, and pass on to the user. insert_customers.sql: INSERT INTO customers (customer_name) VALUES ('Sun Microsystems'); INSERT INTO customers (customer_name) VALUES

RE: What database can I migrate to for Des/2000?

Only 8.1.7 version is not supported for Des2000 repository. You can migrate the existing v7.1.3 repository without any problem with migration utility or any means of migration. should work. -Original Message- Sent: Tuesday, March 06, 2001 1:16 PM To: Multiple recipients of list ORACLE-L

Oracle Installation on DiskArray -

Hi, My company is planning to install Disk Array on Solaris. After that, I am going to install Oracle. I just wanted to know whether is there any special consideration or steps to be taken to install Oracle on this Solaris? If so what are the steps? Where can I get that steps from? I am

RE: [Q] why sequence number jump?

Or, just say, "So what"? [EMAIL PROTECTED] 03/06/01 03:13PM do ALTER SEQUENCE xxx nocache; -Original Message- Sent: Tuesday, March 06, 2001 2:35 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] We have ORACLE 8.1.6 on UNIX server. The database has been run 4 years no sequence number

rename database

Title: rename database Hello everyone - Is it possible to rename a database without recreating the controlfile? I have a feeling it isn't, but can someone verify? Thanks Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL

Marc Andreessen speaks frankly at Oracle AppsWorld / RE: Oracle Licensing

re: Andreessen says software companies, customers act as adversaries backgrounder: ---begin excerpt--- http://www.infoworld.com/articles/hn/xml/01/02/22/010222hnandreessen.xml?p=brs=4?0226mnlv (url may wrap) Thursday February 22, 2001 "NEW ORLEANS -- Marc Andreessen may have

RE: Oracle Licensing

My understanding of oracle licensing is that you pay (and pay and pay) for production, and sometimes test (kind of depends on if you are also using test as a backup of production), but not for development. So you buy support, licenses, etc. for the production boxes. Hence, the availability of

RE: rename database

Title: rename database Hi, Lisa, You can change database global name, but db_name change requires controlfile to be recreated. Vadim Gorbounov Oracle DBA -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 06, 2001 3:40 PMTo: Multiple

RE: [Q] why sequence number jump?

Sorry, overlooked this -Original Message- Sent: Tuesday, March 06, 2001 3:31 PM To: Multiple recipients of list ORACLE-L Or, just say, "So what"? [EMAIL PROTECTED] 03/06/01 03:13PM do ALTER SEQUENCE xxx nocache; -Original Message- Sent: Tuesday, March 06, 2001 2:35 PM To:

Oracle Data Guard

Hi Gang, Can anyonepoint me to some documentation for this product? Technet seems pretty limited. TIA, -Rocky __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L

RE: Oracle Licensing

That is also my understanding. You can download free stuff for 'play' purposes but not for commercial uses. Gotta pay for everything. Hey man, yachts are expensive. Jim [EMAIL PROTECTED] 03/06/01 04:02PM I just went through this with Oracle and they want $$$ for all servers you are using;

RE: Insert

Title: RE: Insert -Original Message- From: Krishna Rao K [mailto:[EMAIL PROTECTED]] Sent: mardi, 6. mars 2001 12:07 What is the best way to Insert when we have '' as part of our string. I want to frame INSERT statements such as the one below, and pass on to the user.

RE: EMPTY_CLOB() call

Title: RE: EMPTY_CLOB() call -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: lundi, 5. mars 2001 12:37 Does anyone see error ORA-600 [19942] and ORA-600 [19944] when the user try to make the function call: EMPTY_CLOB() in and update statement to

RE: Mixed case table in Pro*Cobol

Title: RE: Mixed case table in Pro*Cobol -Original Message- From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED]] Sent: mardi, 6. mars 2001 12:07 Trying to access a table via a DB_LINK. The table is mixed case so need the double quotes. SQL*Plus likes the statement but

RE: 8.1.7. Intelligent Agent

You can get it from Oracle 8.1.7. distribution - do the custom installation and install only IA. Alex Hillman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, Patrice J Sent: Tuesday, March 06, 2001 11:40 AM To: Multiple recipients of list

RE: exporting MDSYS schema from an Oracle Apps 11i database?

Title: RE: exporting MDSYS schema from an Oracle Apps 11i database? -Original Message- From: Tim Sawmiller [mailto:[EMAIL PROTECTED]] Sent: mardi, 6. mars 2001 07:25 Somewhere in the rdbms stuff (I can't remember where anymore) there should be a script to create MDSYS and

Re: Differences between CTAS and alter table MOVE

Hi If you have constraints enabled (primary, unique and referential), then CTAS approach needs reenabling them in the new table. This will take longer. But alter table does not need to disable or enable the constraints and hence alter table move would be more preferable.. Thanks Riyaj

Re: OPS on AIX/rs600

Hi! This is our precise condition! For the last month IBM guys have been 'trying to give' us the planned hardware solution!! Please let me know about ur 'journey'! For starter a. Find out how IBM plans to provide u with 'shared disks' Please let me know their response!!! b.

More Metajunk frustration (at end of a long day...)

All, For those of us paying tens to hundreds of thousands of dollars for support, can we sue Oracle for not honoring support contracts and get rich quick? Considering that it's near impossible to create a tar, is this not a valid thought? And if we can't get rich quick, can we force them to no

RE: More Metajunk frustration (at end of a long day...)

Title: RE: More Metajunk frustration (at end of a long day...) MetaLoo MetaFoo that's great.. -Original Message- From: Yosi Greenfield [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 5:16 PM To: Multiple recipients of list ORACLE-L Subject: More Metajunk frustration

RE: Oracle Licensing

What about support? No one has addressed that yet. -Original Message- Duncan Sent: Tuesday, March 06, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Eek. Yup, just looked at the licensing stuff on the website, and you seem to be right. Just did an inventory of my boxes, too,

Oracle Installation on DiskArray

Hi, Thanks to those who replied. I was wondering whether which RAID level to implement. My database is not a very critical 24x7 database. It is a development database. There are going to be only a few users accessing this database. Infact the data as such is not very important as it is

RE: 8.0 / 8i Bang for the Buck Features

Diana, Good to see you back on the list. One of the DBA's has that book and will review it for applicable performance related info. I was able to get a couple of examples from Technet where they benchmarked a procedure using bulk binds against the same procedure not using bulk binds. The same

RE: can not mount database Exclusively

try connect internal first -Original Message- Setiawan Sent: Tuesday, 6 March 2001 1:25 PM To: Multiple recipients of list ORACLE-L Hi guys, I'm a beginner in Oracle. When I try to startup database via SVRMGR , there's error : "can not mount database Exclusively" Anybody knows why

Re: bitmap index problem

Rocky, compatible is compatible=8.1.5 --- Rocky Welch [EMAIL PROTECTED] wrote: Hi Leslie, What is your COMPATIBLE parameter set to in the init.ora file? -Rocky --- Leslie Lu [EMAIL PROTECTED] wrote: Hi all, When I tried to build a bitmap index (8.1.5), I got this: ERROR at

error after creating second database

Wahai Guys, I created second database using Database Assistant on NT. There's no error when I create this 2nd DB. Then I make a host-string name 'dblokal2' for my second database. I can connect to my second db , but there's an error : the message written below : SQL conn beng/bambang@dblokal2;

RE: No record in import help me please :..(

Hi guys, Thank You Durinda.Jones Don.Jerman Dave Weber Gillies Garry Raghu Kota Ruth Gramolini Mohan, Ross And to all readers.. What I am doing now is to try write my own backup script and test it in my stand alone Sun Ultra 10 with Solaris 2.7 and Oracle 8.1.6 Thank you guys, for giving me

RE: No record in import help me please :..(

Hi, Just some thoughts - at step 7 did teddy commit after the delete - if not other users / sessions would still see the records as present. The import found some records so their must be an emp somewhere. So, try another step from your dba account (sun) of select object_name,

Re: error after creating second database

"You may need to run PUPBLD.SQL as SYSTEM" seems pretty clear to me: NT inclined: set oracle_sid=SID sqlplus connect system/manager @%ORACLE_HOME%\sqlplus\admin\pupbld.sql; REM @D:\Oracle\Ora81\sqlplus\admin\pupbld.sql quit Paul Bambang Setiawan wrote: Wahai Guys, I created second

Re: 8.0 / 8i Bang for the Buck Features

Larry, Watch out for non-unique table aliases used in a multi-tiered statement. (particularly if you're rolling statements dynamically) Query re-write needs to have the table (or inline view) aliases unique. That was the only hitch that I saw when upgrading from 7.3.4 to 8.1.6. Paul [EMAIL

Re: Connected users ??

Hi. I'm going to assume that you're running on NT and have OEM available. Try this: connect with DBA Studio expand the tree under Instance Sessions start sqlplus and run this set long 1000 set pagesize 999 select sql_text from v$sqlarea where sql_text like '%/* OracleOEM */%' / you'll

Re: Product for Field level security

Check out www.teleran.com I believe their product(s) will do what you ask. Jared On Tue, 6 Mar 2001, Mandar Ghosalkar wrote: Hi Guys, I am in need of solutions and ideas. We are developing a Datawarehouse and need to implement "Field level security". Read not Fine grained access

Re: error after creating second database

I've tried it... it works.. but my primary question not only how to fix it but why this thing happened ? Bambang Setiawan "Joseph S. Testa" [EMAIL PROTECTED] 03/07/01 11:35 READ the screen it tell you what to do: HINT: You may need to run PUPBLD.SQL as SYSTEM Does it get more

RE: How to backup entire db?

Use the OEm backup and recovery option. You can create backup databases for fall over. OEM also does exports as well as database backup (control files and archive logs etc). Clint * Clinton S. Naud * Head systems administration -Original Message- Sent: Wednesday, March