OraFAQ Forum: General » Coming problems in my sql plus

Home » Other » General » Coming problems in my sql plus

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Coming problems in my sql plus [message #617795]

Thu, 03 July 2014 13:03

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

When ever we use Username/password as hr/hr
then some problems are coming

error:
ORA-01033: OORACLE initialization or shutdown in progress

how to resolve it.

Report message to a moderator

Re: Coming problems in my sql plus [message #617796 is a reply to message #617795]

Thu, 03 July 2014 13:05

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Because your database is down. Get back to your DBA. It has nothing to do with SQL*Plus.

Report message to a moderator

Re: Coming problems in my sql plus [message #617797 is a reply to message #617796]

Thu, 03 July 2014 13:07

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

And you must at least feedback to your previous questions, it is a basic forum etiquette.

I see Michel has already reminded you to feedback several times, however, you have never responded. Why?

Report message to a moderator

Re: Coming problems in my sql plus [message #617801 is a reply to message #617797]

Thu, 03 July 2014 13:39

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Not solved my issue still, that's why I couldn't give any respond.

Report message to a moderator

Re: Coming problems in my sql plus [message #617802 is a reply to message #617796]

Thu, 03 July 2014 13:42

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

My PC SQL*plus is showing such type of problems, no one role is here DBA, please let me know that how solved this issue.

Report message to a moderator

Re: Coming problems in my sql plus [message #617804 is a reply to message #617802]

Thu, 03 July 2014 13:47

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

DB version and OS?

Report message to a moderator

Re: Coming problems in my sql plus [message #617805 is a reply to message #617802]

Thu, 03 July 2014 13:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

aaditya321 wrote on Thu, 03 July 2014 11:42

My PC SQL*plus is showing such type of problems, no one role is here DBA, please let me know that how solved this issue.

power off the database server & then power it back on

Report message to a moderator

Re: Coming problems in my sql plus [message #617826 is a reply to message #617797]

Thu, 03 July 2014 15:20

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Lalit Kumar B wrote on Thu, 03 July 2014 20:07

And you must at least feedback to your previous questions, it is a basic forum etiquette.

I see Michel has already reminded you to feedback several times, however, you have never responded. Why?

He is one more of these disgusting parasites we see more and more in forum as the skill level decreases. Sad

[Updated on: Thu, 03 July 2014 15:21]

Report message to a moderator

Re: Coming problems in my sql plus [message #617844 is a reply to message #617805]

Thu, 03 July 2014 23:44

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

BlackSwan wrote on Thu, 03 July 2014 13:55

aaditya321 wrote on Thu, 03 July 2014 11:42
My PC SQL*plus is showing such type of problems, no one role is here DBA, please let me know that how solved this issue.

power off the database server & then power it back on

Its automatically power it back on or we have to do some things.

Report message to a moderator

Re: Coming problems in my sql plus [message #617845 is a reply to message #617826]

Thu, 03 July 2014 23:49

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Michel Cadot wrote on Thu, 03 July 2014 15:20

Lalit Kumar B wrote on Thu, 03 July 2014 20:07
And you must at least feedback to your previous questions, it is a basic forum etiquette.

I see Michel has already reminded you to feedback several times, however, you have never responded. Why?

He is one more of these disgusting parasites we see more and more in forum as the skill level decreases.

Hi Michel,

Sorry for delay our feedback, actually I was leaved the forum for some times so I couldn't give any reply. Again I will reach that thread caused some problems has still, by the way Lalit has solved my query.

Report message to a moderator

Re: Coming problems in my sql plus [message #617851 is a reply to message #617845]

Fri, 04 July 2014 01:23

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You're a liar.
You posted, for instance, questions on 14th, 16th and 21st June, you were not out the 21st to post a question but you can't post a feedback on the former 2, how does it come?
Now you are there, so post a feedback in your previous topics.

Report message to a moderator

Re: Coming problems in my sql plus [message #617870 is a reply to message #617851]

Fri, 04 July 2014 02:53

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Michel Cadot wrote on Fri, 04 July 2014 01:23

You're a liar.
You posted, for instance, questions on 14th, 16th and 21st June, you were not out the 21st to post a question but you can't post a feedback on the former 2, how does it come?
Now you are there, so post a feedback in your previous topics.

apologies for my mistake,

Report message to a moderator

Re: Coming problems in my sql plus [message #618000 is a reply to message #617795]

Sun, 06 July 2014 10:52

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

aaditya321 wrote on Thu, 03 July 2014 13:03

When ever we use Username/password as hr/hr
then some problems are coming

error:
ORA-01033: OORACLE initialization or shutdown in progress

how to resolve it.

Hi Guys,

Please tell me solution of my problem, how to solve it.

Report message to a moderator

Re: Coming problems in my sql plus [message #618001 is a reply to message #618000]

Sun, 06 July 2014 10:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

since you choose to ignore Posting Guidelines ( http://www.orafaq.com/forum/t/88153/0/ ), I choose to not answer your questions

Report message to a moderator

Re: Coming problems in my sql plus [message #618002 is a reply to message #618000]

Sun, 06 July 2014 10:58

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Lalit Kumar B wrote on Thu, 03 July 2014 20:05

Because your database is down. Get back to your DBA. It has nothing to do with SQL*Plus.

Report message to a moderator

Re: Coming problems in my sql plus [message #618003 is a reply to message #618002]

Sun, 06 July 2014 11:06

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Its my PC, not role of any DBA.

Report message to a moderator

Re: Coming problems in my sql plus [message #618004 is a reply to message #618003]

Sun, 06 July 2014 11:14

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So you have to learn DBA job:
Database 2 Day DBA
Oracle DBA Lite

Report message to a moderator

Re: Coming problems in my sql plus [message #618846 is a reply to message #618004]

Wed, 16 July 2014 02:06

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Not get satisfied answers here. Only people are sharing bulk links to study.

Report message to a moderator

Re: Coming problems in my sql plus [message #618847 is a reply to message #618846]

Wed, 16 July 2014 02:11

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Because you must read those links to understand what needs to be done to fix your issue. Whats the point if a solution is provided and you don't know what to do with it.

Report message to a moderator

Re: Coming problems in my sql plus [message #618848 is a reply to message #618846]

Wed, 16 July 2014 02:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

aaditya321

Not get satisfied answers here.

You don't want to know what I think about your efforts to learn ANYTHING (starting with how to use your operating system, administer your database at a beginner's level, write several lines of code, ...).

Report message to a moderator

Re: Coming problems in my sql plus [message #618853 is a reply to message #618847]

Wed, 16 July 2014 02:59

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Lalit Kumar B wrote on Wed, 16 July 2014 02:11

Because you must read those links to understand what needs to be done to fix your issue. Whats the point if a solution is provided and you don't know what to do with it.

Hi Lalit,

I could not get from given link, please give me some code so that I can solve our problems.

Report message to a moderator

Re: Coming problems in my sql plus [message #618859 is a reply to message #618853]

Wed, 16 July 2014 03:30

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

I will give you a hint.

sql>alter database recover database;
Database altered.
sql>alter database open;
Database altered.
sql>shutdown imediate;
Database closed.
Database dismounted.
ORACLE instance shut down
SQL> startup;
ORACLE instance started.
Total System Global Area 1670221824 bytes
Fixed Size                  2176328 bytes
Variable Size            1224739512 bytes
Database Buffers          436207616 bytes
Redo Buffers                7098368 bytes
Database mounted.
Database opened.

Would you dare to try all these without reading the links provided here by our Gurus?

Javed A. Khan

Report message to a moderator

Re: Coming problems in my sql plus [message #618861 is a reply to message #618859]

Wed, 16 July 2014 03:46

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I will give you a hint.

And me another one:

SQL> drop database;

Report message to a moderator

Re: Coming problems in my sql plus [message #618864 is a reply to message #618861]

Wed, 16 July 2014 04:17

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Whenever we try to login username and password then just come like error
ORA-01033: OORACLE initialization or shutdown in progress
Our sql*plus is not open then how to write these code.

Report message to a moderator

Re: Coming problems in my sql plus [message #618866 is a reply to message #617805]

Wed, 16 July 2014 04:18

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

BlackSwan wrote on Thu, 03 July 2014 20:55

power off the database server & then power it back on

Report message to a moderator

Re: Coming problems in my sql plus [message #618867 is a reply to message #618861]

Wed, 16 July 2014 04:21

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Michel Cadot wrote on Wed, 16 July 2014 03:46

Quote:
I will give you a hint.

And me another one:
SQL> drop database;

This section SQL> is not coming then how to write your given code and where.

Report message to a moderator

Re: Coming problems in my sql plus [message #618869 is a reply to message #618867]

Wed, 16 July 2014 04:22

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

aaditya321 wrote on Wed, 16 July 2014 14:51

This section SQL> is not coming then how to write your given code and where.

Littlefoot wrote on Wed, 16 July 2014 14:48

BlackSwan wrote on Thu, 03 July 2014 20:55

power off the database server & then power it back on

Report message to a moderator

Re: Coming problems in my sql plus [message #618870 is a reply to message #618867]

Wed, 16 July 2014 04:25

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Well, since you post no real information on what you did so far (did you reboot the DB server or not by now?) you basically have two options:

- Hire a DBA to see what the problem is and fix it for you.
- Sell the DB server on Ebay.

[Updated on: Wed, 16 July 2014 04:25]

Report message to a moderator

Re: Coming problems in my sql plus [message #618872 is a reply to message #618870]

Wed, 16 July 2014 04:26

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

aaditya321 wrote on Sun, 06 July 2014 18:06

Its my PC, not role of any DBA.

Report message to a moderator

Re: Coming problems in my sql plus [message #618876 is a reply to message #618869]

Wed, 16 July 2014 04:40

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Lalit Kumar B wrote on Wed, 16 July 2014 04:22

aaditya321 wrote on Wed, 16 July 2014 14:51
This section SQL> is not coming then how to write your given code and where.

Littlefoot wrote on Wed, 16 July 2014 14:48
BlackSwan wrote on Thu, 03 July 2014 20:55

power off the database server & then power it back on

How to power off the database server & then power it back on

Report message to a moderator

Re: Coming problems in my sql plus [message #618877 is a reply to message #618876]

Wed, 16 July 2014 04:41

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Are you serious?

Report message to a moderator

Re: Coming problems in my sql plus [message #618878 is a reply to message #618876]

Wed, 16 July 2014 04:43

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

What is your OS?

Report message to a moderator

Re: Coming problems in my sql plus [message #618880 is a reply to message #618878]

Wed, 16 July 2014 04:45

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

My OS is window 7

Report message to a moderator

Re: Coming problems in my sql plus [message #618881 is a reply to message #618877]

Wed, 16 July 2014 04:47

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Littlefoot wrote on Wed, 16 July 2014 11:41

Are you serious?

I start to think he is a troll, no one can be so dumb he doesn't know how to power off his PC... although...

Report message to a moderator

Re: Coming problems in my sql plus [message #618882 is a reply to message #618880]

Wed, 16 July 2014 04:48

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Go to services.msc and check whether the Oracle service is up and running. You need to restart your PC if you make changes there, since I have observed that if I stop and restart a service, it needs system reboot for Oracle DB to come up.

Report message to a moderator

Re: Coming problems in my sql plus [message #618884 is a reply to message #618881]

Wed, 16 July 2014 05:05

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Michel Cadot wrote on Wed, 16 July 2014 04:47

Littlefoot wrote on Wed, 16 July 2014 11:41
Are you serious?

I start to think he is a troll, no one can be so dumb he doesn't know how to power off his PC... although...

If your means "power off his PC" i.e. shut down your pc then I have done it many times, its my view.

What is your meaning of "power off his PC" I don't know.

And you said I troll here then its wrong caused I am facing problems from several days and my practice has been stoped from coming issue.

[Updated on: Wed, 16 July 2014 05:06]

Report message to a moderator

Re: Coming problems in my sql plus [message #618889 is a reply to message #618884]

Wed, 16 July 2014 05:32

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

Quote:

Sell the DB server on Ebay

That's what i said. If you go through basic DBA you will get to know /nolog will give you what is not coming.

Quote:

Our sql*plus is not open then how to write these code.

Report message to a moderator

Re: Coming problems in my sql plus [message #618890 is a reply to message #618861]

Wed, 16 July 2014 05:32

javed.khan
Messages: 340
Registered: November 2006
Location: Banglore

Senior Member

Quote:

drop database

[Updated on: Wed, 16 July 2014 05:33]

Report message to a moderator

Re: Coming problems in my sql plus [message #618892 is a reply to message #618889]

Wed, 16 July 2014 05:38

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

javed.khan wrote on Wed, 16 July 2014 05:32

Quote:
Sell the DB server on Ebay

That's what i said. If you go through basic DBA you will get to know /nolog will give you what is not coming.

Quote:
Our sql*plus is not open then how to write these code.

Its my PC no one DBA here. now tell me how to do further.

Caused my sqp*plus editor is not open, and when I used user/password then problems arise.

Report message to a moderator

Re: Coming problems in my sql plus [message #618894 is a reply to message #618892]

Wed, 16 July 2014 05:40

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

now tell me how to do further

You have to first learn Windows, we cannot do it for you and we cannot do it here.

Report message to a moderator

Pages (3): [1 2 3 › »]

Previous Topic:	DB12.1.0.2 New Features
Next Topic:	DB 12c new features

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 21:40:11 CST 2024