Tag Info

New answers tagged

0

Its clear to me now that the Host name in the listener configuration on the Oracle server is indeed the IP/Name of the Oracle server where the database exists and the port number is the port this database will listen to incoming connections. I was wrong in assuming that each incoming connection must be defined as a listener.


2

After a pretty good amount of digging, I found this blog post on doing this for date ranges, and it turns out to work equally well on numeric ranges, with a little modification for handling the 0 and 1 endpoints. Taking the query from there and renaming the columns to be a bit more clear, we have SELECT * FROM (SELECT MAX(T_END) OVER (ORDER BY T_START) ...


0

Continued from previous post. So now we know that DISTINCT and GROUP BY are handled indeed differently, lets go back to question 1. Knowing the above, going back to the original, slower query, this: select company_id from t1 join t2 using(product_id) join ( select company_id from (select distinct company_id from t1) ...


2

Output is from a 11.2.0.4.6 Enterprise Edition database on Oracle Linux 7.1 x86-64 platform. Lets start with question 2 and an easy example. DISTINCT and GROUP BY are handled differently: the optimizer is able to completely eliminate a DISTINCT under certain circumstances, but it can not do the same with GROUP BY. Here is an example: create table t4 as ...


0

Bind the listener to localhost only: LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)) (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))


1

The solution is really dependant on your environment. There are numerous options, from hardware firewalls, to software firewalls, to sqlnet.ora parameters. The first two are beyond the scope of this site. The quickest, probably, is sqlnet.ora. Have a look at the tcp.invited_nodes parameter: ...


1

Not supported. If you want to send e-mails (JavaMail?) from the database, you do not need Java in the database for that, just use the UTL_MAIL package, available in XE as well.


1

No way how to do that. XE version does not support Java Stored Procedures. You have to upgrade at least to "Standard Edition One" or "Oracle Personal Edition". See edition comparsion.


0

SQL> select utl_raw.cast_to_varchar2('41424344') from dual; UTL_RAW.CAST_TO_VARCHAR2('41424344') ------------------------------------ ABCD


0

Oracle will write all the datafiles and such to your DATA directory. You actually have to create a backup in the +flash_recovery_area you have created. What sort of backup are you trying to create? What command are you using to create your backup? For instance, if you wanted to execute a Level 0 IMAGE COPY, you could issue the following command: backup ...


2

Proper backup syntax should have been: backup database tag "first" plus archivelog tag "first"; Now if you look into your list backup output you can notice that only backupsets with archivelogs has tag FIRST. Backupset containing backup of datafiles has autogenerated tag TAG20150515T105436.


0

It is not due to any difference in Oracle's treatment of DISTINCT and GROUP BY. If we replace GROUP BY in the second query with a DISTINCT in SELECT we shall get similar performance/ plan cost as the first one I think, if we are using same clause in both the inner and outer queries with a natural join then Oracle parser is able to recognize that it will ...


1

I think select 1 from dual; is a syntax error. Here's what happens on the wire: With select 1 from dual a connection's lifecycle is: Initial establishment First query (validation does not yet happen) Return to the pool Validation: the pool sends select 1 from dual The database answers: ORA-01403: no data found Next query and so on. The connection is ...


2

You are facing a bug. You need to gather more information using RDA in order to perform an in-depth analysis. These are known bugs related to your ORA-600 message. 10043021 11.2.0.4, 12.1.0.1 ORA-600 [kcbnew_3] after select / analyze on RECYCLEBIN object 17586955 11.2.0.4.4, 11.2.0.4.BP11 ORA-600 [ktspfmdb:objdchk_kcbnew_3] in RAC 12747437 ...


0

The issue turned out to be with the VIP addresses not being allowed to be accessed via port 1521 due to our firewall policy. These IPs are now permitted and the problem has been resolved. thanks to Balazs for all the help.


0

The issue turned out to be with the VIP addresses not being allowed to be accessed via port 1521 due to our firewall policy. These IPs are now permitted and the problem has been resolved. thanks to Balazs for all the help/


-2

I solved it by logging off from ASM and changing directory away from /dev/oracleasm/disks. Afterwards it worked ok.


0

Go to www.sysinternals.com - download the Sysinternals suite - and then run Tcpview and check what executable is running on port 1521. You can sort by port by clicking on the "Local port" column. If you try and run netstat -abn from the command line, you'll (in all likelihood) get an error "The requested operation requires an elevation". Just why this error ...


1

https://support.oracle.com, with a valid support contract. In most cases, even there you will not find the meaning of the arguments. Of course, with access to the source code (e.g Oracle Support employees), one can find the meaning of these arguments, as demonstrated in the Oracle DSI401e course, with a case study.


3

Yes, it is possible. https://docs.oracle.com/database/121/NTDBI/intro.htm#NTDBI2648 Oracle Database supports multiple Oracle homes. You can install this release or previous releases of the software more than once on the same system, in different Oracle home directories. This allows flexibility in deployment and maintenance of the database ...


0

For a start you can use oraenv script to set PATH, LD_LIBRARY_PATH, ORACLE_BASE and ORACLE_HOME: export ORACLE_SID=ORCL ORAENV_ASK=NO . /usr/local/bin/oraenv ORACLE_SID can be parsed from /etc/oratab file. ORACLE_HOSTNAME maybe from HOSTNAME environment variable.


1

i've found the definitive answer from the oracle docs http://docs.oracle.com/cd/E11882_01/license.112/e47877/editions.htm#DBLIC109 in the Oracle Database Standard Edition and Oracle Real Application Clusters (Oracle RAC) section, it specifies "Oracle Automatic Storage Management is required for creating and managing all Oracle database file types. Raw ...


0

No it is not, but it is much easier. For example you can store Oracle datafiles on Veritas VxCFS. There are other certified cluster filesystems, but none of them is for free. Also there was an option to not to use any filesystem. You could have "datafiles" on raw devices. But AFAIK this option is no more available. PS: ASM does not offer better ...


0

Like others indicated, LOAD DATA is not an Oracle Database command. It's specific to MySQL (or derivatives like MariaDB or Percona Server). See https://dev.mysql.com/doc/refman/5.5/en/load-data.html. Maybe the confusion since Oracle corp. owns MySQL? But to solve your actual issue of loading flat file data into Oracle Database 11gR2, look either into ...


0

Here's what worked, although I don't know if it's a good answer or not. I had someone who could log in as an admin on my pc do the Oracle client install. In other words, if you're not a full admin on your machine, it may fail, and not tell you why. I had admin rights, I could edit the registry and path, but there were still some missing rights. Logging ...



Top 50 recent answers are included