[ITCENTER] Error waktu start oracle11g admin

2012-07-27 Terurut Topik Dannie Tj
Hi,

Waktu saya mau start oracle11g admin dapat error seperti dibawah.

[oracle@orclidtc log]$ tail -5 emagent.log emdb.nohup emdctl.trc emagent.trc
== emagent.log ==
2012-07-27 16:19:11,238 Thread-3086387424 Starting Agent 10.2.0.4.2 from
/opt/oracle/111 (00701)
2012-07-27 16:19:11,239 Thread-3086387424 Agent Startup : Startup of HTTP
LISTENER failure (00716)

== emdb.nohup ==
12/07/27 16:19:17 isOMSSecure = 1 isOMSSecureLocked = 1
--- DBConsole internal stop. No OC4J admin passwd hence hard stop. ---
- Fri Jul 27 16:19:19 2012::Commiting Process death. -
- Fri Jul 27 16:19:19 2012::Exiting watchdog loop
 -

== emdctl.trc ==
2012-07-27 16:22:10,640 Thread-308590 WARN  http:
nmehl_connect_internal: connect failed to (10.10.1.152:1158): Connection
refused (error = 111)
2012-07-27 16:22:12,677 Thread-3086825696 WARN  http:
nmehl_connect_internal: connect failed to (10.10.1.152:1158): Connection
refused (error = 111)
2012-07-27 16:22:14,713 Thread-3086407904 WARN  http:
nmehl_connect_internal: connect failed to (10.10.1.152:1158): Connection
refused (error = 111)
2012-07-27 16:22:16,751 Thread-3086457056 WARN  http:
nmehl_connect_internal: connect failed to (10.10.1.152:1158): Connection
refused (error = 111)
2012-07-27 16:22:38,078 Thread-3086756064 WARN  http:
nmehl_connect_internal: connect failed to (10.10.1.152:1158): Connection
refused (error = 111)

== emagent.trc ==
2012-07-27 17:13:33,773 Thread-81816480 ERROR pingManager:
nmepm_pingReposURL: Cannot connect to https://10.10.1.152:1158/em/upload/:
retStatus=-1
2012-07-27 17:14:03,783 Thread-81816480 WARN  http: nmehl_connect_internal:
connect failed to (10.10.1.152:1158): Connection refused (error = 111)
2012-07-27 17:14:03,783 Thread-81816480 ERROR pingManager:
nmepm_pingReposURL: Cannot connect to https://10.10.1.152:1158/em/upload/:
retStatus=-1
2012-07-27 17:14:03,783 Thread-81816480 WARN  http: nmehl_connect_internal:
connect failed to (10.10.1.152:1158): Connection refused (error = 111)
2012-07-27 17:14:03,783 Thread-81816480 ERROR pingManager:
nmepm_pingReposURL: Cannot connect to https://10.10.1.152:1158/em/upload/:
retStatus=-1


*** Saya cek listernernya up

[oracle@orclidtc log]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-JUL-2012 17:15:19

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER

Alias LISTENER
Version   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date27-JUL-2012 16:10:40
Uptime0 days 1 hr. 4 min. 39 sec
Trace Level   off
Security  ON: Local OS Authentication
SNMP  OFF
Listener Parameter File   /opt/oracle/111/network/admin/listener.ora
Listener Log File
/opt/oracle/diag/tnslsnr/orclidtc/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.152)(PORT=1521)))
Services Summary...
Service orcl has 1 instance(s).
  Instance orcl, status READY, has 1 handler(s) for this service...
Service orclXDB has 1 instance(s).
  Instance orcl, status READY, has 1 handler(s) for this service...
The command completed successfully


*** Konfigurasi tnsnames.ora and listener.ora

[oracle@orclidtc log]$ cat /opt/oracle/111/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File:
/opt/oracle/111/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.152)(PORT = 1521))

ORCL =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.152)(PORT = 1521))
(CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
)
  )

[oracle@orclidtc log]$ cat /opt/oracle/111/network/admin/listener.ora
# listener.ora Network Configuration File:
/opt/oracle/111/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.1.152)(PORT = 1521))
)
  )

ADR_BASE_LISTENER = /opt/oracle


*** Port 1158 juga gak ada yang pake. Apanya yang salah ya? mohon masukann


[Non-text portions of this message have been removed]





-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : itcenter-h...@yahoogroups.com 

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
itcenter-dig...@yahoogroups.com 
itcenter-fullfeatu...@yahoogroups.com

* To unsubscribe from this 

[ITCENTER] Convert VOB ke MPEG/AVI

2008-09-20 Terurut Topik Dannie Tj.
Aku download VOB files dan pingin di play di dvd player. 

Ada yg tahu s/w freeware buat convert ke mpeg/avi?

Thx!



-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/



[ITCENTER] Stored Procedure gak mau return datetime

2008-06-30 Terurut Topik Dannie Tj.
Hi,

