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
# 15  
Old 12-18-2010
nms01 is my XP machine.
Day when i start server.
Code:
-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

Code:
-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?
Last edited by radoulov; 12-18-2010 at 04:36 AM.. Reason: Code tags, please!
# 16  
Old 12-18-2010
Quote:
Originally Posted by akhaliq22
But why adapter command not giving me out put?
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:

Quote:
5.2 Adapters Utility
Quote:

Use the adapters utility to display the transport protocols, naming methods, and Oracle Advanced Security options that Oracle Database supports on your system. To use the adapters utility, run the following commands:
$ cd $ORACLE_HOME/bin
$ adapters ./oracle
Anyway, I don't believe you have to worry about it Smilie
# 17  
Old 12-18-2010
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  
Old 12-18-2010
Thanks radoulov Smilie

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:

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

Last edited by Scott; 12-18-2010 at 12:18 PM..
# 19  
Old 12-18-2010
waooo you win ;-)
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  
Old 12-18-2010
It was fun Smilie

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 Smilie
# 21  
Old 12-18-2010
Quote:
Originally Posted by akhaliq22
OK now im going for Oracle Real Application Clusters (RAC) what do u suggestion? where can i get guide?
What exactly do want to know about RAC? There are various articles on the Internet on how to setup a test environment on a VM. My choice would be Tim Hall's www.oracle-base.com, it's enough to mention that he is an Oak Table Network member (this is the last one I tried on my notebook and it was quite interesting: Oracle Database 11g Release 2 RAC On Linux Using VirtualBox).

And of course, you'll need good understanding of Oracle database before you begin to play with RAC. It takes years of hands-on Oracle database administration experience.Smilie

Good luck!
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