Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Oracle accessing from remote host
Top Forums Programming Oracle accessing from remote host Post 302481411 by akhaliq22 on Friday 17th of December 2010 11:41:34 AM
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
 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

LEARN ABOUT DEBIAN

net::time

Net::Time(3perl)					 Perl Programmers Reference Guide					  Net::Time(3perl)

NAME

       Net::Time - time and daytime network client interface

SYNOPSIS

	   use Net::Time qw(inet_time inet_daytime);

	   print inet_time();	       # use default host from Net::Config
	   print inet_time('localhost');
	   print inet_time('localhost', 'tcp');

	   print inet_daytime();       # use default host from Net::Config
	   print inet_daytime('localhost');
	   print inet_daytime('localhost', 'tcp');

DESCRIPTION

       "Net::Time" provides subroutines that obtain the time on a remote machine.

       inet_time ( [HOST [, PROTOCOL [, TIMEOUT]]])
	   Obtain the time on "HOST", or some default host if "HOST" is not given or not defined, using the protocol as defined in RFC868. The
	   optional argument "PROTOCOL" should define the protocol to use, either "tcp" or "udp". The result will be a time value in the same
	   units as returned by time() or undef upon failure.

       inet_daytime ( [HOST [, PROTOCOL [, TIMEOUT]]])
	   Obtain the time on "HOST", or some default host if "HOST" is not given or not defined, using the protocol as defined in RFC867. The
	   optional argument "PROTOCOL" should define the protocol to use, either "tcp" or "udp". The result will be an ASCII string or undef upon
	   failure.

AUTHOR

       Graham Barr <gbarr@pobox.com>

COPYRIGHT

       Copyright (c) 1995-2004 Graham Barr. All rights reserved.  This program is free software; you can redistribute it and/or modify it under
       the same terms as Perl itself.

perl v5.14.2							    2010-12-30							  Net::Time(3perl)
All times are GMT -4. The time now is 05:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy