Listener port number

725039

>
Phiri... testdb and orcl were working fine even when TWO_TASK was set earlier. This server works fine after every restart... but after a few days the problem araises... I suspect that port is keep on increasing the value when reaches threshold the connection cant able establish. Please look at the log file in the first post. I feel some thing is terribly wrong with the setting.
>

So I did not see this post; did you finally manage to resolve this?

>
16-APR-2010 13:00:56 * (CONNECT_DATA=(SERVICE_NAME=testdb)(CID=([email protected])(HOST=integ)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.92.5.37)*(PORT=34487))* * establish * testdb * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

TESTDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = integ)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = testdb)
)
)

Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 2 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

>

That error will continue as long as you do not have testdb being listened to by your listener.

Regards,
Phiri

EdStevens

khaja(DBA) wrote:
Hey DBA84,

He is trying to connect the database locally.Then no concerned with listener here.

Even if the listener is down also,he can able to connect to the database.

Listener comes into picture when you are connecting remotely.

Listener CAN com into the picture on the same server:

sqlplus /  
sqlplus / as sysdba
sqlplus scott/tiger

will use bequeath connections and not require the listener

sqlplus scott/[email protected]

will use the listener, whether local or remote.

KSG:set the oracle_sid & try to connect.


Regards,
khaja

EdStevens

phiri wrote:
>
Yes Phiri... There are two databases running in the server with same oracle home.

I can able to connect to orcl database

But, I cant able to connect to testdb database. Which I have posted in my earlier postings..
>

Two instances, not databases, you can only have one database software installation in an Oracle Home

BZZZT! Wrong answer!

You can very well have two databases with a single oracle home. And along with those two databases, you'd have two instances.

Instance and database are not the same thing. An instance is the memory and processes. The database is the files. The distinction becomes clear when you start dealing with RAC: 1 database, multiple instances managing that database.
>

Very well then; do the following and let us know what happens.

. oraenv

The when prompted for SID, use testdb.

Regards,
Phiri

Edited by: phiri on 16-Apr-2010 16:32

725039

Yes indeed Ed, thanks for spotting that one as well; Hans actually corrected me.

>
sqlplus /
sqlplus / as sysdba
sqlplus scott/tiger
>

The above were all making use of the listener because the OP had TWO_TASK variable set.

Regards,
Phiri