Printable View
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
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
Please tell me you didn't just put the sys password of one of your production boxes online for the whole world to see.
SOX anyone?
i tried shutting down the database to start it up again but i got this other error.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup;
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
SQL> startup force;
ORA-01041: internal error. hostdef extension doesn't exist
This is all I found.
http://dba.ipbhost.com/index.php?showtopic=6136
Seems to be new to 10g.
tahanks i have been able to rectify this problem 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 with this
sqplus sys/@$ORACLE_HOME/rdbms/admin/standard.sql