-
Ora-12520
Hi Friends,
I got ora-12520 when i connect from client using shared server connect
to my database. How do I know if my database has correct shared server
configured?
Thanks a lot
Behind The Success And Failure Of A Man Is A Woman
-
Oracle9i Net Services Administrator's Guide
Release 2 (9.2)
Part Number A96580-02
Configuring Shared Server
http://download-east.oracle.com/docs...mts.htm#447168
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
I already followed the instruction setting up the shared server dear (enable dispacthers) , but I still can not connect using the shared server option from the client tnsnames.ora.
Behind The Success And Failure Of A Man Is A Woman
-
then you didnt follow the instructions did you
-
as far as I know i did ....is there other way to do it? like in gui or browser
based OEM?
Behind The Success And Failure Of A Man Is A Woman
-
do you understand english?
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
On the server
lsnrctl status
post the results
Post also the TNSNAMES entry you use
Cheers
-
Thanks dear , my hero you are back where have you been?
LISTENER STATUS
==================
en0(oracle)/home/oracle> lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.1.0 - Production on 23-OCT-2
007 19:17:59
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.1.
0 - Production
Start Date 22-OCT-2007 17:07:32
Uptime 1 days 2 hr. 10 min. 27 sec
Trace Level off
Security OFF
SNMP ON
Listener Parameter File /u01/app/oracle/product/9.2.0.1.0/network/admin/listen
er.ora
Listener Log File /u01/app/oracle/product/9.2.0.1.0/network/log/listener
.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=en0.maxstack.gov.ph)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=en0.maxstack.gov.ph)(PORT=8080))(
Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=en0.maxstack.gov.ph)(PORT=2100))(
Presentation=FTP)(Session=RAW))
Services Summary...
Service "ORA9i.en0" has 2 instance(s).
Instance "ORA9i", status UNKNOWN, has 1 handler(s) for this service...
Instance "ORA9i", status READY, has 1 handler(s) for this service...
Service "ORA9iXDB.en0" has 1 instance(s).
Instance "ORA9i", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
========================
TNSNAMES.ORA
IASSVR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.15.0.16)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = ora9i.en0)
)
)
Behind The Success And Failure Of A Man Is A Woman
-
Could you please also
sql> show parameter dispatcher
and
ps -ef|grep ora
10x
-
Thanks again
SQL> show parameter dispatcher
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=ORA9iX
DB)
max_dispatchers integer 5
mts_dispatchers string (PROTOCOL=TCP) (SERVICE=ORA9iX
DB)
mts_max_dispatchers integer 5
SQL>
en0(oracle)/home/oracle> ps -ef|grep ora
oracle 82042 1 0 20:04:01 - 0:00 oracleORA9i (LOCAL=NO)
oracle 110686 1 0 Oct 22 - 0:00 ora_lgwr_ORA9i
oracle 221322 1 0 Oct 22 - 0:01 ora_pmon_ORA9i
oracle 377020 1 0 Oct 22 - 0:01 ora_dbw0_ORA9i
oracle 381114 1 0 Oct 22 - 0:04 ora_ckpt_ORA9i
oracle 385212 1 0 Oct 22 - 0:02 ora_smon_ORA9i
oracle 389310 1 0 Oct 22 - 0:00 ora_reco_ORA9i
oracle 393408 1 0 Oct 22 - 0:03 ora_cjq0_ORA9i
oracle 397506 1 0 Oct 22 - 0:19 ora_qmn0_ORA9i
oracle 401604 1 0 Oct 22 - 0:00 ora_s000_ORA9i
oracle 405702 1 0 Oct 22 - 0:00 ora_d000_ORA9i
oracle 422100 1 0 Oct 22 - 0:00 /u01/app/oracle/product/9.2.0.1
.0/bin/tnslsnr LISTENER -inherit
oracle 512072 1 0 16:56:13 - 0:00 oracleORA9i (LOCAL=NO)
oracle 651510 655532 0 20:04:41 pts/1 0:00 ps -ef
oracle 655532 528400 0 20:02:50 pts/1 0:00 -ksh
oracle 667660 655532 0 20:04:41 pts/1 0:00 grep ora
Behind The Success And Failure Of A Man Is A Woman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|