New answers tagged

0

For more than one user to access the same ACL, grant the access privilege to each of the users, with the command "DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEG". Example1 Grant the connect and resolve privileges for host www.us.oracle.com to SCOTT. BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'www.xml', ...


0

Do you have separate Oracle Homes for your Database and Grid Infrastructure (which was new to 11gR2, IIRC)? If so, then the Agent probably runs from the Grid Infrastructure's Oracle Home. Annoyingly, the bin directory in both Oracle Homes contains a program called emctl but only one of them will work as you expect! If in doubt use the Linux find command to ...


0

The error might be a bit misleading. It is correct to restore the control file from the latest backups assuming you want to recover to as late in time as possible. If your control_file_record_keep_time is long enough to also contain the backup pieces of the level 0 backup, rman will start restoring the level 0 backup and continue with the level 1 backup. If ...


0

In your tnsnames.ora on the standby side the needed tns alias for 'rac' is missing. In a data guard configuration it is extremely important that all members can resolve all other members.


0

You can not correct a bad implemented application from the database side in such a way that it will always work as expected. With cursor sharing the database tries to prevent parsing. This works when the application uses bind variables when working on item/person level and literals when working on group/class level. You could try cursor_sharing force. This ...


0

Most of the times some object privileges are missing from the owner[s] of the imported objects. the error PLS-00302: component 'XXX' must be declared can be explained by missing synonyms and/or missing privileges on that object. Verify in the source database that the owner - or sometimes public - had privileges on the object 'XXX' and make sure this is ...


0

Normally we allocate about half of the systems memory for shared_pool and database buffers, preferably mapped on huge pages. AMM is not compatible with huge pages so when a dba is working with the system he would disable that and manage the memory manually. Define a minimum size for the database buffers and also for the shared pool. The rest of the memory is ...


0

Yes, this is an issue with owner and group of lot's of files in oracle home. Most files are of oracle:oinstall but not all. Some are owned by root and some owned by nobody. A safer solution for this would be find -user {old_uid} |xargs chown {new_uid} find -group {old_gid}|xargs chgrp {new_gid} and yes, this should run as root.


0

If a job has to run in an interval, the job needs to be in the state 'SCHEDULED' in between. In case of a job chain, make sure that it actually has an ending, otherwise it will remain running forever. DBA_RUNNING_JOBS only shows the jobs that are in state 'RUNNING' make sure the chain has an END action.


0

I think I have found a good solution for this. Could you tell me if there are better ways other than this one? select a.customer_num, count(distinct b.datekey) num_of_days from (select t.customer_num, t.card_number, t.card_issue_date, t.card_expire_date from test_table t where t....


2

This should get you started: declare s date := date'2020-01-01'; e date := date'2020-01-04'; ndays number; begin ndays := e-s+1; for i in 1..ndays loop dbms_output.put_line (s); s := s+1; end loop; end; / 01-JAN-2020 02-JAN-2020 03-JAN-2020 04-JAN-2020 PL/SQL procedure successfully completed. Just use simple date arithmetic: the ...


0

This depends on many factors. The OEM advisor is not the smartest. Your minimum requirements will be somewhere between the minimum size that allows your database to start and what you have now. Smart would be to check the size of the shared_pool components after the instance has been running a few days. Less memory will cause problems because allocations ...


-2

Using just SQL and using Tom's as_many_rows trick(adjust as required): with as_many_rows_as_you_need as ( select level l from dual connect by level <= 100 ) select customer_num cust, card_number card, (a.card_issue_date + l) dat from as_many_rows_as_you_need , test_table a where a.card_issue_date + l <= a.card_expire_date and a....


0

yes, oracle can do that provided there is a full backup available to start the restore with. When that is restored you can recover the incremental backups against the restored database. When the incrementals were done online (mostly the case, you also need the archived log files)


0

why do you "need" to use this parameter? I suspect yet another x-y question - that you are asking the wrong question to solve the wrong problem. Alternatively, why can't you just add the necessary entry to the listener configuration? LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(...


Top 50 recent answers are included