Hi This is request to DBA man Q. I have installed Oracle 10g Express edition i

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

1 Answers
3571 Views
I also Faced
E-Mail Answers

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

what are the performance views in an oracle rac environment?

0 Answers Oracle,

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

0 Answers

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers Genpact,

What does coalescing a tablespace do?

1 Answers

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers STC,

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

Where in the Oracle directory tree structure are audit traces placed?

1 Answers

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers

what is the use of ocr?

0 Answers Oracle,

WHEN DOWN TIME WHAT CAN U DO?

1 Answers TCS,

how can you communicate with operating system files from oracle?

0 Answers Oracle,

For more DB Administration Interview Questions Click Here