你用internal/oracle进入,是否可以看到你的数据库。
如果没有,试自己创建一个表,应该是可以的。
如果没有,试自己创建一个表,应该是可以的。
解决方案 »
- 兄弟们,谁有图书馆管理系统的课程设计?参考参考(400分)!
- 请教:SQLSERVER中IN子查询能用变量么?
- VB6.0执行Select操作后结果集rs的movenext报错-2147467259
- 在存储过程里如何把一个int 型变量转成一个 string 型变量,和如何把一个string 型变量转成一个 int 型变量...
- SQL 2000 升级到 sql 2008R2 64位
- 0
- 创建数据库
- 怎样得到数据库服务器的某一数据库的所有用户名称和登录名列表
- 想问啊建存储程序的问题
- 百折不曲死皮赖脸, 我象小泉首向一样求解历史问题, 今天我是求解饭碗问题? 今天我是在寻找东方不败! 谁能解下面的问题我请他吃饭!!!
- 请问Informix和Oracle是否支持类似SQL Server的TOP与ORDER BY配合使用的功能
- 有谁能给我解迷
我以internal/oracle试过了,提示:提供的登录身份无效。
另外,我不知这与创建表有何关系?
目前的做法是:
启动OMS前,将sqlnet.ora中SQLNET.AUTHENTICATION_SERVICES设为NONE,然后启动OracleInstanceServer,数据库会自动装载并打开,再将SQLNET.AUTHENTICATION_SERVICES设为NTS,这样就可以用sqlplus internal或在DBA Studio 中以SYSDBA方式登录。
但也许这样不安全。
下面是这个版本ORACLE的文档中一点与OMS有关的内容,也许你能在其中找到什么,反正我还不十分理解(最后一点似乎不对)。
Windows Native Authentication
1 Current user database links are not supported with Windows Native
Authentication.2 If the user is logged on as a Windows 2000 domain user from a
Windows 2000 computer, then Kerberos is the authentication
mechanism used by the NTS adapter.
For all other users (local users, Windows NT 4.0 domain users,
Windows 2000 domain users, Windows 95 users, and Windows 98
users), NTLM is the authentication mechanism used by the NTS
adapter. So, if the authentication is set to NTS, on a standalone
Windows 2000 or Windows NT 4.0 computer, ensure that the Windows
Service "NT LM Security Support Provider" is started. If this service is
not started on a standalone Windows 2000 or Windows NT 4.0
computer, NTS authentication fails. This issue is applicable only if you
are running Windows 2000 or Windows NT 4.0 in standalone mode.
Oracle Database Service on Windows 2000 in AutoStart Mode with Logon as SYSTEM
(Bug 1397927) If you have installed an Oracle database service on Windows
2000, when logging in as SYSTEM user (Local System), with startup mode
set to Automatic, it is possible that the Oracle database service starts but the
database does not start automatically. The following error message is
written to the ORADIM.LOG file in the ORACLE_BASE\ORACLE_
HOME\DATABASE directory.
ORA-12640: Authentication adapter initialization failed
It has also been observed that the services like Oracle Enterprise
Management Agent, Oracle Enterprise Manager Management Server and
Oracle Internet Directory may also fail for the same reason because they
cannot connect to the database.
The workarounds for this problem are:
1. Remove the line sqlnet.authentication_services=(NTS) from
SQLNET.ORA or set sqlnet.authentication_services=(NONE) in
SQLNET.ORA.
2. Start the database manually after the Oracle database service has
started using SQL*Plus connecting as user name INTERNAL. Note that
the INTERNAL user name will not be available after release 8.1.7.
3. Start the service as a specific user:
1. Choose Start > Settings > Control Panel > Services. The Services
dialog box appears.
2. Select the service you want to start.
3. Click the Startup button. The Service dialog box appears.
4. Click This account and specify the user name and corresponding
password.
非常感谢你如此耐心地回答,不过有些东西我还是不能明白,如应该如何启动OracleInstanceServer?
另外,我的问题是不能在Enterprise Manager/console方式下,无法搜索到我建立的数据库oradb。我想在这种方式下,能打开我的数据库,应该怎么办?,希望你能再次参加讨论。
你的数据库已经打开了?
请问:你在Enterprise Manager/console方式下,
所用的username/password/management Server分别是什么,进去以后,能够打开你默认的数据库吗?
password(for the first time,you will be notified to change it):oem_temp
server:jwsup.mydomain.com(full computer name,if you type your IP,it may be translated to your full name automatically)在你搜索节点时,节点上Agent服务必须启动才能将其找到。看看你的Agent是否启动。
不行的话试试手工配置节点。我的一切OK,除了如上所说不能以SYSDBA登陆。
我成功了。原来所说的节点为我的计算机名,而我以前一直用的是我的数据库名oradb.所以不能搜索到!