If you get
ERROR: ORA-01031: insufficient privileges.
while trying to connect as sysdba in sqlplus:
SQL> connect / as sysdba
after installation of Oracle 11g on CentOS.
One reason might be that you should be connecting as oracle OS user which has the privileges.
That user didn't have a default password so I had to create one:
$ sudo passwd oracle
then
$ su - oracle
$ sqlplus '/ as sysdba'
and create a regular non sysdba user:
SQL> CREATE USER admin IDENTIFIED BY passwd;
Then you might want to open TCP port in the firewall on your CentOS box for remote connect:
Main Oracle Net service port:
$ sudo firewall-cmd --zone=public --add-port=1521/tcp --permanent
This is the default port for admin GUI:
$ sudo firewall-cmd --zone=public --add-port=8080/tcp --permanent
$ sudo firewall-cmd --reload
The GUI is enabled by running this function:
EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
The GUI URL will be:
http://<CentOS box IP address>:8080/apex/f?p=4950:1
have you have knowledge on about the oracle to jasper migration that can be easily now done read more... google about optisol oracle to jasper migration.
ReplyDeletecheck on this and have knowledge on this now ! https://data-stuff-etc.blogspot.com/2018/11/ora-01031-insufficient-privileges-in.html
ReplyDeleteyes its interesting much needed thanks!
Deleteclick on this guys.
have a look on this guys!
ReplyDelete