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

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


seco

Recommended Posts

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.

رابط هذا التعليق
شارك

انضم إلى المناقشة

يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

زائر
أضف رد على هذا الموضوع...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   تمت استعادة المحتوى السابق الخاص بك.   مسح المحرر

×   You cannot paste images directly. Upload or insert images from URL.

جاري التحميل
×
×
  • أضف...

برجاء الإنتباه

بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية