Oracle doesn't start up with domain user
Hi, I installed Oracle 9i under Windows 2000 professional with a domain user who has admin rights. After installing I couldn't use it: - If I log in with Administrator/Local Computer then the message of Net Manager (when testing the service) I got the error message Oracle not available After that if I start Oracle Database Configuration Assistant then modify database, go ahead with next, next etc. and finish it then the Oracle becomes available in Net Manager. After restarting the computer the same problem occurs. -- If I log in with Domain user /Domain then the message of Net Manager (when testing the service) I got the error message Initializing first test to use userid: scott, password: tiger Attempting to connect using userid: scott The test did not succeed. ORA-03113: end-of-file on communication channel After that if I start Oracle Database Configuration Assistant to modify database the error message is: ORA-01041: internal error.hostdef extension doesn't exist Both the Administrator and the Domain User are member of : administrators, oradba. I checked the services, they seem to start. Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Sql problem
Tim, Thank you very much for your help. I think it'll work. Zsolt At 07:04 2002.12.19. -0800, you wrote: Zsolt, In Oracle9i, you might be able to make use of the new WITH syntax: SQL> with xxx as 2 (select 1+2 calc from dual) 3 select calc*2 from xxx; CALC*2 -- 6 It might cut down on typographic errors (if not syntax complexity) from repeatedly retyping the same complex formula... Hope this helps... -Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sql problem
Hi, The following select does not work, I get ORA-00904 error message that the AgentShare column does not exists. It would be painful to write down every calculation many times because I can't make a reference to a previous calculated colunm. Select t.*,t.RowId , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding , CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare ,CONTRACT_SHARE_FIXED OtherShareFixed ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED /100 OtherSharePercentage ,AgentShare *2 From Contract_Rows T,Contract Where Contract.Contract_Unique = t.contr_rows_contract_unique Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Slow Application
Hi, Sorry. More clues: Customer side: The Oracle 8i on IBM E Server 230 PIII 899 , 512 Ram, Scsi hard disk.Linux Suse 7.1 operating system. My two separate configurations are - Oracle 9i on AMD Athlon 1200, 512 Ram, 10 Gb Scsi Quantum Viking HD, Linux Suse 7.1 - Oracle 9i on IBM 1700, 512 Ram, 40Gb IDE Maxtor HD, Windows Nt 4.0 The main customer table has only 5000 rows. There are 12 tables related in master-detail relationship in the program using foreign constraint. The application was written in Delphi 5 using Direct Oracle Access from Allaround Automations. Thank you, Zsolt Csillag, Hungary At 06:23 2002.08.13. -0800, you wrote: >Zsolt, > > I think we'll need some additional information, Like what type of > computer >are you and the customer using, what OS, how much data at each site, how many >users, a dump of V$SGA would help too as well as how the disks and files are >laid out. > >Dick Goulet > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Zsolt Csillag 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).
Slow Application
Hi, My application is _very_ slow at the customer's side. The same application is fast on my both computer. The only difference: My databases are 9i, the customer's is 8i. My tablespace is locally managed, the customer's is dictionary one. Both database are cost based and with new statistics gathered. Every table and index files are the same. Do you have any idea? Thank you in advance, Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Zsolt Csillag 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).
Dblink - How to connect two databases
Hi, I'd like to connect from one database to another.(both are 9i) One has a fix Ip address. In this database I made a dblink object. How can I connect to it from the other database? Do I have to make a connection from Net Manager? Please help me! Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Zsolt Csillag 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 9i doesn't start on Linux
Hi, I've installed Oracle 9i on Suse Linux 7.1. The lsnrctl starts nicely, however when I type "dbstart" then it does absolutelly nothing. No error message, but the database won't start. Any ideas? Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Zsolt Csillag 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).
