Ora-07274:spdcr:access error, access to oracledenied.

Ora-07274:spdcr:access error, access to oracledenied.

Problem phenomenon:

The ORA-12545 error is reported when executing the sqlplus/as SYSDBA login database, as follows:

[[email protected] ~]$ Sqlplus/as Sysdbaora-12545:connect failed because targethost or object does not exist

Problem Analysis:

From the error message, this problem should be a simple and common problem, usually due to the SID is incorrect, the host point is not correct and the local authentication in Sqlnet.ora, will be reported as the error, but through the check, there is no problem, as follows:

Problem solving idea One:

First of all, we should check the above mentioned items, the result is not a problem, but it is dead or alive to go up:

[[email protected] ~]$ cat/etc/hosts # do don't remove the following line, orvarious programs# that require netwo RK functionality would fail.127.0.0.1 Localhost.localdomain localhost192.168.7.20 source192.168.7. Target[[email protected] ~]$ echo $ORACLE _sidwoo[[email protected] ~]$ cat/dbsoft/product/11.2.4/d b_1/network/admin/listener.ora# Listener.ora Network Configuration file:/dbsoft/product/11.2.4/db_1/network/admin/ listener.ora# Generated by Oracle configuration tools. LISTENER = (Description_list = (DESCRIPTION = (address = (PROTOCOL = IPC) (KEY = EXTPROC1521)) (address = (PROTOC OL = TCP) (HOST = 192.168.7.20) (PORT = 1521)))) Adr_base_listener =/dbsoft[[email protected] ~]$ cat/dbsoft/prod uct/11.2.4/db_1/network/admin/sqlnet.ora# Sqlnet.ora Network Configuration file:/dbsoft/product/11.2.4/db_1/ network/admin/sqlnet.ora# Generated by Oracle configuration tools. NAMES. Directory_path= (TNSNames, Ezconnect) adr_BASE =/dbsoft 

Problem Solving method Two:

no valuable information was found from the top, and then checked Alert Alarm log file, send the following error :

[[Email protected]~] $tail -50 $ORACLE _base/diag/woo/woo/alert_woo.log |grep ora-ora-07274:spdcr:access error, Access To Oracledenied.

from this error message to look very strange, then on the Internet to find there is no solution to see Askmaclean of the Blog There is a document in this introduction, but the environment is not the same, it is not a dead horse when live horse medical, and then to solve the problem:

Problem Resolution steps:

as you can see from the Askmaclean blog , the ORACLE in the $ORACLE _home/bin directory may be The file status is not causing the problem, and my steps to resolve this issue are as follows :

1, see the $oracle_home/bin/directory of ORACLE This file, you can find no [[email protected] ~]$ ll$oracle_home/bin/oraclels:/dbsoft/product/ 11.2.4/db_1/bin/oracle:no such file or Directory2, and then copies it to the directory from other normal nodes [[email protected] ~] $SCP $oracle_home/bin/ Oracle Source: $ORACLE _HOME/BIN/3, re-view the file and related permissions, you can see that all is right [[email protected] ~]$ Ll$oracle_home/bin/oracle-rwsr-s--x 1 Oracle Oinstall 239627073SEP  2 22:38/dbsoft/product/11.2.4/db_1/bin/oracle4, re-login sqlplus, success, problem solving. [[email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.2.0.4.0 Production onwed Sep 3 00:12:54 2014Copyright (c) 1 982, Oracle.  All rights reserved. Connected to:oracle Database 11g Enterprise editionrelease 11.2.0.4.0-64bit productionwith The partitioning, OLAP, Data Miningand Real Application Testing optionssql>

Ora-07274:spdcr:access error, access to oracledenied.