RE: Names Server
Jack: It appears that the names server is up and running. Try this: 1. Invoke the namesctl utility from a dos prompt. 2. Type "services" (I think) to see what service names are processed. 3. Type "status" to see the status of the names server. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, March 07, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject:Names Server Hi All, >From my names.log file I have the following error (?) Where does it come from (Where did I mess up my configuration) NNO-00807: Error: OCI_NO_DATA NNO-00267: warning: configuration database contains no data for server "[root]" NNO-00315: server is listening on address (ADDRESS =(PROTOCOL=TCP)(HOST=nlzz101535)(PORT=1575)) NNO-00065: loading cached data from checkpoint file "E: \oracle\ora81\network\names\ckpcch.ora" 07-MAR-2002 15:21:59: NNO-00303: server "NTNLZZ101535_ON" started with process ID 358 * All seems to be working fine though TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: Karniotis, Stephen 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: Names Server/Solved
hey im new in ORACLE but i have programming experience more tha 2 years of visual basic is there anyone from you that can help me how to manipulate grid in oracle forms like data grid in visual basic? or can you give me a website so that i can download an OCX to be used in my application? thanx in advance "Jack van Zanen" <[EMAIL PROTECTED]> on 03/11/2002 04:03:18 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc:(bcc: Jenner A Viloria/notes.mayniladwater.com.ph) Hi All, I am hitting bug 1957103 Annoying but no effect on the correct working of the names server (apparantly) THX Jack == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: Names Server/Solved
Hi All, I am hitting bug 1957103 Annoying but no effect on the correct working of the names server (apparantly) THX Jack == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: Names Server
Forgot the output Oracle Names Control for 32-bit Windows: Version 8.1.7.0.0 - Production on 08-MAR-2002 12:15:48 (c) Copyright 1997 Oracle Corporation. All rights reserved. Currently managing name server "marvin" Version banner is "Oracle Names for 32-bit Windows: Version 8.1.7.0.0 - Production" Version banner is "Oracle Names for 32-bit Windows: Version 8.1.7.0.0 - Production" Server name: marvin Server has been running for: 20 hours 18 minutes 31.71 seconds Request processing enabled: yes Request forwarding enabled: yes Requests received:21 Requests forwarded: 0 Foreign data items cached:0 Region data next checked for reload in: 3 hours 41 minutes 28.63 seconds Region data reload check failures:0 Cache next checkpointed in: not set Cache checkpoint interval:not set Cache checkpoint file name: C: \oracle\ora81\network\names\ckpcch.ora Statistic counters next reset in: not set Statistic counter reset interval: not set Statistic counters next logged in:not set Statistic counter logging interval: not set Trace level: 0 Trace file name: C: \oracle\ora81\network\trace\names.trc Log file name:C: \oracle\ora81\network\log\names.log System parameter file name: C: \oracle\ora81\network\admin\names.ora Command-line parameter file name: "" Administrative region name: NLEY Administrative region description:(DESCRIPTION =(SOURCE_ROUTE=OFF)(ADDRESS_LIST=(ADDRESS =(PROTOCOL=TCP)(HOST=NLZZ200929)(PORT=1521)))(CONNECT_DATA =(SID=HOMEBASE)(SRVR=DEDICATED))) ApplTable Index: 0 Contact "" Operational Status0 Save Config on Stop no * - Forwarded by Jack van Zanen/nlzanen1/External/MEY/NL on 11-03-2002 08:14 - Jack van Zanen To: [EMAIL PROTECTED] 11-03-2002 08:14 cc: Subject: RE: Names Server(Document link: Jack van Zanen) Hi Stephen, Indeed my names servers (2) are running fine, and both are using the same Oracle regional database processing requests as they should. I'm just wondering why I have this error message? Services does not seem to be a command but dumping the services to a file showed me a whole list of services (I loaded these also) I'll attach the output from the status command. All looks OK but I'm no expert (yet :-) ) Any Ideas TIA Jack van Zanen "Karniotis, Stephen" puware.com> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Names Server [EMAIL PROTECTED] 07-03-2002 18:28 Please respond to
RE: Names Server
Hi Stephen, Indeed my names servers (2) are running fine, and both are using the same Oracle regional database processing requests as they should. I'm just wondering why I have this error message? Services does not seem to be a command but dumping the services to a file showed me a whole list of services (I loaded these also) I'll attach the output from the status command. All looks OK but I'm no expert (yet :-) ) Any Ideas TIA Jack van Zanen "Karniotis, Stephen" puware.com> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: RE: Names Server [EMAIL PROTECTED] 07-03-2002 18:28 Please respond to ORACLE-L Jack: It appears that the names server is up and running. Try this: 1. Invoke the namesctl utility from a dos prompt. 2. Type "services" (I think) to see what service names are processed. 3. Type "status" to see the status of the names server. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct:(248) 865-4350 Mobile:(248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent:Thursday, March 07, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Hi All, >From my names.log file I have the following error (?) Where does it come from (Where did I mess up my configuration) NNO-00807: Error: OCI_NO_DATA NNO-00267: warning: configuration database contains no data for server "[root]" NNO-00315: server is listening on address (ADDRESS =(PROTOCOL=TCP)(HOST=nlzz101535)(PORT=1575)) NNO-00065: loading cached data from checkpoint file "E: \oracle\ora81\network\names\ckpcch.ora" 07-MAR-2002 15:21:59: NNO-00303: server "NTNLZZ101535_ON" started with process ID 358 * All seems to be working fine though TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst &am
RE: Names Server
Jack: It appears that the names server is up and running. Try this: 1. Invoke the namesctl utility from a dos prompt. 2. Type "services" (I think) to see what service names are processed. 3. Type "status" to see the status of the names server. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, March 07, 2002 10:18 AM To: Multiple recipients of list ORACLE-L Subject:Names Server Hi All, >From my names.log file I have the following error (?) Where does it come from (Where did I mess up my configuration) NNO-00807: Error: OCI_NO_DATA NNO-00267: warning: configuration database contains no data for server "[root]" NNO-00315: server is listening on address (ADDRESS =(PROTOCOL=TCP)(HOST=nlzz101535)(PORT=1575)) NNO-00065: loading cached data from checkpoint file "E: \oracle\ora81\network\names\ckpcch.ora" 07-MAR-2002 15:21:59: NNO-00303: server "NTNLZZ101535_ON" started with process ID 358 * All seems to be working fine though TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen 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: Karniotis, Stephen 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: Names server
Bruce: You are correct in that you do not need a database to store the topology. Instead it stores the topology in cache or using a "replication-type" feature. Here is a white paper I wrote on setting up names. Hope this helps. <> Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 6:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Names server Stephen or others, If I understood correctly, the email below said it is possible to have a Names Server that doesn't require its own database. I have just briefly read the manual on Names and it mentions that Names8 doesn't require a database to store topology but it is recommended. It also mentions service replication where information is stored in Names cache rather than a database. Is this what is being referred to? Stephen - can you provide a bit more information on a Names server that doesn't require a separate database. Thanks, Bruce Reardon -Original Message- Sent: Wednesday, 6 March 2002 1:29 I agree with everyone. Oracle Names saved many days/months of maintenance time in migrating new TNSNAMES to over 3 desktops. The only gotchas with ON was the creation of a separate Administrative database and 24x7 maintenance of it. With the new extensibility features not requiring a database, that job was made much easier. However, the move to LDAP will benefit you even more because all you need to do is put an entry in the directory server for the instances and "magic" occurs. I personally hate the concept of the TNSNAMES file because if violates the "knowledge" security standard of knowing what databases are within the environment. Any savvy user can figure out how to hack in once they have that kind of information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, March 04, 2002 6:08 PM I agree with you Jared. On the last job we had TNSNAMES files out to everyones work station . got to be a pain. Installed Names, created the right files . bingo, all worked . Very easy. -Original Message- Sent: Monday, March 04, 2002 4:29 PM Completely removing names from Oracle would be a mistake IMO. Reason: Name is fairly easy to implement, LDAP is anything but. Jared - "Freeman, Robert " <[EMAIL PROTECTED]> 03/04/02 01:38 PM Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -Original Message- Sent: Monday, March 04, 2002 3:53 PM Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Author: Freeman, Robert INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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). IOUG Paper 103.doc Description: MS-Word document
RE: Names server
Bruce, You can load Oracle Names from a tnsnames.ora file, the repository is not required. Setting it up this way is fairly easy. Jared "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/05/02 03:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Names server Stephen or others, If I understood correctly, the email below said it is possible to have a Names Server that doesn't require its own database. I have just briefly read the manual on Names and it mentions that Names8 doesn't require a database to store topology but it is recommended. It also mentions service replication where information is stored in Names cache rather than a database. Is this what is being referred to? Stephen - can you provide a bit more information on a Names server that doesn't require a separate database. Thanks, Bruce Reardon -Original Message- Sent: Wednesday, 6 March 2002 1:29 I agree with everyone. Oracle Names saved many days/months of maintenance time in migrating new TNSNAMES to over 3 desktops. The only gotchas with ON was the creation of a separate Administrative database and 24x7 maintenance of it. With the new extensibility features not requiring a database, that job was made much easier. However, the move to LDAP will benefit you even more because all you need to do is put an entry in the directory server for the instances and "magic" occurs. I personally hate the concept of the TNSNAMES file because if violates the "knowledge" security standard of knowing what databases are within the environment. Any savvy user can figure out how to hack in once they have that kind of information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent:Monday, March 04, 2002 6:08 PM I agree with you Jared. On the last job we had TNSNAMES files out to everyones work station . got to be a pain. Installed Names, created the right files . bingo, all worked . Very easy. -Original Message- Sent: Monday, March 04, 2002 4:29 PM Completely removing names from Oracle would be a mistake IMO. Reason: Name is fairly easy to implement, LDAP is anything but. Jared - "Freeman, Robert " <[EMAIL PROTECTED]> 03/04/02 01:38 PM Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -Original Message- Sent: Monday, March 04, 2002 3:53 PM Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Author: Freeman, Robert INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).
RE: Names server
Stephen or others, If I understood correctly, the email below said it is possible to have a Names Server that doesn't require its own database. I have just briefly read the manual on Names and it mentions that Names8 doesn't require a database to store topology but it is recommended. It also mentions service replication where information is stored in Names cache rather than a database. Is this what is being referred to? Stephen - can you provide a bit more information on a Names server that doesn't require a separate database. Thanks, Bruce Reardon -Original Message- Sent: Wednesday, 6 March 2002 1:29 I agree with everyone. Oracle Names saved many days/months of maintenance time in migrating new TNSNAMES to over 3 desktops. The only gotchas with ON was the creation of a separate Administrative database and 24x7 maintenance of it. With the new extensibility features not requiring a database, that job was made much easier. However, the move to LDAP will benefit you even more because all you need to do is put an entry in the directory server for the instances and "magic" occurs. I personally hate the concept of the TNSNAMES file because if violates the "knowledge" security standard of knowing what databases are within the environment. Any savvy user can figure out how to hack in once they have that kind of information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, March 04, 2002 6:08 PM I agree with you Jared. On the last job we had TNSNAMES files out to everyones work station . got to be a pain. Installed Names, created the right files . bingo, all worked . Very easy. -Original Message- Sent: Monday, March 04, 2002 4:29 PM Completely removing names from Oracle would be a mistake IMO. Reason: Name is fairly easy to implement, LDAP is anything but. Jared - "Freeman, Robert " <[EMAIL PROTECTED]> 03/04/02 01:38 PM Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -Original Message- Sent: Monday, March 04, 2002 3:53 PM Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Author: Freeman, Robert INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Names server
We switched to names server last year. We had our NT administrator net use to each client in the company (effectively assigning a drive to the administrators machine) and copy the sqlnet.ora over to the remote machine. Fired up about 10 machines and updated > 1000 systems in three different waves. Worked pretty smooth. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, March 05, 2002 1:28 PM To: Multiple recipients of list ORACLE-L Yechiel, That's all well and good if you get to set it up from the beginning. I inherited it. Tnsname.ora everywhere. Different desktops with different names for the same databases. It's a nightmare. I plan to setup Onames when I get a chance to do so. Putting tnsnames.ora on network file servers wouldn't work so well. We have offices ( and users ) in Asia, North America, Europe and the Middle East. At least I only have hundreds of desktops to deal with rather than thousands. Jared àãø éçéàì <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/05/02 07:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Names server Hello All I saw some remarks about updating tnsnames on many desktops. Why would you have tnsnames in every machine? I put our client software on a central server, with the tnsnames. One update to the tnsnames in the server apply to all. Installing for a new PC is importing the registry entries and add two paths to the search list, done in two minutes. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] > Sent: Tue, March 05, 2002 4:29 PM > To:Multiple recipients of list ORACLE-L > Subject: RE: Names server > > I agree with everyone. Oracle Names saved many days/months of maintenance > time in migrating new TNSNAMES to over 3 desktops. The only gotchas > with ON was the creation of a separate Administrative database and 24x7 > maintenance of it. With the new extensibility features not requiring a > database, that job was made much easier. > > However, the move to LDAP will benefit you even more because all you need > to > do is put an entry in the directory server for the instances and "magic" > occurs. I personally hate the concept of the TNSNAMES file because if > violates the "knowledge" security standard of knowing what databases are > within the environment. Any savvy user can figure out how to hack in once > they have that kind of information. > > Thank You > > Stephen P. Karniotis > Technical Alliance Manager > Compuware Corporation > Direct:(248) 865-4350 > Mobile:(248) 408-2918 > Email: [EMAIL PROTECTED] > Web: www.compuware.com > > -Original Message- > Sent: Monday, March 04, 2002 6:08 PM > To:Multiple recipients of list ORACLE-L > Subject: RE: Names server > > I agree with you Jared. On the last job we had TNSNAMES files out to > everyones work station . got to be a pain. Installed Names, created > the right files . bingo, all worked . Very easy. > > -Original Message- > Sent: Monday, March 04, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > > > Completely removing names from Oracle would be a mistake IMO. > > Reason: Name is fairly easy to implement, LDAP is anything but. > > Jared > > > > > > "Freeman, Robert " <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/04/02 01:38 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Names server > > > Names server is depreciated in 9i, but still there. > They were going to remove it, but I think there was a bit of a backlash, > so > they have delayed > the removal. > OID (LDAP) is the replacement. > > We use names server here, have found it to be pretty stable and reduced > tnsnames.ora > administration nicely. > > RF > > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's conscience can > take his freedom away from him. > > > > -Original Message- > Sent: Monday, March 04, 2002 3:53 PM > To: Multiple recipients of
RE: Names server
Yechiel, That's all well and good if you get to set it up from the beginning. I inherited it. Tnsname.ora everywhere. Different desktops with different names for the same databases. It's a nightmare. I plan to setup Onames when I get a chance to do so. Putting tnsnames.ora on network file servers wouldn't work so well. We have offices ( and users ) in Asia, North America, Europe and the Middle East. At least I only have hundreds of desktops to deal with rather than thousands. Jared àãø éçéàì <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/05/02 07:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Names server Hello All I saw some remarks about updating tnsnames on many desktops. Why would you have tnsnames in every machine? I put our client software on a central server, with the tnsnames. One update to the tnsnames in the server apply to all. Installing for a new PC is importing the registry entries and add two paths to the search list, done in two minutes. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] > Sent: Tue, March 05, 2002 4:29 PM > To:Multiple recipients of list ORACLE-L > Subject: RE: Names server > > I agree with everyone. Oracle Names saved many days/months of maintenance > time in migrating new TNSNAMES to over 3 desktops. The only gotchas > with ON was the creation of a separate Administrative database and 24x7 > maintenance of it. With the new extensibility features not requiring a > database, that job was made much easier. > > However, the move to LDAP will benefit you even more because all you need > to > do is put an entry in the directory server for the instances and "magic" > occurs. I personally hate the concept of the TNSNAMES file because if > violates the "knowledge" security standard of knowing what databases are > within the environment. Any savvy user can figure out how to hack in once > they have that kind of information. > > Thank You > > Stephen P. Karniotis > Technical Alliance Manager > Compuware Corporation > Direct:(248) 865-4350 > Mobile:(248) 408-2918 > Email: [EMAIL PROTECTED] > Web: www.compuware.com > > -Original Message- > Sent: Monday, March 04, 2002 6:08 PM > To:Multiple recipients of list ORACLE-L > Subject: RE: Names server > > I agree with you Jared. On the last job we had TNSNAMES files out to > everyones work station . got to be a pain. Installed Names, created > the right files . bingo, all worked . Very easy. > > -Original Message- > Sent: Monday, March 04, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > > > Completely removing names from Oracle would be a mistake IMO. > > Reason: Name is fairly easy to implement, LDAP is anything but. > > Jared > > > > > > "Freeman, Robert " <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/04/02 01:38 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Names server > > > Names server is depreciated in 9i, but still there. > They were going to remove it, but I think there was a bit of a backlash, > so > they have delayed > the removal. > OID (LDAP) is the replacement. > > We use names server here, have found it to be pretty stable and reduced > tnsnames.ora > administration nicely. > > RF > > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's conscience can > take his freedom away from him. > > > > -Original Message- > Sent: Monday, March 04, 2002 3:53 PM > To: Multiple recipients of list ORACLE-L > > > Names server will be obsolete in 9i, I think. > > -Original Message- > Sent: Monday, March 04, 2002 11:33 AM > To: Multiple recipients of list ORACLE-L > > > Hi ALL: > Is any one using names server out there? How the it works? Any infor > are wellcome. > > -- åy«±ç ê~'"jS "Ä,PÛiÿü0ÂÚ}ª¢`.¶+ Ñ%ªÞu+bZÚv+2±Ê&«BÜzÜ(®D®øzÏ9óüçNuüçÎwó9Õ&§' &¥ú+&¹¹bpíz¹Þµ§zË?1¨¥xËlND0åDÊ«±é_~º&¶¬¨¥x%ËlzwZCY²Æ zÚËFº»j×"·'(z-xEÀ ;)zYb .+-êîjwbØ^ë,j86"Énuæ¥w¢{Zx§CRP "Ä.í éÚꨥx%Ër¢ìÛhmêÞÞuúè.¬Ê,zwm áÄ,÷(f§uú+¢Ø^®)ߢ¹¶*')²æìr¸x
RE: Names server
Hello All I saw some remarks about updating tnsnames on many desktops. Why would you have tnsnames in every machine? I put our client software on a central server, with the tnsnames. One update to the tnsnames in the server apply to all. Installing for a new PC is importing the registry entries and add two paths to the search list, done in two minutes. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] > Sent: Tue, March 05, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Names server > > I agree with everyone. Oracle Names saved many days/months of maintenance > time in migrating new TNSNAMES to over 3 desktops. The only gotchas > with ON was the creation of a separate Administrative database and 24x7 > maintenance of it. With the new extensibility features not requiring a > database, that job was made much easier. > > However, the move to LDAP will benefit you even more because all you need > to > do is put an entry in the directory server for the instances and "magic" > occurs. I personally hate the concept of the TNSNAMES file because if > violates the "knowledge" security standard of knowing what databases are > within the environment. Any savvy user can figure out how to hack in once > they have that kind of information. > > Thank You > > Stephen P. Karniotis > Technical Alliance Manager > Compuware Corporation > Direct: (248) 865-4350 > Mobile: (248) 408-2918 > Email:[EMAIL PROTECTED] > Web: www.compuware.com > > -Original Message----- > Sent: Monday, March 04, 2002 6:08 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Names server > > I agree with you Jared. On the last job we had TNSNAMES files out to > everyones work station . got to be a pain. Installed Names, created > the right files . bingo, all worked . Very easy. > > -Original Message- > Sent: Monday, March 04, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > > > Completely removing names from Oracle would be a mistake IMO. > > Reason: Name is fairly easy to implement, LDAP is anything but. > > Jared > > > > > > "Freeman, Robert " <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/04/02 01:38 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Names server > > > Names server is depreciated in 9i, but still there. > They were going to remove it, but I think there was a bit of a backlash, > so > they have delayed > the removal. > OID (LDAP) is the replacement. > > We use names server here, have found it to be pretty stable and reduced > tnsnames.ora > administration nicely. > > RF > > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's conscience can > take his freedom away from him. > > > > -Original Message- > Sent: Monday, March 04, 2002 3:53 PM > To: Multiple recipients of list ORACLE-L > > > Names server will be obsolete in 9i, I think. > > -Original Message- > Sent: Monday, March 04, 2002 11:33 AM > To: Multiple recipients of list ORACLE-L > > > Hi ALL: > Is any one using names server out there? How the it works? Any infor > are wellcome. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > 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 messa
RE: Names server
I agree with everyone. Oracle Names saved many days/months of maintenance time in migrating new TNSNAMES to over 3 desktops. The only gotchas with ON was the creation of a separate Administrative database and 24x7 maintenance of it. With the new extensibility features not requiring a database, that job was made much easier. However, the move to LDAP will benefit you even more because all you need to do is put an entry in the directory server for the instances and "magic" occurs. I personally hate the concept of the TNSNAMES file because if violates the "knowledge" security standard of knowing what databases are within the environment. Any savvy user can figure out how to hack in once they have that kind of information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, March 04, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Subject:RE: Names server I agree with you Jared. On the last job we had TNSNAMES files out to everyones work station . got to be a pain. Installed Names, created the right files . bingo, all worked . Very easy. -Original Message- Sent: Monday, March 04, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Completely removing names from Oracle would be a mistake IMO. Reason: Name is fairly easy to implement, LDAP is anything but. Jared "Freeman, Robert " <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/04/02 01:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Names server Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 04, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Kevin Lange 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: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Names server
Works nicely for us. It was a bit flakey before we had a region database, but is rock solid now. I installed OID for a 'play' recently, and after considerable pain I finally got the GUI running, only to find that what was on the screen made absolutely no sense to me whatsoever. RTFM'ing had a similar effect. -- David Lord -Original Message- Sent: 04 March 2002 19:33 To: Multiple recipients of list ORACLE-L Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG 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: Names server
Hi, Works fine for us on Solaris 8 Oracle 8.1.7 20 Dbs in the Nameserver. Regards Henrik E. -- On Mon, 4 Mar 2002, Yahoo wrote: -!-Hi ALL: -!-Is any one using names server out there? How the it works? Any -!-infor are wellcome. -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[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: Names server
Hi All, Following is my observation on UNIX Server. Except for this CLIENT Connections and individual connections from around the world and servers work without any problems. Just to add.. With Names Server life and management is easy... - This test was performed with ORACLE NAMES CONFIGURED on the SAME SYSTEM... and using the SAME ORACLE HOME / VERSION.(8.1.7) I had 5 background processes to run more or less concurrently using a simple SQL Script.. such as select sysdate from dual; These scripts were executed almost 20 times.. and here is approximated result.. Here are the success rates for each of the 5 processes that try to connect: First spawned process: 60% success rate. Second process: 20% Third process: 25% Fourth process: 45% Fifth process: 55% Overall success rate: 41% Never did all the 5 processes were successful. NOW... If I added a sleep 1 command in shell script before each of the 5 scripts.. success rate was 100%. Similarly, Instead of USING ORACLE NAMES.. I changed SQLNET to use TNSNAMES.. and performed similar test WITHOUT SLEEP 1.. (i.e. performed the original test which failed with ORACLE NAMES)... RESULT FOR TNSNAMES : 100 % Success. NOTE : Only change was TNSNAMES used instead of ONAMES. Any suggestions / parameters that need to be verified ? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 07:23 PM > We use Oracle Names big time. > Our approach is to keep using it until it *really* does not come on the > Install CD. > It will be a mistake to get rid of something that has now stabilized very > well. > - Kirti > > -Original Message- > Sent: Monday, March 04, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > > > Completely removing names from Oracle would be a mistake IMO. > > Reason: Name is fairly easy to implement, LDAP is anything but. > > Jared > > > > > > "Freeman, Robert " <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/04/02 01:38 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: Names server > > > Names server is depreciated in 9i, but still there. > They were going to remove it, but I think there was a bit of a backlash, > so > they have delayed > the removal. > OID (LDAP) is the replacement. > > We use names server here, have found it to be pretty stable and reduced > tnsnames.ora > administration nicely. > > RF > > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's conscience can > take his freedom away from him. > > > > -Original Message- > Sent: Monday, March 04, 2002 3:53 PM > To: Multiple recipients of list ORACLE-L > > > Names server will be obsolete in 9i, I think. > > -Original Message- > Sent: Monday, March 04, 2002 11:33 AM > To: Multiple recipients of list ORACLE-L > > > Hi ALL: > Is any one using names server out there? How the it works? Any infor > are wellcome. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > 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: Deshpande,
RE: Names server
We use Oracle Names big time. Our approach is to keep using it until it *really* does not come on the Install CD. It will be a mistake to get rid of something that has now stabilized very well. - Kirti -Original Message- Sent: Monday, March 04, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Completely removing names from Oracle would be a mistake IMO. Reason: Name is fairly easy to implement, LDAP is anything but. Jared "Freeman, Robert " <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/04/02 01:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Names server Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 04, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Deshpande, Kirti 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: Names server
I agree with you Jared. On the last job we had TNSNAMES files out to everyones work station . got to be a pain. Installed Names, created the right files . bingo, all worked . Very easy. -Original Message- Sent: Monday, March 04, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Completely removing names from Oracle would be a mistake IMO. Reason: Name is fairly easy to implement, LDAP is anything but. Jared "Freeman, Robert " <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/04/02 01:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Names server Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 04, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Kevin Lange 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: Names server
Completely removing names from Oracle would be a mistake IMO. Reason: Name is fairly easy to implement, LDAP is anything but. Jared "Freeman, Robert " <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/04/02 01:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Names server Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 04, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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).
RE: Names server
Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 04, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert 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: Names server
Names server will be obsolete in 9i, I think. -Original Message-From: Yahoo [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 11:33 AMTo: Multiple recipients of list ORACLE-LSubject: Names server Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome.