能否正常启动OEM或OMS关键有以下两点: 第一.Oracle的系统服务是否开启; 第二.登录时用的用户名和口令是否正确。 那么先针
能否正常启动OEM或OMS关键有以下两点:
第一.Oracle的系统服务是否开启;
第二.登录时用的用户名和口令是否正确。
那么先针对第一点谈谈Oracle的系统服务。在完全安装的情况下,Oracle的系统服务共有11项:
1.Oracle OLAP 9.0.1.0.1
2.Oracle OLAP Agent
3.OracleOraHome90Agent
4.OracleOraHome90ClientCache
5.OracleOraHome90HTTPServer
6.OracleOraHome90ManagementServer(0.5M)
7.OracleOraHome90PagingServer
8.OracleOraHome90SNMPPeerEncapsulator
9.OracleOraHome90SNMPPeerMasterAgent
10.OracleOraHome90TNSListener(5.2M)
11.OracleServiceORACLE(70M)
(注:OraHome90是可以在安装时改变的Oracle的主目录名称,是安装时的默认值)
其中最重要的服务有3个,分别是OracleOraHome90ManagementServer、OracleOraHome90TNSListener与 OracleServiceORACLE。
下面就来看一下有哪些启动错误与它们有关。
1.Oracle系统提示:Ora-12541:TNS:没有监听器;
2.操作系统提示:在本地计算机无法启动OMS服务
错误:1053:服务并未及时响应来控制请求附带;
以上两种错误提示大都是由OracleOraHome90TNSListener监听服务引起的。
解决方法:控制面版-> 管理工具-> 服务-> 右键单击“OracleOraHome90TNSListener”,再单击“启动”。
3.Oracle系统提示:Ora-12500:TNS:监听程序无法启动专用服务器进程;
该错误是由OracleServiceORACLE专用服务器进程引起的。
解决方法:控制面版-> 管理工具-> 服务-> 右键单击“OracleServiceORACLE”,再单击“启动”。
4.Oracle系统提示:VTK-1000:无法连接到Management Server。
请验证您已输入Oracle Management Server的正确主机名和状态。
该错误引起的原因有两种,一是OracleOraHome90ManagementServer还没启动;二是没有输入主机名。
解决方法:控制面版-> 管理工具-> 服务-> 右键单击“OracleOraHome90ManagementServer”,再单击“启动”,
或是输入您这台计算机的完整名称。
接着针对第二点谈谈登录时用的用户名和口令。
在安装结束后,系统提供了两个默认的数据库系统管理员,其用户名和口令分别是SYS/change_on_install和SYSTEM/manager,
同时系统还提供了登录OMS的用户名和口令:sysman/oem_temp。这里容易出现错误的是在登录OMS是用SYS或SYSTEM作为用户名进行登录,
那么Oracle系统就回有“登录身份证明不正确”的提示。
小结:这三个服务的启动或关闭还有先后的顺序。
一般来讲,,启动时必须先启动 OracleOraHome90TNSListener
再启动 OracleOraHome90ManagementServer 或OracleServiceORACLE,
在启动OracleOraHome90ManagementServer时,同时也启动了OracleServiceORACLE。
而关闭时必须先关闭OracleOraHome90ManagementServer
再关闭OracleOraHome90TNSListener或OracleServiceORACLE,
关闭OracleOraHome90ManagementServer时,若有提示输入用户名和口令,请输入sysman的用户名和口令,以确保成功的执行。
有些其他提示如:资源已被占用,I/O重复,端口已被使用等等之类的话,那最好与系统管理员联系,再寻求解决办法。

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

TostorestringsefficientlyinMySQL,choosetherightdatatypebasedonyourneeds:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseTEXTforlong-formtextcontent.4)UseBLOBforbinarydatalikeimages.Considerstorageov

When selecting MySQL's BLOB and TEXT data types, BLOB is suitable for storing binary data, and TEXT is suitable for storing text data. 1) BLOB is suitable for binary data such as pictures and audio, 2) TEXT is suitable for text data such as articles and comments. When choosing, data properties and performance optimization must be considered.

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

MySQLstringdatatypesshouldbechosenbasedondatacharacteristicsandusecases:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseBINARYorVARBINARYforbinarydatalikecryptographickeys.4)UseBLOBorTEXTforlargeuns


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

SublimeText3 Chinese version
Chinese version, very easy to use

mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
