Skip to main content
26 votes
Accepted

What is the default username and password to the oracle pre-built virtual machine?

The default password for the HR, sys and system accounts is oracle. The Unix password for the oracle user is also oracle.
Philᵀᴹ's user avatar
  • 31.8k
14 votes

Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS

I encountered this exact error and found it was my mistake. Spent whole day for that. Please, carefully observe your /etc/hostname and /etc/hosts. In my case, "oem" was put in /etc/hosts and "eom" ...
munkhbayar batkhuu's user avatar
12 votes
Accepted

How to connect to oracle 12c from sqlplus without password in command line

This answer based on a1ex07 comment: given the folowing detailes: user name: demo password: Pass1234 ip: 1.2.3.4 listener port: 1521 oracle SID: orcl pdb service name: pdborcl connect to core db ...
SHR's user avatar
  • 874
12 votes
Accepted

How to backup an Oracle database from SQL Developer

No. And then yes. Well, it depends. What are your requirements? Backup / Restore Capabilities Do you want a backup of the database ... ... for a restore ... to perform recovery ... to roll ...
John K. N.'s user avatar
11 votes
Accepted

Oracle shrinking / reclaiming free tablespace space

I agree with EdStevens' comment, but here are some other ideas: The AskTom website has a script that will list exactly how much you can shrink the existing data files. If that doesn't yield much ...
Mark Stewart's user avatar
  • 1,133
10 votes
Accepted

Query with ROWNUM returns differents rows on every execution

