No more data to read from socket error

For errors like this you should involve oracle support. Unfortunately you do not mention what oracle release you are using. The error can be related to optimizer bind peeking. Depending on the oracle version different workarounds apply. You have two ways to address this: upgrade to 11.2 set oracle parameter _optim_peek_user_binds = false Of course underscore parameters …

Read more

Oracle client ORA-12541: TNS:no listener

You need to set oracle to listen on all ip addresses (by default, it listens only to localhost connections.) Step 1 – Edit listener.ora This file is located in: Windows: %ORACLE_HOME%\network\admin\listener.ora. Linux: $ORACLE_HOME/network/admin/listener.ora Replace localhost with Step 2 – Restart Oracle services Windows: WinKey + rservices.msc Linux (CentOs):sudo systemctl restart oracle-xe

PLS-00103: Encountered the symbol “CREATE”

At line 5 there is a / missing. There is a good answer on the differences between ; and / here. Basically, when running a CREATE block via script, you need to use / to let SQLPlus know when the block ends, since a PL/SQL block can contain many instances of ;.

PLS-00201 – identifier must be declared

When creating the TABLE under B2BOWNER, be sure to prefix the PL/SQL function with the Schema name; i.e. B2BOWNER.F_SSC_Page_Map_Insert. I did not realize this until the DBAs pointed it out. I could have created the table under my root USER/SCHEMA and the PL/SQL function would have worked fine.

SQL not a single-group group function

Well the problem simply-put is that the SUM(TIME) for a specific SSN on your query is a single value, so it’s objecting to MAX as it makes no sense (The maximum of a single value is meaningless). Not sure what SQL database server you’re using but I suspect you want a query more like this …

Read more