Home » RDBMS Server » Server Administration » ORA-01012: not logged on (Oracle 11.2.0.4.1,linux 2.6)
ORA-01012: not logged on [message #619629] Wed, 23 July 2014 14:49 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,
When i try to query database i get following error.
SQL> select name from v$database;
select name from v$database
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0

Help me to fix the error?

Regards,
Srini
Re: ORA-01012: not logged on [message #619632 is a reply to message #619629] Wed, 23 July 2014 15:04 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Isn't the error message (ORA-01012: not logged on) pretty self-evident?

Re: ORA-01012: not logged on [message #619633 is a reply to message #619629] Wed, 23 July 2014 15:04 Go to previous messageGo to next message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
Topic locked. This must a deliberate attempt to irritate people by showing excessive stupidity.

If you disagree, you can report the message to another moderator ho might have a different opinion.
Re: ORA-01012: not logged on [message #619638 is a reply to message #619633] Wed, 23 July 2014 15:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
This must a deliberate attempt to irritate people by showing excessive stupidity.


No, it is his normal level of smartness. Laughing

Re: ORA-01012: not logged on [message #619642 is a reply to message #619638] Wed, 23 July 2014 16:55 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Quote:
Isn't the error message (ORA-01012: not logged on) pretty self-evident?

So you mean to say i have not logged into database when i execute the select statement if that so then you are wrong.
Its actually a permission issue in /home directory i came to know that.

Thanks for unlocking the thread to write something i was waiting for.

[Updated on: Wed, 23 July 2014 16:57]

Report message to a moderator

Re: ORA-01012: not logged on [message #619644 is a reply to message #619642] Wed, 23 July 2014 16:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Its actually a permission issue in /home directory i came to know that.
I don't believe you.
post reproducible test case.

It is actually the Problem Exists Between Keyboard And Chair!
Re: ORA-01012: not logged on [message #619648 is a reply to message #619644] Wed, 23 July 2014 18:17 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Blackswan,

It is something you have to check number of process in the database if it is ok then you have to
check the permission of all files under oracle home and compare it and if you see any difference
in the file permission then you have to change it.

This is how the issue was fixed.

Regards,
Srini
Re: ORA-01012: not logged on [message #619649 is a reply to message #619648] Wed, 23 July 2014 19:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I don't believe you.
post reproducible test case.
Re: ORA-01012: not logged on [message #619690 is a reply to message #619648] Thu, 24 July 2014 07:45 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Sounds like you actually did several things, and you are ascribing the 'solution' to the wrong action.
Re: ORA-01012: not logged on [message #619694 is a reply to message #619690] Thu, 24 July 2014 08:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Maybe because he gave the "solution" to another of the several topics he created in parallel. Smile

Re: ORA-01012: not logged on [message #619697 is a reply to message #619629] Thu, 24 July 2014 10:23 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
@OP, common tell the truth now. You managed to bring up your DB using suggestions in your previous lengthy topic and now you continue with similar fraudulent attempts. How did you try to login the DB? Copy paste the session, everything that you did after you somehow managed to bring the DB up.
Re: ORA-01012: not logged on [message #619706 is a reply to message #619697] Thu, 24 July 2014 11:39 Go to previous messageGo to next message
tim2boles
Messages: 38
Registered: August 2008
Location: Clarksburg, WV
Member
I will tell you that I have had this occur before when the instance has "crashed" and the shared memory segment was not released by the OS. There may be other reasons (your session was killed) but would need more information on the one given by the OP to determine the validity of it.
Re: ORA-01012: not logged on [message #619717 is a reply to message #619706] Thu, 24 July 2014 13:12 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

There is nothing to tell the truth apart from what i have been telling you all.
When backup fails , i started to investigate the problem.
Backup for database DR0001C is failing with below errors.Could you suggest how to fix it ?
 Code: [Select all] [Show/ hide]RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 502 (oinstall), current egid =
503 (dba)

I came to know that there is a problem in logging to database.
SQL> select name from v$database;
select name from v$database
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0

Then i was told that it was related to file permission issue and number of process in database.
This is what i know.People who want to believe can believe and who want to ask further questions you are welcome.

Some people think they are smart enough and want to spoil others name but i am not like that type of person.
We must show our smartness in our work rather than spoiling others names.( who has done good for us)

Regards,
Srini

Regards,
Srini
Re: ORA-01012: not logged on [message #619722 is a reply to message #619717] Thu, 24 July 2014 13:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
want to spoil others name


Laughing

Which name?
Balaji? Ajit? Jack? Mohan? Mathew? Suhas? Srini? william?

icon10.gif  Re: ORA-01012: not logged on [message #619727 is a reply to message #619722] Thu, 24 July 2014 13:46 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Very Happy
Re: ORA-01012: not logged on [message #619739 is a reply to message #619717] Thu, 24 July 2014 14:37 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
Database admin wrote on Thu, 24 July 2014 13:12
There is nothing to tell the truth apart from what i have been telling you all.
When backup fails , i started to investigate the problem.
Backup for database DR0001C is failing with below errors.Could you suggest how to fix it ?
 Code: [Select all] [Show/ hide]RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-27140: attach to post/wait facility failed
ORA-27300: OS system dependent operation:invalid_egid failed with status: 1
ORA-27301: OS failure message: Operation not permitted
ORA-27302: failure occurred at: skgpwinit6
ORA-27303: additional information: startup egid = 502 (oinstall), current egid =
503 (dba)

<snip>


Oh, so this is related to your other thread (http://www.orafaq.com/forum/m/619616/#msg_619616)??????
Why didn't you just stick with that one? It would have saved everyone a lot of headaches.

The one time I saw the above error stack was when an SA accidentally changed ownership of files in $ORACLE_HOME. I had to kill the oracle processes at the OS level, get the ownership/permissions restored, then restart everything.

Just a bit of 'fatherly advice' from someone who has been "around the block" more than a few times ...

As long as you continue to play "guess what's in my pocket" ..
.. as long as you continue to spread the same core problem across multiple threads ...
.. as long as you continue to post under different names .. and seemingly take pride in it, no less ..

then you will continue to earn the enmity of people on this forum. If you want to be treated like a professional, it's way past time for you to step up and act like a professional.
Re: ORA-01012: not logged on [message #619744 is a reply to message #619739] Thu, 24 July 2014 15:20 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

EdStevens,

Its not like i wanted to open a multiple thread for single issue.It just happened and i will make sure it does not happen next time henceforth .

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

Report message to a moderator

Re: ORA-01012: not logged on [message #619840 is a reply to message #619744] Fri, 25 July 2014 08:32 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Database admin wrote on Thu, 24 July 2014 16:20

Its not like i wanted to open a multiple thread for single issue.It just happened


It just happened? Explain.
Re: ORA-01012: not logged on [message #619851 is a reply to message #619840] Fri, 25 July 2014 08:55 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
joy_division wrote on Fri, 25 July 2014 19:02
Database admin wrote on Thu, 24 July 2014 16:20

Its not like i wanted to open a multiple thread for single issue.It just happened


It just happened? Explain.


Joy, he has already explained in other threads his (in)ability to understand how OS commands can be (ab)used in Oracle and vice-versa to generate some interesting errors Smile
Re: ORA-01012: not logged on [message #619882 is a reply to message #619851] Fri, 25 July 2014 12:48 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Lalit Kumar B wrote on Fri, 25 July 2014 09:55
joy_division wrote on Fri, 25 July 2014 19:02

It just happened? Explain.


Joy, he has already explained in other threads his (in)ability to understand how OS commands can be (ab)used in Oracle and vice-versa to generate some interesting errors Smile


But what I am saying is "it just happened" to me means the multiple threads "just happened" to be created as if by magic, without apparent user interaction.
Previous Topic: Shutdown immediate taking more time to down database
Next Topic: Message found in alert log
Goto Forum:
  


Current Time: Tue Mar 19 04:15:21 CDT 2024