ORA-07274: spdcr: access error, access to oracledenied., spdcroracledenied

ORA-07274: spdcr: access error, access to oracledenied., spdcroracledenied

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

 

 

Symptom:

The ORA-12545 error is reported when SQL plus/as sysdba logs into the database, as follows:

[oracle@source ~]$ 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 because the SID is incorrect, the host points to an incorrect one, and in SQLNET. if the local verification is disabled in ora, the above error will be reported, but the check is normal, as shown below:

 

Solution 1:

First, we should check the items mentioned above. The results are correct, but they cannot be stored in the dead:

[oracle@source ~]$ cat /etc/hosts # Do not remove the following line, orvarious programs# that require network functionality will fail.127.0.0.1               localhost.localdomain localhost192.168.7.20            source192.168.7.21            target[oracle@source ~]$ echo $ORACLE_SIDwoo[oracle@source ~]$ cat/DBSoft/product/11.2.4/db_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 = (PROTOCOL = TCP)(HOST = 192.168.7.20)(PORT = 1521))    )  )ADR_BASE_LISTENER = /DBSoft[oracle@source ~]$ cat/DBSoft/product/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

Solution 2:

Check the alert alarm log file and send the following error:

[oracle@source~]$tail -50 $ORACLE_BASE/diag/Woo/woo/alert_woo.log |grep ORA-ORA-07274: spdcr: access error, access to oracledenied.

 

Looking at this error message, I am very unfamiliar. Then I went to the Internet to find a solution. I can see that there is a document in askmaclean's blog about this, but the environment is different. If it doesn't work, it's a dead horse, then, the problem is solved:

 

Solution steps:

From the askmaclean blog, we can see that this problem may occur due to the incorrect oracle File status in the $ ORACLE_HOME/bin directory. The steps for solving this problem are as follows:

1. Check the oracle file in the $ ORACLE_HOME/bin/directory. [oracle @ source ~] is not found. $ Ll $ ORACLE_HOME/bin/oraclels:/DBSoft/product/11.2.4/db_1/bin/oracle: no such file or directory2. copy the file from other normal nodes to the directory [oracle @ target ~] $ Scp $ ORACLE_HOME/bin/oracle source: $ ORACLE_HOME/bin/3. Check the file and related permissions again. It can be seen that [oracle @ source ~] is correct. $ Ll $ ORACLE_HOME/bin/oracle-rwsr-s -- x 1 oracle oinstall 239627073Sep 2/DBSoft/product/11.2.4/db_1/bin/oracle4 login to sqlplus again, successful, solve the problem. [Oracle @ source ~] $ Sqlplus/as sysdbaSQL * Plus: Release 11.2.0.4.0 Production onWed Sep 3 00:12:54 2014 Copyright (c) 1982,201 3, 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>