New answers tagged oracle-11g
There is no reasonable way how to do that. For example till 11gR1 SELinux was not certified to be used with Oracle database. Since 11gR2 this is at least not recommended. Let's assume that you and Oracle DBA are adult, where is the problem then? Oracle is not running with root privs. On the other hand Oracle requires many kernel tunables(sysctl) to be set ...
When you use sqlplus a549189/myPassword@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=identityprovisionreport.fmr.com)(PORT=1524))(CONNECT_DATA=(SID=AARCER1)))" then you don't need any tnsnames.ora file. Your entry in tnsnames.ora file should be like this: AARCER1 = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= identityprovisionreport.fmr.com)(PORT=1524)) ...
You can't restrict by IP address. All you can really do is create a new user and only grant them SELECT on that one table. create user newuser identified by 'p4ssword'; grant connect, resource to newuser; grant select on yourtable to newuser; It is actually possible to check the IP address a user is logging in from using a login trigger, and deny the ...
This is a bug, fixed in the July 2014 CPU - See Oracle Support document 1666884.1. Easily reproduced with the following: create view v1 as ( select 'view' as vvv from dual ); create view v2 as ( select * from v1 ); with v1 as ( select 'cte' as vvv from dual) select * from v2;
Lets define the controlfile in oracle: it is a small binary file that records the physical structure of the database and its include: 1) The database name. 2) Names and locations of associated datafiles and redo log files. 3) The timestamp of the database creation 4) The current log sequence number 5) Checkpoint information
Top 50 recent answers are included