Monthly Archives: July 2017

ohasd failed to start

Situation : 1) Two 11.2.0.4 RAC nodes( racnode1/2). Deleted node racnode2 . Upgraded OS from RHEL 4  to RHEL 7 for racnode2, then tried to add node racnode2 back into cluster from racnode1. 2) export IGNORE_PREADDNODE_CHECKS=Y, Ran addnode.sh ->  orainstRoot.sh->root.sh, … Continue reading

Posted in GI and RAC, Upgrading and Patching | Tagged , , , , , , , , , , | Leave a comment

Copy Oracle Home Binary from One RAC Node to Another RAC Node

For some reason on RAC node 2 ( racnode2) , RAC oracle home binary needs to be copied from another node racnode1. 1)As RAC Oracle home owner, go to ORACLE_HOME/oui/bin  on racnode1: oracle@racnode1:/u01/app/oracle/product/11.2.0/dbhome_1/oui/bin$ ./addNode.sh “CLUSTER_NEW_NODES={racnode2}” Performing pre-checks for node addition … Continue reading

Posted in GI and RAC, Install and Upgrade | Tagged , , , , | Leave a comment

Move OCR, Voting Disk File, ASM SPILE to a New Diskgroup ( 11.2.0.4 )

Below exercise is to move everything from old OCR/VOTING diskgroup OCR_VOTE  to new diskgroup OCR_VOTE2. 1)Create New CRS Diskgroup: SQL> create diskgroup OCR_VOTE2 external redundancy disk ‘ORCL:OCR_VOTE2’; Diskgroup created. SQL> alter diskgroup OCR_VOTE2 set attribute ‘compatible.asm’=’11.2.0.0’; Diskgroup altered. 2) Mount … Continue reading

Posted in ASM, GI and RAC | Tagged , , , , , , , , , , , | Leave a comment

Dropping an Empty Partition Without “Update Indexes” Necessary

As we know  the ‘update indexes’ clause is used  to drop the local indexes and update the global index  when we drop a partition. So the indexes will still be VALID” The below example shows when we drop an empty … Continue reading

Posted in Partitioning | Tagged , , , | Leave a comment

The Master Node of RAC Cluster

1) Check from ocssd.log: $ cat $GRID_HOME/log/racnode1/cssd/ocssd.l* |grep ‘master node’ |tail -1 2017-07-18 10:09:21.431: [ CSSD][1102125408]clssgmCMReconfig: reconfiguration successful, incarnation 217002855 with 2 nodes, local node number 2, master node number 2 2) Check from crsd.log $ cat $GRID_HOME/log/racnode1/crsd/crsd.l* |grep ‘OCR … Continue reading

Posted in 12c new features, GI and RAC | Tagged , | Leave a comment

WARNING: Console code page (850) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page “Notes for Windows users” for details.

When trying to connect to my first PostgreSQL database, got the below warning : C:>psql -h 192.168.78.51 -U postgres -d postgres Password for user postgres: psql (9.6.3) WARNING: Console code page (850) differs from Windows code page (1252) 8-bit characters … Continue reading

Posted in Client | Tagged , | Leave a comment

Unable to connect to server: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host “192.168.78.51” and accepting TCP/IP connections on port 5432?

When trying to connect to a new PostgreSQL database, the below error occurred: C:\Program Files (x86)\pgAdmin 4\v1\runtime>psql -h 192.168.78.51 -d postgres psql: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host “192.168.78.51” and accepting TCP/IP … Continue reading

Posted in Client | Tagged , , , , | Leave a comment

Enable Telnet on Windows 10

Control Panel -> Programs -> Programs and Features ->Turn Windows Features on or off  

Posted in Windows | Tagged , | Leave a comment

Install PostgreSQL 9.6 on RHEL 7

1)  Go to https://www.postgresql.org/download, and choose your platform accordingly. 2)  Action on the below steps as per instructions : Install the repository RPM: yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm Install the client packages: yum install postgresql96 Optionally install the server packages: yum install postgresql96-server … Continue reading

Posted in Install and Upgrade, PostgreSQL | Tagged , , , , , , , , , , | Leave a comment

ORA-65066: The specified changes must apply to all containers in 12C

  $ sqlplus sys@pdb1 as sysdba SQL> alter user system identified by “Password!23”; alter user system identified by “Password!23” * ERROR at line 1: ORA-65066: The specified changes must apply to all containers SQL> show con_name CON_NAME —————- PDB1   … Continue reading

Posted in 12c new features, ORA- ERRORS | Tagged , | Leave a comment