ROWNUM is evaluated before ORDER BY, that is not how ROWNUM should be used. To use ROWNUM properly, use a query like this: SELECT * FROM ( SELECT DISTINCT t1.ZRESUBDIV, t1.SUBDIV_NAME ...
Balazs Papp's user avatar
  • 40.8k
9 votes

Unable to check whether the location specified is on CFS

There are many suggestions how to solve this problems floating around (and many are undoubetly in their way correct) In my case, neither did the change of "Security-Settings" work nor was ...
Andreas J's user avatar
  • 223
9 votes

Is it possible to create an alias/shortcut/makro/function for a collection of keywords?

You can tell the tool, in this case SQL Developer, to do it for you. I talk about how to set this up here https://www.thatjeffsmith.com/archive/2014/02/auto-replace-in-oracle-sql-developer/ But ...
thatjeffsmith's user avatar
8 votes
Accepted

ARCHIVELOG in Oracle 12c multitenant PDB

Because all PDBs share the same redo log files, it's not possible to enable archive log mode only for a specific PDB. All PDBs share the archive log mode of the CDB. Remember, the PDBs themselves ...
atokpas's user avatar
  • 8,642
8 votes

Oracle 12c - Can not login to Enterprise Manager - XDB Login prompt

You should enable global port for EM Express to Manage a CDB and the PDBs, execute: exec dbms_xdb_config.SetGlobalPortEnabled(TRUE)
elkoo's user avatar
  • 181
7 votes

Query with ROWNUM returns differents rows on every execution

ROWNUM is the wrong way of doing this kind of query. As @Kris Johnston explains in a comment with the "cart and the horse" simile: The WHERE clause is executed before the ORDER BY, and you can't ...
ypercubeᵀᴹ's user avatar
7 votes
Accepted

For accessing Oracle 12c RAC database by JDBC to ensure high availability, should I use TAF or FCF?

In this case, should I use TAF or FCF? TAF- Transparent Application Failover is a database session-level connection failover mechanism and works only for OCI clients. FCF- Fast Connection Failover ...
atokpas's user avatar
  • 8,642
7 votes
Accepted

Problem granting user privileges via roles in Oracle 12c

You did not mention it, but this is quite typical when using PL/SQL. Privileges granted through roles are disabled for named PL/SQL blocks that are defined to execute with definer's rights. How ...
Balazs Papp's user avatar
  • 40.8k
7 votes

Resolving port 5500 not free issue during Oracle 12c Release 2 Database Configuration Assistant installation on CentOS

You might want to try adding your host to /etc/hosts. I encountered the same error and the problem went away after I've done so. See Install Oracle Database 12c On CentOS7 by M.el Khamlichi. ...
Steven's user avatar
  • 71
7 votes
Accepted

Rotate table for year-over-year comparison

Yes, more concise ways of pivoting exist for your scenario. Option 1 For instance, you could use the PIVOT operator: SELECT * FROM ( SELECT road_id, insp_year, condition ...
Andriy M's user avatar
  • 23.1k
6 votes

What is the default username and password to the oracle pre-built virtual machine?

Okay, this is probably a better answer, since the objective is to be able to work with the 'system' database. Use: sqlplus system as sysdba and the password is -> oracle I got in using ...
John B's user avatar
  • 61
6 votes

Will a SELECT . . . INTO use short-circuit evaluation for a COALESCE?

Yes, per documentation: Database SQL Language Reference (Oracle 11g): COALESCE() Oracle Database uses short-circuit evaluation. The database evaluates each expr value and determines whether it is ...
KevinKirkpatrick's user avatar
6 votes
Accepted

"ORA-01033: Oracle initialization or shutdown in progress" error after PC restart

The tutorial you linked uses the multitenant architecture with pluggable databases. I quickly read through the tutorial, and it does not cover this topic, but pluggable databases do not open ...
Balazs Papp's user avatar
  • 40.8k
6 votes
Accepted

Oracle restrict user to use USERS tablespace

The user TEST may have the UNLIMITED TABLESPACE privilege, or a quota defined on the USERS tablespace. To revoke them: revoke unlimited tablespace from test; alter user test quota 0 on users; If the ...
Balazs Papp's user avatar
  • 40.8k
6 votes
Accepted

RMAN - no datafile found during recovery

Asking the database to do the impossible. You changed the TAG, so you created a new initial set of image copies. As diskspace was becoming increasingly tight, I changed the backup script to use ...
Balazs Papp's user avatar
  • 40.8k
6 votes
Accepted

Trigger to get next prefixed ID: Is there a better way?

I expect your trigger to throw runtime "Mutating table" error . Unless autonomous transaction is used because you cannot query the table that fires the row-level trigger inside its body. I'd rather ...
a1ex07's user avatar
  • 9,010
6 votes

How to replace and overwrite all existing objects in Oracle with impdp for full database import?

I don't think there is a "Replace" option for non-table objects like procedures, packages etc. The best option would be to drop the schema entirely before the datapump import. This way, datapump ...
andba77's user avatar
  • 559
6 votes

How to replace and overwrite all existing objects in Oracle with impdp for full database import?

There is one trap - if you drop schema - you lost all grants to other schema objects that schema had - and some of vievs/procedures/functions which depends on objects in other schemas - will not ...
Piotr Pisera's user avatar
6 votes
Accepted

Current state of INTEGER vs NUMBER in Oracle

The BLOG The logic behind that post is so ludicrous that it deserves a sarcastic answer. Oracle does the "is it an integer?" check while it is waiting for the I/O call to the disk to return the ...
Michael Kutz's user avatar
  • 4,829
5 votes
Accepted

Change date precision values

I have an oracle database table with date format as 'mm/dd/yyyy' No you don't.. ;) You have an Oracle database table with a date datatype. Period. Any type of "format" is for display only, and is ...
Ditto's user avatar
  • 506
5 votes
Accepted

ORA-01017: invalid username/password;logon denied

I have seen this only once so far, but there is an issue described in the My Oracle Suppport note: FIPS use causes ORA-01017: Invalid Username/password with Managed ODP.NET (Doc ID 1937500.1) I will ...
Balazs Papp's user avatar
  • 40.8k
5 votes

What is the default username and password to the oracle pre-built virtual machine?

You should be able to login to the database as follows: sqlplus sys/oracle@localhost/orcl12c as sysdba
HadidAli's user avatar
  • 177
5 votes
Accepted

How to clean Archive logs

Start the instance in MOUNT mode, delete the logs, then open the database. $ rman target / RMAN> startup mount RMAN> delete force noprompt archivelog all; RMAN> alter database open;
Balazs Papp's user avatar
  • 40.8k

Only top scored, non community-wiki answers of a minimum length are eligible