Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with oracle
Search options not deleted
user 7102
All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.
0
votes
Oracle database transfer: database isolation
An Oracle Pluggable Database (PDB) is a self-contained database (with schemas, users, roles, datafiles, etc.) you can plug out of a service/container-db (CDB) and plug back in onto another service/container-db …
- 672
0
votes
oracledatase administrator
Remember the dot '.'
# you can also do this interactivly
[oracle@host01 ~]$ . oraenv <<< ORCLDB
ORACLE_SID = [oracle] ? The Oracle base has been set to /u01/app/oracle
# is my environment set? … [oracle@host01 ~]$ env | grep ORA
ORACLE_SID=ORCLDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_2
# yes it is
[oracle@host01 ~]$ type sqlplus
sqlplus is /u01/app/oracle …
- 672
1
vote
Accepted
what is the reason tablespace not showing in dba_tablepsaces after being created succefully
/system01.dbf
/opt/oracle/oradata/FREE/sysaux01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/sysaux01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/users01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/system01.dbf
/opt/oracle … ----------------------------------------------
/opt/oracle/oradata/FREE/FREEPDB1/sysaux01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/users01.dbf
/opt/oracle/oradata/FREE/FREEPDB1/system01.dbf
/opt/oracle/oradata …
- 672
0
votes
How to register static listener in listener_scan as well?
This should do
SQL>alter system set remote_listener = 'xxx-scan:1521' sid='*';
Best of luck!
- 672
0
votes
0
answers
119
views
dbaascli - non-interactive
dbname C1B02 \
--dbUniqueName C1B02S \
--dbSID C1B02 \
--createAsCDB yes \
--pdbName PDB1 \
--dbCharset AL32UTF8 \
--dbNCharset AL16UTF16 \
--sgaSizeInMB 4096 \
--pgaSizeInMB 1024 \
--oracleHome /u02/app/oracle …
- 672
1
vote
Accepted
Unable to connect to Oracle user in pluggable database
-- without specifying service_name, you will connect to the CDB (root con)
SQL>connect u/p<NOTHING_HERE>
-- the service_name 'PDB1' will be made available when pdb is created
SQL>!lsnrctl status
SQL …
- 672
0
votes
Accepted
Cannot connect to a pluggable database via IDE
In order to connect to a pluggable database, you need to specify the SERVICE_NAME for it (forslash notation '/XEPDB1'), so you will have to specify database type "Oracle Database" and not "Oracle SID" …
- 672
1
vote
Oracle XE 18c, on every connect attempt, Oracle listener OracleOraDB18Home1TNSListener stops...
I suggest you uninstall the 18c XE and rather go with Oracle VirtualBox and fire up one of Oracle's linux boxes where Oracle Database is present. … Another option is to run your Autonomous Oracle Database in Oracle Cloud. It is free forever. This is my preferred option these days.
Best of luck! …
- 672
1
vote
I do not remember my oracle system password
Make sure you have set ORACLE_SID to the database instance name, in my example it is XE.
Your Windows user needs to be a member of local group "ORA_DBA".
So, now you do not connect to the database by …
- 672
0
votes
Unable to connect to an Oracle 12c Docker container
gvenzl/oracle-xe 18.4.0 e1d4dae1771b 4 days ago 3.69GB
gvenzl/oracle-xe latest e1d4dae1771b 4 days ago 3.69GB
gvenzl/oracle-xe 18-full 13085168429b 12 days ago … 6.36GB
gvenzl/oracle-xe 18.4.0-full 13085168429b 12 days ago 6.36GB
gvenzl/oracle-xe full 13085168429b 12 days ago 6.36GB
docker-compose.yml for persistent database.
version: '3.8 …
- 672
0
votes
Launching LSNRCTL produces an error
set ORACLE_HOME=C:\app\Owner\product\18.0.0\dbhomeXE
set PATH=%PATH%;%ORACLE_HOME%\bin
lsnrctl status
- 672
0
votes
Show All online SID Database Oracle 11 in Linux SuSe and Find Database file
cat /etc/oratab
As a DBA, you need to learn the Oracle Data Dictionary. … One Oracle Database System (SID) can serve multiple databases (schemas). …
- 672
2
votes
Get tablespace name from dump file
https://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_import.htm
impdp hr/hr DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp
SQLFILE=dpump_dir2:expfull.sql
- 672
2
votes
Is it free to download an Oracle Enterprise Edition image from Docker?
Make sure you accept the Oracle Standard Terms and Restrictions (green checkmark)
Now you are ready for the bash-console! … You will have to download the Oracle Database software and put them into designated folders before executing the build script.
Oracle Database 18c XE is full of EE feature. …
- 672
0
votes
Oracle - Delete dmp files from ASM diskgroup
Just did a small test.
# find some ASM files
asmcmd find DATA/T101N/AUTOBACKUP/2020_09_20/ \*
+DATA/T101N/AUTOBACKUP/2020_09_20/s_1051641713.313.1051641713
+DATA/T101N/AUTOBACKUP/2020_09_20/s_10516587 …
- 672