Of course you have to replace dbname with your database name.
and check the configuration there.
At this point try to type
login as: B_DB1user B_DB1user@220.127.116.11's password: p@ssw0rd Last login: Fri Feb 8 13:06:53 2013 from 10.10.167.8 [B_DB1user@bamdb001 ~]$
If this is not giving you a connection detail check the entries in tnsnames.ora
[B_DB1user@bamdb001 ~]$ tnsping ORACLE
[B_DB1user@bamdb001 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
bluerose999 wrote:Yes, you missed the basic information you need to connect to a database server (tns entry information) and I'm trying to understand.
Is there anything I missed defining like Environment Variables
might be the problem in remote server?
Can't you ask these information to the company that is providing the service?
WAMS = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = *18.104.22.168*)(PORT = *???*)) (CONNECT_DATA = (SERVER = *DEDICATED OR SHARED*) (*SID OR SERVICE NAME* = *NAME OF DB INSTANCE*) ) )
bluerose999 wrote:If you don't have any quota limit in your Unix environment and you are allowed to write in a directory then you can spool to that directory and transfer the file later on with any file transfer tool that it is working.
Few days ago I read in some forum that we can use WinScp tool to transfer files from remote server to our local machine.
Is it possible that I can do spooling in remote server itself and later using WinScp I can transfer that file to my local machine?
Kindly let me know is this possible, mean while i will try this option.