Thursday, July 26, 2018
Wednesday, July 25, 2018
ORA-01031 INSUFFICIENT PRIVILEGES
When trying to connect to the database as sys from command prompt getting the below error
The issue is due to the password file got corrupted
Creating a new password file will resolve the issue
Back up the password file under ORACLE_HOME/database (PWDorcl.ora)
Create new password file with the command below:
Note: set the ORACLE_HOME, ORACLE_SID and PATH variables
before running the below command
Try to connect again
Steps for Connecting Oracle cloud database from sqldeveloper
Note: Get the private key from oracle cloud database instance (privateKey)
Open sqldeveloper
Under View select SSH
Right click on SSH hosts and click on New SSH Host
Provide name, host and browse the private key file and click on ok
Test the newly created ssh host connection
Right click on the newly created ssh host connection and
click on new local port forward
Give name, host and port and click on ok
Right click and click on connect to connect the ssh host
Now connect the oracle cloud database as below
Test the connection
Click on connect to connect the database
Installing Oracle Analytics Cloud Developer Client Tool
Downloading the software:
Download the software from below link:
http://www.oracle.com/technetwork/middleware/oac/downloads/oac-tools-4392272.html
Download the software from below link:
http://www.oracle.com/technetwork/middleware/oac/downloads/oac-tools-4392272.html
Right click on the setup file and run as administrator
Click Next
Provide home directory path to install and
Click next
Click install
Wait
until the process got completed
Click next
Click finish
Subscribe to:
Posts (Atom)
Opatch reports 'Cyclic Dependency Detected' error when patching ODI Issue: When applying a Patch Set Update (PSU) to WebLogic Se...
-
Getting the below error when installing oracle database 12c on linux machine Soft Limit: maximum stack size - This is a prerequisite con...
-
After configuring SSL with Custom Identity and Trust Keystores and when we try to start the servers getting the below error ...
-
1. Creating a directory in hdfs $ hdfs dfs -mkdir <paths> 2. List the directories in hdfs $ hdfs dfs -l...