Re: Server upgrade NT4 -> W2K Oracle implications
under the original scenario, presumably one would deinstall oracle before upgrading from NT4 to win2k, and then reinstall it after win2k is in place. - another possible alternative: (first: backup backup backup) variation on the test box theme: add an additional hard drive to install win2k dual boot, reinstall oracle on the win2k partition as a test, and point it at the database (a test instance?) on the other drive and see if it works? if you are anal about security (or what passes for security in the MS world), NT4 to Win2k upgrade is more difficult to "secure" . doing a clean win2k install and exportin/importing your database is probable a good idea, but may not strictly be necessary. there is a vast amount of info on the net about NT4 upgrade to Win2k vs clean Win2K install. my impression is that to really exploit the more advanced capabilities of Wink, it is considered better to do a clean install. regards, ep On 9 May 2002 at 16:53, [EMAIL PROTECTED] wrote: Date sent: Thu, 09 May 2002 16:53:52 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sounds good in theory. > > What if the upgrade destroys some DLL in the SYSTEM32 directory that > Oracle is dependent on? > > There may be none Oracle registry entries set such as: > > HKLM\SYSTEM\CurrentControlSet\Control\WaitToKillServiceTimeout > > This is sometimes set to a much higher than default value to > allow Oracle to shutdown properly without getting killed by NT. > > > Sounds like something that should be tested on a non-critical > system first. > > Jared > > > > > > > "O'Neill, Sean" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 05/09/2002 03:47 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:Server upgrade NT4 -> W2K Oracle implications > > > We have an 8.1.7 SE database on a server which is currently NT4 SP6. The > System Admin group wish to upgrade the server to W2K and propose doing so > by > recreating the C: partitition. Our Oracle software resides on E: (same > physical disk) and database files on other disks/partitions. Are there > any > implications for the Oracle software and database for this upgrade. Are > there any steps I need to take pre or post OS upgrade?. In particular I'm > wondering about implications for the registry. > Any advice/help would be 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 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: Eric D. Pierce 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] (no
RE: Cannot import--URGENT
Ok, first, do not do imports/exports as sys. The last thing you every want to do is move around sys's tables. Second, did sys truly own the tables? Hopefully not. I hate to hear you have non data dictionary tables owned by sys in a production database. Course there are those certain pesky little third party tools that sometimes make you do that but just don't use them. The fact that you are using different character sets is no biggy. Ignore that comment. It would be an issue if say you were storing Japanese characters in one database and you were not setup to accept them on the other. For the most part its not a concern. I leave it to you to do your own research on that to see if it truly is an issue. Seeing as how there are truly no errors in you import I keep going back to the fact that sys is not the original owner of the table. So it tried to import sys's tables into ravi and there were none so all is good. Unless you are starting/shutting your database or rerunning any catalog related scripts (for upgrades or whatever) you need to forget the fact you know the sys password. Course there are the occasional grants that need to be done as well but really question why you are signing on as sys and whether or not it can be done as another user in the database. -Original Message- Rafiq Sent: Saturday, May 11, 2002 8:48 PM To: Multiple recipients of list ORACLE-L I was having similar problem with one of our table while exporting using direct=y. No error either from export or while importing but no record with data inserted although doing count it was giving right count. Solution was to export that particular table with conventional path i.e. not using direct while export. But in your case , it looks your not using direct=y right. Oracle support could not figure it out this problem. Platform for export and import was HP-UX 11. export version 8.1.6.2 and importing to 8.1.7.2 database. Anyhow it was problem was with export as size of dmp file size was visibly totally different. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Sat, 11 May 2002 19:08:25 -0800 Ravindra - Just from looking at your error messages, it sounds like the two Oracle systems have different character sets. I would check this out if I were you. The other thing to check for is whether the tables are created in a different schema than you are expecting. As SYS or SYSTEM, select owner from dba_tables where table_name = 'MYTABLE'; If the table was actually created, but in a different schema, this query should tell you where. Again, these are just a couple of ideas for you to look into, and the other people who have replied have also given you some good ideas to look into. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, May 11, 2002 8:23 PM To: Multiple recipients of list ORACLE-L I am trying to import from my production database to another database.Table level export was done on the production databse for 4 table.It ended w/o any errors. When I am trying to import to anther user on a different datasbe the import compltes successfully without any warning but no table/records are imported The tables being imported are not existing in the new user's schema. I have tried this on 8.1.7 to 8.1.7 and also on 8.1.7 to 9.0.1. These tables on the production database are protected so I can export them only as sys user.I am attaching the log from the import.What is the problem. Am i missing anything imp sys/change_on_install fromuser=sys touser=ravi file=g.dmp log=g.log Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production Export file created by EXPORT:V08.01.07 via conventional path import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) export server uses US7ASCII NCHAR character set (possible ncharset conversion) Import terminated successfully without warnings. Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://w
RE: Cannot import--URGENT
I was having similar problem with one of our table while exporting using direct=y. No error either from export or while importing but no record with data inserted although doing count it was giving right count. Solution was to export that particular table with conventional path i.e. not using direct while export. But in your case , it looks your not using direct=y right. Oracle support could not figure it out this problem. Platform for export and import was HP-UX 11. export version 8.1.6.2 and importing to 8.1.7.2 database. Anyhow it was problem was with export as size of dmp file size was visibly totally different. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Sat, 11 May 2002 19:08:25 -0800 Ravindra - Just from looking at your error messages, it sounds like the two Oracle systems have different character sets. I would check this out if I were you. The other thing to check for is whether the tables are created in a different schema than you are expecting. As SYS or SYSTEM, select owner from dba_tables where table_name = 'MYTABLE'; If the table was actually created, but in a different schema, this query should tell you where. Again, these are just a couple of ideas for you to look into, and the other people who have replied have also given you some good ideas to look into. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, May 11, 2002 8:23 PM To: Multiple recipients of list ORACLE-L I am trying to import from my production database to another database.Table level export was done on the production databse for 4 table.It ended w/o any errors. When I am trying to import to anther user on a different datasbe the import compltes successfully without any warning but no table/records are imported The tables being imported are not existing in the new user's schema. I have tried this on 8.1.7 to 8.1.7 and also on 8.1.7 to 9.0.1. These tables on the production database are protected so I can export them only as sys user.I am attaching the log from the import.What is the problem. Am i missing anything imp sys/change_on_install fromuser=sys touser=ravi file=g.dmp log=g.log Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production Export file created by EXPORT:V08.01.07 via conventional path import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) export server uses US7ASCII NCHAR character set (possible ncharset conversion) Import terminated successfully without warnings. Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Cannot import--URGENT
Ravindra - Just from looking at your error messages, it sounds like the two Oracle systems have different character sets. I would check this out if I were you. The other thing to check for is whether the tables are created in a different schema than you are expecting. As SYS or SYSTEM, select owner from dba_tables where table_name = 'MYTABLE'; If the table was actually created, but in a different schema, this query should tell you where. Again, these are just a couple of ideas for you to look into, and the other people who have replied have also given you some good ideas to look into. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, May 11, 2002 8:23 PM To: Multiple recipients of list ORACLE-L I am trying to import from my production database to another database.Table level export was done on the production databse for 4 table.It ended w/o any errors. When I am trying to import to anther user on a different datasbe the import compltes successfully without any warning but no table/records are imported The tables being imported are not existing in the new user's schema. I have tried this on 8.1.7 to 8.1.7 and also on 8.1.7 to 9.0.1. These tables on the production database are protected so I can export them only as sys user.I am attaching the log from the import.What is the problem. Am i missing anything imp sys/change_on_install fromuser=sys touser=ravi file=g.dmp log=g.log Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production Export file created by EXPORT:V08.01.07 via conventional path import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) export server uses US7ASCII NCHAR character set (possible ncharset conversion) Import terminated successfully without warnings. Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS 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: Cannot import--URGENT
How was the export created? Do you have the output from the export, or the script that created it? -Joe --- Ravindra B <[EMAIL PROTECTED]> wrote: > I am trying to import from my production database to another > database.Table level export > was done on the production databse for 4 table.It ended w/o any > errors. > > When I am trying to import to anther user on a different datasbe > the import compltes > successfully without any warning but no table/records are imported > The tables being imported are not existing in the new user's > schema. > I have tried this on 8.1.7 to 8.1.7 and also on 8.1.7 to 9.0.1. > > These tables on the production database are protected so I can > export them > only as sys user.I am attaching the log from the import.What is the > problem. > Am i missing anything > > imp sys/change_on_install fromuser=sys touser=ravi file=g.dmp > log=g.log > > Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - > Production > With the Partitioning option > JServer Release 9.0.1.1.1 - Production > > Export file created by EXPORT:V08.01.07 via conventional path > import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR > character set > export client uses WE8ISO8859P1 character set (possible charset > conversion) > export server uses US7ASCII NCHAR character set (possible ncharset > conversion) > Import terminated successfully without warnings. > > Ravindra > __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: Cannot import--URGENT
Ravi, Why is your fromuser=sys? Are you specifying a parfile anywhere? Jack --- Ravindra B <[EMAIL PROTECTED]> wrote: > I am trying to import from my production database to > another database.Table level export > was done on the production databse for 4 table.It > ended w/o any errors. > > When I am trying to import to anther user on a > different datasbe the import compltes > successfully without any warning but no > table/records are imported > The tables being imported are not existing in the > new user's schema. > I have tried this on 8.1.7 to 8.1.7 and also on > 8.1.7 to 9.0.1. > > These tables on the production database are > protected so I can export them > only as sys user.I am attaching the log from the > import.What is the problem. > Am i missing anything > > imp sys/change_on_install fromuser=sys touser=ravi > file=g.dmp log=g.log > > Connected to: Oracle9i Enterprise Edition Release > 9.0.1.1.1 - Production > With the Partitioning option > JServer Release 9.0.1.1.1 - Production > > Export file created by EXPORT:V08.01.07 via > conventional path > import done in WE8MSWIN1252 character set and > AL16UTF16 NCHAR character set > export client uses WE8ISO8859P1 character set > (possible charset conversion) > export server uses US7ASCII NCHAR character set > (possible ncharset conversion) > Import terminated successfully without warnings. > > Ravindra > __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey 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).
Cannot import--URGENT
I am trying to import from my production database to another database.Table level export was done on the production databse for 4 table.It ended w/o any errors. When I am trying to import to anther user on a different datasbe the import compltes successfully without any warning but no table/records are imported The tables being imported are not existing in the new user's schema. I have tried this on 8.1.7 to 8.1.7 and also on 8.1.7 to 9.0.1. These tables on the production database are protected so I can export them only as sys user.I am attaching the log from the import.What is the problem. Am i missing anything imp sys/change_on_install fromuser=sys touser=ravi file=g.dmp log=g.log Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - ProductionWith the Partitioning optionJServer Release 9.0.1.1.1 - Production Export file created by EXPORT:V08.01.07 via conventional pathimport done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character setexport client uses WE8ISO8859P1 character set (possible charset conversion)export server uses US7ASCII NCHAR character set (possible ncharset conversion)Import terminated successfully without warnings. Ravindra
