OraFAQ Forum: Server Administration » Inrease SGA Parameter

Home » RDBMS Server » Server Administration » Inrease SGA Parameter (Windows)

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

Inrease SGA Parameter [message #467017]

Thu, 22 July 2010 00:56

maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai

Member

SQL> alter system set sga_max_size=1G scope=spfile;

System altered.

SQL> startup force
ORA-12545: Connect failed because target host or object does not exis
SQL> show parameter sga
ERROR:
ORA-03114: not connected to ORACLE

SQL> startup force
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup force
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

Please Help

Thanks & Regards
Manish Hemnani

Report message to a moderator

Re: Inrease SGA Parameter [message #467018 is a reply to message #467017]

Thu, 22 July 2010 01:02

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

exit sqlplus and retry.

Regards
Michel

Report message to a moderator

Re: Inrease SGA Parameter [message #467025 is a reply to message #467017]

Thu, 22 July 2010 01:12

maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai

Member

Thanks Micheal

Can you tell me why it happened

Report message to a moderator

Re: Inrease SGA Parameter [message #467029 is a reply to message #467025]

Thu, 22 July 2010 01:19

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

sqlplus is tightly linked in Oracle code and sometimes it happens (above all with a shutdown abort) due to the relation between process and OS shared memory, I think.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-01031: insufficient privileges
Next Topic:	refresh asa_recommendation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 12:05:16 CDT 2024