Oracle client compatibility with Windows XP
Hi According to Metalink note 161546.1 you need at least the 9.0.1 Oracle client for Windows XP. We are currently using the 8.1.7 client to go against 8.1.7 databases and 7.3.4 databases. Does anyone know of any issues when you use the 9 client against 7.3.4 databases? Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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).
Oracle9iAS and proxy servers
Hi I have used Oracle8i but I am new to the Oracle9iAS world. I would like to set up a proxy server outside a firewall which routes to an Oracle9iAS server inside the firewall. Can the proxy server just be a basic Apache install, or are their benefits/requirements to using 9iAS (maybe the core or minimal edition) as the proxy? Can anyone point me at some documentation on this topic, as nothing came up on my MetaLink search except numerous references to the "Proxy log on failed" problem. Thanks, Ben ====== Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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).
Oracle and LDAP servers
Hi In reading MetaLink I have come up with the following list of LDAP servers that are certified for use with Oracle. in 8.1.7 - OID, NDS, Active Directories and iPlanet in 9i - OID, Active Directories Can anyone update this? When they say an LDAP is certified for use with Oracle does this mean that the Oracle Internet Directory C API and PL/SQL API(dbms_ldap) will work against them? Or does it just mean that the OID can sync to it. My real question is if I want to use iPlanet or some such beast how do I identify, and authorize Oracle database users? Thanks, Ben == Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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).
Oracle8i and LDAP
Hi Does Oracle8i come with any built in LDAP functions or do you have to write your own functions to search and update an LDAP directory? Does the Oracle Internet Directory come with Oracle8i or is purchased separately? Thanks. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: Oracle8i and LDAP
Hi Well I have partially answered my own question. I see in the Net8 manual that it can use an LDAP server to replace Oracle Names and lookup connect strings for service names. However I am still not sure if Oracle8i can authenticate a username and password in an LDAP. If it can, does anyone know how it queries the LDAP. What I really want to know is whether Oracle has any specific requirements that an LDAP server would need to be able to handle. This will help us choose an Oracle compatible LDAP. I have found a chart indicating that OID is included with Oracle9iAS EE. -Original Message- Sent: Tuesday, January 15, 2002 4:02 PM To: Multiple recipients of list ORACLE-L Hi Does Oracle8i come with any built in LDAP functions or do you have to write your own functions to search and update an LDAP directory? Does the Oracle Internet Directory come with Oracle8i or is purchased separately? Thanks. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: Ben Poels 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).
Oracle8i and the Jserv demos
Hi I have installed Oracle 8.1.7.0 on an AIX 4.3 box and the Jserv demos do not work. I looked at the jserv.log and it seems to not be finding the java executables. I downloaded Java.rte for AIX from IBM and put it in the $ORACLE_HOME/Apache/jdk/bin directory but it still doesn't work. I am not too familiar with AIX so can anyone explain to me how and where to install java on an AIX box. I would open a tar but we renewed our licenses and ever since I have been unable to get registered properly with MetaLink. Thanks, Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: SCOTT/TIGER
Ed Scott was one of the founders of Oracle and that was a sign on he liked to use. -Original Message- Sent: Wednesday, January 23, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Anyone out there know the history of this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Ben Poels 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: Oracle 9i installation Java RunTime Environment was not found.
Hi The history for this question is incomplete but I will add this thought anyway. When installing on AIX boxes Oracle will not install java due to license restrictions. I am not sure if your error is during installation or after. The HTTP server may not work because there was no jre or jdk in $ORACLE_HOME/Apache/. I had to put a soft link in to my /usr/jdk where I had installed java. Then everything worked. Hope this helps. Ben -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Neil KhotSent: Thursday, January 24, 2002 2:49 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle 9i installation Java RunTime Environment was not found. Hello Onder, I have JRE Installed here is what I get $: java -versionjava version "1.3.0_02"Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.0_02)Java HotSpot(TM) Client VM (build 1.3.0_02, mixed mode) There fore Java is installed. I think this might have something to do with Oracle not able to create /tmp/Orainstall/jre/bin/jre on its own even thought there are enough permission and disk space. Any help is appreciated Neil Khot - Original Message - From: E.Onder Kokturk To: Multiple recipients of list ORACLE-L Sent: Thursday, January 24, 2002 1:10 AM Subject: Re: Oracle 9i installation Java RunTime Environment was not found. >Dear Friends, I am trying to install Oracle 9i on Sun Solaris 5.8.But while installting i get the following error hi, you need JRE for installation. I think your system didn't installed or have a problem. You can download , install and try to install Oracle again. -Onder Kokturk
RE: How to use Email server in 9iAS.
Hi What couldn't you download from OTN and why. OTN has the following manuals which I downloaded - Planning Guide, Installation Guide, Administration Guide and Developers Guide. I toyed with the idea of setting up the Email Server for mass mailings (not spam!) with personalized text from an Oracle database. However I have not had a chance to pursue it yet and it does not seem to be very widely used. Right now I am just using SendMail and utl_smtp to solve my problem. Ben -Original Message- [EMAIL PROTECTED] Sent: Wednesday, April 03, 2002 11:53 PM To: Multiple recipients of list ORACLE-L Hi I wish to install Email server in 9iAS. but i don't know how to do that. i try to download the same from OTN but unable to get it. so let me know how to do and configure the same Rgds Ayyappan.S This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s), please note that any distribution, printing, copying or use of this communication or the information in it is strictly prohibited. If you have received this communication in error, please notify the sender immediately and then destroy any copies of it. Visit us @ www.ssiworldwide.com -- 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: Ben Poels 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: Differences between Oracle JDBC thin and thick drivers
Hi I believe the difference is that the OCI drivers use SQL*Net or NET8 or whatever they call it now, whereas the thin driver does not require SQL*Net on the client machine. Ben Poels Sr. Technical Analyst Queen's University -Original Message- Avrami Sent: Tuesday, April 09, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Hello all, I have a question concerning the Oracle JDBC thin vs. thick drivers and how they might affect operations from an application perspective. We're in a Solais 8/Oracle 8.1.7.2 environment. We have several applications on several servers connecting to the Oracle database. For redundancy, we're looking into setting up TAF (transparent application failover). Currently, some of our apps use the Oracle JDBC thin drivers to talk to the database, with a connection string that like this: jdbc:oracle:thin:@host:port:ORACLE_SID In a disaster recovery mode, where we would switch the database from one server to another, the host name in the above string would become invalid. That means we have to shut down our application servers and restart them with an updated string. Using the Oracle OCI (thick) driver though, allows us to connect to a Net8 service instead of a specific server: jdbc:oracle:oci8:@NET8_SERVICE_NAME Coupled with the FAILOVER=ON option configured in Net8, it is then possible to direct a connection from the first server to the failover database on another server. This is exactly what we would like to do. My question is, from an application perspective, how is the Oracle thick driver different from the thin driver? If everything else is "equal" (i.e. the thick driver is compatible with the app servers) would there be something within the the thick/OCI driver that could limit functionality vs. the thin driver? My understand, which obviously is sketchy, is that the thick driver is a superset of the thin driver. If this is the case, and for example if all database connections were handled through a configuration file with the above OCI connection string, then theoretically the thick driver should work. If anyone has any info on this that they can share, it would be greatly appreciated. Thanks, Lou Avrami -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis Avrami 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: Ben Poels 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).
Installing Discoverer4i with Oracle9iAS
Hi, I am having trouble with this install. First a warning. If you are installing this on Solaris get the 9iAS 1.0.2.2.2 version as the 1.0.2.2.1 version would not even start up the Discoverer install for me (and I did have PsuedoColor set on my emulator as it uses the old installer in motif mode). Anyway the Disco install says it worked but I cannot get it going. My locator.log is complaining about being unable to bind a preference object. I noticed one error in the pref.txt file - the IP address did not get set. After looking on Metalink it seems that the install makes a lot of mistakes in setting up parameter files. Has anyone successfully installed this who would like to share their pref.txt, jserv.properties, discoviewer.properties, etc. Thanks in advance, Ben == Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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).
Close instances while installing new versions or creating new databases
Hi The install guides that I have seen specify that you shut down all instances before any installations. Is it really necessary to close all instances and listeners on a server when you are: a)Installing a new version of Oracle in a new $ORACLE_HOME OR b)Creating a new database under the new $ORACLE_HOME What about when creating a new database under an existing $ORACLE_HOME which has open instances. Thanks. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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).
SQLLDR core dumping
Hi I installed 9iAS 1.0.2.2.2 on Solaris 8. All went well except the Portal component failed. When I tried to re-run the opca (portal configuration assistant) it failed on a segmentation fault in SQLLDR. Oracle support seems to be stumped by this. Has anyone else run into this? Thanks, Ben Poels Queen's University -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: Saving down time on Install
Jack, I asked this question last week. I got one reply saying that it was okay to install and build new databases with another version running in a different Oracle home (from Rachel I think). I assume she had tried it out but I don't know for sure. Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: Two instances with same name on the same Server
Hi This could happen if you have Oracle installed twice on the box. The same SID could be started up from each of the binaries. Ben -Original Message- [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 5:48 PM To: Multiple recipients of list ORACLE-L Hello Folks, I was teaching DBA stuff to a newbie, and I had him play with an Oracle 7.3.4 instance on an old HP box. I was teaching him about oradebug, ipcs and how to associate shared memory segments with an Oracle Instance. After some time, he came back and said there were 2 Oracle instances with the same name running. I did a ps -ef|grep pmon and was indeed surprised to find two process with the same SID running. An ipcs showed two Oracle Id's. I connected to the instance, and shut it down. It now showed only one pmon process, which I was not able to connect to, and had to kill all the background process. He does not remember the exact sequence of steps that he did. I tried to retrace the steps from whatever he said, but to no avail. I brought up the instance, did an ipcsrm, and tried to bring up another instance, all to nothing. 7.3.4 is the only Oracle version installed on this box. Any thoughts on this? I am curious to know. Raj -- 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: Ben Poels 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: Oracle IFS
aarden 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: > 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: Alexandre Gorbatchev 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: Boivin, Patrice J 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: Ben Poels 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: 9i Release 2 features/fixes
Try this link: http://otn.oracle.com/products/ias/pdf/9iasr2newfeature.pdf Ben -Original Message- Robert Sent: Monday, May 06, 2002 3:14 PM To: Multiple recipients of list ORACLE-L I have been trying, like you wouldn't believe, to get a list of new features in 9iR2. I have run into stone wall after stone wall. I think there has been some internal confusion and debate over what to include in 9iR2, based on some of what I've heard. I've even heard that Logical Stand-by will not be in 9iR2, but I can not verify this. Looking hard, will report if I find anything. RF -Original Message- Sent: Monday, May 06, 2002 11:14 AM To: Multiple recipients of list ORACLE-L The big thing that I'm looking forward to is the logical standby database. This will allow you to apply logs between different versions of Oracle. Should allow us to drastically reduce downtime during upgrades. -Original Message- Sent: Friday, May 03, 2002 6:18 PM To: Multiple recipients of list ORACLE-L You can sure that Oid will be better - because lets face it - it couldn't have got any worse :-) --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > Does anyone know of or have a list of new > features/fixes for Release 2 of > 9i? I can't find anything on oracle.com except XML > XML XML. > > Just wondering if OiD gets any better, I guess. :) > > TIA, > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jesse, Rich > 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Miller, Jay 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: 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: Ben Poels INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
SSL and non-SSL requests on same Apache server in 9iAS?
Hi, I want to host SSL and non-SSL requests on one physical server running one 9iAS. After installing 9iAS the httpd.conf file specifies by default that it is listening on port . Later on in httpd.conf it has an SSL directive that says it's listening on port 80 and 443. Does this mean that this one Apache server can service non-SSL requests on and SSL requests on 443 at the same time? There is a document on Metalink(135231.1) that describes how to run two Apache servers in one 9iAS home. Again what is not clear to me is whether or not one could be handling SSL and the other non-SSL. Anyone have any recommendations on how to do this? I may also be asked to host 40-bit and 128-bit encryption on the same web site. Again any recommendations? Thanks. ====== Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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).
Hundreds of schemas in one instance?
Hi Our university wants to set up a server that will provide groups on campus with a standard set of services for web hosting, data collection or whatever they want to do. As much as possible each user should have their own isolated chunk of the server. An Oracle database will sit in the background to provide whatever database services they need. My thought is to go with one instance with a unique schema, including separate tablespaces/datafiles, for each user. Some of the pros for this are: - easy set up for new users - easy software upgrades - simplified tuning, backups, monitoring, auditing - user isolation, especially disk space usage - multiple instances would use far more memory Some cons are: - everyone must use the same release of the software - database down time affects everyone - might run into system maximums, for example max. number of datafiles - an enormous SYSTEM tablespace Has anyone had to this kind of thing? Any comments or suggestions? TIA, Ben == Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: Hundreds of schemas in one instance?
Hi The assumption is that every user of this system will have totally unique requirements. There will be no data sharing and no commonality of purpose. As far as alternatives I am not even thinking about multiple instances. Other alternatives include - many schemas and one tablespace, or many schemas and an arbitrary number of tablespaces, or an arbitrary number of schemas matched to an arbitrary number of tablespaces, or one schema for all users using fine grained access control (thanks for the idea Jack it sounds quite useful). Peter: All users would be equal and no critical systems will be housed on this instance, but backup and recovery is definitely complicated by having so many data files and tablespaces. By the "opposite direction" do you mean only one tablespace. Jared: The benefit is isolation. As much as possible keep the users from affecting each other. Performance effects are unavoidable but separate tablespaces would keep one user from gobbling up all the available disk space. Will definitely have to watch out for the data dictionary filling up the SYSTEM tablespace and bringing everything to a screeching halt. Ben -Original Message- Sent: Wednesday, March 06, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Hi Our university wants to set up a server that will provide groups on campus with a standard set of services for web hosting, data collection or whatever they want to do. As much as possible each user should have their own isolated chunk of the server. An Oracle database will sit in the background to provide whatever database services they need. My thought is to go with one instance with a unique schema, including separate tablespaces/datafiles, for each user. Some of the pros for this are: - easy set up for new users - easy software upgrades - simplified tuning, backups, monitoring, auditing - user isolation, especially disk space usage - multiple instances would use far more memory Some cons are: - everyone must use the same release of the software - database down time affects everyone - might run into system maximums, for example max. number of datafiles - an enormous SYSTEM tablespace Has anyone had to this kind of thing? Any comments or suggestions? TIA, Ben ====== Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: Hundreds of schemas in one instance?
Hi The assumption is that every user of this system will have totally unique requirements. There will be no data sharing and no commonality of purpose. As far as alternatives I am not even thinking about multiple instances. Other alternatives include - many schemas and one tablespace, or many schemas and an arbitrary number of tablespaces, or an arbitrary number of schemas matched to an arbitrary number of tablespaces, or one schema for all users using fine grained access control (thanks for the idea Jack it sounds quite useful). Peter: All users would be equal and no critical systems will be housed on this instance, but backup and recovery is definitely complicated by having so many data files and tablespaces. By the "opposite direction" do you mean only one tablespace. Jared: The benefit is isolation. As much as possible keep the users from affecting each other. Performance effects are unavoidable but separate tablespaces would keep one user from gobbling up all the available disk space. Will definitely have to watch out for the data dictionary filling up the SYSTEM tablespace and bringing everything to a screeching halt. Ben -Original Message- Sent: Wednesday, March 06, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Hi Our university wants to set up a server that will provide groups on campus with a standard set of services for web hosting, data collection or whatever they want to do. As much as possible each user should have their own isolated chunk of the server. An Oracle database will sit in the background to provide whatever database services they need. My thought is to go with one instance with a unique schema, including separate tablespaces/datafiles, for each user. Some of the pros for this are: - easy set up for new users - easy software upgrades - simplified tuning, backups, monitoring, auditing - user isolation, especially disk space usage - multiple instances would use far more memory Some cons are: - everyone must use the same release of the software - database down time affects everyone - might run into system maximums, for example max. number of datafiles - an enormous SYSTEM tablespace Has anyone had to this kind of thing? Any comments or suggestions? TIA, Ben ====== Ben Poels - Senior Technical Analyst - Queen's University at Kingston Phone: 613.533.2449 Fax: 613.533.2168 Email: [EMAIL PROTECTED] == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: New born DBA.....
Here is a quick list: Daily checks - Oracle Alert file logs - system resources - backups - archive logs - error logs Weekly checks - free space in Tablespaces, Tables, Indexes and Clusters Monthly checks - fragmentation in Tables, Indexes and Clusters Ben Poels Queen's University -Original Message- Xing Sent: Tuesday, March 27, 2001 7:46 PM To: Multiple recipients of list ORACLE-L Hi guys, I am a new DBA, can you please tell me what are the common task list as DBA for Oracle8i on Solaris 7. I mean things that I should do and check regularly. I know backup is one of them. Thank you Sinardy Soon be OCP certified -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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: Ben Poels 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).
skipping the java.sh step in database create
Hi, If you are not using anything to do with Java is it then safe to skip running the java.sh script that dbassist creates during database creation in Oracle 8.1.7? This step takes forever and uses a lot of System tablespace. Ben Poels Queen's University Kingston, Ontario -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: Off Topic: How to set up a unix job in cron?
Hi, Wouldn't: 0 * * * * yourjobpath/yourjobscript be simpler Ben -Original Message- Sent: Monday, February 12, 2001 12:00 AM To: Multiple recipients of list ORACLE-L 0 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23 * * * YourJobPath/YourJobScript Djordje - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Sunday, February 11, 2001 10:10 PM > Hello fellas, > > Could any one please tell me how to set up a job (a unix shell script) as a cron job, so that it runs every 1 hour every day? The platforms is aix 4.33 and also Solaris 8 and also HP 11. > > Thanks and Regards, > > raja > > > Get your small business started at Lycos Small Business at http://www.lycos.com/business/mail.html > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viraj Luthra > 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: djordjej 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: Ben Poels 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).
final word on 8.1.7 install and java?
Hi, I did not really see a comprehensive answer on the java questions involving 8.1.7 installs. I installed 8.1.7 on AIX 4.3.2 and the 1.1.8 jre was installed. The install asked for a location for the JDK. I just created an empty /opt/java directory with another telnet session, hit continue and it happily carried on. I think I just have to install JDK in this directory now and all will be well. Is this true? Ben -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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).
Can Oracle7 and Oracle8 co-exist?
Hi, I want to install Oracle 8.1.7 on the same AIX 4.3.2 box which is already running Oracle 7.3.4.5. I will use a separate Oracle owner and Oracle home for the new 8.1.7 software. Has anybody had any problems with these two versions co-existing on the same platform? I have them both installed now but before I spend a lot of time trying to break it I thought I'd check to see whether or not this has worked out at other sites. Thanks, Ben Poels Queen's University Kingston, Ontario -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben Poels 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: Can Oracle7 and Oracle8 co-exist?
Hi Scott, Nice to hear from you again. I am migrating several warehouses on the same server from 734 to 817. If I use a separate owner then I won't have to worry about running different profiles when I sign on. (heh I'm getting older with some gray hairs and I am liable to forget which set of databases I'm working on). I also can set up separate cron jobs under the different owner sign-ins and easily migrate one warehouse at a time. I don't really see any drawbacks to using different owners even if it isn't a requirement. Ben Poels Queen's University Kingston, Ontario (613)533-2449 -Original Message- Canaan Sent: Friday, February 23, 2001 4:47 PM To: Multiple recipients of list ORACLE-L Ben, This is no problem. They don't need to have different owners. If you are running Oracle Applications 10.7, and you want to use an Oracle 8i instance to house it, then you must do this type of install. You will have 2 Oracle homes, each with it's own database listener and all associated files. They will be installed in separate directories, by default. You will need to have a way to setup your environment when you login to pick the Oracle home you want to use and setup all of the environment variables correctly. Ben Poels wrote: > Hi, > > I want to install Oracle 8.1.7 on the same > AIX 4.3.2 box which is already running > Oracle 7.3.4.5. I will use a separate Oracle > owner and Oracle home for the new 8.1.7 software. > > Has anybody had any problems with these two > versions co-existing on the same platform? > I have them both installed now but before > I spend a lot of time trying to break it I > thought I'd check to see whether or not this > has worked out at other sites. > > Thanks, > > Ben Poels > Queen's University > Kingston, Ontario > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ben Poels > 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). -- Scott Canaan ([EMAIL PROTECTED]) "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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: Ben Poels 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: Svrmgrl "connect internal" asks for password??
If you want to search for that document you need to enter 69642.1 for the document no. search on the advanced search page. Ben Poels Queen's University -Original Message- Sent: Thursday, March 08, 2001 9:01 AM To: Multiple recipients of list ORACLE-L If you have access to Metalink there is a good article there (Doc. 69642 or just put your subject in search), which lists all different causes why this might happen audit dir being full is one of them, ORACLE_HOME and/or SID set inapropriatelly, and a number of others. Djordje - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, March 07, 2001 1:06 PM > Try looking in $ORACLE_HOME/rdbms/audit directory. If this directory is > full, it can not create the .aud file to log that someone is using svrmgrl and > will > ask for password. > > Terry > > "Fowler, Kenneth R" wrote: > > > List, > > > > I have an installation of Oracle 8.1.6 on a DBA test server where svrmgrl > > "connect internal" seems to want a password... > > > > Sun Microsystems Inc. SunOS 5.8 Generic February 2000 > > > > Configured oracle environment aliases... > > > > Alias SID Oracle Home > > - --- --- > > dba816dba816/Volumes/app/oracle/product/8.1.6 > > dba817dba817/Volumes/app/oracle/product/8.1.7 > > > > $ id > > uid=301(oracle) gid=300(dba) > > $ groups > > dba > > $ env | grep ORACLE > > ORACLE_BASE=/Volumes/app/oracle > > $ dba816 > > dba816 $ env | grep ORACLE > > ORACLE_BASE=/Volumes/app/oracle > > ORACLE_SID=dba816 > > ORACLE_HOME=/Volumes/app/oracle/product/8.1.6 > > dba816 $ cdcreate > > /Volumes/app/oracle/admin/dba816/create > > dba816 $ svrmgrl > > > > Oracle Server Manager Release 3.1.6.0.0 - Production > > > > Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. > > > > Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production > > With the Partitioning option > > JServer Release 8.1.6.2.0 - Production > > > > SVRMGR> connect internal; > > Password: > > Password: > > ORA-01031: insufficient privileges > > SVRMGR> ^D > > Server Manager complete. > > dba816 $ dba817 > > dba817 $ env | grep ORACLE > > ORACLE_BASE=/Volumes/app/oracle > > ORACLE_SID=dba817 > > ORACLE_HOME=/Volumes/app/oracle/product/8.1.7 > > dba817 $ cdcreate > > /Volumes/app/oracle/admin/dba817/create > > dba817 $ svrmgrl > > > > Oracle Server Manager Release 3.1.7.0.0 - Production > > > > Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. > > > > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production > > With the Partitioning option > > JServer Release 8.1.7.0.0 - Production > > > > SVRMGR> connect internal; > > Connected. > > SVRMGR> ^D > > Server Manager complete. > > > > I know that the usual reason for this is that the account running svrmgrl is > > not a member of the appropriate unix group (usually "dba" or as specified at > > installation time) but this is not the case here. On this server I have > > Oracle 8.1.6 (Home = /Volumes/app/oracle/product/8.1.6) and Oracle 8.1.7 > > (Home = /Volumes/app/oracle/product/8.1.7). My login script sets up aliases > > for each SID listed in /var/opt/oracle/oratab. These aliases use the oraenv > > script with environment variable ORAENV_ASK=NO to set appropriate values for > > ORACLE_SID, ORACLE_HOME and PATH etc. Other than that, the environment is > > exactly the same regardless of what SID I switch to (see log above). > > However "connect internal" asks for a password for Oracle 8.1.6 but does not > > ask for one for Oracle 8.1.7. I am pretty sure that I specified that the > > group name be "dba" for 8.1.6 and 8.1.7 so that should not be the issue. > > > > Can anybody give me some pointers of other things to look at to try and > > resolve the problem??? > > > > Thanks, > > Ken > > _ > > Clinical and Regulatory Informatics - Groton/New London > > Coordinator, Business and Technical Services > > Tel: (860) 732-0026Fax: (860) 715-8346 > > Email: [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Fowler, Kenneth R > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego,