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
# 8  
Old 12-17-2010
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 Smilie
# 9  
Old 12-17-2010
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  
Old 12-17-2010
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  
Old 12-17-2010
just see this website
DBAsupport.com

-bash-3.00$ make -f ins_sqlplus.mk install
-bash: make: command not found
# 12  
Old 12-17-2010
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 Smilie
# 13  
Old 12-17-2010
-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 luckSmilie
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  
Old 12-17-2010
Quote:
Originally Posted by akhaliq22
Code:
-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
[...]

Code:
-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)
    )
  )

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

Try:

Code:
tnsping orcl
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