Re: Oracle vs. MySQL
Anyone here have major gripes about mySQL that oracle solved? I would not dream of developing without foreign keys/referential integrity. Oracle catches many of my programming mistakes as constraint errors before they mess things up and waste a lot of time. I don't get many constraint errors with my programs in fully debugged production environments, so I guess I might be able to get away without constraints there, but I generally would prefer not to take the chance as the consequences are more severe. However, I have not tried Postgres, which I understand is free and has referential integrity. Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gardner 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).
Re: OT: Encryption software
Witold, You could use a perl script with the blowfish module to encrypt the file and email it, and then send the user a decryption program. Perl programs can be turned into exe programs, though I think that in this case the user would be able to reverse engineer it and extract the password -- not sure if that is a problem for you. This scheme would be rather inconvenient for the end user as they would have to copy and paste or save the email and then run the program to decrypt it. Why not use an ssl-secure web server? Tim We are looking for a product that can be used to encrypt an Oracle report. In short a process will run a report, the file will be encrypted, and sent by email. And we would like to be able to use the product from command line so that the entire process can run automatically. I have already looked at products from PGP but the only product that can be used with the command line option is PGP E-business server for about $7000. The price is way too high for the volume that we will have. I started to look at other products and found a few Has anyone used an encryption product and can share experience, good and bad? Thanks Witold -- 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: Tim Gardner 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).
Re: need to recreate database
Lyuda, If the database is still running on the old server, and the disk structure is the same on the new server, the easiest way is to do an export of the old database and an import with full=Y on the new server. If the database was shut down before the files were copied, this should also work, but you will need to set up the SID on the new server and have the init.ora point to the copied files. Tim I need to recreate a database, basically make a complete copy of one of the existing databases on a new server. My networking people already copied all datafiles, control file, log files, init file, etc to the target server. They also reproduced operating system directory structure. What I need to do is to make the second part of the task work, create the database, services, etc and make it run. I have not done it before and if I was doing it I would probably do export/import type of thing but the higher ups would like to have it done this way. One of the people has an idea suggesting just recreating the registry setting by exporting it from the existing machine to the new one. The other option is to reinstall Oracle but I am not sure how to make it to accept existing physical components(datafiles, control file, etc). If someone has a suggestion I would greatly appreciate it. Thank you in advance. Lyuda Hoska -- Please see the official ORACLE-L FAQ: http://www.orafaq.comhttp://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: Tim Gardner 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).
Re: OFA (Optimal Flexible Architecture) in practice
Does anyone use OFA as their company standard? If so, are there any complaints about it's structure? For example, the commingling of different database subdirectories under a given mount point? e.g.. /u02/oradata/db_name1/userdata01.dbf /u02/oradata/db_name2/userdata01.dbf /u03/oradata/db_name1/userdata02.dbf /u03/oradata/db_name2/userdata02.dbf You cannot cd to a given subdirectory, ls -ltR | more to see all the datafiles associated with a given database. Instead, from / you have to ls -ltR | grep db_name1 to scan the full file system. Seems like there should be a better way. Any input, pro or con, is appreciated. Linda, The point of OFA is to spread out the database over different drives for performance reasons. For example, you might want to separate indexes from data. Would what you are proposing allow for multiple drives? Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gardner 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).
Re: Multiple Oracle Instances on NT
Lisa, I have worked exclusively with Oracle on Unix, but not at all with Oracle on NT. Our users have come to us with a requirement to run an application with their database on NT. They want to build both a test and production environment on the same NT box. I would like to know some basics about running Oracle on NT - can you run multiple instances of Oracle on one NT machine - if so, what do I need to look out for (ie. what things are different that a Unix installation) - are any of the processes, etc. drastically different - ie. security, networking, logging - what type of system requirements (ie. memory, CPU) are needed on NT Thanks for any help you can give me! I run many instances on an NT box for development (not production) use. Whenever I get a new job for a new client, I build a new instance for developing the application. It works fine on a low-end system for development purposes. In a recent post (19:18 -0400 6/20/01) I described what I do to create an instance on NT: When I create a new instance under NT, I do this: set ORACLE_SID=newsid c:\ORANT\bin\oradim80 -new -sid newsid -intpwd newsid -startmode auto -pfile f:\ORANTdb\newsid\init.ora c:\ORANT\bin\oradim80 -startup -sid newsid -starttype srvc,inst -usrpwd newsid -pfile f:\ORANTdb\newsid\init.ora c:\ORANT\bin\svrmgr30 @f:\ORANTdb\newsid\run1.sql c:\ORANT\bin\svrmgr30 @f:\ORANTdb\newsid\run2.sql where run1.sql is: spool c:\ORANT\database\spoolmain set echo on connect INTERNAL/newsid startup nomount pfile=f:\ORANTdb\newsid\init.ora CREATE DATABASE newsid LOGFILE 'f:\ORANTdb\newsid\log1.ora' SIZE 1024K, 'f:\ORANTdb\newsid\log2.ora' SIZE 1024K MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXLOGHISTORY 1 DATAFILE 'f:\ORANTdb\newsid\Sys1.ora' SIZE 50M MAXDATAFILES 254 MAXINSTANCES 1 CHARACTER SET WE8ISO8859P1 NATIONAL CHARACTER SET WE8ISO8859P1; spool off and run2.sql is: spool c:\ORANT\database\spoolmain set echo on connect INTERNAL/newsid ALTER DATABASE DATAFILE 'f:\ORANTdb\newsid\Sys1.ora' AUTOEXTEND ON; CREATE ROLLBACK SEGMENT SYSROL TABLESPACE SYSTEM STORAGE (INITIAL 100K NEXT 100K); ALTER ROLLBACK SEGMENT SYSROL ONLINE; @c:\ORANT\Rdbms80\admin\catalog.sql; @c:\ORANT\Rdbms80\admin\catproc.sql @c:\ORANT\Rdbms80\admin\caths.sql spool off Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gardner 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).
new instances on Linux different from NT?
I'm trying to figure out how to create new instances on Red Hat Linux. Can anyone tell me the Linux commands that correspond to the following: When I create a new instance under NT, I do this: set ORACLE_SID=newsid c:\ORANT\bin\oradim80 -new -sid newsid -intpwd newsid -startmode auto -pfile f:\ORANTdb\newsid\init.ora c:\ORANT\bin\oradim80 -startup -sid newsid -starttype srvc,inst -usrpwd newsid -pfile f:\ORANTdb\newsid\init.ora c:\ORANT\bin\svrmgr30 @f:\ORANTdb\newsid\run1.sql c:\ORANT\bin\svrmgr30 @f:\ORANTdb\newsid\run2.sql where run1.sql is: spool c:\ORANT\database\spoolmain set echo on connect INTERNAL/newsid startup nomount pfile=f:\ORANTdb\newsid\init.ora CREATE DATABASE newsid LOGFILE 'f:\ORANTdb\newsid\log1.ora' SIZE 1024K, 'f:\ORANTdb\newsid\log2.ora' SIZE 1024K MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXLOGHISTORY 1 DATAFILE 'f:\ORANTdb\newsid\Sys1.ora' SIZE 50M MAXDATAFILES 254 MAXINSTANCES 1 CHARACTER SET WE8ISO8859P1 NATIONAL CHARACTER SET WE8ISO8859P1; spool off and run2.sql is: spool c:\ORANT\database\spoolmain set echo on connect INTERNAL/newsid ALTER DATABASE DATAFILE 'f:\ORANTdb\newsid\Sys1.ora' AUTOEXTEND ON; CREATE ROLLBACK SEGMENT SYSROL TABLESPACE SYSTEM STORAGE (INITIAL 100K NEXT 100K); ALTER ROLLBACK SEGMENT SYSROL ONLINE; @c:\ORANT\Rdbms80\admin\catalog.sql; @c:\ORANT\Rdbms80\admin\catproc.sql @c:\ORANT\Rdbms80\admin\caths.sql spool off Thanks, Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gardner 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).