Home » RDBMS Server » Networking and Gateways » ORA-01034, -27101 remote connection error after upgrading database from 11g to 12c (Oracle Enterprise 12g, OEL 7 uek)
ORA-01034, -27101 remote connection error after upgrading database from 11g to 12c [message #677550] Wed, 25 September 2019 10:16 Go to next message
rcct
Messages: 36
Registered: May 2013
Location: Ottawa, ON
Member
After I upgrade my database from 11.2.0.4 to 12.2.0.1, I am able to connect normally to the database on my server. However, when I try to connect remotely from Toad or SQL developer, I get the two errors. My Toad is using 12c client for connectivity. I was able to connect before I started the upgrade. Database starts up normally, no errors in alert log. Kindly advise, thanks.
Re: ORA-01034, -27101 remote connection error after upgrading database from 11g to 12c [message #677551 is a reply to message #677550] Wed, 25 September 2019 10:55 Go to previous message
rcct
Messages: 36
Registered: May 2013
Location: Ottawa, ON
Member
Thanks issue is resolved, the database had local_listener set to an obsolete listener, and so the connection was not going through. Setting the parameter to '' resolved it.
Previous Topic: installing client on network drive/share
Next Topic: Intermittent Error ORA-28500 + ORA-28511
Goto Forum:
  


Current Time: Thu Mar 28 18:21:42 CDT 2024