Visit Our UNIX and Linux User Community


Unable to configure Oracle sqlplus V12 properly. Need Help. Resources could'nt be found elsewhere .


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Unable to configure Oracle sqlplus V12 properly. Need Help. Resources could'nt be found elsewhere .
# 1  
Old 09-15-2014
Oracle 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:
Code:
sqlplus64

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. Smilie

Moderator's Comments:
Mod Comment 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.



Last edited by radoulov; 09-15-2014 at 04:23 PM..
# 2  
Old 09-15-2014
Did you just install the Oracle client? Do you have an Oracle Database server to connect with the client?

Users are setup on the DB side.
This User Gave Thanks to colshine For This Post:
# 3  
Old 09-15-2014
Oracle I installed just 3 *rpm files using alien software which converted them into *.deb files, installed.

alien took care of the installation of the *.deb files itself.
Yeah, i get that the username and password has to be setup at the server side. But, i am a newbie to sqlplus and a total noob in this topic. I want to use this locally on my personal machine for my practice purposes.
Anyhow, answer for your question, Files i installed:
  • oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
  • oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
  • oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm



as per the instructions on, https://help.ubuntu.com/community/Oracle%20Instant%20Client
# 4  
Old 09-15-2014
You have installed only the client. You're not able to connect as there's no database ...
Oracle Database Server is not supported on Ubuntu, you can use a free supported
platform like Oracle Linux.
This User Gave Thanks to radoulov For This Post:
# 5  
Old 09-15-2014
Oracle

Quote:
You have installed only the client. You're not able to connect as there's no database ...
Oracle Database Server is not supported on Ubuntu, you can use a free supported
platform like Oracle Linux.
If you don't mind, can you please give me a guided step by step procedure of what to do and the URL of the apt resources for the mentioned platform (Ubuntu 14.04 64 bit) required for the installation, Or at least redirect me to a page containing the procedures, which you think would really work?

This is a much needed software for me now. Smilie
Thanks in advance. Smilie
# 6  
Old 09-15-2014
As I said, you should use a supported platform (not Debian/Ubuntu!).
You can use either the official documentation or the quick guides on Tim Hall's oracle-base.com.
# 7  
Old 09-15-2014
Thanks for you instant response.

Quote:
As I said, you should use a supported platform (not Debian/Ubuntu!).
You can use either the official documentation or the quick guides on Tim Hall's oracle-base.com.
Ok, I begin to understand the nature of the problem.
But, the following procedure made me wonder, if 11g would work on Ubuntu:

Code:
http://meandmyubuntulinux.blogspot.in/2012/05/installing-oracle-11g-r2-express.html

So, Can you please check that article and tell me, if i follow those steps exactly as prescribed, i would be able to create a username, password to use them to log in locally into my personal computer to practice my subject? Smilie

---------- Post updated at 12:58 AM ---------- Previous update was at 12:58 AM ----------

I have used that link as as code, only because that i was unable to post an URL. Sorry.
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #867
Difficulty: Medium
John McDonald developed Lisp in 1958 while he was at the Massachusetts Institute of Technology (MIT).
True or False?

10 More Discussions You Might Find Interesting

1. Web Development

Do anyone know how to configure document to point to home directory properly in apache?

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

2. UNIX for Dummies Questions & Answers

SQLPLUS not found

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

3. Shell Programming and Scripting

Can't get shell parameters to pass properly to sqlplus

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)
Discussion started by: WhoDatWhoDer
3 Replies

4. Ubuntu

sqlplus: command not found

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)
Discussion started by: sandy0594
20 Replies

5. Shell Programming and Scripting

sqlplus: not found

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. Shell Programming and Scripting

sqlplus : not found

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

7. Shell Programming and Scripting

Multiple SQLPLUS background processes not working properly

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)
Discussion started by: rawat_me01
1 Replies

8. HP-UX

sqlplus: command not found

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

9. UNIX for Dummies Questions & Answers

No screens found problem - and I cant use keybord properly to solve!!

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)
Discussion started by: olddays
1 Replies

10. UNIX for Dummies Questions & Answers

unable to access hpfs/ntfs properly

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)
Discussion started by: moxxx68
1 Replies

Featured Tech Videos