Re: DB Config. Assistant
I assume you're talking about the dbassist tool. If it's working as on unix, you should find the log files in $ORACLE_BASE/admin/$ORACLE_SID/create. I prefer the old way, using scripts, this way I can rerun the scripts for all the different environnements. HTH --- KENNETH JANUSZ [EMAIL PROTECTED] a écrit : 9i on XP Prof. on DELL PC (no network) I tried to use DBCA to create a DB on my PC. I have never used this tool before. It appeared to run OK with no errors. However, when I query the V$ views I don't see it and I cannot connect to it. I ran DBCA twice to create the DB and the second time I didn't get any error message saying the DB already existed. I don't know that I should since I have never used DBCA before. If there is anyone out there that have used this tool before please give me some insight into it. Thanks and have a good day, Ken Janusz, CPIM = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: DB Config. Assistant
Stefen: I have to apologize, I goofed. In dbca the final wizard window has an OK button at the bottom. It was below my lower screen edge and I didn't see it. So, I didn't press it and of course didn't create the DB. On my third time through the process I noticed this button, pressed it and 45 min. later had my DB. I went out on TOAD and there it is. It sure helps if you know what the heck you are doing. Ah Duh! Thanks for the help and have a good day, Ken Janusz, CPIM - Original Message - From: Stefan Jahnke To: Multiple recipients of list ORACLE-L Sent: Tuesday, April 30, 2002 9:20 AM Subject: AW: DB Config. Assistant Hi I don't use dbca, but did it even create the data dictionary ? Run catalog.sql and catproc.sql (and whatever you need) to create it manually. Regards, Stefan -Ursprüngliche Nachricht-Von: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Gesendet: Dienstag, 30. April 2002 15:38An: Multiple recipients of list ORACLE-LBetreff: DB Config. Assistant 9i on XP Prof. on DELL PC (no network) I tried to use DBCA to create a DB on my PC.I have never used this tool before. It appeared to run OK with no errors. However, when I query the V$ views I don't see it and I cannot connect to it. I ran DBCA twice to create the DB and the second time I didn't get any error message saying the DB already existed. I don't know that I should since I have never used DBCA before. If there is anyone out there that have used this tool before please give me some insight into it. Thanks and have a good day, Ken Janusz, CPIM
Re: DB Config. Assistant
Hi Ken, When you run the database configuration assistant (DBCA) it asks you to provide the sid for the database. You should be able to see the service associated with this database by looking at the "services". Don't know ANY XP but the service should be named "OracleServiceSID". Check to make sure that this service is started. If not you will have to start this service before you can connect. Assuming that it is started you can connect from a dos window by typing set oracle_sid="yoursid" sqlplus system/manager from here you should be able to query the dd tables. John [EMAIL PROTECTED] wrote: 9i on XP Prof. on DELL PC (no network) I tried to use DBCA to create a DB on my PC.I have never used this tool before. It appeared to run OK with no errors. However, when I query the V$ views I don't see it and I cannot connect to it. I ran DBCA twice to create the DB and the second time I didn't get any error message saying the DB already existed. I don't know that I should since I have never used DBCA before. If there is anyone out there that have used this tool before please give me some insight into it. Thanks and have a good day, Ken Janusz, CPIM