Loading...

Follow Talip Hakan Ozturk's ORACLE BLOG on Feedspot

Continue with Google
Continue with Facebook
or

Valid

Hi, In this post, I want to share the required steps for Startup, Shut Down, Reset, or Power Cycle the Oracle MiniCluster S7-2 Engineered System. Notify affected users that the server will be shut down. Log into one of the nodes as an MCMU administrator such as mcinstall mcinstall@dpwadm-n1:/var/home/mcinstall % mcmu status -G -k List …

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi, When I try to create Oracle Enterprise Manager with EMCA for 11.2.0.3 database running on 18c Grid Infrastructure, it fails with following error mesaage Database Control (DBC) 11.2 web site creation with emca fails for Oracle Flex with this error message: WARNING: Error determining the nodes associated with cluster database for ASM Apr 9, …

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi, We have installed two node 18c Grid Infrastructure and DB software. Also we need to run 11.2.0.3 database on this 18c Grid Infrastructure. While we install 11.2.0.3 RAC binary, runInstaller fails with below error. [INS-35354] The system on which you are attempting to install Oracle RAC is not part of a valid cluster. This …

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi, Today, I faced the below errors in my alert log file. Direct NFS: Failed to set socket buffer size.wtmax=[1056768] rtmax=[1056768], errno=-1 Mon Apr 08 20:00:51 2019 Direct NFS: Failed to set socket buffer size.wtmax=[1056768] rtmax=[1056768], errno=-1 Mon Apr 08 20:00:51 2019 Direct NFS: Failed to set socket buffer size.wtmax=[1056768] rtmax=[1056768], errno=-1 Mon Apr 08 …

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi, If the Public Network interface change involves different subnet(netmask) or interface, delete the existing interface information from OCR and add it back with the correct information is required.  In the example here, the subnet is changed from 10.2.156.0  to 10.2.166.0 % $GRID_HOME/bin/oifcfg delif -global eth0/10.2.156.0 % $GRID_HOME/bin/oifcfg setif -global eth0/10.2.166.0:public Then make the change …

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi, I need to rename a pluggable database. It is so easy to rename.7 Let’s do it step by step: 1. Firstly set containter to PDB named DEV alter session set container=DEV; 2. shutdown and open it in restricted mode. shutdown immediate; startup open restrict; 3. Now rename the PDB alter pluggable database DEV rename …

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi, For some security reasons, you may want to change RAC scan listener port number. As grid user: Modify SCAN listener port $GRID_HOME/bin/srvctl modify scan_listener -p <new_scan_port> Please don’t forget to update database init.ora/spfile parameter file as: alter system set remote_listener='<scan_name>:<new_port_number>’ scope=both sid=’*’; Restart SCAN listener so the new port will be effect $GRID_HOME/bin/srvctl stop …

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi, Changing public IP or VIP only without changing interface, subnet or netmask or changing MAC address only without changing anything else If the change is only public IP or VIP address and the new ones are still in the same subnet, same interface, or if the change is only for public IP MAC address, …

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi, For some reasons you may want to change scan name or scan ip addresses. As grid user stop resources: $GRID_HOME/bin/srvctl stop scan_listener $GRID_HOME/bin/srvctl stop scan Update DNS entries for new scan name and ip addresses. As root user modify SCAN: $GRID_HOME/bin/srvctl modify scan -n <new_scan_name> For 11.2.0.1 only, if you intend to change SCAN …

Read Full Article
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Hi, After installation Oracle 18c RAC database, I got following error messages in alert log file. Database wass using public ip for the cluster_interconnects instead of HAIP.From. Alert log file content [USER(4431)]CRS-2317: Fatal error: cannot get local GPnP security keys (wallet). [USER(4431)]CRS-2316:Fatal error: cannot initialize GPnP, CLSGPNP_ERR (Generic GPnP error). kggpnpInit: failed to init gpnp …

Read Full Article

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview