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
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
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 Search options user 55924

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.

1
vote
You need to refer Oracle installation guide but you should need to consider your server technical details too. If your server is having 64 GB physical memory then you can keep 1/3 SHMMAX size of this …
answered Jan 2 '15 by doc123
0
votes
You can see Syslog using root user. In Oracle cloud machine you cannot login as root directly. But you can login as OPC user and after that switch yourself as root using the sudo command. SYSLOG is … located in /var/log/messages. If you installed Oracle management cloud then you can get GUI called "Oracle Log Analytics interface". You can check from this interface. …
answered Mar 5 '18 by doc123
-1
votes
When you are spooling from SQL*Plus for making script that time always execute following commands before executing spool set heading off set feedback off set pagesize 0 spool file_name Because th …
answered Feb 2 '18 by doc123
2
votes
What is the entry in SQLNET.ora file of following parameter? names.default_domain = world If it doesn't contain your myNewDomain domain name then kindly modify it. I hope it will resolve your domain …
answered Jan 29 '18 by doc123
0
votes
for interacting with your Oracle database. Use your SYS user with login credential for entering in sqlplus. After login into sqlplus, create your user using commands. …
answered Mar 3 '18 by doc123
0
votes
Change parameter REMOTE_LOGIN_PASSWORDFILE=exclusive using pfile or spfile. create again spfile which contains above entry shutdown oracle using windows services execute orapwd file=%ORACLE_HOME …
answered Jan 18 '18 by doc123
1
vote
Did you check firewall enabled or not on your Linux machine? If it is enabled then you should need to add your port 1521 for accepting requests just like the following command. sudo iptables -I INPUT …
answered Feb 1 '18 by doc123