بسم الله

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

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

شكرا

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

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

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


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

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.