إنتقال للمحتوى

  • تسجيل الدخول عبر الفيس بوك تسجيل الدخول عبر تويتر Log In with LinkedIn Log In with Google      تسجيل دخول    
  • إنشاء حساب

صورة
- - - - -

لا استطيع انشاء قاعده بيانات جديده من Sql* Plus


3 رد (ردود) على هذا الموضوع

#1 seco

seco

    عضو

  • الأعضــاء
  • 5 مشاركة

تاريخ المشاركة 05 August 2007 - 09:22 PM

بسم الله

بعد تنصيب oracle 9i مباشره ذهبت الى ال SQL*PLUS لانشاء قاعده بيانات جديده ب create database mm;

يعطينى رساله تقول insufficient priviligies !!
ما الحل ؟

شكرا

#2 -=|mOOdY|=-

-=|mOOdY|=-

    مشرف سابق وعضو مميز

  • المجموعة الماسية
  • 1,324 مشاركة

تاريخ المشاركة 05 August 2007 - 09:25 PM

ما هو المستخدم الذي تستعمله لانشاء database ???

استعمل المستخدم sys

صورة

!!! كم أنت عبقري !!!


#3 seco

seco

    عضو

  • الأعضــاء
  • 5 مشاركة

تاريخ المشاركة 05 August 2007 - 09:31 PM

شكرا لردك
لا استطيع الدخول ب sys رغم انى ادخلت نفس ال password التى قمت بتحديدها فى التنصيب !!


يعطينى رساله تقول
TNS couldn't resolve service name

#4 -=|mOOdY|=-

-=|mOOdY|=-

    مشرف سابق وعضو مميز

  • المجموعة الماسية
  • 1,324 مشاركة

تاريخ المشاركة 05 August 2007 - 10:47 PM

The database you are trying to connect to, is not known by your Oracle client.



Typically, every Oracle Home installed on your pc wil have a subdirectory called network\admin or net80\admin (Oracle 8.0 client).

This subdirectory should contain a file sqlnet.ora which contains following line:

NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME)

Possible other values are ONAMES, NCIS, OID, ...



In the case of Oracle Instant client or if someone has changed the default location where sqlnet.ora and tnsnames.ora resides, you will have to look for the alternative path which is identified by the TNS_ADMIN variable.

This can either be a registry variable (set on HKEY_LOCAL_MACHINE\software\oracle), an environment variable (see your .profile on Unix or choose Properties, Advanced, Environment Variables of My Computer on Windows) or stored in some batch script.



Default installations will use a TNSNAMES.ora file to resolve database names.

See if the tnsnames.ora file exists in your sub directory.



If it doesn't exist and NAMES.DIRECTORY_PATH only contains TNSNAMES (and optionally HOSTNAME), there will be no name resolving.



You will need to create a tnsnames.ora file which will contain all databases you want to connect to.

A typical entry looks like this:



ORA102.WORLD =

  (DESCRIPTION =

	(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))

	(CONNECT_DATA =

	  (SERVER = DEDICATED)

	  (SID = databasename)

	)

  )





You will have to replace hostname and databasename and possible the portnumber to reflect your Oracle databases.



If you think both sqlnet.ora and tnsnames.ora are correct, you might be using multiple Oracle Homes.

Typically this is the case if you install Oracle Developer suite after you install a database on your pc.



With Oracle Locator Express you can easily switch between multiple Oracle Homes.



If you are using other resolving technologies such as Oracle names or Oracle Internet Directory, you can add the service to either ONAMES or OID.

صورة

!!! كم أنت عبقري !!!