Login or Register to Ask a Question and Join Our Community


Programming

Oracle accessing from remote host

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Programming Oracle accessing from remote host
# 1  
Old 12-17-2010
Error Oracle accessing from remote host
i have installd oracle 10 on Solaris 10 now i want to access this database from remote machine.
Code:
-bash-3.00$ tnsping 192.168.92.49

[SIZE=2]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
Code:
-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
Code:
 -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.
Last edited by Scott; 12-17-2010 at 12:19 PM.. Reason: Please use code tags, and less formatting
# 2  
Old 12-17-2010
You have to start the tnslsnr daemon for oracle on the Solaris 10 box.
This User Gave Thanks to jim mcnamara For This Post:
akhaliq22
# 3  
Old 12-17-2010
how can i start this service?
# 4  
Old 12-17-2010
With:
Code:
$ lsnrctl start

You can check it with:
Code:
$ lsnrctl status

# 5  
Old 12-17-2010
just check tnsping result
Code:
-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$

Last edited by Scott; 12-17-2010 at 12:45 PM.. Reason: Please use code tags
# 6  
Old 12-17-2010
What is the dot (.) doing here:

Code:
CONNECT_DATA=(SERVICE_NAME=nms01.)

# 7  
Old 12-17-2010
i really dont knw from whr this . came
these are the config files
Code:
-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
Last edited by Scott; 12-17-2010 at 01:06 PM.. Reason: Code tags, please...
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check/get the exit status of a remote command executed on remote host through script

Geeks, Could you please help me out in my script and identify the missing piece. I need to check/get the exit status of a remote command executed on remote host through script and send out an email when process/processes is/are not running on any/all server(s). Here's the complete... (5 Replies)
Discussion started by: lovesaikrishna
5 Replies

2. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

3. Shell Programming and Scripting

Pause processes in remote host and resume execution in another remote host

Hi, Given addresses of 2 remote machines, using a shell script is it possible to get the state of running processes in "src" stop all the processes in "src" exit out of "src" ssh into "dest" resume the state of executing processes captured in step 1 in "dest" Assumption: "src" is... (3 Replies)
Discussion started by: Saeya Darsan
3 Replies

4. UNIX for Advanced & Expert Users

Help! How to find the local host after few ssh hops to remote host???

I do a ssh to remote host(A1) from local host(L1). I then ssh to another remote(A2) from A1. When I do a who -m from A2, I see the "connected from" as "A1". => who -m userid pts/2 2010-03-27 08:47 (A1) I want to identify who is the local host who initiated the connection to... (3 Replies)
Discussion started by: gomes1333
3 Replies

5. Shell Programming and Scripting

running commands to remote host from centralized host

Gurus/Experts We have a centralized UNIX/Solaris server from where we can actually ssh to all other UNIX/Solaris servers...I need to write a script that reside on this centerlized server and do FileSystem monitoring (basically run df -h or -k) of other remote servers and then send an email to me... (6 Replies)
Discussion started by: anjum.suri
6 Replies

6. Shell Programming and Scripting

Run a shell script from one host which connext to remote host and run the commands

I want to write a script which would run from one host say A and connect to other remote host B and then run rest of commands in that host. I tried connecting from A host to B with SSH but after connecting to host B it just getting me inside Host B command prompt. Rest of the script is not running... (6 Replies)
Discussion started by: SN2009
6 Replies

7. UNIX for Dummies Questions & Answers

Accessing a Remote Backup

I had my server crash so I am trying to access the remote backup I had to get all the data back, and I cannot for the life of me remember how to access the backup drive. I made the backups through Plesk and it seems to be locking up whenever I use it to access the backup drive. If this just is... (0 Replies)
Discussion started by: daallie
0 Replies

8. UNIX for Dummies Questions & Answers

Accessing a modem on another Solaris host

Hi! I have 2 Solaris 9 servers (server 1 and server 2) on my network, both have a serial port with dial in/out modems. On server 1 there are always problems with the modem connection, so I really would like server 1 to use the the modem(s) on server 2, when sending something. Is there some way... (4 Replies)
Discussion started by: gsf
4 Replies

9. Solaris

How to delete the files from local host to remote host

Hi all, i am copying .gz files from production server to development server using "scp" command.my requirement is after copying .gz files i want to delete old .gz files(two days back) in development server from production server. like this way i need to delelte .log ,.z and .dmp files... (3 Replies)
Discussion started by: krishna176
3 Replies

10. UNIX for Advanced & Expert Users

Accessing X application from remote

Hi, I need to access X application like xclock( running on remote solaris box) on my local windows machine. I know we have some X-win 32 s/f.. Tried with it , but not succesfull. Do we have any other software to access solaris X application from local windows system. What all setups are... (6 Replies)
Discussion started by: pradeep_desh
6 Replies
Login or Register to Ask a Question