| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-27101 RH linux 9 Oracle 9.2.0.3
I set the value to 2147483648 and it still does the same thing.
Oracle database is open but when trying to connect through sqlnet I get ORA-27101. I do shutdown immediate and startup and the problem is gone for a while.
I now stopped the archiver again and see if that gives me problems.
BTW: Is it normal 9i behaviour to write logswitches to trace????
TIA Jack
-----Original Message-----
Sent: Wednesday, July 30, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
Damn your right,
I need new glasses :-)
Thx
-----Original Message-----
Sent: Wednesday, July 30, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
The parameter shmmax (Shared Memory) is lower than the sugested. Please check:
Yours: 536870912
Sugested: 2147483648
Sandro Augusto da Silva
Technology Services & Support
NLA Technology Services
Phone: +55 11 3398-8438
Fax: +55 11 3398-7522
-----Mensagem original-----
De: Jack van Zanen [mailto:JACK_at_QUANTSYSTEMS.NL]
Enviada em: quarta-feira, 30 de julho de 2003 09:59
Para: Multiple recipients of list ORACLE-L
Assunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3
Hi,
Have tried to reconnect and get the error message 27101 (when using @sid logon)
[root_at_Linux admin]# cd /proc/sys/kernel
[root_at_Linux kernel]# cat sem
250 32000 100 128
[root_at_Linux kernel]# cat shmmax
536870912
[root_at_Linux kernel]# cat shmmni
4096
[root_at_Linux kernel]# cat shmall
2097152
[root_at_Linux kernel]# ulimit -u
4095
[root_at_Linux kernel]# cat /proc/sys/net/ipv4/ip_local_port_range
1024 65000
[root_at_Linux kernel]# cat /proc/sys/fs/file-max
65536
[root_at_Linux kernel]#
Only difference is that I set my semaphores higher than recommended (cat sem, cat shmmax)
Thx
-----Original Message-----
Sent: Wednesday, July 30, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
Have you tried to reconnect to the instance? Does the instance shuts down or your connection?
Try changing the following parameters:
Oracle9i
Installation Guide
Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris
2-20 Installation Guide
Perform the following steps to modify the kernel parameters by using the /proc
file system.
cat or more utility. For example, using the cat utility, enter the following
command:
# cat sem
The output lists, in order, the values for the SEMMSL, SEMMNS, SEMOPM,
and SEMMNI parameters. The following example shows how the output
appears:
250 32000 32 128
In the preceding output example, 250 is the value of the SEMMSL parameter,
32000 is the value of the SEMMNS parameter, 32 is the value of the SEMOPM
parameter, and 128 is the value of the SEMMNI parameter.
4. Modify the parameter values by using the following command syntax:
# echo SEMMSL_value SEMMNS_value SEMOPM_value SEMMNI_value > sem
Replace the parameter variables with the values for your system in the order
that they are entered in the preceding example. For example:
# echo 100 32000 100 100 > sem
5. Review the current shared memory parameters by using the cat or more
utility. For example, using the cat utility, enter the following command:
# cat shared_memory_parameter
In the preceding example, the variable shared_memory_parameter is either the
SHMMAX or SHMMNI parameter. The parameter name must be entered in
lowercase letters.
6. Modify the shared memory parameter by using the echo utility. For example,
to modify the SHMMAX parameter, enter the following command:
# echo 2147483648 > shmmax
7. Modify the shared memory parameter by using the echo utility. For example,
to modify the SHMMNI parameter, enter the following command:
Setup Tasks to Perform as root User
# echo 4096 > shmmni
8. Modify the shared memory parameter by using the echo utility. For example,
to modify the SHMALL parameter, enter the following command:
# echo 2097152 > shmall
9. Write a script to initialize these values during system startup, and include the
script in your system init files.
# echo 65536 > /proc/sys/fs/file-max
ulimit -n 65536
# echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_change
processes per user.
ulimit -u 16384
The parameters in the following table are the minimum values required to run
Oracle9i with a single-database instance on Linux.
See Also: Your system vendor's documentation for more
information on script files and init files.
Sandro Augusto da Silva
Technology Services & Support
NLA Technology Services
Phone: +55 11 3398-8438
Fax: +55 11 3398-7522
-----Mensagem original-----
De: Jack van Zanen [mailto:JACK_at_QUANTSYSTEMS.NL]
Enviada em: quarta-feira, 30 de julho de 2003 06:39
Para: Multiple recipients of list ORACLE-L
Assunto: RE: ORA-27101 RH linux 9 Oracle 9.2.0.3
512Mb RAM
2Gb Swap space
10:44:37 up 2 days, 21:15, 4 users, load average: 0.00, 0.05, 0.03 119 processes: 115 sleeping, 4 running, 0 zombie, 0 stopped CPU states: 0.3% user 0.0% system 0.0% nice 0.0% iowait 99.6% idle Mem: 513788k av, 506088k used, 7700k free, 0k shrd, 117192k buff
386908k actv, 39520k in_d, 9728k in_c
Swap: 2097136k av, 22708k used, 2074428k free 257980k
cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
15439 root 15 0 1164 1164 864 R 0.3 0.2 0:00 0 top
1 root 15 0 104 88 52 S 0.0 0.0 0:06 0 init
2 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 keventd
3 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kapmd
4 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0
ksoftirqd_CPU
9 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 bdflush
5 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kswapd
6 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kscand/DMA
7 root 15 0 0 0 0 SW 0.0 0.0 5:18 0
kscand/Normal
8 root 15 0 0 0 0 SW 0.0 0.0 0:00 0
kscand/HighMe
10 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kupdated
11 root 25 0 0 0 0 SW 0.0 0.0 0:00 0
mdrecoveryd
15 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
**************************************************************
Strange indeed.
Jack
----Original Message-----
Sent: Wednesday, July 30, 2003 11:09 AM
To: Multiple recipients of list ORACLE-L
Jack,
ORA-27101: shared memory realm does not exist
Oracle probably been aborted for some reason.
Strange how you can do a select * from v$database.
How much memory and swap space you have configured.
Regards
Suhen
-----Original Message-----
Sent: Wednesday, 30 July 2003 6:44 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have above setup on my homebox. Every now and then I get Oracle error 27101, and have to restart the database. I can connect / as sysdba and select * from v$database though.
Has anybody seen this happen before and may be able to help me with this.??
The only thing that I can see is a trace file (I don't know if this is from the same time as when the database stopped serving requests) from the archiver. There is nothing in the alert log whatsoever.
Is it normal behaviour that logswitches are recorded to trace files??
I have stopped the archiver process to see if that makes the problem go away.
alert_Ora92.log ora92_arc0_2583.trc ora92_arc0_2674.trc ora92_arc0_10031.trc ora92_arc0_2597.trc ora92_arc0_2710.trc ora92_arc0_10498.trc ora92_arc0_2629.trc ora92_arc0_2842.trc ora92_arc0_10533.trc ora92_arc0_2634.trc ora92_arc0_5115.trc ora92_arc0_10557.trc ora92_arc0_2651.trc ora92_arc0_8432.trc ora92_arc0_14874.trc ora92_arc0_2657.trc ora92_arc0_8607.trc
Node name: Linux Release: 2.4.20-18.9 Version: #1 Thu May 29 07:08:16 EDT 2003 Machine: i686
[oracle_at_Linux bdump]$ df -k
Filesystem 1K-blocks Used Available Use% Mounted on /dev/hdc2 10078852 7872268 1694596 83% / /dev/hdc1 99043 14310 79619 16% /boot none 256892 0 256892 0% /dev/shm /dev/hdc4 66542832 6880604 56282028 11% /data
[oracle_at_Linux bdump]$ ls -l /data//oradata/Ora92/archive/
total 8124
-rw-r----- 1 oracle dba 452096 Jul 27 13:33 1_55.dbf -rw-r----- 1 oracle dba 1085952 Jul 28 08:56 1_56.dbf -rw-r----- 1 oracle dba 6752256 Jul 30 09:24 1_57.dbf
PARAMETER SETTINGS:
*.background_dump_dest='/oracle/oradata/admin/Ora92/bdump' *.compatible='9.2.0.0.0' *.control_files='/oracle/oradata/Ora92/control01.ctl','/oracle/oradata/Ora92/control02.ctl','/oracle/oradata/Ora92/control03.ctl'
*.core_dump_dest='/oracle/oradata/admin/Ora92/cdump' *.db_block_size=8192 *.db_cache_size=8388608 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='Ora92' *.fast_start_mttr_target=300 *.hash_join_enabled=TRUE *.instance_name='Ora92' *.java_pool_size=0 *.large_pool_size=8388608 *.log_archive_dest_1='LOCATION=/data/oradata/Ora92/archive' *.log_archive_format='%t_%s.dbf' *.log_archive_start=true *.nls_date_language='DUTCH' *.nls_language='DUTCH' *.nls_numeric_characters=',.' *.open_cursors=300 *.pga_aggregate_target=25165824 *.processes=150 *.query_rewrite_enabled='FALSE' *.remote_login_passwordfile='EXCLUSIVE' *.shared_pool_reserved_size=4194304 *.shared_pool_size=8388608 *.sort_area_size=2097152 *.star_transformation_enabled='FALSE' *.timed_statistics=TRUE *.undo_management='AUTO' *.undo_retention=10800 *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/oracle/oradata/admin/Ora92/udump' *******************************************************************************
TIA Jack
Esta mensagem, incluindo seus anexos, pode conter informação confidencial e/ou privilegiada. Se você recebeu este e-mail por engano, não utilize, copie ou divulgue as informações nele contidas. E, por favor, avise imediatamente o remetente, respondendo ao e-mail, e em seguida apague-o. Este e-mail possui conteúdo informativo e não transacional. Caso necessite de atendimento imediato, recomendamos utilizar um dos canais disponíveis:
<http://www.bankboston.com.br> Internet Banking , <http://www.bankboston.com.br/bpt> BankBoston por telefone ou agência/representante de atendimento de sua conveniência. Agradecemos suacolaboração.
This message, including its attachments, may contain confidential and/or privileged information. If you received this email by mistake, do not use, copy or disseminate any information herein contained. Please notify us immediately by replying to the sender and then delete it. This email is for information purposes only, not for transactions. In case you need immediate assistance, please use one of the following channels:
<http://www.bankboston.com.br> Internet Banking , <http://www.bankboston.com.br/bpt> BankBoston by phone or branch/relationship manager at your convenience. Thank you for yourcooperation.
Esta mensagem, incluindo seus anexos, pode conter informação confidencial e/ou privilegiada. Se você recebeu este e-mail por engano, não utilize, copie ou divulgue as informações nele contidas. E, por favor, avise imediatamente o remetente, respondendo ao e-mail, e em seguida apague-o. Este e-mail possui conteúdo informativo e não transacional. Caso necessite de atendimento imediato, recomendamos utilizar um dos canais disponíveis:
<http://www.bankboston.com.br> Internet Banking , <http://www.bankboston.com.br/bpt> BankBoston por telefone ou agência/representante de atendimento de sua conveniência. Agradecemos suacolaboração.
This message, including its attachments, may contain confidential and/or privileged information. If you received this email by mistake, do not use, copy or disseminate any information herein contained. Please notify us immediately by replying to the sender and then delete it. This email is for information purposes only, not for transactions. In case you need immediate assistance, please use one of the following channels:
<http://www.bankboston.com.br> Internet Banking , <http://www.bankboston.com.br/bpt> BankBoston by phone or branch/relationship manager at your convenience. Thank you for yourcooperation.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: JACK_at_QUANTSYSTEMS.NL Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Jul 31 2003 - 10:54:32 CDT
 |
 |