03-21-2012
Imho. This is not a routine unix problem. Not heard of this exact fault before and it would take some effort to generate this effect with unix commands. Spilling coffee in the keyboard would be easier!
First: Can you try a different physical keyboard? Can you try a different terminal? Anybody else got the problem?
Second: Ignoring sqlplus. Does typing the @ character at the shell command prompt behave differently when you are logged in as root compared with when you are logged in as oracle or any other user?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am a new user, who wants to connect to oracle through shell scripting.
Can anybody help me?
Regards,
Divyesh (2 Replies)
Discussion started by: divyesh shah
2 Replies
2. Shell Programming and Scripting
Hi Friends,
I am having Perl 5 and Oracle 9i. I just wanna to connect Oracle DB & to perform some select query statement.
Could anyone pls let me know.
I've tried below command which i found in some website, But it throws some error.:confused:
Executed:
perl -e 'use DBI; print... (1 Reply)
Discussion started by: Vijayakumarpc
1 Replies
3. Shell Programming and Scripting
Hi All,
I am trying to connect oracle from unix mechine but i am getting an error like
Ksh: sqlplus: not found
Any one please tell me how to connect oracle from unix mechine.
I would appreciate if any one send the query.
Regards,
Ravi kumar.Gongati (2 Replies)
Discussion started by: ravi gongati
2 Replies
4. Solaris
We have a Sun solaris 9 server (say A), with oracle 9 installed and running, at one place(say X).
We have installed oracle client in windows machines and accessing the database through one application developed by our software vendor. The windows machines are connected through LAN in which the... (0 Replies)
Discussion started by: skbpk_in
0 Replies
5. Shell Programming and Scripting
I want to use Perl to connect to a remote Oracle DB
I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server.
Is this possible?
I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my... (0 Replies)
Discussion started by: frustrated1
0 Replies
6. Shell Programming and Scripting
Hello,
Returing to Unix scripts after a long while,
This might be a simple question for most of you ,
I need to connect from a .sh script to oracle, select XYZ.nextval from dual ,
, meaning either get the Current Val or Next Val for a sequence.
How do I store the return value , I know... (2 Replies)
Discussion started by: Shanks
2 Replies
7. Shell Programming and Scripting
I need to connect my Oracle 11g DB from shell script with 'sysdba' permissions. To do this I have to switch user from 'root' to 'oracle'.
I've tried the following with no success.
su - oracle -c "<< EOF1
sqlplus -s "/ as sysdba" << EOF2
whenever sqlerror exit sql.sqlcode;... (2 Replies)
Discussion started by: NetBear
2 Replies
8. Shell Programming and Scripting
I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'.
What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies
9. UNIX and Linux Applications
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
could someone please help me in shell scripting. i want to connect to oracle database which is on remote sever.
requirement:
1 want to check files in source directory if file exist then a execute a corresponding batch jobs on unix sever and fetch data from oracle database which is on remote... (2 Replies)
Discussion started by: refi123
2 Replies
write(1) General Commands Manual write(1)
NAME
write - interactively write (talk) to another user
SYNOPSIS
DESCRIPTION
The command copies lines from your terminal to that of another user. When first called, it sends the message:
to the receiving user's terminal. When it has successfully completed the connection, it also sends two bells to your own terminal to indi-
cate that what you are typing is being sent.
To set up two-way communication, the recipient of the message (user) must execute the command:
(yourterminal is only required if the originator is logged in more than once.)
Communication continues until an end of file is read from the terminal, an interrupt is sent, or the recipient executes At that point,
writes on the other terminal and exits.
To write to a user who is logged in more than once, use the terminal argument to indicate which line or terminal to send to (e.g., Other-
wise, the first writable instance of the user found in database is assumed and the following message is displayed:
terminal
...
Permission to write may be denied or granted with the command (see mesg(1)). Writing to others is normally allowed by default. Certain
commands, in particular and disallow messages in order to prevent interference with their output. However, if the user has the appropriate
privileges, messages can be forced onto a write-inhibited terminal.
If the character is found at the beginning of a line, calls the POSIX shell (see sh-posix(1)) to execute the rest of the line as a command.
The following protocol is suggested for using When you first to another user, wait for the user to back before starting to send. Each per-
son should end a message with a distinctive signal (such as "" for "over") so that the other person knows when to reply. Similarly, the
signal "" (for "over and out") can be used to indicate the end of the conversation.
EXTERNAL INFLUENCES
Environment Variables
determines the locale to use for the locale categories when both and the corresponding environment variable (beginning with do not specify
a locale. If is not set or is set to the empty string, a default of "C" (see lang(5)) is used.
determines the format and contents of date and time strings.
determines the language in which messages are displayed.
If any internationalization variable contains an invalid setting, behaves as if all internationalization variables are set to "C". See
environ(5).
International Code Set Support
Single- and multi-byte character code sets are supported.
DIAGNOSTICS
The user you are trying to write to is not logged on.
Your correspondent has denied write permission
after your session started. Your session is ended.
Your correspondent sent end-of-file,
or you set your terminal to and your correspondent tried to write to you. If you have a session established, you can continue to
write to your correspondent.
The user you are trying to write to has denied write permission (with
Your terminal is set to
and the recipient cannot respond to you.
EXAMPLES
By issuing the command:
user sends a message to user screen. If responds:
two-way communication between and is established.
FILES
To find user
To execute shell commands
SEE ALSO
elm(1), mail(1), mailx(1), mesg(1), nroff(1), pr(1), sh-posix(1), sh(1), who(1), utmpd(1M), getutsent(3C).
STANDARDS CONFORMANCE
write(1)