Interested to Buy Any Domain ? << Click Here >> for more details...
Hi This is request to DBA man
Q. I have installed Oracle 10g Express edition in Linux
fedora Core 6.When i have run the following script for
ORACLE _HOME environment variable setting . script is ".
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh"
variable is set but it is working only in current session.
If i restart the system again i should run that script. So
haw to set permanently ? even i have try with export command
for that environment set it also does not work.
Q. When i run sqlplus in shell prompt It is working but when
i give user name and password the following error come out i.e
# sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2
19:45:40 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
I have also proper partition of disk means swap memory are
available.
# fdisk -l
Disk /dev/sda: 40.0 GB, 40060403712 bytes
255 heads, 63 sectors/track, 4870 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 1275 10241406 7
HPFS/NTFS
/dev/sda2 1276 4870 28876837+ f W95
Ext'd (LBA)
/dev/sda5 1276 3187 15358108+ 7
HPFS/NTFS
/dev/sda6 3188 4672 11928231 83 Linux
/dev/sda7 4673 4863 1534176 82
Linux swap / Solaris
- 1 Answers
- 3512 Views
- I also Faced
- E-Mail Answers
Answer Posted / muthu
please add that script path to .bach_profile
for example .
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how to restore files with rman?
Query processing is slow(eg select query)how will u solve that
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what is a user-defined lock?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is a system database and what is a user database? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
