| ORA-01012: not logged on [message #619629] |
Wed, 23 July 2014 14:49  |
|
|
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 #619633 is a reply to message #619629] |
Wed, 23 July 2014 15:04  |
John Watson
Messages: 8455
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 #619642 is a reply to message #619638] |
Wed, 23 July 2014 16:55 |
|
|
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 #619648 is a reply to message #619644] |
Wed, 23 July 2014 18:17 |
|
|
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 #619697 is a reply to message #619629] |
Thu, 24 July 2014 10:23 |
Lalit Kumar B
Messages: 3171
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 |
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 |
|
|
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 #619882 is a reply to message #619851] |
Fri, 25 July 2014 12:48 |
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
Lalit Kumar B wrote on Fri, 25 July 2014 09:55joy_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.
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
