clnt_create: RPC: Port mapper failure – Unable to receive: errno 113 (No route to host)

Opublikowano przez Wiech

# edytujemy i dorzucamy po stronie serva:
vi /etc/sysconfig/nfs
MOUNTD_PORT=”888″
STATD_PORT=”889″
RQUOTAD_PORT=”890″
LOCKD_TCPPORT=”891″
LOCKD_UDPPORT=”891″

# FW

iptables -I INPUT -m state –state NEW -p tcp –dport 888 -j ACCEPT
iptables -I INPUT -m state –state NEW -p udp –dport 888 -j ACCEPT
iptables -I INPUT -m state –state NEW -p tcp –dport 889 -j ACCEPT
iptables -I INPUT -m state –state NEW -p udp –dport 889 -j ACCEPT
iptables -I INPUT -m state –state NEW -p tcp –dport 891 -j ACCEPT
iptables -I INPUT -m state –state NEW -p udp –dport 891 -j ACCEPT
iptables -I INPUT -m state –state NEW -p tcp –dpo


…

Drop private dblink from sys

Opublikowano przez Wiech

— user: sys

select db_link from dba_db_links where OWNER=’USERname’;
dblink_name

— tworzymy procedurkę:

CREATE OR REPLACE PROCEDURE USERname.drop_dblink AS
BEGIN
EXECUTE IMMEDIATE 'drop database link db


…

ORA-29024: Certificate validation failure (UTL_HTTP – HTTPS)

Opublikowano przez Wiech

Podczas pobrania adresu „https://…” pojawia się błąd:

select UTL_HTTP.request(’https://…’) from dual
*
Error at line 1
ORA-29273: HTTP request failed
ORA-06512: at „SYS.UTL_HTTP”, line 1530
ORA-29024: Certificate validation failure
ORA-06512: at „SYS.UTL_HTTP”, line 380
ORA-06512: at „SYS.UTL_HTTP”, line 1470
ORA-06512: at line 1

tworzymy wallet-a:

mkdir -p /u01/app/oracle/product/11.2.0.4/dbhome_1/wallet
orapki wallet create -wallet /u01/app/oracle/product/11.2.0.4/dbhome_1/wallet -pwd Password123 -auto_login

dodajemy certyfikaty:

orapki wallet add -wallet /u01/app/oracle/product/11.2.0.4/dbhome_1/wallet -trusted_cert -cert „/tmp/INTERCA.crt” -pwd Passwo


…

The OLE DB provider „OraOLEDB.Oracle” for linked server * reported an error. Access denied. Msg 7350, Level 16, State 2, Line 3 Cannot get the column information from OLE DB provider „OraOLEDB.Oracle” for linked server *.

Opublikowano przez Wiech

Pełny komunikat:

Msg 7399, Level 16, State 1, Line 3
The OLE DB provider „OraOLEDB.Oracle” for linked server * reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 3
Cannot get the column information from OLE DB provider „OraOLEDB.Oracle” for linked server *.

Neleży w Server Objects -> Linked Servers -> Providers dorzucić „Allow inprocess” w danym providerze
…

PRCR-1013 : Failed to start resource, ORA-01078, ORA-01565, ORA-17503, ORA-01017

Opublikowano przez Wiech

Po aktualizacji grida z 12 do 19 i restarcie nie wstaja bazy

[oracle@dbnod ~]$ srvctl start instance -d BAZA -i BAZA1
PRCR-1013 : Failed to start resource ora.BAZA.db
PRCR-1064 : Failed to start resource ora.BAZA.db on node dbnod
CRS-5017: The resource action „ora.BAZA.db start” encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/BAZA/spfileBAZA.ora’
ORA-17503: ksfdopn:10 Failed to open file +DATA/BAZA/spfileBAZA.ora
ORA-01017: invalid username/password; logon denied
. For details refer to „(:CLSN00107:)” in „/u01/app/grid/diag/crs/dbnod/crs/trace/crsd_oraagent_oracle.trc”.
CRS-2674: Start of 'ora.BAZA.db’ on 'dbnod’ failed…