Home » SQL & PL/SQL » SQL & PL/SQL » password  () 1 Vote
password [message #249465] Wed, 04 July 2007 10:22 Go to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
hi ppl!!!
i had instald SQLplus few months back and was not using it.

but now when i have to use it for my project i realised that i have forgotten my password as i had changed it.
now i dont know what to do.

pls help me!! will i have to reinstall the program???



thank you
mummu

[Updated on: Wed, 04 July 2007 10:43]

Report message to a moderator

Re: password [message #249466 is a reply to message #249465] Wed, 04 July 2007 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Welcome to the forum
2/ Nothing is urgent in forum so "soon!!" is useless and counterproductive
3/ IM speak is not in use here, write english as correctly as you can
4/ You can locally connect "/ as sysdba" with OS Oracle owner and change the user password with "alter user".

Regards
Michel
Re: password [message #249467 is a reply to message #249465] Wed, 04 July 2007 10:29 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
U should read the sticky b4 posting using chat talk 2 get answers.
Re: password [message #249468 is a reply to message #249466] Wed, 04 July 2007 10:44 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
how do you connect using sysdba??
is sysdba the username?? if so, then what's the password???

Re: password [message #249469 is a reply to message #249468] Wed, 04 July 2007 10:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sqlplus "/ as sysdba"

Regards
Michel

Re: password [message #249472 is a reply to message #249469] Wed, 04 July 2007 10:59 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
i cant type any queries as i cant log on to the program!!!
how am i supose to use the above statement????
Re: password [message #249474 is a reply to message #249472] Wed, 04 July 2007 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
At OS prompt, connected with OS Oracle owner, just type what I posted.

Regards
Michel
Re: password [message #249475 is a reply to message #249474] Wed, 04 July 2007 11:16 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
sorry for that pm.
as soon as i click SQL plus, i get a dialogue box asking me for user name and password. now, what am i supose to do??
Re: password [message #249477 is a reply to message #249475] Wed, 04 July 2007 11:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you on the server containing the database?
Are you member of the ORA_DBA group?
If yes, just type "/ as sysdba" in the user field (without the "), nothing in the other fields.

Regards
Michel
icon10.gif  Re: password [message #249478 is a reply to message #249477] Wed, 04 July 2007 11:33 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
thanx a lot!!!!! it worked!!!
Re: password [message #249479 is a reply to message #249478] Wed, 04 July 2007 11:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I recommend you to read the Database Platform Guide for Microsoft Windows
Then to go to http://www.oracle.com/pls/db102/portal.portal_db?selected=1 and read all what you can.

Regards
Michel
Re: password [message #249482 is a reply to message #249479] Wed, 04 July 2007 11:45 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
but, i cant perform any queries
Re: password [message #249484 is a reply to message #249465] Wed, 04 July 2007 11:49 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
I can't fly.
Re: password [message #249485 is a reply to message #249484] Wed, 04 July 2007 11:50 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
ppl this is important. its no joke. i have to get my project done.
please help me!!!
Re: password [message #249486 is a reply to message #249465] Wed, 04 July 2007 11:53 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
You also can't read & follow the posting guidelines as found in the STICKY posts at the top of this forum.

Nobody is standing behind you so we can't see what you typed & how Oracle responded.

>i have to get my project done.
How much are you being paid for this effort?
Re: password [message #249487 is a reply to message #249485] Wed, 04 July 2007 11:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste your screen, the whole session AFTER having read How to format your posts and applying it.

Regards
Michel
Re: password [message #249488 is a reply to message #249486] Wed, 04 July 2007 11:55 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
are you going to help me or not?????
Re: password [message #249489 is a reply to message #249465] Wed, 04 July 2007 11:56 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
OK, have it your way.
NOT
You're On Your Own (YOYO)!
Re: password [message #249492 is a reply to message #249487] Wed, 04 July 2007 12:03 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jul 4 20:56:58 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> create table me (s_no number(5), name varchar(20));
create table me (s_no number(5), name varchar(20))
*
ERROR at line 1:
ORA-01109: database not open
Re: password [message #249494 is a reply to message #249492] Wed, 04 July 2007 12:13 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
what should i do to open my database???
Re: password [message #249495 is a reply to message #249465] Wed, 04 July 2007 12:16 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
post complete CUT & PASTE while doing the following:
sqlplus
/ as sysdba
shutdown abort
startup
Re: password [message #249497 is a reply to message #249495] Wed, 04 July 2007 12:20 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
what do you mean by
post complete CUT and PASTE while doing the following???
i should type that code and then cut and paste the output???
Re: password [message #249499 is a reply to message #249465] Wed, 04 July 2007 12:23 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
>i should type that code and then cut and paste the output???
Yes

What is OS name & version?
Re: password [message #249500 is a reply to message #249499] Wed, 04 July 2007 12:24 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
sorry, but what's OS??
and i am using SQL plus
Re: password [message #249501 is a reply to message #249465] Wed, 04 July 2007 12:26 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
Operating System name & version?
Re: password [message #249503 is a reply to message #249501] Wed, 04 July 2007 12:28 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
version
9.2.0.1.0
Re: password [message #249504 is a reply to message #249503] Wed, 04 July 2007 12:30 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
SQL> / as sysdba shutdown abort start up;
create table me (s_no number(5), name varchar(20))
*
ERROR at line 1:
ORA-01109: database not open



now what???
Re: password [message #249507 is a reply to message #249504] Wed, 04 July 2007 12:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to first start your database but now stop doing anything and read the doc I posted.
Your knowledge is currently too low to be able to manage and use an Oracle database.

Regards
Michel

[Updated on: Wed, 04 July 2007 12:45]

Report message to a moderator

Re: password [message #249508 is a reply to message #249507] Wed, 04 July 2007 12:47 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
yeah. i am just a high school student. and i did as you told me. i have pasted the screen shot with the query i had written due to which i got an error saying that 'database not open'
pls tell me how to open my database as i am not even able to create a table.
Re: password [message #249509 is a reply to message #249508] Wed, 04 July 2007 12:48 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Jul 4 20:56:58 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> create table me (s_no number(5), name varchar(20));
create table me (s_no number(5), name varchar(20))
*
ERROR at line 1:
ORA-01109: database not open
Re: password [message #249511 is a reply to message #249508] Wed, 04 July 2007 12:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
pls tell me how to open my database as i am not even able to create a table.

I will surely not do that until you read the "Database Platform Guide for Microsoft Windows" (see link above).
You will break your database, you will then ask us how to recover it, you will...
Stop now. You have to learn the basics for managing an Oracle database on Windows.
Oracle is a professional database. You have to read. You have to learn BEFORE using it.

Regards
Michel

Re: password [message #249512 is a reply to message #249511] Wed, 04 July 2007 13:03 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
kkk....i read
Re: password [message #249513 is a reply to message #249512] Wed, 04 July 2007 13:07 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
but didnt get most of it!! can you pls tel me what to do?? am i suppose to use the grant privilege option???
Re: password [message #249514 is a reply to message #249513] Wed, 04 July 2007 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read again and again my previous post until you know what to do.

Regards
Michel

[Updated on: Wed, 04 July 2007 13:13]

Report message to a moderator

Re: password [message #249515 is a reply to message #249514] Wed, 04 July 2007 13:16 Go to previous messageGo to next message
mummu
Messages: 19
Registered: July 2007
Junior Member
yeah i no that i am not supose to give any such queries. but still i was just asking.
i am not good at oracle as you are.i am just a school student.
pls help me. i did read the platform guide. its all about how to create a database,delete a database and all.
pls help me.
Re: password [message #249516 is a reply to message #249465] Wed, 04 July 2007 13:24 Go to previous messageGo to next message
BlackSwan
Messages: 25037
Registered: January 2009
Location: SoCal
Senior Member
>its all about how to create a database,delete a database and all.
including how to startup & shutdown a database using sqlplus.
Re: password [message #249518 is a reply to message #249515] Wed, 04 July 2007 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This topic is closed.
./fa/448/0/
Regards
Michel
Re: password [message #249585 is a reply to message #249511] Thu, 05 July 2007 02:07 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Wed, 04 July 2007 19:54
I will surely not do that until you read the "Database Platform Guide for Microsoft Windows" (see link above).

mummu wrote on Wed, 04 July 2007 20:07
but didnt get most of it!! can you pls tel me what to do?? am i suppose to use the grant privilege option???


19:54 Please read the guide
20:07 I read it but don't understand it

Advice: Quit highschool and start selling fast-reading courses!

[Updated on: Thu, 05 July 2007 02:07]

Report message to a moderator

Previous Topic: Sql Update stmt help
Next Topic: Finding Common Columns in a set of tables
Goto Forum:
  


Current Time: Mon Dec 05 10:37:11 CST 2016

Total time taken to generate the page: 0.12539 seconds