Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FAN and PHP

User_TEJ1ZFeb 3 2016 — edited Feb 11 2016

Hi,

I'm trying to set up my PHP Applications with FAN Support. After about a week of unsuccessful testing I am really stuck and would like to ask here for further

help. This is my configuration:

OCI8 Version = 2.0.8

PHP Version = 5.5.23

Oracle DB Version = 11.2.0.3

Oracle Client Version = 11.2.0.3

oci8.events = On

I am using a new service with AQ notification = on

When I shutdown one instance (killing pmon or shutdown abort) my application gets:

ORA-12520: TNS:listener could not find available handler for requested type of server

I thought that it should switch the connection to a surviving instance. But it seems that it caches the connect information to the local instance/local listener but

as this listener doesn't have informationen about the killed instance my application receives ora-12520

Does someone have further hints on how to fix that problem? Thanks in advance!

Comments

Gaz in Oz

You will need to supply more information.

. sqlcl version

  sql -v

  or from within sqlcl

  show version

. How do you start the bash shell?

. copy/paste how you start bash. (xterm emulator? cmd.exe? Conemu64?...)

. copy/paste how you start sqlcl

Basically, to help you, you need to show us what you are doing, not just tell us.

For example, up-arrow works for me on windows 10 with bash 3.1:

F:\Oracle>bash

bash-3.1$ sql gaz/gaz@xe

SQLcl: Release 17.2.0 Production on Mon Oct 02 17:45:15 2017

Copyright (c) 1982, 2017, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL> show version

Oracle SQLDeveloper Command-Line (SQLcl) version: 17.2.0.184.0917

SQL> -- pressing up arrow

SQL> show version

calinm

Hi,

I start using the shortcut on the desktop:

C:\cygwin64\bin\mintty.exe -i /Cygwin-Terminal.ico -

$ java -version

java version "1.8.0_131"

echo $TERM

xterm

$ echo $BASH_VERSION

4.3.46(7)-release

After pressing arrow up 4 times, the cursor goes up 4 lines, as seen in the screenshot

pastedImage_0.png

I also tried to start it using cygwin.bat which contains:

@echo off

C:

chdir C:\cygwin64\bin

bash --login -i

this time, arrow up does nothing.

I have nothing in .bash_profile, or any other init scripts.

Thank you,

Calin

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 10 2016
Added on Feb 3 2016
3 comments
1,375 views