OraFAQ Forum: Client Tools » ORA-01012: not logged on

Home » Other » Client Tools » ORA-01012: not logged on

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

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

Fri, 15 June 2007 12:33

seyiisq
Messages: 125
Registered: September 2005

Senior Member

i was having an error ORA-00018: maximum number of sessions exceeded.
so i took the step below but now i am having another error

logged on as sys
Connected to an idle instance.
SQL> alter system set sessions = 225 scope = spfile;
alter system set sessions = 225 scope = spfile
*
ERROR at line 1:
ORA-01012: not logged on

pls help

[Updated on: Fri, 15 June 2007 12:48]

Report message to a moderator

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

Fri, 15 June 2007 12:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>SQL> conn system/enitan@orcl_1 as sysdba
>Connected to an idle instance.
The database is DOWN/idle.
You need to start it or at least MOUNT it.

Report message to a moderator

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

Fri, 15 June 2007 12:54

seyiisq
Messages: 125
Registered: September 2005

Senior Member

tried it but got the following

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded

Report message to a moderator

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

Fri, 15 June 2007 12:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> SHUTDOWN ABORT
SQL> STARTUP

Report message to a moderator

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

Fri, 15 June 2007 13:08

seyiisq
Messages: 125
Registered: September 2005

Senior Member

I tried that as well but got another error

SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Report message to a moderator

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

Fri, 15 June 2007 13:16

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Reload your listener.

Report message to a moderator

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

Fri, 15 June 2007 13:16

seyiisq
Messages: 125
Registered: September 2005

Senior Member

I stopped the listener and started it again then I tried starting the instance but still with another error.

SQL> startup
ORA-01041: internal error. hostdef extension doesn't exist

Report message to a moderator

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

Fri, 15 June 2007 13:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to be logged directly on the database server system as the OS user which owns the Oracle software; usually "oracle".
What Operating system name & version?
Which oracle version to FOUR decimal places?
Use CUT & PASTE to show the following results:
$ sqlplus
/ as sysdba
shutdown abort
startup
exit

Report message to a moderator

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

Fri, 15 June 2007 15:57

seyiisq
Messages: 125
Registered: September 2005

Senior Member

thanks alot
i have been able to rectify this problem as u said using 'shutdown abort'
my instance is now up and running but the problem here now is when i log in as user system i keep having this page

SQL*Plus: Release 10.1.0.2.0 - Production on Fri Jun 15 21:51:14 2007

Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-06553: PLS-213: package STANDARD not accessible

ERROR:
ORA-06553: PLS-213: package STANDARD not accessible

Error accessing package DBMS_APPLICATION_INFO

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

pls is there any problem at all

Report message to a moderator

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

Fri, 15 June 2007 16:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>pls is there any problem at all
It is no problem for me.

Report message to a moderator

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

Sat, 16 June 2007 01:27

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

Senior Member
Account Moderator

Execute "catalog.sql" and "catproc.sql" (connected "as sysdba" of course).

Regards
Michel

Report message to a moderator

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

Sat, 16 June 2007 07:40

seyiisq
Messages: 125
Registered: September 2005

Senior Member

tried it but got the following error

SQL> @catalog.sql;
SP2-0310: unable to open file "catalog.sql"
SQL> @catproc.sql;
SP2-0310: unable to open file "catproc.sql"
SQL>

Report message to a moderator

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

Sat, 16 June 2007 07:56

seyiisq
Messages: 125
Registered: September 2005

Senior Member

Tried this as well but got the error below

SQL> execute catalog.sql;
BEGIN catalog.sql; END;

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible

SQL> execute catproc.sql;
BEGIN catproc.sql; END;

*
ERROR at line 1:
ORA-06553: PLS-213: package STANDARD not accessible

Report message to a moderator

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

Sat, 16 June 2007 08:34

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

Senior Member
Account Moderator

These scripts are in $ORACLE_HOME/rdbms/admin not anywhere.

Regards
Michel

Report message to a moderator

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

Sat, 16 June 2007 08:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Some folks don't even know how to use "find". How sad.

Report message to a moderator

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

Sat, 16 June 2007 13:20

seyiisq
Messages: 125
Registered: September 2005

Senior Member

thanks michel it worked. pls can you tell why i
executed catalog.sql and catproc.sql

Report message to a moderator

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

Sat, 16 June 2007 13:33

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

Senior Member
Account Moderator

Because these scripts create the "standard" package and most of all internal others.

Regards
Michel

Report message to a moderator

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

Sat, 16 June 2007 15:12

seyiisq
Messages: 125
Registered: September 2005

Senior Member

grateful. thanks heaps

Report message to a moderator

Previous Topic:	Reporting in Oracle............
Next Topic:	sql plus report format problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 20:42:25 CST 2024