RE: What are the restrictions in naming an Oracle SID/Database?
Jared wrote Which reminds me, I somehow missed that when cloning a SAP db last weekend. Guess I'll go fix it now. Surely one of those things is more than enough :( Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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: What are the restrictions in naming an Oracle SID/Database?
At the moment I have 5, more to come. What fun. Niall Litchfield [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2003 12:50 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: What are the restrictions in naming an Oracle SID/Database? Jared wrote Which reminds me, I somehow missed that when cloning a SAP db last weekend. Guess I'll go fix it now. Surely one of those things is more than enough :( Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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).
RE: What are the restrictions in naming an Oracle SID/Database?
Even the global_name can be different from the SID and db_name. Everytime I clone a database from a hot backup the SID name is different but the db_name is the same till I complete the recovery. Then I change the db_name as well. 9 times out of 10, I forget to change the global_name -- fortunately it doesn't matter as I am not using Advanced Replication. Hemant At 12:59 PM 30-06-03 -0800, you wrote: Actually folks, we've promogulated this idea that a SID and a database name have to be the same. Nothing could be farther from the truth. In a recent attempt to make a new copy of our PeopleSoft database from a BCV copy I found that you can have a different name for the database from the SID. And wouldn't you believe it, the 9i DBCA supports that idea?? Therefore you could have a SID on empprod and a name of emp_prod with no trouble. Actually I found a good reason to go back to my old methods of using numbers as SIDs. Why, the JDBC driver. SIDs should be NON case sensitive as they once were in SQL*Net V1. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, June 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L I think it will allow under score as part of SID name but it is not recommended. Thanks, Ashoke -Original Message- Sent: Monday, June 30, 2003 11:35 AM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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: Senthil Kumar D 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: Mandal, Ashoke 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: Goulet, Dick 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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]
Re: What are the restrictions in naming an Oracle SID/Database?
Which reminds me, I somehow missed that when cloning a SAP db last weekend. Guess I'll go fix it now. On Tuesday 01 July 2003 08:34, Hemant K Chitale wrote: Even the global_name can be different from the SID and db_name. Everytime I clone a database from a hot backup the SID name is different but the db_name is the same till I complete the recovery. Then I change the db_name as well. 9 times out of 10, I forget to change the global_name -- fortunately it doesn't matter as I am not using Advanced Replication. Hemant At 12:59 PM 30-06-03 -0800, you wrote: Actually folks, we've promogulated this idea that a SID and a database name have to be the same. Nothing could be farther from the truth. In a recent attempt to make a new copy of our PeopleSoft database from a BCV copy I found that you can have a different name for the database from the SID. And wouldn't you believe it, the 9i DBCA supports that idea?? Therefore you could have a SID on empprod and a name of emp_prod with no trouble. Actually I found a good reason to go back to my old methods of using numbers as SIDs. Why, the JDBC driver. SIDs should be NON case sensitive as they once were in SQL*Net V1. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, June 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L I think it will allow under score as part of SID name but it is not recommended. Thanks, Ashoke -Original Message- Sent: Monday, June 30, 2003 11:35 AM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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: Senthil Kumar D 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: Mandal, Ashoke 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: Goulet, Dick 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat
RE: What are the restrictions in naming an Oracle SID/Database?
Ashoke The problem with long SID names or special characters is that the SID is used in a lot of circumstances. For example, on Unix systems, you end up with other characters being concatenated with the SID and this becomes a process name (as in lgwr_ora_$ORACLE_SID). So the issue isn't entirely within Oracle's control. The recommendation has traditionally been to keep it to 4 or 5 characters, strictly alphanumeric. The danger is that you will get the instance created just fine and then somewhere later encounter a situation where your special SID exceeds something else's limits. Hitting issues like this is why the more experienced DBAs tend also to be fairly conservative. Usually you have to solve enough problems without creating your own. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 30, 2003 10:50 AM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? 2. What is the maximum size of a SID/Database name in Unix? 3. What is the maximum size of a SID/Database name in Windows? 4. Is there any other restrictions? Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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).
RE: What are the restrictions in naming an Oracle SID/Database?
Ashoke, As far as I know, 1) YES 2) depends on your version of Unix. 3) Don't use Windows as a server platform. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, June 30, 2003 11:50 AM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? 2. What is the maximum size of a SID/Database name in Unix? 3. What is the maximum size of a SID/Database name in Windows? 4. Is there any other restrictions? Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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: Goulet, Dick 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: What are the restrictions in naming an Oracle SID/Database?
What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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: Senthil Kumar D 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: What are the restrictions in naming an Oracle SID/Database?
Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder -Original Message- Sent: Monday, June 30, 2003 12:35 PM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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: Senthil Kumar D 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: Singh Pushpinder 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: What are the restrictions in naming an Oracle SID/Database?
oh and the stupid reason why??? 8.3 filenames, init1234.ora joe Singh Pushpinder wrote: Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder -Original Message- Sent: Monday, June 30, 2003 12:35 PM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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). -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: What are the restrictions in naming an Oracle SID/Database?
3). it was 3 for stupid dos/windows platforms way back when i was doing v5 on 386 PC. joe Singh Pushpinder wrote: Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder -Original Message- Sent: Monday, June 30, 2003 12:35 PM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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). -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: What are the restrictions in naming an Oracle SID/Database?
dh, i meant 4 init1234.ora, i should just quit this field. joe Joe Testa wrote: 3). it was 3 for stupid dos/windows platforms way back when i was doing v5 on 386 PC. joe Singh Pushpinder wrote: Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder -Original Message- Sent: Monday, June 30, 2003 12:35 PM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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). -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: What are the restrictions in naming an Oracle SID/Database?
I think it will allow under score as part of SID name but it is not recommended. Thanks, Ashoke -Original Message- Sent: Monday, June 30, 2003 11:35 AM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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: Senthil Kumar D 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: Mandal, Ashoke 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: What are the restrictions in naming an Oracle SID/Database?
Actually folks, we've promogulated this idea that a SID and a database name have to be the same. Nothing could be farther from the truth. In a recent attempt to make a new copy of our PeopleSoft database from a BCV copy I found that you can have a different name for the database from the SID. And wouldn't you believe it, the 9i DBCA supports that idea?? Therefore you could have a SID on empprod and a name of emp_prod with no trouble. Actually I found a good reason to go back to my old methods of using numbers as SIDs. Why, the JDBC driver. SIDs should be NON case sensitive as they once were in SQL*Net V1. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, June 30, 2003 4:34 PM To: Multiple recipients of list ORACLE-L I think it will allow under score as part of SID name but it is not recommended. Thanks, Ashoke -Original Message- Sent: Monday, June 30, 2003 11:35 AM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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: Senthil Kumar D 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: Mandal, Ashoke 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: Goulet, Dick 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: What are the restrictions in naming an Oracle SID/Database?
my test environment is an Oracle 9.2.0 database running on Windows 2000 and it's SID 6 characters.ORA920 :) Nick -Original Message- Sent: Monday, June 30, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder -Original Message- Sent: Monday, June 30, 2003 12:35 PM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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: Senthil Kumar D 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: Singh Pushpinder 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: Nick Wagner 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: What are the restrictions in naming an Oracle SID/Database?
The maximum length for SID varies depends on Oracle versions and platforms. Check your doc. -Original Message- Sent: Monday, June 30, 2003 6:05 PM To: Multiple recipients of list ORACLE-L my test environment is an Oracle 9.2.0 database running on Windows 2000 and it's SID 6 characters.ORA920 :) Nick -Original Message- Sent: Monday, June 30, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Hi Kumar, 3) I believe it is 4 chars. Thanks, Inder -Original Message- Sent: Monday, June 30, 2003 12:35 PM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. --Senthil. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mandal, Ashoke 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: Senthil Kumar D 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: Singh Pushpinder 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: Nick Wagner 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: Richard Ji 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: What are the restrictions in naming an Oracle SID/Database?
DB_NAME specifies a database identifier of up to 8 characters. The following characters are valid in a database name: alphanumeric characters, underscore (_), number sign (#), and dollar sign ($). No other characters are valid. Oracle removes double quotation marks before processing the database name. Therefore you cannot use double quotation marks to embed other characters in the name. The database name is case insensitive. In fact cannot use non-ASCII characters in a database name and in the create database statement. For example cannot use special characters from european \ asian character sets like characters with umlauts. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 30, 2003 21:19 : What are the restriction in naming an Oracle SID/Database? : : 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? : : 2. What is the maximum size of a SID/Database name in Unix? : : 3. What is the maximum size of a SID/Database name in Windows? : : 4. Is there any other restrictions? : : : : Thanks, : Ashoke : : -- : Please see the official ORACLE-L FAQ: http://www.orafaq.net : -- : Author: Mandal, Ashoke : 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: [EMAIL PROTECTED] 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: What are the restrictions in naming an Oracle SID/Database?
And clarifying point 1 - at least the underscore is allowed in database and instance names. EMP_PROD would be a valid database and instance name. -Original Message- From: Senthil Kumar D [mailto:[EMAIL PROTECTED] What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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: What are the restrictions in naming an Oracle SID/Database?
With Oracle 8.1 and above you can have database names and instance names that are at least 8 characters long using Windows NT or 2000. I currently have several databases with 8-character database and instance names, in Oracle 8.1, 9.0, 8.2 on Windows NT and Windows 2000. -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED] oh and the stupid reason why??? 8.3 filenames, init1234.ora Singh Pushpinder wrote: Hi Kumar, 3) I believe it is 4 chars. -Original Message- Sent: Monday, June 30, 2003 12:35 PM To: Multiple recipients of list ORACLE-L What are the restriction in naming an Oracle SID/Database? 1. Can I have special character in SID/Database name? e.g. Is a SID name 'emp_prod' is allowed? No You can not use spl char's. SID name should be in alpha's. 2. What is the maximum size of a SID/Database name in Unix? 8 chars 3. What is the maximum size of a SID/Database name in Windows? 8chars 4. Is there any other restrictions? SID names should be unique. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer 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).