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
- 3505 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
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what are the types of connection load-balancing?
What are statistics, under what circumstances they go out of date, how do you update them?
what is ora 24313?what is the procedure to exclude that error?
Query processing is slow(eg select query)how will u solve that
What is a correlated sub-query? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