Aku ada masalah lain nih, mau minta tolong kasih masukan soalnya udah mumet nih 
kepala :((


Ceritanya aku manggil SP sp_date_after_clarify_close untuk return datetime 
value.

Problemnya, tiap kali SP itu aku run/compile, selalu dapat error 

Msg 257, Level 16, State 3, Procedure sp_date_after_clarify_close, Line 57
Implicit conversion from data type datetime to int is not allowed. Use the 
CONVERT function to run this query.



Problem nya itu aku perhatikan dibagian RETURN(...), kalau aku remark '--' 
hasil compile nya sukses. 

Kenapa ya? padahal @date_time = date_after_clarify_close = datetime type.

Thx sebelumnya.







Main Program


DECLARE @date_after_clarify_close datetime

EXEC @date_after_clarify_close=dbo.sp_date_after_clarify_close
   @date_clarify_close,
   @int_issue_id,
   ''


-

STORED PROCEDURE


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[sp_date_after_clarify_close]
 @date_clarify_close datetime,
 @int_issue_id int,
 @date_after_clarify_close datetime OUTPUT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @date_temp datetime

DECLARE cr_date_after_clarify_close CURSOR 
FOR
SELECT date_response
FROM responses
WHERE issue_id = @int_issue_id
ORDER BY date_response

OPEN cr_date_after_clarify_close

FETCH NEXT FROM cr_date_after_clarify_close into @date_temp

WHILE @@FETCH_STATUS = 0
BEGIN

 IF @date_temp = @date_clarify_close
BEGIN
   FETCH NEXT FROM cr_date_after_clarify_close into @date_temp

   SET @date_after_clarify_close = @date_temp  
END
 ELSE 
FETCH NEXT FROM cr_date_after_clarify_close into @date_temp

END

CLOSE cr_date_after_clarify_close 

DEALLOCATE cr_date_after_clarify_close

RETURN (@date_after_clarify_close) --- Suspect issue disini, karena kalo 
aku remark '--', run/compile nya jalan mulus.

END




Msg 257, Level 16, State 3, Procedure sp_date_after_clarify_close, Line 57
Implicit conversion from data type datetime to int is not allowed. Use the 
CONVERT function to run this query.



[Non-text portions of this message have been removed]




-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/



Set HOSTNAME [Re: [ITCENTER] Re: telnet ke vmware]

2007-07-12 Terurut Topik Dannie Tj.
Thx, udah bisa telnet sekarang :)

Skarang mau nanya, gimana caranya nge set hostname di SOLARIS 10 kalau di 
set dhcp client?

Udah coba set manual di /etc/hosts dan /etc/inetipnodes, lalu reboot 
machine, abis itu informasinya balik lagi ke 'unknown'

xxx.yyy.zzz.hhh  unknown # Added by DHCP

gimana caranya supaya hostname nya jadi permanent?

thx!



- Original Message - 
From: pbgabsi [EMAIL PROTECTED]
To: ITCENTER@yahoogroups.com
Sent: Thursday, July 12, 2007 12:32 AM
Subject: [ITCENTER] Re: telnet ke vmware


Edit virtual Machine setting  Hardware  Ethernet, SOL



-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##

## Jaket ITCENTER tersedia di http://shop.itcenter.or.id 
 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 


Re: [ITCENTER] Re: telnet ke vmware

2007-07-11 Terurut Topik Dannie Tj.
sorry masih gak nangkep.

set sebagai host dimana mas/mbak?

thx.

- Original Message - 
From: pbgabsi [EMAIL PROTECTED]
To: ITCENTER@yahoogroups.com
Sent: Tuesday, July 10, 2007 6:14 PM
Subject: [ITCENTER] Re: telnet ke vmware


set sebagai host, SOL

--- In ITCENTER@yahoogroups.com, Dannie Tj. [EMAIL PROTECTED] wrote:

 Saya ada install Solaris pake vmware.
 
 Pertanyaannya, gimana caranya supaya saya bisa telnet ke SUN dari
windows? 
 Saya lihat, ip nya si SUN beda dengan windows.
 
 Setting di vmware nya pake 'bridge'.
 
 Thx.





-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##

## Jaket ITCENTER tersedia di http://shop.itcenter.or.id 
 
Yahoo! Groups Links






-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##

## Jaket ITCENTER tersedia di http://shop.itcenter.or.id 
 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 


[ITCENTER] telnet ke vmware

2007-07-10 Terurut Topik Dannie Tj.
Saya ada install Solaris pake vmware.

Pertanyaannya, gimana caranya supaya saya bisa telnet ke SUN dari windows? 
Saya lihat, ip nya si SUN beda dengan windows.

Setting di vmware nya pake 'bridge'.

Thx. 



-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##

## Jaket ITCENTER tersedia di http://shop.itcenter.or.id 
 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 


[ITCENTER] Milis SUN SOLARIS

2007-07-08 Terurut Topik Dannie Tj.
Hi,

Ada yg tahu milisnya SUN SOLARIS yg Indonesia gak?

Thx.


-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] 
## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ##

## Jaket ITCENTER tersedia di http://shop.itcenter.or.id 
 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/