Oracle accessing from remote host

Applications Programming
1

i have installd oracle 10 on Solaris 10 now i want to access this database from remote machine.

-bash-3.00$ tnsping 192.168.92.49

TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 17-DEC-2010 21:06:51

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
/export/home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=iac-nms01.))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.92.49)(PORT=1521)))
TNS-12541: TNS:no listener
-bash-3.00$

i have configured listener.ora

-bash-3.00$ more listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = VMSol10)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

when a apply this adapters command i didnt find any adapter

 -bash-3.00$ adapters

Installed Oracle Net transport protocols are:

Installed Oracle Net naming methods are:

Installed Oracle Advanced Security options are:

-bash-3.00$

Please help me out.

2

You have to start the tnslsnr daemon for oracle on the Solaris 10 box.

1 Like
3

how can i start this service?

4

With:

$ lsnrctl start

You can check it with:

$ lsnrctl status
5

just check tnsping result

-bash-3.00$ lsnrctl start
LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 17-DEC-2010 21:36:09

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started
-bash-3.00$ lsnrctl status

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 17-DEC-2010 21:36:21

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VMSol10)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
Start Date                17-DEC-2010 18:56:50
Uptime                    0 days 2 hr. 39 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /export/home/oracle/oracle/product/10.2.0/db_1/network                                                                                        /admin/listener.ora
Listener Log File         /export/home/oracle/oracle/product/10.2.0/db_1/network                                                                                        /log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VMSol10)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 2 handler(s) for this service...
The command completed successfully
-bash-3.00$

-bash-3.00$ tnsping nms01

TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 17-DEC-2010 21:39:38

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
/export/home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=nms01.))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.92.49)(PORT=1521)))
TNS-12541: TNS:no listener
-bash-3.00$
6

What is the dot (.) doing here:

CONNECT_DATA=(SERVICE_NAME=nms01.)
7

i really dont knw from whr this . came
these are the config files

-bash-3.00$ more listener.ora
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = VMSol10)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = orcl)
      (ORACLE_HOME = /export/home/oracle/oracle/product/10.2.0/db_1/)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /export/home/oracle/oracle/product/10.2.0/db_1/)
      (SID_NAME = orcl)
    )
  )

-bash-3.00$ more tnsnames.ora
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.9)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = orcl)
      (INSTANCE_NAME = orcl)
    )
  )
-bash-3.00$ more sqlnet.ora
# sqlnet.ora Network Configuration File: /export/home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

---------- Post updated at 09:56 PM ---------- Previous update was at 09:53 PM ----------

VMSol10=192.168.92.9
is solaris where oracle is installd

8

I only have Oracle installed on one server, so I'm trying to setup a VM with the Oracle client to test.

Can you ping VMSol10 from the remote server? And is the TNS on the remote server set up?

The realisation that I've forgotten more about Oracle than I currently know just hit me :smiley:

9

yup i can ping vmsol10 from my XP machine and i can ping from solaris 10 ping nms01 but i am not able to tnsping nms01.
i think im facing the big issue is adapter dont forget about that.
whn i apply $adapters command i didnt get any tcp/udp adapters

10

You might be right, I seem to have overlooked that adapters output.

This might not cover your problem exactly, but it does discuss along the lines of what you're experiencing:

DBAsupport.com

11

just see this website
DBAsupport.com

-bash-3.00$ make -f ins_sqlplus.mk install
-bash: make: command not found

12

You might find make in /usr/ccs/bin.

For me to pursue this much further, I'd have to install Oracle on Solaris. That could take some time :slight_smile:

13

-bash-3.00$ pwd
/export/home/oracle/oracle/product/10.2.0/db_1/sqlplus/lib
-bash-3.00$ /usr/ccs/bin/make -f ins_sqlplus.mk install

-bash-3.00$ adapters
Installed Oracle Net transport protocols are:

Installed Oracle Net naming methods are:

