shared memory

[خالد الجعفري]

تواجهني المشكلة المرفقة في الصورة ارجو ممن لدية فكرة المساعد.....

[خالد الجعفري]

لدي جهاز محمل بقاعدة بيانات ومرتبط بشبكة وموجود سرفر محمل بقاعدة بيانات ايضاً
عندما اشغل الجهاز وهو مرتبط بالشبكة تظهر الرسالة الموضحة في الصورة .
واذا تم فصل الشبكة من الجهاز وقمت بتشغيل الجهاز يشتغل طبيعي ..
الموضوع الذي ارجو المساعدة منكم هو:
كيف ممكن اربط بين اكثر من قاعدة بيانات بدون ظهور هذة الرسالة.
مشكورين.............

[kamal480]

بسم الله الرحمن الرحيم

اخى الكريم بالنسبة لموضوع الربط فهو سهل جدا ما هو عليك فعلة هو ان تعمل alias لكل قاعدة وعند الاتصال تحدد فى connect string اسم ال alias
يعنى مثلا
hr/hr@local
or
hr/hr@server
حيث ان local هو ال alias الذى يعرف القاعدة على ال pc
اما ال server فهو ال alais الخاص بالسيرفر
وان شاء الله ينفع

اخـــــــــــــــــــــــــــتوك كمــــــــــــــــــــــــال

[kamal480]

بسم الله الرحمن الرحيم

اخى الكريم اما بالنسبة لمشكلة الاتصال فاليك هذا الحل عسى ان ينفع اقرائة بتمعن


You can connect to the database when logged on as the Oracle software owner
both locally and remotely.

When logged into the UNIX system as anyone but the Oracle software owner, you
can connect remotely or with two_task set. However, when you try to connect
locally, you receive one or more of the following errors:

ORA-01034 "ORACLE not available"
*Cause: Oracle was not started up. Possible causes include the
following:
- The SGA requires more space than was allocated for it.
- The operating-system variable pointing to the instance
is improperly defined.
*Action: Refer to accompanying messages for possible causes and
correct the problem mentioned in the other messages.
If Oracle has been initialized, then on some operating
systems, verify that Oracle was linked correctly. See
the platform specific Oracle documentation.

ORA-07429 "smsgsg: shmget() failed to get segment."
*Cause: a shared memory segment used for all part of the SGA
could not be retrieved.
*Action: Use the system error number in the error message to
determine why the segment could not be retrieved.
If it does not exist, shutdown the database using the
"abort" option, and then restart it. If the get failed
because the permissions are incorrect, make sure that
the ownership of the oracle executable is the same as
that on the shared memory segment.

ORA-07318 "smsget: open error when opening sgadef.dbf file."
*Cause: Unable to open sgadef.dbf file.
*Action: Check errno. Possible permission problem. Verify that
sgadef.dbf file exists.

ORA-27121 unable to determine size of shared memory segment (Oerr:ORA.27121)
*Cause: shmctl() call failed
*Action: check permissions on segment, contact Oracle support


Problem Explanation:
====================

The file system is mounted with nosuid.


Search Words:
=============

suid, sticky bit, sqlplus, SQL*PLUS, two task, loopback, ora-1034, ora-7429,
ora-7318

Solution Description:
=====================

You need to check permissions on both the binary and the file system.

First, verify that the Oracle binary is set with the uid bit.

Next, check the permissions of the directory upon which Oracle software is
installed. To do this type in:

% mount

A sample output is as follows:

/tmp on swap read/write on Tue Jul 7 18:26:43 1998
/u01 on /dev/dsk/c0t8d0s2 setuid/read/write on Tue Jul 7
18:26:43 1998
/u02 on /dev/dsk/c0t5d0s2 setuid/read/write on Tue Jul 7
18:26:43 1998

If the directory is not mounted with setuid it will look like this:

/u01 on /dev/dsk/c0t8d0s2 nosuid/read/write on Tue Jul 7
18:26:43 1998

If the directory is mounted with NOSUID, then have the system administrator
remount the file system with suid enabled. For further assistance with doing
that, contact the Operating System vendor.


Solution Explanation:
=====================

By default the file system is mounted with Setuid execution allowed.
Specifying nosuid causes the file system to be mounted with setuid execution
disallowed. Therefore, even if the permissions are set correctly on the
Oracle binary, suid is still not in effect.


Solution References:
====================

For more information on suid consult:
Man pages for mount_ufs