OraFAQ Forum: Server Administration » ORA-01012: not logged on

Home » RDBMS Server » Server Administration » ORA-01012: not logged on (Oracle 11.2.0.4.1,linux 2.6)

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

ORA-01012: not logged on [message #619629]

Wed, 23 July 2014 14:49

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

Report message to a moderator

Re: ORA-01012: not logged on [message #619632 is a reply to message #619629]

Wed, 23 July 2014 15:04

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

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

Report message to a moderator

Re: ORA-01012: not logged on [message #619633 is a reply to message #619629]

Wed, 23 July 2014 15:04

John Watson
Messages: 8965
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.

Report message to a moderator

Re: ORA-01012: not logged on [message #619638 is a reply to message #619633]

Wed, 23 July 2014 15:49

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

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

Report message to a moderator

Re: ORA-01012: not logged on [message #619642 is a reply to message #619638]

Wed, 23 July 2014 16:55

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

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!

Report message to a moderator

Re: ORA-01012: not logged on [message #619648 is a reply to message #619644]

Wed, 23 July 2014 18:17

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

Report message to a moderator

Re: ORA-01012: not logged on [message #619649 is a reply to message #619648]

Wed, 23 July 2014 19:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I don't believe you.
post reproducible test case.

Report message to a moderator

Re: ORA-01012: not logged on [message #619690 is a reply to message #619648]

Thu, 24 July 2014 07:45

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.

Report message to a moderator

Re: ORA-01012: not logged on [message #619694 is a reply to message #619690]

Thu, 24 July 2014 08:43

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

Senior Member
Account Moderator

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

Report message to a moderator

Re: ORA-01012: not logged on [message #619697 is a reply to message #619629]

Thu, 24 July 2014 10:23

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.

Report message to a moderator

Re: ORA-01012: not logged on [message #619706 is a reply to message #619697]

Thu, 24 July 2014 11:39

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.

Report message to a moderator

Re: ORA-01012: not logged on [message #619717 is a reply to message #619706]

Thu, 24 July 2014 13:12

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

Report message to a moderator

Re: ORA-01012: not logged on [message #619722 is a reply to message #619717]

Thu, 24 July 2014 13:22

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

Senior Member
Account Moderator

Quote:

want to spoil others name

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

Report message to a moderator

Re: ORA-01012: not logged on [message #619727 is a reply to message #619722]

Thu, 24 July 2014 13:46

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Report message to a moderator

Re: ORA-01012: not logged on [message #619739 is a reply to message #619717]

Thu, 24 July 2014 14:37

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.

Report message to a moderator

Re: ORA-01012: not logged on [message #619744 is a reply to message #619739]

Thu, 24 July 2014 15:20

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

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.

Report message to a moderator

Re: ORA-01012: not logged on [message #619851 is a reply to message #619840]

Fri, 25 July 2014 08:55

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

Report message to a moderator

Re: ORA-01012: not logged on [message #619882 is a reply to message #619851]

Fri, 25 July 2014 12:48

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

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.

Report message to a moderator

Previous Topic:	Shutdown immediate taking more time to down database
Next Topic:	Message found in alert log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 17:07:23 CST 2025