1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / mahendraswain


Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core..

Answer / 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

More DB Administration Interview Questions

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?

0 Answers  

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers  

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

What command would you use to encrypt a PL/SQL application?

1 Answers  




Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

how can you schedule a job in database?

0 Answers   Oracle,

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories