Home » Other » General » Coming problems in my sql plus
Coming problems in my sql plus [message #617795] Thu, 03 July 2014 13:03 Go to next message
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.
Re: Coming problems in my sql plus [message #617796 is a reply to message #617795] Thu, 03 July 2014 13:05 Go to previous messageGo to next message
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.
Re: Coming problems in my sql plus [message #617797 is a reply to message #617796] Thu, 03 July 2014 13:07 Go to previous messageGo to next message
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?
Re: Coming problems in my sql plus [message #617801 is a reply to message #617797] Thu, 03 July 2014 13:39 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
Not solved my issue still, that's why I couldn't give any respond.
Re: Coming problems in my sql plus [message #617802 is a reply to message #617796] Thu, 03 July 2014 13:42 Go to previous messageGo to next message
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.
Re: Coming problems in my sql plus [message #617804 is a reply to message #617802] Thu, 03 July 2014 13:47 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
DB version and OS?
Re: Coming problems in my sql plus [message #617805 is a reply to message #617802] Thu, 03 July 2014 13:55 Go to previous messageGo to next message
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
Re: Coming problems in my sql plus [message #617826 is a reply to message #617797] Thu, 03 July 2014 15:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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.
Re: Coming problems in my sql plus [message #617845 is a reply to message #617826] Thu, 03 July 2014 23:49 Go to previous messageGo to next message
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. Sad



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.
Re: Coming problems in my sql plus [message #617851 is a reply to message #617845] Fri, 04 July 2014 01:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Coming problems in my sql plus [message #617870 is a reply to message #617851] Fri, 04 July 2014 02:53 Go to previous messageGo to next message
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,
Re: Coming problems in my sql plus [message #618000 is a reply to message #617795] Sun, 06 July 2014 10:52 Go to previous messageGo to next message
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.
Re: Coming problems in my sql plus [message #618001 is a reply to message #618000] Sun, 06 July 2014 10:55 Go to previous messageGo to next message
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
Re: Coming problems in my sql plus [message #618002 is a reply to message #618000] Sun, 06 July 2014 10:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.


Re: Coming problems in my sql plus [message #618003 is a reply to message #618002] Sun, 06 July 2014 11:06 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
Its my PC, not role of any DBA.
Re: Coming problems in my sql plus [message #618004 is a reply to message #618003] Sun, 06 July 2014 11:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Coming problems in my sql plus [message #618846 is a reply to message #618004] Wed, 16 July 2014 02:06 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
Not get satisfied answers here. Only people are sharing bulk links to study.
Re: Coming problems in my sql plus [message #618847 is a reply to message #618846] Wed, 16 July 2014 02:11 Go to previous messageGo to next message
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.
Re: Coming problems in my sql plus [message #618848 is a reply to message #618846] Wed, 16 July 2014 02:17 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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, ...).
Re: Coming problems in my sql plus [message #618853 is a reply to message #618847] Wed, 16 July 2014 02:59 Go to previous messageGo to next message
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.
Re: Coming problems in my sql plus [message #618859 is a reply to message #618853] Wed, 16 July 2014 03:30 Go to previous messageGo to next message
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
Re: Coming problems in my sql plus [message #618861 is a reply to message #618859] Wed, 16 July 2014 03:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I will give you a hint.


And me another one:
SQL> drop database;


Razz
Re: Coming problems in my sql plus [message #618864 is a reply to message #618861] Wed, 16 July 2014 04:17 Go to previous messageGo to next message
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.
Re: Coming problems in my sql plus [message #618866 is a reply to message #617805] Wed, 16 July 2014 04:18 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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

Re: Coming problems in my sql plus [message #618867 is a reply to message #618861] Wed, 16 July 2014 04:21 Go to previous messageGo to next message
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;


Razz


This section SQL> is not coming then how to write your given code and where.
Re: Coming problems in my sql plus [message #618869 is a reply to message #618867] Wed, 16 July 2014 04:22 Go to previous messageGo to next message
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


Re: Coming problems in my sql plus [message #618870 is a reply to message #618867] Wed, 16 July 2014 04:25 Go to previous messageGo to next message
ThomasG
Messages: 3211
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

aaditya321 wrote on Sun, 06 July 2014 18:06
Its my PC, not role of any DBA.


Re: Coming problems in my sql plus [message #618876 is a reply to message #618869] Wed, 16 July 2014 04:40 Go to previous messageGo to next message
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
Re: Coming problems in my sql plus [message #618877 is a reply to message #618876] Wed, 16 July 2014 04:41 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Are you serious?
Re: Coming problems in my sql plus [message #618878 is a reply to message #618876] Wed, 16 July 2014 04:43 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
What is your OS?
Re: Coming problems in my sql plus [message #618880 is a reply to message #618878] Wed, 16 July 2014 04:45 Go to previous messageGo to next message
aaditya321
Messages: 225
Registered: January 2014
Location: Delhi
Senior Member
My OS is window 7
Re: Coming problems in my sql plus [message #618881 is a reply to message #618877] Wed, 16 July 2014 04:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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...

Re: Coming problems in my sql plus [message #618882 is a reply to message #618880] Wed, 16 July 2014 04:48 Go to previous messageGo to next message
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.
Re: Coming problems in my sql plus [message #618884 is a reply to message #618881] Wed, 16 July 2014 05:05 Go to previous messageGo to next message
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 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Quote:
Sell the DB server on Ebay

Smile
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.
Re: Coming problems in my sql plus [message #618890 is a reply to message #618861] Wed, 16 July 2014 05:32 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Quote:
drop database
Laughing

[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 Go to previous messageGo to next message
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

Smile
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.
Re: Coming problems in my sql plus [message #618894 is a reply to message #618892] Wed, 16 July 2014 05:40 Go to previous messageGo to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

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


Current Time: Fri Mar 29 09:25:15 CDT 2024