IOTN :: Field Book :: Tibero

ȸ¿ø°¡ÀÔ

* Cannot get semaphore:errno=28

ÃÖ±æÈ£ [LIST]   2019-03-06 19:03:14, Á¶È¸ : 4,297 [tibero@linux64 config]$ tbboot Listener port = 18629 *************************************************************************** * Cannot get semaphore: * key = 0xc45fa1c1, errno=28 *************************************************************************** Tibero instance startup failed! [tibero@linux64 ~]$ tbboot semget failed.: No space left on device *************************************************************************** * Cannot get semaphore: * key = 0xee327975, errno=28 *************************************************************************** Tibero instance startup failed! Listener port = 8629 [tibero@linux64 ~]$ MAX_SESSION_COUNT=400 MEMORY_TARGET=8G TOTAL_SHM_SIZE=4G [tibero@linux64 ~]$ tbsvr -v Tibero 5   (DB 5.0 S1419) Tibero 6   (DB 6.0 FS06_CS_1709) errno=28 ¿¡·¯³ª¸é ipcrm ÇÊ¿ä ipcs -m | grep tibero | awk '{print $2}' | while read line ; do ipcrm -m $line; done ipcs -s | grep tibero | awk '{print $2}' | while read line ; do ipcrm -s $line; done Á¶Ä¡ vi /etc/sysctl.conf kernel.sem = 10000 32000 10000 10000 net.ipv4.ip_local_port_range = 1024 65500 sysctl -p È®ÀÎ cat /proc/sys/kernel/sem cat /proc/sys/net/ipv4/ip_local_port_range ¾ÈµÇ¸é ¼öÁ¤ [ sysctl -p ÇÏ¸é »ý±è ] echo 10000   32000   10000   10000 > /proc/sys/kernel/sem echo 1024    65500 > /proc/sys/net/ipv4/ip_local_port_range ¸Þ´º¾ó Á¤º¸ 10000   32000   10000   10000  /proc/sys/kernel/sem shmall 2097152 /proc/sys/kernel/shmall shmmax ¹°¸®ÀûÀÎ ¸Þ¸ð¸®ÀÇ Àý¹Ý (byte) /proc/sys/kernel/shmmax shmmni 4096 /proc/sys/kernel/shmmni file-max 6815744 /proc/sys/fs/file-max ip_local_port_range 1024 ~ 65000 /proc/sys/net/ipv4/ip_local_port_range Ãâó URL: https://technet.tmaxsoft.com/upload/download/online/tibero/pver-20131217-000019/tibero_install/chapter_preinstall_preparation.html#d5e676 technet >> download >> tibero >> ¿Â¶óÀθŴº¾ó 2. ¼³Ä¡ Àü Áغñ»çÇ× 2.3. ¿î¿µÃ¼Á¦º° Ä¿³Î ÆĶó¹ÌÅÍ ¼³Á¤   2.3.1. Linux 18.232.179.37

LIST

CategoryAdminBackup and RecoveryTroubleshootScriptTool	Á¦¸ñ	ÀÛ¼ºÀÚ	ÀÛ¼ºÀÏ	Á¶È¸
Troubleshoot	ERROR: bind error (port=8200) [Address already in use]	ÃÖ±æÈ£	2022/02/18	166
Admin	Tibero 5 , SP1, patch, downgrad ¸Þ¸ð	ÃÖ±æÈ£	2021/02/10	2148
Admin	tibero jdbc driver version È®ÀÎ	ÃÖ±æÈ£	2021/02/01	542
Admin	rename db name / TB_SID	ÃÖ±æÈ£	2021/02/01	958
Troubleshoot	T-UP / SELECT COUNT(*) FROM ALL_TYPES WHERE TYPE_NAME = 'XMLTYPE'	ÃÖ±æÈ£	2021/02/01	5310
Backup and Recovery	alter database backup controlfile to trace / CREATE CONTROLFILE / alter system set _CF_DD_CHECK=N	ÃÖ±æÈ£	2021/01/29	407
Troubleshoot	interal dd update failed!! [ patch ÇÊ¿ä ]	ÃÖ±æÈ£	2020/12/20	69859
Backup and Recovery	TBR-1024 : Database needs media recovery	ÃÖ±æÈ£	2020/12/20	2586
Troubleshoot	* Cannot get semaphore:errno=28	ÃÖ±æÈ£	2019/03/06	4297
Backup and Recovery	tbexport TBR-90401: JDBC-90401:Connection refused by the server. - Connection refused	ÃÖ±æÈ£	2019/02/15	3704
Troubleshoot	TBR-8033: Specified schema object was not found.	ÃÖ±æÈ£	2018/07/11	157338
Admin	tibero6 ¼öµ¿ ¼³Ä¡	ÃÖ±æÈ£	2018/07/11	25930
Backup and Recovery	TBR-1004: Unable to read file TBR-7004: This DDL statement is not permitted	ÃÖ±æÈ£	2017/11/26	2931
Admin	Tibero SQL Trace [ SQL_TRACE / DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION / SET AUTOTRACE ON / v$sql_plan ]	ÃÖ±æÈ£	2017/09/06	16183
Admin	Tibero ¸ð´ÏÅ͸µ °¡À̵å - TechNet	ÃÖ±æÈ£	2017/09/05	16252
Troubleshoot	java.sql.SQLSyntaxErrorException: ORA-00924: missing BY keyword	ÃÖ±æÈ£	2016/08/25	3384
Troubleshoot	Oracle dblink Tibero UTF8 DB ÇѱÛó¸®	ÃÖ±æÈ£	2015/09/08	10913

¸ñ·Ïº¸±â   ´ÙÀ½ÆäÀÌÁö

1 [2]

Copyright 1999-2023 Zeroboard / skin by ÃÖ±æÈ£(gilho.kr@gmail.com)