Pubudu: Data and Decisions

Oracle Database 23ai is a major milestone in Oracle’s database evolution, bringing AI centric features, richer search capabilities, and smarter performance optimizations directly into the core engine. One of the main areas where 23ai has improved is  indexing , enabling faster, more flexible, and AI aware data access for both traditional and modern workloads. Key indexing improvements Native AI Vector Indexing for Semantic Search A major advancement in 23ai is the integration of AI vector search and specialized vector indexes directly within the database engine. Traditional B-tree indexes used for exact lookups, but they aren’t designed for similarity search, a backbone of many AI applications such as recommendation engines, semantic search, and retrieval-augmented generation (RAG). Oracle offers: Hierarchical Navigable Small World (HNSW) indexes Efficient for approximate nearest neighbor search at scale. Inverted File Flat (IVF-Flat) indexes Optimized for large dimensiona...

Problem: Couldn't login as SYS user to Oracle 11g Database through SQL Developer. But I could log in through SQLPLUS with the same username & password. Tried several times through SQL developer(By selecting right options) but only SYS user seems to have this problem. Solution: 1.Login the remote server and login as sys/123 as sysdba.(Or whatever your password) 2.Reset the password ( alter user sys identified by 123;)(With your prefered password) 3.Relogin the oracle as sys. Now I could log in to the SQL developer through SYS user successfully.I know it's strange..but it worked!

Problem: In SQL Worksheet you cant edit or use back space. This may happen on newly installed Oracle SQL Developer. Solution: Go to    Tools | Preferences | Accelerators and press    Load Preset . Then it'll   l oad the default preset. Then try again to edit.

Error: Failed to open a session for the virtual machine VT-x features locked or unavailable in MSR. (VERR_VMX_MSR_LOCKED_OR_DISABLED) The details are: Result Code: E_FAIL (0×80004005) Component: Console Interface: IConsole {1968b7d3-e3bf-4ceb-99e0-cb7c913317bb} Solution: You have to change the processor Number to get rid of this error. So go to vitual-Box Machine–>setting–>system–>Processor–> change the CPU No. to 1. Then restart the VM and it'll work.

The Oracle SQL developer is NOT supported on 64 bits JDK. Your PC environment may be : Database : Oracle 11g / OS Platform : Windows 7 Ultimate 64 bits / JDK : 1.6 .0_24, 64 bits So it will give you an error when trying to open SQL Developer. When you click on the Oracle SQL developer, it prompts you to give the JDK folder location. However, after you specified the correct JDK folder, it prompts you following error dialog box : Unable to find Java Virtual Machine. To point to a location of a Java Virtual Machine.... Solution To solve it, install a 32 bits / x86 JDK and update your SQL developer config file, so that it points to the 32 bits JDK. Edit the “sqldeveloper.conf“, which can be found under {ORACLE_HOME}\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf , make sure “SetJavaHome” is pointing to your 32 bits JDK.

To list only usernames type the following awk command. awk -F':' '{ print $1}' /etc/passwd Eg: [root@jbsvr u01]#   awk -F':' '{ print $1}' /etc/passwd root bin daemon adm lp sync shutdown halt mail news uucp operator games gopher ftp nobody rpm dbus nscd vcsa pcap rpc mailnull smmsp sshd rpcuser nfsnobody haldaemon avahi apache ntp xfs gdm sabayon jboss jbtest apacheds avahi-autoipd oprofile exim oracle orafin amandabackup

Step1:  Mount the OS disk and copy the contents to a local path which will be the main repository path: mkdir -p /linuxdvd/   cp -RH /mnt/dvd/* /linuxdvd/ Step2:  Create new yum repository (e.g. rhel-local.repo) Create the repo file vi /etc/yum.repos.d/rhel-local.repo   Insert the below content to the file.Change the details according to your environment. [rhel6.3-local] name=RHEL 6.3 local repository baseurl=file:///linuxdvd/ gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release enabled=1