Re: question about migrating to 9i
Hi! Yes, the problem with own scipts was, that they tended go get old, especially when the same Oracle7 scripts were used for creating 8i databases etc.. Novadays there's lot more to do than just run create, catalog catproc to create a full blown database. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 11, 2003 4:24 AM Faan, Thanks. After auto creation of script I changed it according to our own requirement and it is a really nice features. The other databases we added afterword we used the same scripts adter some changes. No need to keep our own scripts all the time. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 10 Sep 2003 16:34:42 -0800 Dennis and Rafiq, When you use the dbca you are prompted for this option at the end i.e. create scripts or create the DB. I HIGHLY recommend you go with the 'create script' option as this allows you to QA the Oracle Intelligence before kicking it off. It also serves as a good tutorial on what is involved in creating a Oracle DB without studying the interesting Oracle docs...;-) -f -Original Message- Sent: Wednesday, September 10, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Dennis, There is an option to just create a script for you based on your critaria and then you can modify it according to your requirement before creating the database. I think I used this almost 1 year back so don't remember exactly at what stage it ask for this option... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 09 Sep 2003 17:49:27 -0800 Ryan dbca is indeed available with Solaris. I used it today in fact. What I've learned about it is: - It runs in X-Windows. I don't have much expertise with X-Windows, but it seems to run fine from the Solaris console. - Unable to create a block size greater than 8k, at least what I've found. I believe the reason is that dbca doesn't create the data files, but has precreated files it just copies into place. That's my theory anyway. - All data files are created with autoextend on. But you can change that later. - The database is created with spfile which I don't like but it is easy enough to CREATE PFILE FROM SPFILE. - I am usually a skeptic of GUI tools, but I am really impressed with this tool. One alternative you could suggest to your production people is for them to use dbca on a test system to create a database close to the one you want. Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great script (two versions in one, actually) that you can review, edit, etc. This is an easy way to implement the 9i features you list without studying the manual for the syntax for each feature. Good luck, we production DBAs can be a touchy lot. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 5:55 PM To: Multiple recipients of list ORACLE-L they are doing it by hand i believe. no dbca. its a solaris system. dont think there is a dbca for solaris? Im not a production dba, so i dont know for certain,. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:14 PM Ryan If you (or whoever) is using dbca, I believe all this is configured automatically. But watch the block size. That is the only thing you can't change later. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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
Re: question about migrating to 9i
Tanel, Thanks. By the way congrat for becoming an OCM Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 11 Sep 2003 03:19:24 -0800 Hi! Yes, the problem with own scipts was, that they tended go get old, especially when the same Oracle7 scripts were used for creating 8i databases etc.. Novadays there's lot more to do than just run create, catalog catproc to create a full blown database. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 11, 2003 4:24 AM Faan, Thanks. After auto creation of script I changed it according to our own requirement and it is a really nice features. The other databases we added afterword we used the same scripts adter some changes. No need to keep our own scripts all the time. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 10 Sep 2003 16:34:42 -0800 Dennis and Rafiq, When you use the dbca you are prompted for this option at the end i.e. create scripts or create the DB. I HIGHLY recommend you go with the 'create script' option as this allows you to QA the Oracle Intelligence before kicking it off. It also serves as a good tutorial on what is involved in creating a Oracle DB without studying the interesting Oracle docs...;-) -f -Original Message- Sent: Wednesday, September 10, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Dennis, There is an option to just create a script for you based on your critaria and then you can modify it according to your requirement before creating the database. I think I used this almost 1 year back so don't remember exactly at what stage it ask for this option... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 09 Sep 2003 17:49:27 -0800 Ryan dbca is indeed available with Solaris. I used it today in fact. What I've learned about it is: - It runs in X-Windows. I don't have much expertise with X-Windows, but it seems to run fine from the Solaris console. - Unable to create a block size greater than 8k, at least what I've found. I believe the reason is that dbca doesn't create the data files, but has precreated files it just copies into place. That's my theory anyway. - All data files are created with autoextend on. But you can change that later. - The database is created with spfile which I don't like but it is easy enough to CREATE PFILE FROM SPFILE. - I am usually a skeptic of GUI tools, but I am really impressed with this tool. One alternative you could suggest to your production people is for them to use dbca on a test system to create a database close to the one you want. Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great script (two versions in one, actually) that you can review, edit, etc. This is an easy way to implement the 9i features you list without studying the manual for the syntax for each feature. Good luck, we production DBAs can be a touchy lot. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 5:55 PM To: Multiple recipients of list ORACLE-L they are doing it by hand i believe. no dbca. its a solaris system. dont think there is a dbca for solaris? Im not a production dba, so i dont know for certain,. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:14 PM Ryan If you (or whoever) is using dbca, I believe all this is configured automatically. But watch the block size. That is the only thing you can't change later. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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
RE: question about migrating to 9i
I was told by one Oracle instructor that new features of 9i, including Oracle Managed Files, could allow you to create a viable production database by simply typing CREATE DATABASE -- once the init.ora (SPFILE?) was created and the hardware layed out properly. Perhaps not something many will use, but it could be one of those good and nasty over-simplified marketing tools. :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: question about migrating to 9i
Hi! Actually you can issue just create database with non-OMF configuration in 9i as well. The command creates files like log1orcl.ora, log2orcl.ora, dbsorcl.ora, und1orcl.ora under $OH/dbs (or $OH/database as I tested on windows with 9.2.0.4). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 6:39 PM I was told by one Oracle instructor that new features of 9i, including Oracle Managed Files, could allow you to create a viable production database by simply typing CREATE DATABASE -- once the init.ora (SPFILE?) was created and the hardware layed out properly. Perhaps not something many will use, but it could be one of those good and nasty over-simplified marketing tools. :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: question about migrating to 9i
Dennis, There is an option to just create a script for you based on your critaria and then you can modify it according to your requirement before creating the database. I think I used this almost 1 year back so don't remember exactly at what stage it ask for this option... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 09 Sep 2003 17:49:27 -0800 Ryan dbca is indeed available with Solaris. I used it today in fact. What I've learned about it is: - It runs in X-Windows. I don't have much expertise with X-Windows, but it seems to run fine from the Solaris console. - Unable to create a block size greater than 8k, at least what I've found. I believe the reason is that dbca doesn't create the data files, but has precreated files it just copies into place. That's my theory anyway. - All data files are created with autoextend on. But you can change that later. - The database is created with spfile which I don't like but it is easy enough to CREATE PFILE FROM SPFILE. - I am usually a skeptic of GUI tools, but I am really impressed with this tool. One alternative you could suggest to your production people is for them to use dbca on a test system to create a database close to the one you want. Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great script (two versions in one, actually) that you can review, edit, etc. This is an easy way to implement the 9i features you list without studying the manual for the syntax for each feature. Good luck, we production DBAs can be a touchy lot. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 5:55 PM To: Multiple recipients of list ORACLE-L they are doing it by hand i believe. no dbca. its a solaris system. dont think there is a dbca for solaris? Im not a production dba, so i dont know for certain,. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:14 PM Ryan If you (or whoever) is using dbca, I believe all this is configured automatically. But watch the block size. That is the only thing you can't change later. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Ryan 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: DENNIS WILLIAMS 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). _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official
RE: question about migrating to 9i
Dennis and Rafiq, When you use the dbca you are prompted for this option at the end i.e. create scripts or create the DB. I HIGHLY recommend you go with the 'create script' option as this allows you to QA the Oracle Intelligence before kicking it off. It also serves as a good tutorial on what is involved in creating a Oracle DB without studying the interesting Oracle docs...;-) -f -Original Message- Sent: Wednesday, September 10, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Dennis, There is an option to just create a script for you based on your critaria and then you can modify it according to your requirement before creating the database. I think I used this almost 1 year back so don't remember exactly at what stage it ask for this option... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 09 Sep 2003 17:49:27 -0800 Ryan dbca is indeed available with Solaris. I used it today in fact. What I've learned about it is: - It runs in X-Windows. I don't have much expertise with X-Windows, but it seems to run fine from the Solaris console. - Unable to create a block size greater than 8k, at least what I've found. I believe the reason is that dbca doesn't create the data files, but has precreated files it just copies into place. That's my theory anyway. - All data files are created with autoextend on. But you can change that later. - The database is created with spfile which I don't like but it is easy enough to CREATE PFILE FROM SPFILE. - I am usually a skeptic of GUI tools, but I am really impressed with this tool. One alternative you could suggest to your production people is for them to use dbca on a test system to create a database close to the one you want. Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great script (two versions in one, actually) that you can review, edit, etc. This is an easy way to implement the 9i features you list without studying the manual for the syntax for each feature. Good luck, we production DBAs can be a touchy lot. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 5:55 PM To: Multiple recipients of list ORACLE-L they are doing it by hand i believe. no dbca. its a solaris system. dont think there is a dbca for solaris? Im not a production dba, so i dont know for certain,. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:14 PM Ryan If you (or whoever) is using dbca, I believe all this is configured automatically. But watch the block size. That is the only thing you can't change later. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Ryan 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: question about migrating to 9i
Faan, Thanks. After auto creation of script I changed it according to our own requirement and it is a really nice features. The other databases we added afterword we used the same scripts adter some changes. No need to keep our own scripts all the time. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wed, 10 Sep 2003 16:34:42 -0800 Dennis and Rafiq, When you use the dbca you are prompted for this option at the end i.e. create scripts or create the DB. I HIGHLY recommend you go with the 'create script' option as this allows you to QA the Oracle Intelligence before kicking it off. It also serves as a good tutorial on what is involved in creating a Oracle DB without studying the interesting Oracle docs...;-) -f -Original Message- Sent: Wednesday, September 10, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Dennis, There is an option to just create a script for you based on your critaria and then you can modify it according to your requirement before creating the database. I think I used this almost 1 year back so don't remember exactly at what stage it ask for this option... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 09 Sep 2003 17:49:27 -0800 Ryan dbca is indeed available with Solaris. I used it today in fact. What I've learned about it is: - It runs in X-Windows. I don't have much expertise with X-Windows, but it seems to run fine from the Solaris console. - Unable to create a block size greater than 8k, at least what I've found. I believe the reason is that dbca doesn't create the data files, but has precreated files it just copies into place. That's my theory anyway. - All data files are created with autoextend on. But you can change that later. - The database is created with spfile which I don't like but it is easy enough to CREATE PFILE FROM SPFILE. - I am usually a skeptic of GUI tools, but I am really impressed with this tool. One alternative you could suggest to your production people is for them to use dbca on a test system to create a database close to the one you want. Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great script (two versions in one, actually) that you can review, edit, etc. This is an easy way to implement the 9i features you list without studying the manual for the syntax for each feature. Good luck, we production DBAs can be a touchy lot. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 5:55 PM To: Multiple recipients of list ORACLE-L they are doing it by hand i believe. no dbca. its a solaris system. dont think there is a dbca for solaris? Im not a production dba, so i dont know for certain,. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:14 PM Ryan If you (or whoever) is using dbca, I believe all this is configured automatically. But watch the block size. That is the only thing you can't change later. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Ryan 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
RE: question about migrating to 9i
Ryan If you (or whoever) is using dbca, I believe all this is configured automatically. But watch the block size. That is the only thing you can't change later. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: question about migrating to 9i
Little tidbits I kind of like is setting a default temporary tablespace and setting it in the create database statement. You can also change the sys and system passwords in the create database statement. Plus, you can create the undo tablespace there too. I seem to be creating a lot of 9i databases around here right now and that stuff comes in kind of handy. :) --Walt Weaver Bozeman, Montana -Original Message- From: Ryan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 3:59 PM To: Multiple recipients of list ORACLE-L Subject: question about migrating to 9i Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself.
RE: question about migrating to 9i
Ryan dbca is indeed available with Solaris. I used it today in fact. What I've learned about it is: - It runs in X-Windows. I don't have much expertise with X-Windows, but it seems to run fine from the Solaris console. - Unable to create a block size greater than 8k, at least what I've found. I believe the reason is that dbca doesn't create the data files, but has precreated files it just copies into place. That's my theory anyway. - All data files are created with autoextend on. But you can change that later. - The database is created with spfile which I don't like but it is easy enough to CREATE PFILE FROM SPFILE. - I am usually a skeptic of GUI tools, but I am really impressed with this tool. One alternative you could suggest to your production people is for them to use dbca on a test system to create a database close to the one you want. Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great script (two versions in one, actually) that you can review, edit, etc. This is an easy way to implement the 9i features you list without studying the manual for the syntax for each feature. Good luck, we production DBAs can be a touchy lot. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 5:55 PM To: Multiple recipients of list ORACLE-L they are doing it by hand i believe. no dbca. its a solaris system. dont think there is a dbca for solaris? Im not a production dba, so i dont know for certain,. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 6:14 PM Ryan If you (or whoever) is using dbca, I believe all this is configured automatically. But watch the block size. That is the only thing you can't change later. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, September 09, 2003 4:59 PM To: Multiple recipients of list ORACLE-L Im not going to physically do the migration, but I want to make sure certain features are set up. Let me know if Im missing any of the basics(anything that is a pain to add on my own later). Locally Managed tablespaces are the default right? Automatic Segment Allocation Undo Tablespace SPFILE any other goodies Im forgetting? Just basic settings. rest I can do myself. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: Ryan 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: DENNIS WILLIAMS 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).