Hi Tom,

I am using Oracle 817 on NT. when i Try to Close my Database using the alter Database Close it says it can do it only with no sessions conected.

I checked my v$session and i get Lot of Sessions with No Programs and Type as user Connected ...

What are these sessions and what are their uses.

Regards,
Ganesh R

It seems that alter database close then ( do maintenance work here) ,shutdown the db and startup again is equal to use:
shutdown db then startup mount (do maintenance work here).
it is just the different option. Is my thinking right ?

Dear Tom,

Thanks for your help.

The database(dev instance) is up and running.I made few changes in init.ora(non-dynamic parameters).

Shall I use startup force to restart the instance?

Is "startup force" equivalent to
1)shutdown immediate
2)startup

Correct me if I am wrong?

Hi Tom,

I am trying to do a shutdown then a startup mount but I get the following:

> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
> startup mount;
ORA-03113: end-of-file on communication channel
> startup mount;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

In UNIX I "cat" the error log and tailed the last 40 lines and got the following:

Thu Nov 2 00:14:35 2006
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
All dispatchers and shared servers shutdown
Thu Nov 2 00:14:39 2006
ALTER DATABASE CLOSE NORMAL
Thu Nov 2 00:14:39 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Nov 2 00:14:40 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 2863
Successful close of redo thread 1.
Thu Nov 2 00:14:41 2006
Completed: ALTER DATABASE CLOSE NORMAL
Thu Nov 2 00:14:41 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu Nov 2 00:14:51 2006
Starting ORACLE instance (normal)
Thu Nov 2 00:14:51 2006
WARNING: EINVAL creating segment of size 0x000000000f400000
fix shm parameters in /etc/system or equivalent

Any ideas why I can't do a startup mount?

Thanks

Hi Tom,

Thanks for elucidating the warning in the alert log for me. I am trying the following, to reset the sga_max_size, logged on as "sys":

> show sga

Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes

> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 235999352

> alter system set sga_max_size=170M scope=spfile;

System altered.

> startup force;

ORA-03113: end-of-file on communication channel
> show sga
ORA-03114: not connected to ORACLE

Is this the correct way to re-size the SGA Memory? How do I find the limit of my system's memory (Red Hat Linux Advanced Server release 2.1AS (Pensacola) ) and size the sga accordingly.

This is the size of my sga currently:

1 select SUM(VALUE)+(1024*1024) from v$parameter where name in
2 ('db_16k_cache_size','db_2k_cache_size','db_32k_cache_size',
3 'db_4k_cache_size','db_8k_cache_size','db_cache_size',
4 'db_keep_cache_size','db_recycle_cache_size',
5 'java_pool_size','large_pool_size',
6* 'shared_pool_size','log_buffer')
> /

SUM(VALUE)+(1024*1024)
----------------------
219676672

Thanks

Hey Tom,

That's FANTASTIC! Thanks for the 10G installation link. I basically edited the /etc/sysctl.conf file.

I set the following up:

kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096

And then did a /sbin/shutdown -r now

Then I did a database shutdown and mount startup and it worked!

I think my technical skills have increased a million-fold from using this site. Thanks so much :-)

Thank you Tom. It worked like a magic!

hi tom,

in my database im not able to extend my sga_max_size to 2048m(i mean 2gb).my db_cache_size=300m,shared_pool_size=300m.now im trying to extend my sga max size but im unable extend it please tell why its happening and solution for it.