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 124831
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
How critical is it if SYSAUX is full?
Please refer the below link to know more about SYSTEM and SYSAUX tablespaces
Lack of space in SYSTEM and SYSAUX tablespace in oracle 11g R2
Thanks …
0
votes
SQL*Plus TNS:protocol adapter error
Please make sure that oracleserviceSID is running in your services.msc.
Then try restart your listener from services.msc itself or from command prompt(connect to sqlplus sys as sysdba).
(Hope you ha …
1
vote
Accepted
Can I sync an existing database using a .dmp file?
If you want to replace everything then the safest method is to drop all schemas and import it again using imp
drop user schema_name cascade
You can also try ignore=y parameter in conventional impo …
0
votes
Whether Oracle Data Guard re-transmits logs from their starting after network interruptions?
I've faced network interruptions in my running data guard setup and there were situations were log shipping from primary to standby was stopped.
In those situations I restarted the standby data guard …
-1
votes
1
answer
11k
views
sqlplus / as sysdba is not working in windows, ERROR: ORA-12560: TNS:protocol adapter error
I tried to login using sqlplus / as sysdba in Oracle 11g, but it is asking for a password. So I tried to login using sqlplus "/ as sysdba" since I'm using Windows. … But it is showing the following error:
sqlplus "/ as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Mon May 22 12:51:22 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved. …
1
vote
0
answers
4k
views
ORA-17627:invalid username/password;logon denied error message when trying to duplicate data...
I'm trying to duplicate the database for the purpose of Data broker in windows platform. When I'm trying to duplicate using below command
DUPLICATE TARGET DATABASE TO LOCALDEV FROM ACTIVE DATABASE;
…
5
votes
6
answers
33k
views
Lack of space in SYSTEM and SYSAUX tablespace in oracle 11g R2
SYSTEM and SYSAUX Tablespace size of my DB is in the following status now:
SYSTEM - PCT_USED= 99
SYSAUX - PCT_USED= 95
I believe the db is in critical situation now. What can I do to bring back i …
2
votes
1
answer
36k
views
Oracle 11g Rman restore with another database name from backup in windows platform
Can anyone share the proper method of RMAN restore to another server with another database name in oracle 11g(Windows platform). …
1
vote
0
answers
1k
views
When trying to configure data guard broker I'm getting Error: ORA-16606: unable to find prop...
I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to my configuration and when I'm t …
0
votes
1
answer
2k
views
Oracle 11g database archive log got increased suddenly in production server
What could be the reason for this unusual behaviour of Oracle database?
Is this an issue with our database or Oracle ADF application or related to our servers? …