Advertisement

02.04.2008 at 09:46PM PST, ID: 23137229
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Tags: oracle, database, 10g, oracle 10g on linux
Hi experts,
I get the following error when I want to start sqlplus:

[oracle@localhost ~]$ sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
[oracle@localhost ~]$

For more information, tnsnames.ora is as follows:

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

for more information, oracle's .bash_profile is as follows:

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
      . ~/.bashrc
fi
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
PATH=$PATH:$HOME/bin:$ORACLE_HOME:$ORACLE_HOME/bin
export PATH
LIBPATH=$ORACLE_HOME/lib:$LIBPATH;export LIBPATH
ORACLE_SID=orcl;export ORACLE_SID
# User specific environment and startup programs
unset USERNAME


regards,
raju1
Start your free trial to view this solution
Question Stats
Zone: OS
Question Asked By: raju1
Solution Provided By: omarfarid
Participating Experts: 2
Solution Grade: B
Views: 666
Translate:
Loading Advertisement...
02.04.2008 at 09:52PM PST, ID: 20820927

Rank: Guru

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.04.2008 at 10:01PM PST, ID: 20820963

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.04.2008 at 10:04PM PST, ID: 20820975

Rank: Guru

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.04.2008 at 10:05PM PST, ID: 20820976

Rank: Sage

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.04.2008 at 10:36PM PST, ID: 20821073

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.04.2008 at 10:37PM PST, ID: 20821077

Rank: Guru

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.04.2008 at 10:49PM PST, ID: 20821122

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.04.2008 at 10:52PM PST, ID: 20821130

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.04.2008 at 10:55PM PST, ID: 20821138

Rank: Guru

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
02.04.2008 at 10:58PM PST, ID: 20821149

Rank: Guru

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
02.04.2008 at 09:52PM PST, ID: 20820927

Rank: Guru

can you export the env variables as well?

in .bash_profile add the following line after setting the env variables:

export ORACLE_HOME LIBPATH

Why you unset USERNAME
 
02.04.2008 at 10:01PM PST, ID: 20820963
I have mentioned it on the question. I wrote it in .bash_profile as follows:
LIBPATH=$ORACLE_HOME/lib:$LIBPATH;export LIBPATH

Is it correct?

I am new to linux for oracle. I don't know Why you unset USERNAME.
 
02.04.2008 at 10:04PM PST, ID: 20820975

Rank: Guru

Ok, the line

LIBPATH=$ORACLE_HOME/lib:$LIBPATH;export LIBPATH

is correct, but you need to do so for ORACLE_HOME as well:

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 ; export ORACLE_HOME

 
02.04.2008 at 10:05PM PST, ID: 20820976

Rank: Sage

Set this in command line:

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_HOME

and then try to connect to sqlplus.
 
02.04.2008 at 10:36PM PST, ID: 20821073
I have mentioned on the question that I wrote as follows:
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
PATH=$PATH:$HOME/bin:$ORACLE_HOME:$ORACLE_HOME/bin

is it correct?
 
02.04.2008 at 10:37PM PST, ID: 20821077

Rank: Guru

You need to change

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1

to

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 ; export ORACLE_HOME
Accepted Solution
 
02.04.2008 at 10:49PM PST, ID: 20821122
Thanks. I have re-written my .bash_profile as follows:

ORACLE_BASE=/uo1/app/oracle; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_OWNER=oracle; export ORACLE_OWNER
PATH=$PATH:$HOME/bin:$ORACLE_HOME:$ORACLE_HOME/bin
export PATH
NLS_LANG=AMERICAN; export NLS_LANG
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib; export LD_LIBRARY_PATH
LIBPATH=$ORACLE_HOME/lib:$LIBPATH;export LIBPATH
ORA_NLS33=$ORACLE_HOME/nls/data; export ORA_NLS33
ORACLE_SID=orcl;export ORACLE_SID
# User specific environment and startup programs
unset USERNAME
#export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
#export PATH=/u01/app/oracle/product/10.2.0/db_1/bin


It is working now. But it shows the following errors now:

SQL> connect system/immi123
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
 
02.04.2008 at 10:52PM PST, ID: 20821130
Enter user-name: sys/immi123 as sysdba
Connected to an idle instance.

SQL> select table_name from tabs;
select table_name from tabs
*
ERROR at line 1:
ORA-01034: ORACLE not available
 
02.04.2008 at 10:55PM PST, ID: 20821138

Rank: Guru

Oracle database is not started, or you are using the wrong SID

Check if oracle is started or if you SID is different.

To check if oracle is running, run

ps -ef | grep ora

You should see some processes that are owned by oracle

OR

ipcs

You should see some shared memory owned by Oracle, etc.

OR

contact your DBA to start oracle DB.

 
02.04.2008 at 10:58PM PST, ID: 20821149
 
 
02.05.2008 at 12:24AM PST, ID: 20821434
Pls can you solve the prrblem of php installment. Whe I run the following command:
./configure --prefix=/web/php --with-oci8=$ORACLE_HOME --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc/httpd/conf --enable-sigchild

Errors after checking:
Checking OCI8 libraries dir... Configure: error: Oracle (OCI8) required libraries not found


I have also run the following command, but it generates the same error.
./configure --prefix=/web/php --with-oci8=$ORACLE_HOME/lib --with-apxs2=/usr/sbin/apxs --with-config-file-path=/etc/httpd/conf --enable-sigchild

After this make command shows the following errors:
make; *** No target specified and no makefile found. Stop.
 
 
02.05.2008 at 12:33AM PST, ID: 20821466
I have submitted full path instead of $ORACLE _HOME.
 
 
 
20080236-EE-VQP-29 / EE_QW_2_20070628