Unable to configure Oracle sqlplus V12 properly. Need Help. Resources could'nt be found elsewhere .
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:
on my terminal.
It prompts for username and password which i dont know and i also couldn't login as sys or sysdba as per the instruction of pages found on other pages on the internet. Please help, I beg. Need this so much.
I can provide you with further information for you to help me.
Moderator's Comments:
Moved to UNIX for Dummies Questions & Answers!
P.C.: I want to use sqlplus locally on my personal computer. There is no server-client architecture or network here, in my home. But, in college, we use network.
i can't access my ntfs partition from one of my linux devices and can only acess it read only on the other... the two linux systems are Fedora core 4
and Ubuntu Hoary hedghog5*... all three are on a 40Gig drive ofcourse the
windows partition is the primary partition but Fedora doesn't recognize ... (1 Reply)
Title explains it already. I need to solve the problem from log files. But backspace types ^H . I dont know how to delete character. How can I mend the keybord ? (1 Reply)
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)
Hi All,
I am running 25 background process from a Unix shell script which calls a single Oracle procedure with different paramenters each time.
These 25 process creates 25 different files.
When i run these 25 Background SQLPLUS processes, few files are not created completly but if i run 25... (1 Reply)
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)
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)
I installed Oracle 10.2.1.0 in Ubuntu 10.10..my installation was well,i could even open isqlplus( http://ubuntu.ubuntu-domain:5560/isqlplus/workspace.uix ) and execute some queries..But,back in terminal when i try to login to sqlplus i am getting error (20 Replies)
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
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)
Hi
from Running web apps from your home folder
I've more or less follow the guide,
the reason why I'm expering 403 Forbidden is because the higher level directory will take precedance.
$ ls -lrthd /home/phpmy/www/joomla/ drwxrwxr-x 2 phpmy phpmy 4.0K May 1 20:26... (2 Replies)
Discussion started by: jediwannabe
2 Replies
LEARN ABOUT DEBIAN
sql::reservedwords::oracle
SQL::ReservedWords::Oracle(3pm) User Contributed Perl Documentation SQL::ReservedWords::Oracle(3pm)NAME
SQL::ReservedWords::Oracle - Reserved SQL words by Oracle
SYNOPSIS
if ( SQL::ReservedWords::Oracle->is_reserved( $word ) ) {
print "$word is a reserved Oracle word!";
}
DESCRIPTION
Determine if words are reserved by Oracle Database.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either Oracle7, Oracle8i, Oracle9i or Oracle10g.
is_reserved_by_oracle7( $word )
Returns a boolean indicating if $word is reserved by Oracle7.
is_reserved_by_oracle8( $word )
Returns a boolean indicating if $word is reserved by Oracle8i.
is_reserved_by_oracle9( $word )
Returns a boolean indicating if $word is reserved by Oracle9i.
is_reserved_by_oracle10( $word )
Returns a boolean indicating if $word is reserved by Oracle10g.
reserved_by( $word )
Returns a list with Oracle versions that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_oracle7
is_reserved_by_oracle8
is_reserved_by_oracle9
is_reserved_by_oracle10
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://www.oracle.com/technology/documentation/>
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords::Oracle(3pm)