Home » SQL & PL/SQL » Client Tools » ORA-01012: not logged on
ORA-01012: not logged on [message #245259] Fri, 15 June 2007 12:33 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.

Re: ORA-01012: not logged on [message #245265 is a reply to message #245259] Fri, 15 June 2007 12:54 Go to previous messageGo to next message
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

Re: ORA-01012: not logged on [message #245266 is a reply to message #245259] Fri, 15 June 2007 12:58 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
SQL> SHUTDOWN ABORT
SQL> STARTUP
Re: ORA-01012: not logged on [message #245268 is a reply to message #245259] Fri, 15 June 2007 13:08 Go to previous messageGo to next message
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
Re: ORA-01012: not logged on [message #245271 is a reply to message #245268] Fri, 15 June 2007 13:16 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Reload your listener.
Re: ORA-01012: not logged on [message #245272 is a reply to message #245259] Fri, 15 June 2007 13:16 Go to previous messageGo to next message
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

Re: ORA-01012: not logged on [message #245273 is a reply to message #245259] Fri, 15 June 2007 13:16 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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
Re: ORA-01012: not logged on [message #245309 is a reply to message #245259] Fri, 15 June 2007 15:57 Go to previous messageGo to next message
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
Re: ORA-01012: not logged on [message #245311 is a reply to message #245259] Fri, 15 June 2007 16:08 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>pls is there any problem at all
It is no problem for me.
Re: ORA-01012: not logged on [message #245334 is a reply to message #245309] Sat, 16 June 2007 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Execute "catalog.sql" and "catproc.sql" (connected "as sysdba" of course).

Regards
Michel
Re: ORA-01012: not logged on [message #245359 is a reply to message #245259] Sat, 16 June 2007 07:40 Go to previous messageGo to next message
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>
Re: ORA-01012: not logged on [message #245360 is a reply to message #245259] Sat, 16 June 2007 07:56 Go to previous messageGo to next message
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
Re: ORA-01012: not logged on [message #245362 is a reply to message #245360] Sat, 16 June 2007 08:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
These scripts are in $ORACLE_HOME/rdbms/admin not anywhere.

Regards
Michel
Re: ORA-01012: not logged on [message #245363 is a reply to message #245259] Sat, 16 June 2007 08:39 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Some folks don't even know how to use "find". How sad.
Re: ORA-01012: not logged on [message #245391 is a reply to message #245259] Sat, 16 June 2007 13:20 Go to previous messageGo to next message
seyiisq
Messages: 125
Registered: September 2005
Senior Member
thanks michel it worked. pls can you tell why i
executed catalog.sql and catproc.sql
Re: ORA-01012: not logged on [message #245396 is a reply to message #245391] Sat, 16 June 2007 13:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because these scripts create the "standard" package and most of all internal others.

Regards
Michel
Re: ORA-01012: not logged on [message #245416 is a reply to message #245259] Sat, 16 June 2007 15:12 Go to previous message
seyiisq
Messages: 125
Registered: September 2005
Senior Member
grateful. thanks heaps
Previous Topic: Reporting in Oracle............
Next Topic: sql plus report format problem
Goto Forum:
  


Current Time: Thu Dec 08 00:13:02 CST 2016

Total time taken to generate the page: 0.11970 seconds