Listener problems
Hi lists, I have some problem with my listener. That is resolved with the help of metalink. But I have a doubt in this regard. When I try to see the status, lsnrctl status 816LISTENER the statement hung for 10 minutes. I checked metalink and found the solution was, probably the size of listener.log is very big. So archive/remove it. In the mean time , this was resolved by another group of DBAs. In such a situations how to create another listener.log. If I stop/start the listener, this will affect the clients who are running trnx. how do i create another log. And how to know the size of listener.log (There is no parameter for this) is is o/s dependent? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) 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: RE: Unix Oracle Processes
Hi I am not sure if I have understood ur problem but can u please try this 1. cd $ORACLE_HOME/dbs 2. ls -alt lk*.ora 3. if there is any file by the name lk.ora where db_name is the database name and NOT SID then try removing this file and starting up the database again. do this ONLY if this database is NOT a. standby or b. Oracle parallel sever ( init.ora does NOT have any parallel server parameters!) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan 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: Unix Oracle Processes
Hi, Yes the SID is the same as the one I shut down. Also, when I try and start the database up it is giving me an ORA-01102 error (Cannot mount database in exclusive mode at startup). The other db on the system is shutdown properly. I had thought that only Win NT gives ORA01102 errors - not Unix - (but I;m wrong ofcourse!) Regards, Sujatha -Original Message- Sent: Monday, 26 November 2001 2:10 PM To: Multiple recipients of list ORACLE-L are you running more than one Oracle instance? you should see ora__smon -- is the value of sid the same as that of the database that you shutdown? did the database you think you shut down, shut down properly? --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > Hi, > > If I have shutdown my database doesn't that mean that all the smon, > pmon > processes will be killed??? > > After I shutdown my db and I do a ps -ef | grep ora I still see pmon, > smon, > lgwr etc processes. > > I am running HP-UX and v 8.1.7 > > Cheers, > > Sujatha > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sujatha Madan > 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Sujatha Madan 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: Unix Oracle Processes
are you running more than one Oracle instance? you should see ora__smon -- is the value of sid the same as that of the database that you shutdown? did the database you think you shut down, shut down properly? --- Sujatha Madan <[EMAIL PROTECTED]> wrote: > Hi, > > If I have shutdown my database doesn't that mean that all the smon, > pmon > processes will be killed??? > > After I shutdown my db and I do a ps -ef | grep ora I still see pmon, > smon, > lgwr etc processes. > > I am running HP-UX and v 8.1.7 > > Cheers, > > Sujatha > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sujatha Madan > 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). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
Unix Oracle Processes
Hi, If I have shutdown my database doesn't that mean that all the smon, pmon processes will be killed??? After I shutdown my db and I do a ps -ef | grep ora I still see pmon, smon, lgwr etc processes. I am running HP-UX and v 8.1.7 Cheers, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan 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: Morpheus killed my Oracle! Help!
Look in your /etc/services or inetd.conf file. It sounds like Morpheous still has a listener attached to the port and you need to remove the reverence to 1521. If inetd.conf needs editing you will need to send a kill -1 to the inetd process to re read the inetd.conf Cheers Peter McLarty E-mail: [EMAIL PROTECTED] Technical Consultant WWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia Mobile: +61 (0)402 094 238 -- Facsimile: +61 (0)7 3303 3048 Csillag Zsolt <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 26/11/2001 09:00 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject: Morpheus killed my Oracle! Help! Hi, I've installed Morpheus. Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt), because the 1521 port was already used. (that's why the listener couldn't start) I uninstalled Morpheus but the port is still used. I've tried other ports but every one seems to be used. Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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). -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.
Morpheus killed my Oracle! Help!
Hi, I've installed Morpheus. Right after that I couldn't attach to Oracle ( 8.1i under Windows Nt), because the 1521 port was already used. (that's why the listener couldn't start) I uninstalled Morpheus but the port is still used. I've tried other ports but every one seems to be used. Thank you in advance Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Operating Systems
There has been a version of Oracle for Solaris on Intel available for some time. Unfortunately that time is coming to an end. There will not be any Solaris Intel Oracle 9, so 8i is the end of the line for the platform. Regards, Chris Gait -- 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: Dba studio under 9i for Linux?
Hi, Thank you very much. It works. At 10:40 2001.11.18. -0800, you wrote: >Hi, > >Use oemapp in $ORACLE_HOME/bin. oemapp requiers some parameter (that tells >witch program to start (DBA studio among others)). If you call it without >parameters it will tell you possible values. > >regards > >torben holm > > >Csillag Zsolt wrote: > > > Hi, > > > > Can you tell me where can I find Dba Studio under Oracle 9i for Linux. > > I've tried the different files in the Bin directory with no result. > > > > T.I.A. > > > > Zsolt Csillag > > Hungary > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Csillag Zsolt > > 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). Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Import MS SQL Server 2000 DB into Oracle EE 8.1.7
Hi, Ms sql server itself has a migration utility which is better than Oracle's, and supports more diverse kinds of database and data types. I myself used that utility for transfering data from text files into oracle 8.1.7 give a try cheers :) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, November 25, 2001 9:30 PM > Jyoti, > > The Migration Workbench is designed to migrate the > structure and data. It's available as a free download > (once you register) from http://technet.oracle.com > > HTH, > > -- Anita > > --- "S.Jyotinarayan" <[EMAIL PROTECTED]> wrote: > > I have done a typical installation of Oracle 8i EE. > > I have the following: > > > > Ora-OraHome81 -> Enterprise Manager -> Migration > > Assistant > > Ora-OraHome81 -> Migration Utilities -> Oracle Data > > Migration Assistant > > > > I do not have Oracle Migration Workbench installed > > (where would it be, if i need it?). > > > > If Oracle Migration workbench works well for > > migrating the design of a MS SQL Server 2000 > > database to Oracle. What can I do for migrating the > > data too? > > > > Thanx a lot in advance > > Jyoti. > > > > - Original Message - > > From: Clinton Naude > > To: Multiple recipients of list ORACLE-L > > Sent: Thursday, November 22, 2001 4:45 PM > > Subject: RE: Import MS SQL Server 2000 DB into > > Oracle EE 8.1.7 > > > > > > Can't do the data, but the design yes. > > Oracle provides a tools called Oracle Migration > > qworkbench that works pretty well. > > Make sure that you change the table owner names > > etc to the correct owner. > > > > Good luck. > > > > Clint > > -Original Message- > > From: S.Jyotinarayan [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, November 22, 2001 12:45 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Import MS SQL Server 2000 DB into > > Oracle EE 8.1.7 > > > > > > Hi all, > > > > How do I import a MS SQL Server 2000 database > > (design and data) into Oracle EE 8.1.7 (typical > > installation) ? > > > > Thanx in advance > > > > > __ > Do You Yahoo!? > Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. > http://geocities.yahoo.com/ps/info1 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: A. Bardeen > 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: yilmaz 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: Import MS SQL Server 2000 DB into Oracle EE 8.1.7
Jyoti, The Migration Workbench is designed to migrate the structure and data. It's available as a free download (once you register) from http://technet.oracle.com HTH, -- Anita --- "S.Jyotinarayan" <[EMAIL PROTECTED]> wrote: > I have done a typical installation of Oracle 8i EE. > I have the following: > > Ora-OraHome81 -> Enterprise Manager -> Migration > Assistant > Ora-OraHome81 -> Migration Utilities -> Oracle Data > Migration Assistant > > I do not have Oracle Migration Workbench installed > (where would it be, if i need it?). > > If Oracle Migration workbench works well for > migrating the design of a MS SQL Server 2000 > database to Oracle. What can I do for migrating the > data too? > > Thanx a lot in advance > Jyoti. > > - Original Message - > From: Clinton Naude > To: Multiple recipients of list ORACLE-L > Sent: Thursday, November 22, 2001 4:45 PM > Subject: RE: Import MS SQL Server 2000 DB into > Oracle EE 8.1.7 > > > Can't do the data, but the design yes. > Oracle provides a tools called Oracle Migration > qworkbench that works pretty well. > Make sure that you change the table owner names > etc to the correct owner. > > Good luck. > > Clint > -Original Message- > From: S.Jyotinarayan [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 22, 2001 12:45 PM > To: Multiple recipients of list ORACLE-L > Subject: Import MS SQL Server 2000 DB into > Oracle EE 8.1.7 > > > Hi all, > > How do I import a MS SQL Server 2000 database > (design and data) into Oracle EE 8.1.7 (typical > installation) ? > > Thanx in advance > __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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).
hi
hi I am ashar from Karachi,Pakistan.I just wanna know that are oracle 9i exam guides of oracle press available in US? there are 4 exams of oracle 9i, are all 4 books available there.I heard that only oracle 9i sql book is available right now.Please do inform me. Ashar __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: M.A.Siddiqui 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: Import MS SQL Server 2000 DB into Oracle EE 8.1.7
How about trying the other way around - pushing the data from SQLServer to Oracle? There was a tool in SQL7 (not sure if they still have it in SQL2000 but I should think they do) called DTS (Data Transformation Service), that will transfer your tables with the data over to Oracle.. Have a read up about it to see if it fits your requirements.. HTH Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of S.JyotinarayanSent: 25 November 2001 05:50To: Multiple recipients of list ORACLE-LSubject: Re: Import MS SQL Server 2000 DB into Oracle EE 8.1.7 I have done a typical installation of Oracle 8i EE. I have the following: Ora-OraHome81 -> Enterprise Manager -> Migration Assistant Ora-OraHome81 -> Migration Utilities -> Oracle Data Migration Assistant I do not have Oracle Migration Workbench installed (where would it be, if i need it?). If Oracle Migration workbench works well for migrating the design of a MS SQL Server 2000 database to Oracle. What can I do for migrating the data too? Thanx a lot in advance Jyoti. - Original Message - From: Clinton Naude To: Multiple recipients of list ORACLE-L Sent: Thursday, November 22, 2001 4:45 PM Subject: RE: Import MS SQL Server 2000 DB into Oracle EE 8.1.7 Can't do the data, but the design yes. Oracle provides a tools called Oracle Migration qworkbench that works pretty well. Make sure that you change the table owner names etc to the correct owner. Good luck. Clint -Original Message-From: S.Jyotinarayan [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 22, 2001 12:45 PMTo: Multiple recipients of list ORACLE-LSubject: Import MS SQL Server 2000 DB into Oracle EE 8.1.7 Hi all, How do I import a MS SQL Server 2000 database (design and data) into Oracle EE 8.1.7 (typical installation) ? Thanx in advance