oracle用管理员身份运行,Add ORACLE Listener Fail or ORA-125XX, Don't forget "Run as Administrator"(以管理员身份运行) ...

Add ORACLE Listener Fail, Don't forget "Run as Administrator" on windows7/8

Today A friend find me to help her to solve a listener issue. "Run as Administrator" is What a troublesome thing on win8

Question:

She had with installation of Oracle 11R2 on Windows 8 (64-bit). The issues I faced The errors can't connect database using Listener Service, and not able add new listener.

Symptoms:

1,lsnrctl status

TIP:

Show listener has started but no monitor database services, check the database state

2, select open_mode from v$database;

show parameter local_listener

TIP:

DB is open read write mode. because the DB no-RAC and listener in 1521 port ,so try to reset local_listener parameter had modified value 'loc_listener'.

3，Try to register DB service in Listener.

alter system register;

lsnrctl status

Tip:

Show it is still not listening to the DB service

4， the following change listener listens for static and restart listener

#append listener.ora SID_LIST_LISTENER node like this

(SID_DESC =

(GLOBAL_DBNAME = anbob)

(ORACLE_HOME = /oracle/product/11.2.0/db_1)

(SID_NAME = anbob)

)

Tip:

Static listeners still no work for DB service, and I can not connect the DB using listener service , then I consider to delete the listener and re-create.

5，try to delete this service using oracle netca

cmd -> netca

Tip:

open "Net Configuration Assistant" but not found Listener exists(but later I try to add new listener using "Listener"name get error "ServiceAliasException: Could not save Service Alias: TNS-04406: Object already exists")

6，try to delete this service manually using WINDOWS "SC" tool.

sc stop "OracleOraDb11g_home1TNSListener"

-- done.

sc delete OracleOraDb11g_home1TNSListener

TIP:

delete fail. error is following

[SC] OpenSCManager 失败 5:

拒绝访问。

start regedt32. Go to HKEY_LOCAL_MACHINE/SYSTEM/CURRENTCONTROLSET/SERVICES/ Find the Service you want to remove and delete it.

TIP

try again delete using SC, but delete fail still.

7, Delete current listener fail. I try to add a new listener, use the new listener name and port

netca --> add --> LISTENER_ANBOB AND 1523 port -- finish.

Tip:

listener.ora file had append the new listener info, but not show in WINDOWS service list. and not able connect DB using the new listener.

Let us stop and rethink about 6 # error message “拒绝访问”，It should be a permissions issue. though the current user("WZZ") is not "administrator", but also a member of ADMINISTRATORS group. I thought Windows OS provide a new security policy to run a program in win7 and new, It is called "Run as Administrator" .

Solution:

1. Now a first attempt gave an Access Denied, but after storing the command in a Batch file and executing the batch file to "Run as Administrator" (right-click the command file and choose that option),OracleOraDb11g_home1TNSListener service name had removed!

#create a batch file

#file name: rm_lsnr.bat

sc delete OracleOraDb11g_home1TNSListener

2. Delete current listener.ora in ORACLE_HOME

del %ORACLE_HOME%\

etwork\\admin\\listener.ora

3. run netca to create listener service by Oracle

Start -> All programs -> Oracle - OraDb11g_home1 -> Configuration and Migration Tools -> Net Configuration Assistant

right-click the "Net Configuration Assistant" icon and choose "Run as Administrator", now try to add a new listener, Listener name using LISTENER default and port is 1521. then start the listener service and login the database run "alter system register";

lsnrctl status to verify the new listener is worked. I could login using Oracle Net :-) The problem appeared to be Administrative privileges.

「喜欢文章，快来给作者赞赏墨值吧」 赞赏

【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源(墨天轮)，文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论

请登录后发表评论