Compiled Messages:
------------------------------------------------------------
Message no. 7398
Posted by Abhash Bhandary (abhandary) on Wednesday, April 12, 2006 3:11pm
Subject: project09
Do we also have to give the default setting for the tablespace we
create on project 9?
Abhash
------------------------------------------------------------
Message no. 7399[Branch from no. 7398]
Posted by Abhash Bhandary (abhandary) on Wednesday, April 12, 2006 3:15pm
Subject: Re: project09
oh sorry guys i think i am too tired or something ...it is clearly given
in the question what the default settings are ....silly of me.
Abhash
------------------------------------------------------------
Message no. 7403[Branch from no. 7399]
Posted by Bikash Adhikari (badhikari) on Wednesday, April 12, 2006 8:52pm
Subject: Re: project09
Yes you are right ..... I guess you are too tired.
BIkash
------------------------------------------------------------
Message no. 7412[Branch from no. 7403]
Posted by Muhammad Latif (mlatif) on Thursday, April 13, 2006 1:54am
Subject: Re: project09
Hey Abhash:
Well u didnt give us any room to reply. :)
Arsal
------------------------------------------------------------
Message no. 7415[Branch from no. 7412]
Posted by Waseem Manzoor (wmanzoor) on Thursday, April 13, 2006 1:59am
Subject: Re: project09
Good job Abash, You solved it-----:)
Waseem Manzoor
------------------------------------------------------------
Message no. 7416[Branch from no. 7398]
Posted by Antoinette Lockett (arlockett) on Thursday, April 13, 2006 2:28am
Subject: Re: project09
Abhash,
I guess it your paper getting the best of you.
------------------------------------------------------------
Message no. 7420[Branch from no. 7399]
Posted by Kelli Lemon (kmlemon) on Thursday, April 13, 2006 1:38pm
Subject: Re: project09
Yea get some rest Abhash, it's well deserved.
------------------------------------------------------------
Message no. 7421
Posted by Alex Auffenorde (aaauffenorde) on Thursday, April 13, 2006 5:33pm
Subject: BIG PROBLEM
Alright guys & ladies here is a great problem to wrap your heads around.
I am unable to log into SQL. I recieve the error ORA-01033. This error
means that the database is either in the middle of starting up or
shutting down and thus I cannot connect. I have worked on this problem
for over 4 hours and to no avail. I have googled this to no end, I have
tried every utility that came with the ORACLE 10G install and there is
no help there.
Have any of you encountered this error? If so how did you fix it.
Well Im off to crack some more code.
Alex
------------------------------------------------------------
Message no. 7422[Branch from no. 7398]
Posted by Gwendolyn Mobley (gdmobley) on Thursday, April 13, 2006 5:39pm
Subject: Re: project09
Abhash
I've overlooked instructions myself..glad you found your answer.
Gwen
------------------------------------------------------------
Message no. 7425[Branch from no. 7421]
Posted by Rhonda Nichols (renichols2) on Thursday, April 13, 2006 9:16pm
Subject: Re: BIG PROBLEM
DID You try this:
1) SHUTDOWN IMMEDIATE; followed by a STARTUP;
-Rhonda
------------------------------------------------------------
Message no. 7426
Posted by Rhonda Nichols (renichols2) on Thursday, April 13, 2006 9:26pm
Subject: Math Problem
UNBELIEVABLE MATH PROBLEM
Here is a math trick so unbelievable that it will stump you.
1. Grab a calculator. (you won't be able to do this one in your head)
Go ahead I'll wait.....
2. Key in the first three digits of your phone number (NOT the area code)
3. Multiply by 80
4. Add 1
5. Multiply by 250
6. Add the last 4 digits of your phone number
7. Add the last 4 digits of your phone number again.
8. Subtract 250
9. Divide number by 2
Do you recognize the answer?
------------------------------------------------------------
Message no. 7427
Posted by Rhonda Nichols (renichols2) on Thursday, April 13, 2006 10:02pm
Subject: pROJECT 9 PROBLEM
I am getting the following error when trying to create my tablespace:
Error on line 2
CREATE TABLESPACE TEC5323DATA
DATAFILE
'C:\TEMP\TEC5323DATA.DBF' SIZE 100 K
ORA-12913: Cannot create dictionary managed tablespace
Anyone else having this problem? It seems my SYSTEM tablespace was set up as locally
managed and can't be changed now. Do I have to reload?
------------------------------------------------------------
Message no. 7428[Branch from no. 7421]
Posted by Krishnamurth Ashwini (kashwini) on Thursday, April 13, 2006 11:33pm
Subject: Re: BIG PROBLEM
Alex,
I found a myriad of solutions for this particular error. The ones I have
listed below are the most recommended by several Oracle users. You may
have already tried some of these.
Problem: ORA-01033
Cause:
An attempt was made to log on while Oracle is being started up or shutdown.
Possible solutions:
1. This means that your database is either starting or closing. Its
better to wait untill this process get completed.
2. Try to restart the machine and wait until all the processes have
started completely.
3. Type the following commands at the SQL prompt
SQL> sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown abort
SQL> startup nomount
SQL> alter database mount;
SQL> alter database open;
SQL>shutdown normal
SQL>startup
Visit this website to view more solutions for this problem. You may be
able to relate to a similar problem listed in this website.
http://www.orafaq.com/forum/t/38120/0/
Let me know when you find a solution.
Ash
------------------------------------------------------------
Message no. 7429[Branch from no. 7426]
Posted by Krishnamurth Ashwini (kashwini) on Thursday, April 13, 2006 11:39pm
Subject: Re: Math Problem
Rhonda,
This surely is a fine problem. But if you closely observe these steps
(or evaluate the equation), it is actually asking us to
1. multiply the first three digits of our phone number with 1000 and then
2. add the rest of the 4 digits to it.
For example...if your phone number is 234-5678
1. 234*1000 =234000
2. 234000+5678 = 2345678
I surely had fun with this.
Thanks
Ash
------------------------------------------------------------
Message no. 7430[Branch from no. 7429]
Posted by Krishnamurth Ashwini (kashwini) on Thursday, April 13, 2006 11:41pm
Subject: Re: Math Problem
Sorry, missed a zero....It's 10,000 not 1000
------------------------------------------------------------
Message no. 7431[Branch from no. 7428]
Posted by Gnaneshwar Bukka (gbukka) on Friday, April 14, 2006 2:49am
Subject: Re: BIG PROBLEM
Hey Alex...great information.....thank you...
Gnaneshwar Bukka.
------------------------------------------------------------
Message no. 7432[Branch from no. 7426]
Posted by Gnaneshwar Bukka (gbukka) on Friday, April 14, 2006 2:52am
Subject: Re: Math Problem
Excellent Rhonda...I got my phone number...this is good stuff...
Gnaneshwar Bukka.
------------------------------------------------------------
Message no. 7434[Branch from no. 7427]
Posted by Rohini Shrestha (rshrestha) on Friday, April 14, 2006 4:06am
Subject: Re: pROJECT 9 PROBLEM
ORA-12913: Cannot create dictionary managed tablespace
Cause: An attempt was made to create a dictionary managed tablespace in
a database whose SYSTEM tablespace is locally managed.
Action: Create a locally managed tablespace.
Try following codes, it may work but I am not sure...
To create a locally managed tablespace ( in fact to change from
dictionary managed to locally managed tablespace):
SQL> begin
2 dbms_space_admin.tablespace_migrate_to_local
3 (tablespace_name=> 'USERS', rfno=>5);
4 end;
5 /
To verify that tablespace is now locally-managed:
SQL> select TABLESPACE_NAME, EXTENT_MANAGEMENT
2 FROM DBA_TABLESPACES
3 where tablespace_name = 'USERS';
Visit this website for more information
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1163235055159
Rohini
------------------------------------------------------------
Message no. 7440[Branch from no. 7428]
Posted by Imran Pathan (ipathan) on Friday, April 14, 2006 6:37am
Subject: Re: BIG PROBLEM
Heyyy Thank you for the information
Imran
------------------------------------------------------------
Message no. 7441[Branch from no. 7426]
Posted by Imran Pathan (ipathan) on Friday, April 14, 2006 6:38am
Subject: Re: Math Problem
Hi Rhonda,
Nice math problem
Imran
------------------------------------------------------------
Message no. 7442[Branch from no. 7434]
Posted by Imran Pathan (ipathan) on Friday, April 14, 2006 6:39am
Subject: Re: pROJECT 9 PROBLEM
Hi Rohini,
Thanks for the link That is really helpful
Imran
------------------------------------------------------------
Message no. 7443[Branch from no. 7429]
Posted by Rhonda Nichols (renichols2) on Friday, April 14, 2006 7:49am
Subject: Re: Math Problem
Great observation Ash!!!
-Rhonda
------------------------------------------------------------
Message no. 7444[Branch from no. 7428]
Posted by Alex Auffenorde (aaauffenorde) on Friday, April 14, 2006 12:05pm
Subject: Re: BIG PROBLEM
Thank you for your advice. I have tried the restart, but it still
doesn't work. As for the SQL commands, I cannot even log on to get an
SQL prompt.
-Alex
------------------------------------------------------------
Message no. 7445[Branch from no. 7422]
Posted by Abhash Bhandary (abhandary) on Friday, April 14, 2006 1:10pm
Subject: Re: project09
Thankyou Guys
------------------------------------------------------------
Message no. 7446[Branch from no. 7441]
Posted by Abhash Bhandary (abhandary) on Friday, April 14, 2006 1:17pm
Subject: Re: Math Problem
i tried to use some brain ........but the system says....no brain
found........
good one Rhonda
Abhash
------------------------------------------------------------
Message no. 7447[Branch from no. 7442]
Posted by Abhash Bhandary (abhandary) on Friday, April 14, 2006 1:18pm
Subject: Re: pROJECT 9 PROBLEM
Good info Rohini ..Thanx
Abhash
------------------------------------------------------------
Message no. 7450[Branch from no. 7444]
Posted by Bikash Adhikari (badhikari) on Friday, April 14, 2006 2:51pm
Subject: Re: BIG PROBLEM
Alex,
I dont know if by this time you have already fixed your problem, but the
most common solution that i came up with is to, wait a few minutes, then
retry the operation.
Hope that might have helped you.
BIkash
------------------------------------------------------------
Message no. 7451[Branch from no. 7426]
Posted by Bikash Adhikari (badhikari) on Friday, April 14, 2006 2:52pm
Subject: Re: Math Problem
Very nice. I had fun with it.
Thank you.
BIkash
------------------------------------------------------------
Message no. 7454[Branch from no. 7444]
Posted by Kelsey Pooley (kjpooley) on Friday, April 14, 2006 3:31pm
Subject: Re: BIG PROBLEM
This happened to me two weeks ago. I would get the pop up box to type in my
username, password and SSID and then it would just sit there, never giving me a
prompt. After trying everything I could think of (including reinstalling Oracle) for about
four days, I ran my recovery disks for my computer and reinstalled Oracle. It worked,
but it probably wasn't the most efficient solution. VERY FRUSTRATING AND TIME
CONSUMING : )
I wish I had some better advice. I couldn't figure out why it worked one day and not the
next. I thought maybe I had a virus or something on my computer?
Good luck Alex.
Kelsey
------------------------------------------------------------
Message no. 7455[Branch from no. 7421]
Posted by Sagun Piya (srpiya2) on Friday, April 14, 2006 9:21pm
Subject: Re: BIG PROBLEM
thank you guys,
I again came to know one of the several problems while connecting to oracle. Thanks for
information
Sagun
------------------------------------------------------------
Message no. 7456[Branch from no. 7427]
Posted by Sagun Piya (srpiya2) on Friday, April 14, 2006 9:22pm
Subject: Re: pROJECT 9 PROBLEM
thanks for a Good info
sagun
------------------------------------------------------------
Message no. 7461[Branch from no. 7421]
Posted by Gwendolyn Mobley (gdmobley) on Friday, April 14, 2006 9:42pm
Subject: Re: BIG PROBLEM
Alex,
all the info I've found is the same as Ash, Rhonda and everyone else. Sorry I couldn't
find more useful info. I can't wait to get oracle off my machine.
Gwen
------------------------------------------------------------
Message no. 7462[Branch from no. 7426]
Posted by Gwendolyn Mobley (gdmobley) on Friday, April 14, 2006 9:45pm
Subject: Re: Math Problem
Rhonda,
yep...UNBELIEVABLE!!!
gwen
------------------------------------------------------------
Message no. 7464[Branch from no. 7434]
Posted by Gwendolyn Mobley (gdmobley) on Friday, April 14, 2006 9:47pm
Subject: Re: pROJECT 9 PROBLEM
Rohini,
good info thanks.
gwen
------------------------------------------------------------
Message no. 7466[Branch from no. 7456]
Posted by Krupa Kandavalli (kkandavalli) on Saturday, April 15, 2006 9:36am
Subject: Re: pROJECT 9 PROBLEM
Hi Rohini ,
Good Information
Thank you
------------------------------------------------------------
Message no. 7467
Posted by Abhash Bhandary (abhandary) on Saturday, April 15, 2006 9:36am
Subject: Proj 09
I was trying to do the project 9 and I specified all the sizes as given
in the problem but i ran into a problem. When i run the query i get the
message :
ORA-03214: File Size specified is smaller than minimum required
The initial size that i put was 100K as asked by the problem,......then
just to check i set the initial size to 200K and the query seems to run
properly
Has anyone had the same problem??? Can any one suggest what i am doing
wrong?
Abhash
------------------------------------------------------------
Message no. 7470[Branch from no. 7426]
Posted by Swarna Bangaru (sbangaru) on Saturday, April 15, 2006 11:24am
Subject: Re: Math Problem
I surely did have fun doing this. Thanks for sharing.
------------------------------------------------------------
Message no. 7471[Branch from no. 7444]
Posted by Harold Harris (hjharris2) on Saturday, April 15, 2006 12:20pm
Subject: Re: BIG PROBLEM
Alex,
I would look in the "Processes Tab" of my machine's "Task Manager" to determine if any
Oracle related process is running in the background. If so...I would end that processes
and reboot my machine.
HH
------------------------------------------------------------
Message no. 7472[Branch from no. 7467]
Posted by Bikash Adhikari (badhikari) on Saturday, April 15, 2006 12:28pm
Subject: Re: Proj 09
Abhash
This is what i have found for the error you are having. And i think that the solution to it is to increase the file size as you did.
ORA-03214: File Size specified is smaller than minimum required.
Cause: File size specified for add/resize datafile/temporary file does not allow for the minimum required of one allocation unit.
Action: Increase the specification for the file size.
I hope that this helps you in some way.
BIkash
------------------------------------------------------------
Message no. 7473[Branch from no. 7426]
Posted by Venkat Munagala (vrmunagala) on Saturday, April 15, 2006 2:52pm
Subject: Re: Math Problem
That was really a good stuff Rhonda
Rohit
------------------------------------------------------------
Message no. 7474[Branch from no. 7427]
Posted by Venkat Munagala (vrmunagala) on Saturday, April 15, 2006 2:54pm
Subject: Re: pROJECT 9 PROBLEM
Thank you for the information
------------------------------------------------------------
Message no. 7483[Branch from no. 7426]
Posted by Phanindra Maddhi (pmaddhi) on Saturday, April 15, 2006 3:22pm
Subject: Re: Math Problem
Nice stuff Rhonda
------------------------------------------------------------
Message no. 7486[Branch from no. 7426]
Posted by Waseem Manzoor (wmanzoor) on Saturday, April 15, 2006 3:54pm
Subject: Re: Math Problem
I got my no
------------------------------------------------------------
Message no. 7487[Branch from no. 7472]
Posted by Waseem Manzoor (wmanzoor) on Saturday, April 15, 2006 3:57pm
Subject: Re: Proj 09
I incremented by 100K and it worked in my case.
Waseem
------------------------------------------------------------
Message no. 7491[Branch from no. 7461]
Posted by Muhammad Latif (mlatif) on Saturday, April 15, 2006 4:22pm
Subject: Re: BIG PROBLEM
Hey Alex:
I agree with Kelsey.
Arsal
------------------------------------------------------------
Message no. 7492[Branch from no. 7491]
Posted by Phanindra Maddhi (pmaddhi) on Saturday, April 15, 2006 4:25pm
Subject: Re: BIG PROBLEM
I agree with u
------------------------------------------------------------
Message no. 7493[Branch from no. 7426]
Posted by Muhammad Latif (mlatif) on Saturday, April 15, 2006 4:32pm
Subject: Re: Math Problem
Hey Rhonda:
Good exercise :)
Arsal
------------------------------------------------------------
Message no. 7494[Branch from no. 7429]
Posted by Muhammad Latif (mlatif) on Saturday, April 15, 2006 4:34pm
Subject: Re: Math Problem
Hey Ash:
I can't understand how you made this interpretation. The formula Rhonda has given is
completely different from what you are saying.
Arsal
------------------------------------------------------------
Message no. 7495[Branch from no. 7474]
Posted by Muhammad Latif (mlatif) on Saturday, April 15, 2006 4:37pm
Subject: Re: pROJECT 9 PROBLEM
Hey Rohini:
Thanks for the information. I hope it helped Rhonda.
Arsal
------------------------------------------------------------
Message no. 7496[Branch from no. 7487]
Posted by Muhammad Latif (mlatif) on Saturday, April 15, 2006 4:39pm
Subject: Re: Proj 09
Hey Abhash:
It was working fine with me!
Arsal
------------------------------------------------------------
Message no. 7497[Branch from no. 7494]
Posted by Krishnamurth Ashwini (kashwini) on Saturday, April 15, 2006 7:12pm
Subject: Re: Math Problem
Arsal,
Just solve the equation as given in the steps (assuming first three
digits of the phone number as 'x' and the next four digits as 'y'). You
will get what I said.
Ash
------------------------------------------------------------
Message no. 7498[Branch from no. 7426]
Posted by Kelli Lemon (kmlemon) on Saturday, April 15, 2006 8:13pm
Subject: Re: Math Problem
Rhonda,
That was pretty good. I've done something similar to that before but I was able to get my
birthdate or something like that. Thanks for sharing
Kelli
------------------------------------------------------------
Message no. 7504
Posted by Alex Auffenorde (aaauffenorde) on Saturday, April 15, 2006 10:45pm
Subject: Thanks
Thanks to those who tried to help me.
I finally figured it out. It turns out that my database was corrupted.
I tried the Recover Utility and it also did not work. I had to create
a new database and am using it now.
-Alex
------------------------------------------------------------
Message no. 7505[Branch from no. 7467]
Posted by Alex Auffenorde (aaauffenorde) on Saturday, April 15, 2006 10:47pm
Subject: Re: Proj 09
I also encountered this problem. It means that the initial file size is
too small. I corrected my by making it 1M. It then worked great.
It is not the incrementation, it is the initial implementation that the
error refers too.
-Alex
------------------------------------------------------------
Message no. 7509[Branch from no. 7426]
Posted by Krupa Kandavalli (kkandavalli) on Sunday, April 16, 2006 12:21am
Subject: Re: Math Problem
That was fun rhonda, I enjoyed the prob
------------------------------------------------------------
Message no. 7510[Branch from no. 7434]
Posted by Swarna Bangaru (sbangaru) on Sunday, April 16, 2006 12:22am
Subject: Re: pROJECT 9 PROBLEM
thanks for the info, the link was helpful
------------------------------------------------------------
Message no. 7512[Branch from no. 7504]
Posted by Abhash Bhandary (abhandary) on Sunday, April 16, 2006 4:40pm
Subject: Re: Thanks
Good to hear that you are back on track.
Abhash
------------------------------------------------------------
Message no. 7513[Branch from no. 7495]
Posted by Rhonda Nichols (renichols2) on Sunday, April 16, 2006 8:41pm
Subject: Re: pROJECT 9 PROBLEM
Thanks!
------------------------------------------------------------