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
I am getting error ORA-03113 at the time of startup database.
Please utilize oraenv to make sure you have all environment variables set before startup.
. oraenv (don't forget the dot)
--> input the SID
sqlplus / as sysdba
startup force --performs a shutdown abo …
- 672
1
vote
Accepted
I can open a connection with SQL Developer but when i do the same with .NET returns me ORA-1...
Your database instance "BDTEST1" will, by default, register service "BDTEST1" in the Oracle Listener. Oracle Listener will expose that SERVICE_NAME. … Side note: Behind a service there can be multiple oracle database hosts and DR hosts. If you connect using SID, you will always connect to the named instance (SID). …
- 672
3
votes
Accepted
Listener.ora Location
Watch out for variable TNS_ADMIN which overrides Oracle default network directory. …
- 672
0
votes
Is it possible to connect to Oracle Database through OCI using a reverse proxy?
You can access your database remotely by establishing a ssh tunnel.
#ssh -N -L [local port]:[database host]:[remote port] [username]@[remote host]
ssh -N -L 9998:x.x.x.x:1521 -i ~/.ssh/id_rsa_aws.pem …
- 672
4
votes
best practice either create multiple databases or multiple users
Oracle has this new pluggable pill in their latest release 12.1.0.1 of the database which is supposed to address the "multiple database vs. multiple schema" discussion. …
- 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
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
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
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
votes
SQLPlus configuration problem or firewall issue
I deployed Oracle Connection Manager on RedHat 6. Everything configured through ansible. … Everything was working on my Vagrant Oracle Linux during development, but once deployed to RedHat I had these ORA- messages. …
- 672
2
votes
How to fetch file path from a folder through PL/SQL
Mr. Kyte wrote about accessing os-file-information utilizing the preprocessor directive a while ago. Perhaps this is what you are after.
query the operating system
- 672
3
votes
Oracle client throwing ORA-12541: TNS:no listener
Please login as oracle user and try these steps.
Set your oracle environment
$ . oraenv # note the dot!
$ <input your SID>
Login and fire up. …
- 672
5
votes
Where to start with Oracle?
I like this one:
Oracle Magazine SQL 101 …
1
vote
How to organize a development environment using Oracle XE 11g?
Any serious development project involves source control and a deploy process - SCM (Software Configuration Management). Make sure you put all your database objects (table, index, packages etc..) under …
- 672
2
votes
ORA-12541: TNS:no listener
My sequence of steps for troubleshooting
Is the listener resolvable? C:\>tnsping MYDB (Confirms: the database listener is running on serverside)
Is there a firewall issue? C:\>telnet hostname 1521 …
- 672