listener_problem

[Arsalan]

Hi Arsalan

1-listener is running

2-tnsping is also work

3-from client side also tnsping are working.

4.from client side i can not connect to db, it give error ora-12518

when i connect to db server  it give error.

Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

[ErmanArslansOracleBlog]

I think your setup is not correct.
I guess your environment lacks a configuration , something like security limits for Oracle OS user.

Check the limits.conf.
Check oracle OS user s limits (using limit -a)
Make sure you are aligned with the installation.
Also check kernel parameters. i.e: kernel.shmmax

If the issue persists, describe your environment in details and send me the screenshot of the errors, so that I can see the full error stack..

But once again, this is probably a setup issue. Check oracle OS user's limits, check kernel parameters, check the ownership of oracle binary, check OS layer firewall (if it is open)  --by reviewing the installation guide..

Here is a document for you: Look what Oracle support suggests there.. I mean look what Oracle Supports recommends checking;

UNIX: TNS-12518: TNS:listener Could Not Hand Off Client Connection (Doc ID 2025041.1)
UNIX: TNS-12518,TNS-12536 When Listener Load Increases (Doc ID 1920559.1)

[Arsalan]

I installed oracle 11g in windows 2008,

The server was shutdown by system admin  gays,so after restart  server here some oracle services

was not restarted like.

1-oracle vss writer service

2-oracle DBConsoled

3-Oracle MTRecovery service

4.Oracle Service DWHSIG

so After i started these services now it work normal.

Thanks you for your quick response

[ErmanArslansOracleBlog]

Aha.. Your env is windows. again an OS layer thing, as you see...

18 Şub 2017 13:10 tarihinde "Arsala [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

I installed oracle 11g in windows 2008,

The server was shutdown by system admin  gays,so after restart  server here some oracle services

was not restarted like.

1-oracle vss writer service

2-oracle DBConsoled

3-Oracle MTRecovery service

4.Oracle Service DWHSIG

so After i started these services now it work normal.

Thanks you for your quick response

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/listener-problem-tp2179p2183.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML