11-22-2011
I am invoking sqlplus by just typing sqlplus on the command line. Then it is asking for username and password which I am entering in and ending up with an error Target host doesn't exist. I see that I have to set environment variable called ORACLE_HOME to the directory where oracle was installed. This is exactly what my question was.
How do I set a environment variable in linux that points to a windows server directory assuming that windows and linux are in the same network?
10 More Discussions You Might Find Interesting
1. Solaris
Hello everybody .. i want connect with smbclient to an windows server 2003 with active directory. Exist a version of samba that can do this?
Thank you very much for your time.
Good Luck :b: (3 Replies)
Discussion started by: enkei17
3 Replies
2. Windows & DOS: Issues & Discussions
Hi
i am writing a script in unix where after some validations, i require the script to connect to a windows server and then kich off a batch file there. i tried ftp and got the error message that "the remote host refused an attempted connect operation".
I am able to connect to this unix... (4 Replies)
Discussion started by: vidzz911
4 Replies
3. Shell Programming and Scripting
Hi All,
I need to connect windows server by unix shell script then search the directory for some keyword in all files in that directory...
Windows Server is \\wh01ad04
Please help me and thanks in advance (2 Replies)
Discussion started by: Pratik4891
2 Replies
4. Shell Programming and Scripting
Hi everyone,
I have oracle 9i installed in Windows XP and i have ubuntu in VM WARE.
I would like to know how to connect to Oracle in windows xp from Linux through shel scripting...... (3 Replies)
Discussion started by: Zimbu
3 Replies
5. Red Hat
I want to connect RHEL server from my windows 7 Professional machine graphically. I logged into 1 RHEL server with IP, 10.101.17.80 using Putty from my Windows 7 professional machine. Now from this server, 10.101.17.80, I want to connect to another RHEL server 10.101.17.79. I used,
ssh -X... (1 Reply)
Discussion started by: RHCE
1 Replies
6. Windows & DOS: Issues & Discussions
Hi,
We are running Linux server and are required to connect to Windows server and fetch the files from windows server.
How can i connect to Windows server from Linux? I have to do this with a automated shell script on Linux
I appreciate your response. (4 Replies)
Discussion started by: reachmexyz
4 Replies
7. Shell Programming and Scripting
I am trying to connect to Windows server via Linux server through a script and run two commands " cd and ls " But its giving me error saying " could not start the program" followed by the command name i specify e g : "cd"
i am trying in this manner "
ssh username@servername "cd... (5 Replies)
Discussion started by: sunil seelam
5 Replies
8. Linux
Hi my name is Manju.
->I have configure the two way authentication on my linux server.
->Now I am able to apply two way authenticator on particuler user.
->Now I want to map this linux server to my AD server.
->Kindly tell me how to map AD(Active Directory) with this linux server.
... (0 Replies)
Discussion started by: manjusharma128
0 Replies
9. AIX
Hi,
I followed this procedure in order to mount in AIX a shared folder in windows server 2000.
https://www-304.ibm.com/support/docview.wss?uid=isg3T1012550
Ive tested the shared folder from other windows Server, and its fine.
What Ive do in AIX is:
Logon as root
Under /Home/spss/ I... (2 Replies)
Discussion started by: trevian3969
2 Replies
10. Shell Programming and Scripting
Hi,
I am facing an issue in connecting to database from Linux shell script. Here is my code
export ORACLE_BASE=xxx
export ORACLE_SID=xxx
export ORACLE_HOME=xxxx
DB_PATH=xxx/'yyy@yy'
UserId=`sqlplus -s $DB_PATH <<EOF
set head off feedback off
select max(USER_ID)+1 from USERS;... (6 Replies)
Discussion started by: yuvi
6 Replies
LEARN ABOUT CENTOS
dropuser
DROPUSER(1) PostgreSQL 9.2.7 Documentation DROPUSER(1)
NAME
dropuser - remove a PostgreSQL user account
SYNOPSIS
dropuser [connection-option...] [option...] [username]
DESCRIPTION
dropuser removes an existing PostgreSQL user. Only superusers and users with the CREATEROLE privilege can remove PostgreSQL users. (To
remove a superuser, you must yourself be a superuser.)
dropuser is a wrapper around the SQL command DROP ROLE (DROP_ROLE(7)). There is no effective difference between dropping users via this
utility and via other methods for accessing the server.
OPTIONS
dropuser accepts the following command-line arguments:
username
Specifies the name of the PostgreSQL user to be removed. You will be prompted for a name if none is specified on the command line and
the -i/--interactive option is used.
-e, --echo
Echo the commands that dropuser generates and sends to the server.
-i, --interactive
Prompt for confirmation before actually removing the user, and prompt for the user name if none is specified on the command line.
-V, --version
Print the dropuser version and exit.
--if-exists
Do not throw an error if the user does not exist. A notice is issued in this case.
-?, --help
Show help about dropuser command line arguments, and exit.
dropuser also accepts the following command-line arguments for connection parameters:
-h host, --host=host
Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory
for the Unix domain socket.
-p port, --port=port
Specifies the TCP port or local Unix domain socket file extension on which the server is listening for connections.
-U username, --username=username
User name to connect as (not the user name to drop).
-w, --no-password
Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a
.pgpass file, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to enter a
password.
-W, --password
Force dropuser to prompt for a password before connecting to a database.
This option is never essential, since dropuser will automatically prompt for a password if the server demands password authentication.
However, dropuser will waste a connection attempt finding out that the server wants a password. In some cases it is worth typing -W to
avoid the extra connection attempt.
ENVIRONMENT
PGHOST, PGPORT, PGUSER
Default connection parameters
This utility, like most other PostgreSQL utilities, also uses the environment variables supported by libpq (see Section 31.14, "Environment
Variables", in the documentation).
DIAGNOSTICS
In case of difficulty, see DROP ROLE (DROP_ROLE(7)) and psql(1) for discussions of potential problems and error messages. The database
server must be running at the targeted host. Also, any default connection settings and environment variables used by the libpq front-end
library will apply.
EXAMPLES
To remove user joe from the default database server:
$ dropuser joe
To remove user joe using the server on host eden, port 5000, with verification and a peek at the underlying command:
$ dropuser -p 5000 -h eden -i -e joe
Role "joe" will be permanently removed.
Are you sure? (y/n) y
DROP ROLE joe;
SEE ALSO
createuser(1), DROP ROLE (DROP_ROLE(7))
PostgreSQL 9.2.7 2014-02-17 DROPUSER(1)