Installed Oracle Advanced Security options are:

you see my luck:(
ok thank u sooooo much for helping me im going to sleep now its 11:31PM
if you get any solvtion thn plz tell me.
thanks again and good night

14

You defined the OracleNet service as orcl (it's case insensitive), why are you trying to tnsping nms01 instead?

Try:

tnsping orcl
15

nms01 is my XP machine.
Day when i start server.

-bash-3.00$ lsnrctl start

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 18-DEC-2010 10:06:14

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Starting /export/home/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
System parameter file is /export/home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /export/home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VMSol10)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=VMSol10)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
Start Date                18-DEC-2010 10:06:17
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /export/home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /export/home/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VMSol10)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 2 handler(s) for this service...
The command completed successfully
-bash-3.00$

NOw

-bash-3.00$ tnsping orcl

TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 18-DEC-2010 10:07:57

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
/export/home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.9)(PORT = 1521)) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = orcl) (INSTANCE_NAME = orcl)))
OK (20 msec)
-bash-3.00$

But why adapter command not giving me out put?

16

Are you able to connect now?
I don't know why the adapters utility returns nothing, I've never used it.
I see that the documented way of invoking it is:

Anyway, I don't believe you have to worry about it :slight_smile:

17

ok thanks i know that my problem and i have to search for it.
i have tried already these commands ($ cd $ORACLE_HOME/bin ,$ adapters ./oracle) but no output.
this database was install on WM i will try this on physical machine then will inform you about the results.

18

Thanks radoulov :slight_smile:

I just installed Oracle (albeit 11g) on Solaris 10 - which to my amazement worked(!!), and adapters also gives no output. But everything else is OK:

$ hostname
sol10

$ adapters

Installed Oracle Net transport protocols are:


Installed Oracle Net naming methods are:


Installed Oracle Advanced Security options are:

$ 

$ tnsping DB1  

TNS Ping Utility for Solaris: Version 11.2.0.1.0 - Production on 18-DEC-2010 16:33:29

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/oracle/product/11.2/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sol10)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DB1)))
OK (10 msec)

I added the new "DB1" (as DB2) to the TNS of another DB server running Oracle 10:

$ hostname
ora1

$ tnsping DB2

TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 18-DEC-2010 15:47:17

Copyright (c) 1997, 2006, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.2/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = sol10)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = DB1)))
OK (10 msec)

$ sqlplus test1234/test1234@DB2

SQL*Plus: Release 10.2.0.3.0 - Production on Sat Dec 18 15:56:12 2010

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

On my Linux server adapters gives output without any parameters:

$ hostname
ora1

$ adapters

Installed Oracle Net transport protocols are:

    IPC
    BEQ
    TCP/IP
    SSL
    RAW
    SDP/IB

Installed Oracle Net naming methods are:

    Local Naming (tnsnames.ora)
    Oracle Directory Naming
    Oracle Host Naming
   Error!!!   Oracle Names Server Naming is not completely installed!

Installed Oracle Advanced Security options are:

    RC4 40-bit encryption
    RC4 56-bit encryption
    RC4 128-bit encryption
    RC4 256-bit encryption
    DES40 40-bit encryption
    DES 56-bit encryption
    3DES 112-bit encryption
    3DES 168-bit encryption
    AES 128-bit encryption
    AES 192-bit encryption
    AES 256-bit encryption
    MD5 crypto-checksumming
    SHA-1 crypto-checksumming
    Kerberos v5 authentication
    RADIUS authentication
19

waooo you win :wink:
thanks you so much for helping me that much... i cant ex-price my filling but i can thanks to u.

OK now im going for Oracle Real Application Clusters (RAC) what do u suggestion? where can i get guide?

20

It was fun :slight_smile:

Or at least it was after giving up on that OUI java installer nonsense, and installing it using a response file!

For RAC documentation, I'd go to the Oracle site.

Or use a search engine :slight_smile: