RE: (no subject)

2002-02-20 Thread JoJo Al-Zawawi



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)

2002-02-20 Thread JoJo Al-Zawawi



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)

2001-06-29 Thread chao_ping

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(r‰œœV­
+r5ëp¢¹z»âqëçÎwó9ÔPóŸ9ßÎtçTšœ8ž‚€š–'è®xšæå‰Â'µêçz֜që,üÆ¢–)à.+-±:Õ*.®Ç¥}úèšØb²f¢–)à–+-±éÝjq
+j)fzˁëh.+-êî}«\ŠÜœ¢ièµá$ì¥éeŠx(|¸¬´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)

2001-06-29 Thread C.S.Venkata Subramanian

 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).