sqlplus connect to database error

Do test in Japan, the use of Japan's environment, each should be sqlplus configuration oracle environment variables (ORACLE_SID, ORACLE_HOME, PATH), due to lack of experience, there have been two very hard to understand the error. This in the shell, the set of these three variables do not need to export, like direct writing, and later appeared in the following two errors.

1, ORACLE_SID = eoss
ERROR
ORA-07217: sltln: environment variable cannot be evaluated.
export ORACLE_SID

The need for change: export ORACLE_SID = eoss

2, OACLE_HOME = / app/eoss/eossdb/9.2.0
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
export OACLE_HOME

The need for change: export OACLE_HOME = / app/eoss/eossdb/9.2.0
  • del.icio.us
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

Related Posts of sqlplus connect to database error

  • ORACLE10G full version centos5 installed (the installation has passed)

    ORACLE10G full version centos5 installed (the installation has passed) 1. Centos 5.0 install rn GUI must be installed, it is best not to start selinux rn rn rn 2. . Ready to install the software: (this is very important, is the first installation fai ...

  • Merge the use of (1)

    Merge to select from a table update or insert some data to another table. And finally is used to update or insert depends on the conditions of the statement. rn Here's our easy to cite an example: rn rn SQL> create table merge_test1 (a number, ...

  • SGA extended the principle of 32bit oracle

    SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...

  • High Availability Oracle Flashback

    Brief introduction Flashback Database is a point in time (PIT) restore the database approach. This incomplete recovery strategy can be used to restore the logic because of human error cause damage to the database. At the introduction of 10g, it is de ...

  • An example of the use of TKPROF

    First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE

  • Diagnosis and principles of order

    SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...

  • ORACLE 10G dataguard configuration Step by Step

    oracle dataguard

Leave a Reply

Recent
Recent Entries
Tag Cloud
Random Entries
Latest Comments