Login or Register to Ask a Question and Join Our Community


HP-UX

Accessing databases using sql*plus on HP box

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems HP-UX Accessing databases using sql*plus on HP box
# 1  
Old 09-14-2005
Accessing databases using sql*plus on HP box
When I try to connect to databse from HP box using the following command

sqlplus <username>@<databasename>

I get this error message:

ksh: <database name> : not found

I can connect to the database outside the UNIX box using sqlplus though.

Looks like the problem is the way HP Unix is interpreting the the key "@"

Can someone help with this?
# 2  
Old 09-14-2005
What happens when you type sqlplus by itself? You should be prompted with something like this:
Code:
$ sqlplus

SQL*Plus: Release ...
...

Enter user-name:

# 3  
Old 09-14-2005
Yes, that works
# 4  
Old 09-14-2005
Type:
stty -a
You will probably see
intr = DEL; quit = ^\; erase = ^H; kill= @

Use the command:
stty intr ^c kill ^?
to fix that.
# 5  
Old 12-21-2005
or else just put \ (backslash) before @ in ur sqlplus command.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Notify when the script run(hourly)on my jump-box only when there is a failure on my remote-box

Team, Presently I have a script, which i have set up cron on one of my Jump-boxes,and gives me the output on every hourly basis,fetching the data from the remote machine.Basically it gives me the list of all active users logged and its count once we execute the script.Here the count is... (6 Replies)
Discussion started by: whizkidash
6 Replies

2. Windows & DOS: Issues & Discussions

SQL Server import csv or txt on a Solaris box

New to using sql server and unix, but say I have here /home/foo/file.txt Can I use some kind of process to push that .txt into a sql server? Or Is there a sql server utility that can be configured to find a unix box and go into /home/foo/file.txt and slurp it up:) Or is there any PC and... (5 Replies)
Discussion started by: sas
5 Replies

3. Solaris

Need to move all databases from solaris to linux box

Hi , Could anyone please advice me that how can i easily transfer all the databases from solaris box to linux box.. Thanks, Mani ---------- Post updated at 03:38 AM ---------- Previous update was at 03:36 AM ---------- One update: This is a Mysql databases... it around 20 DB (1 Reply)
Discussion started by: Mani_apr08
1 Replies

4. Shell Programming and Scripting

Accessing the variable from pl sql bolck

I hve a PL SQL block in unix where i define a variable "var_px_cat" and use it for taking count SELECT COUNT(*) INTO var_px_cat FROM A WHERE B = '$CATEGORIE_ID'; Now how do I access the variable "var_px_cat" in unix after exiting from pl sql block. (3 Replies)
Discussion started by: theeights
3 Replies

5. UNIX for Dummies Questions & Answers

Backing Up and Emailing Home Directory and SQL Databases

Hello, I run a web hosting company, and I'm wondering how I can use cPanel's Cron Jobs so that a copy of my entire home directory and a copy all of my MySQL databases can be compressed and emailed to me. I know nothing about Linux, Unix, or whatever that thing with the penguin is called. :) ... (7 Replies)
Discussion started by: millipedeman
7 Replies

6. Shell Programming and Scripting

ftp file starting with particular name on Windows box to Unix box using shell script

Hello all ! I'm trying to write a shell script (bash) to ftp a file starting with particular name like "Latest_" that is present on a Windows box to UNIX server. Basically I want to set this script in the cron so that daily the new build that is posted on the Windows box can be downloaded to the... (2 Replies)
Discussion started by: vijayb4u83
2 Replies

7. Programming

accessing mysql from ms-sql

Hi, I was trying to access Mysql Server sitting in Linux Box from MS-SQL through linked server concept. I am getting the error as : "Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary... (0 Replies)
Discussion started by: DILEEP410
0 Replies

8. UNIX for Advanced & Expert Users

Accessing PL/SQL OUT variables in Korn Shell Script

Hello All, I was just wondering if there is any direct way to access PL/SQL OUT variables from Korn Shell Script. I could already figure out how to return a single value back from PL/SQL to Shell Script (using bind variable). But, what if we want to return multiple values? One option I... (4 Replies)
Discussion started by: bright_future
4 Replies

9. Shell Programming and Scripting

Shell script for accessing a file in the network drive and invoking oracle sql loader

Hi, Please let me know if anybody is having a solution handy for the below tasks... It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task. Task: Check if the network drive exists Check... (0 Replies)
Discussion started by: sayydevara
0 Replies

10. UNIX for Advanced & Expert Users

concurrency issue while Accessing Mail Box from shell script

Hi Bros, I am in a serious trouble with concurrency issue while using mailx. I have a shell script which reads all the emails of a unix user account and create a copy (another mbox for processing and archive purpose). This script works fine for 99.99% of the time but sometime it start creating... (2 Replies)
Discussion started by: Sumit_Fundoo
2 Replies
Login or Register to Ask a Question