04-13-2011
hey,here are the results:
Quote:
oracle@ubuntu:~$ export ORACLE_SID=orcl
oracle@ubuntu:~$ export PATH=$PATH:/opt/oracle/oracle/product/10.2.0/db_2/bin
oracle@ubuntu:~$ export ORACLE_HOME=/opt/oracle/oracle/product/10.2.0/db_2
oracle@ubuntu:~$ sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 13 15:06:03 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: scott
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
Enter user-name:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Can someone tell me how to execute sqlplus command.
I`m Executing:
sqlplus user/pasw @/report/output/new/PlatformOut_Cdrs.sql
the error is:
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Aug 9 15:37:44 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:... (3 Replies)
Discussion started by: Nel
3 Replies
2. Shell Programming and Scripting
hello all
im trying to use in sun Solaris the information received from the top command
now i several machines that dont have install the top program so when im running the script im geting error
saying after im running this code :
set MemoryInfo = `top | grep Memory`
if (... (2 Replies)
Discussion started by: umen
2 Replies
3. HP-UX
hi,
i need bash shell script run on the crontab(Unix tru64).
i have write my shell. it's using sqlplus command and connect to oracle db.
execute cron job when i have error messege: "sqlplus: command not found"
have you any suggestion? (4 Replies)
Discussion started by: Tlg13team
4 Replies
4. Shell Programming and Scripting
Hi,
Below is my script:
#!/bin/sh
sqlplus uname/pwd@instance <<EOF
set wrap off
set feedback off
set pagesize 0
set verify off
set trimspool on
set linesize 5000
spool /arboru02/FX/scripts/customer_profile_def.txt
select... (1 Reply)
Discussion started by: ss_ss
1 Replies
5. Shell Programming and Scripting
Hi All ,
At the end I have to post my problem thinking I'll be able to get a clue.
I have done a shell script to access a table in our database to extract some logs .
Script is working when executed manually ,but when I set it up in cronjob it is not working. I know thins should be a... (2 Replies)
Discussion started by: Davinzy
2 Replies
6. UNIX for Dummies Questions & Answers
hi,
I am new to unix and trying to connect to oracle from unix.
I typed the below command and the error is sqlplus not found
$ sqlplus
-ksh: sqlplus: not found
can someone please tell me what is missing? I see that oracle is available on this unix box in the path /opt/oracle as... (7 Replies)
Discussion started by: Vijay81
7 Replies
7. Shell Programming and Scripting
Hi ,
i am new to unix i need a small clarification regarding this
sqlplus -s $USER_NAME/$PASSWD@$ORA_SID<< EOF >> SQL_CONN_LOG.log
In the above command what is the meaning of <<EOF>>
Thanks,
krishna. (2 Replies)
Discussion started by: rams_krishna
2 Replies
8. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
9. UNIX for Dummies Questions & Answers
I installed Oracle sqlplus on My Ubuntu 14.04 64bit version as per the instructions on:
help.ubuntu page (Unable to post the URL as i'm new user here).
I'm totally new to SQL and now i'm learning queries in my college.
I installed 64bit version of sqplus and run it executing the command:... (14 Replies)
Discussion started by: arjunmayilvagan
14 Replies
10. UNIX and Linux Applications
Hi all,
i face an error related to my server ""it's running server"" when i use sqlplus command
$ sqlplus
bash: sqlplus: command not found
the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup.
i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies
LEARN ABOUT DEBIAN
dch-repeat
DCH-REPEAT(1) General Commands Manual DCH-REPEAT(1)
NAME
dch-repeat - repeats a changelog entry into an older release
SYNOPSIS
dch-repeat --build-tree <PATH>
dch-repeat --source-release <RELEASE>
dch-repeat --target-release <RELEASE>
dch-repeat --devel-release <RELEASE>
dch-repeat --pocket <POCKET>
dch-repeat -h
DESCRIPTION
dch-repeat is used to repeat a changelog into an older release. It expects that --build-tree is laid out with each Ubuntu release as a
separate directory ("feisty", "edgy", etc).
For example, if gimp had a security update prepared for Feisty in $TREE/feisty/gimp-2.2.13, running dch-repeat in $TREE/edgy/gimp-2.2.13
would pull in the latest changelog from the Feisty build.
OPTIONS
Listed below are the command line options for dch-repeat:
-h or --help
Display a help message and exit.
--build-tree PATH
Base of build trees. Default is /scratch/ubuntu/build.
-s or --source-release RELEASE
Which release to take changelog from.
--target-release RELEASE
Which release to build into.
--devel-release RELEASE
Which release is the development release.
--pocket POCKET
Which pocket to use.
AUTHOR
dch-repeat was written by Kees Cook <kees@ubuntu.com>. This manual page was written by Jonathan Patrick Davies <jpds@ubuntu.com>.
Both are released under the GNU General Public License, version 2.
SEE ALSO
dch(1).
ubuntu-dev-tools 10 August 2008 DCH-REPEAT(1)