RE: (no subject)
I'm also a brand new student of Oracle. The EXACT same thing happened to me in class a couple of weeks ago when I created a 2nd database. The reason it happened was that I didn't create the DB all in one day...and when I went in on the 2nd day to finish it, I did notstartup the 2nd database before continuing to run the scripts, etc. So, the default database started and then some of the commands/scripts actually modified the default database's control files, etc. It was a real mess. We couldn't mount to delete certain files, yet we couldn't delete certain files in nomount, etc. The teacher had me run the attached script, and that fixed it. And I learned some more lessons, hahaha! I don't know if this is what happened to you, but since your situation is EXACTLY like mine, error messages, etc., I would suspect this. So check out the attached script and maybe it'll help. You'll have to modify the .sql file to replace with your database names. In the existing file, "will" is the default database and "test" is the database I was creating. Check through and fix up filenames, paths, etc. --JoJo -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, February 20, 2002 7:54 AMTo: Multiple recipients of list ORACLE-LSubject: (no subject)I'm a student dba'r running 9i on windows xp. I have created a second database (database name=bill, instance name = bill). After I first created it, I tried to mount it after shutting down the installation seed database (database name = orcl, instance name = orcl). I kept getting the message 'cannot mount database in exclusive mode'. After several attempts to get out of exclusive mode, I gave up. The next night, without making any changes, I tried again and this time I was sucessful in mounting the bill database. I created a data tablespace (data) and four tables which I populated. Then I queried the database name from v$database and got the response 'bill'. Next I queried the instance name from v$instance and got 'orcl' when I should have gotten 'bill'. I double checked the database name and again got 'bill'.nbs! ! p; How can this be? But the real problem is that when I tried to mount the database bill again tonight, I again got the message ''cannot mount database in exclusive mode'. I can't find an explanation for this in the book. I tried to startup nomount using the 'bill' pfile which showed an idel instance started. Then I tried to issue the alter database mount parallel command but it comes back with the 'cannot mount database in exclusive mode'. When I then query the instance_name from v$instance I get orcl instead of bill. Can any one help me out?Thanks!Bill Johnson CONTROL.SQL Description: Binary data
RE: (no subject)
One more thing about the script I sent -- that was for 8i, not 9i, so check it out in that respect, as well. Cheers, JoJo
Re: (No Subject)
hi, just do: '' represent ' SQL create table testtb(a varchar(90)); Table created. SQL insert into testtb values('i love oracle''s money'); 1 row created. SQL select * from testtb; A i love oracle's money SQL drop table testtb; Table dropped. - Original Message - From: C.S.Venkata Subramanian [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 29, 2001 1:30 PM Subject: (No Subject) HI Gurus, I want to insert single quotes with my data from my application. Some data will contain quotes and some may not. How can this be achieved? Kindly help TIA Regards C.S.Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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). æ¬zǶ¨}ø©ND ±@Bm§ÿðà +iöªrºØhÈZ¢§DMÈZ¢§Éòj(rV +r5ëp¢¹z»âqëçÎwó9ÔPó9ßÎtçT8'è®xæåÂ'µêçzÖqë,üÆ¢)à.+-±:Ã*.®Ç¥}úèØb²f¢)à+-±éÝjq +j)fzËëh.+-êî}«\Ü¢ièµá $ì¥éex(|¸¬´k«¹©Ý{azg¬±¨àØw%¹×)Þríj)â +I@ND º+¶§jg¨~f¢)à+-Ê°j{m¡·«zj/y×ë¢f(ºf²j[(±éݶ³Ü¢i×è®az¸§~æjبX¤z˱Êân)à
Re: (No Subject)
Thanks Chao -- On Thu, 28 Jun 2001 23:47:32 chao_ping wrote: hi, just do: '' represent ' SQL create table testtb(a varchar(90)); Table created. SQL insert into testtb values('i love oracle''s money'); 1 row created. SQL select * from testtb; A i love oracle's money SQL drop table testtb; Table dropped. - Original Message - From: C.S.Venkata Subramanian [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 29, 2001 1:30 PM Subject: (No Subject) HI Gurus, I want to insert single quotes with my data from my application. Some data will contain quotes and some may not. How can this be achieved? Kindly help TIA Regards C.S.Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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).