User hmmftg | chat.stackexchange.com

hmmftg

Aug 14, 2012 18:05

@Phil should I create separate listener for extproc?

hmmftg

Aug 14, 2012 18:03

@Phil but now I cannot run my extenal proc!!! it says: ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "CALL_C_PROGRAM", line 1
ORA-06512: at line 5

hmmftg

Aug 14, 2012 18:03

@Phil I removed the (PROGRAM = extproc) from listener.ora

hmmftg

Aug 14, 2012 17:47

@Phil I post the question

hmmftg

Aug 14, 2012 17:41

@Phil The bad thing here is I'm also Oncall but software support not DBA!

hmmftg

Aug 14, 2012 17:40

@Phil actually it is 22:00 here and he will never answer me this late!

hmmftg

Aug 14, 2012 17:37

@Phil @Jack Yes lsnrctl start

hmmftg

Aug 14, 2012 17:36

@Phil Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testiold)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testiold)(PORT=1521)))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
IBM/AIX RISC System/6000 Error: 78: Connection timed out

hmmftg

Aug 14, 2012 17:35

;( why I cannot start my listener? it says time out!!!

hmmftg

Aug 14, 2012 17:19

Thanks god stackexchange didn't block us!

hmmftg

Aug 14, 2012 17:18

@Phil actually they stopped supporting my country!

hmmftg

Aug 14, 2012 17:16

@Phil we don't have any killall but kill -9 works fine

hmmftg

Aug 14, 2012 17:14

@Phil Wow I dunno that

hmmftg

Aug 14, 2012 17:13

TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
IBM/AIX RISC System/6000 Error: 78: Connection timed out

hmmftg

Aug 14, 2012 17:12

@Phil lsnrctl stop waits... after a minute

hmmftg

Aug 14, 2012 17:12

@Phil It doesn't work

hmmftg

Aug 14, 2012 17:11

@Phil and calling the function causes: ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "CALL_C_PROGRAM", line 1
ORA-06512: at line 5

hmmftg

Aug 14, 2012 17:11

@Phil I cannot restart the listener

hmmftg

Aug 14, 2012 17:10

@Phil I do as you said but there is one problem

hmmftg

Aug 14, 2012 17:10

@Phil Hi Phil

hmmftg

Aug 14, 2012 17:10

Oracle listener question can anybody help me?

hmmftg

Aug 14, 2012 17:09

Hi again!

hmmftg

Aug 14, 2012 15:41

Yup

hmmftg

Aug 14, 2012 15:35

Has anyone any idea for my asked question?

hmmftg

Aug 14, 2012 15:03

thanks for your help

hmmftg

Aug 14, 2012 15:03

Ok I'll do that

hmmftg

Aug 14, 2012 15:02

I have a C library which has been maked and now I have .so file in my dir

hmmftg

Aug 14, 2012 15:01

can I ask something else?

hmmftg

Aug 14, 2012 15:00

thank you very much phil

hmmftg

Aug 14, 2012 14:59

wow worked

hmmftg

Aug 14, 2012 14:58

and after that I have to start listener again?

hmmftg

Aug 14, 2012 14:57

You mean I should start db by sqlplus?

hmmftg

Aug 14, 2012 14:50

I'm writing the question

hmmftg

Aug 14, 2012 14:50

ps auxww | grep pmon | grep -v grep returns nothing

hmmftg

Aug 14, 2012 14:47

OK

hmmftg

Aug 14, 2012 14:46

it says:

hmmftg

Aug 14, 2012 14:46

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory

hmmftg

Aug 14, 2012 14:46

I cannot connect to db

hmmftg

Aug 14, 2012 14:45

Starting /oracle/10.2.4/db/OraHome_1/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
System parameter file is /oracle/10.2.4/db/OraHome_1/network/admin/listener.ora
Log messages written to /oracle/10.2.4/db/OraHome_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testiold)(PORT=1521)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error

hmmftg

Aug 14, 2012 14:45

but I saw this error:

hmmftg

Aug 14, 2012 14:45

I modified my listener.ora file to support external procedure calls

hmmftg

Aug 14, 2012 14:44

Hi mr Phil can you help me?

hmmftg

Aug 14, 2012 14:44

(ADDRESS =
(PROTOCOL = IPC)
(KEY = EXTPROC)
)

hmmftg

Aug 14, 2012 14:43

and add this lines;

hmmftg

Aug 14, 2012 14:43

So I come to modify listener.ora

hmmftg

Aug 14, 2012 14:43

I wanted to call an external proc

hmmftg

Aug 14, 2012 14:42

Hi there! Can anyone help me with listener problem in Oracle?

hmmftg

The Heap™ – Consultancy ©®