| Main Menu
Online
|
|
Posted by: admin on Wednesday, September 02, 2009 - 07:45 PM
PostNuke
|
To disable a user to connecting to Database login using connect "/ as sysdba" after login to OS :
1. In $ORACLE_HOME/network/admin/sqlnet.ora file modify the following line to
SQLNET.AUTHENTICATION_SERVICES=(NONE)
2. Restart listener, with this command :
lsnrctl stop
lsnrctl start
or
Remove dba group to the user who is logging in to the OS.
Note : orapwd file is used to authenticate users over the network only. Users who already logged in to the Database can not be restricted to connect '/ as sysdba' until they logout.
---
Dedi
|
|
|
Posted by: admin on Wednesday, September 02, 2009 - 07:33 PM
Linux
|
For ENABLE restricted access :
Edit the sqlnet.ora file in $ORACLE_HOME/network/admin/ :
change "tcp.validnode_checking = yes" and "tcp.invited_nodes=(myhost,172.16.3.251)"
only "myhost" and host with ip "172.16.3.251" can connect to database.
this the content of sqlnet.ora file :
...
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
tcp.validnode_checking = yes
tcp.invited_nodes=(myhost,172.16.3.251)
...
For DISABLE restricted access :
change "tcp.validnode_checking = no"
so, every client can connect to database.
this the content of sqlnet.ora file :
...
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
tcp.validnode_checking = no
tcp.invited_nodes=(myhost,172.16.3.251)
...
You must restart the oracle listener to activated that new setting above, with the following command :
lsnrctl stop
lsnrctl start
---
Dedi
|
|
|
|
Posted by: admin on Saturday, July 25, 2009 - 08:12 AM
Linux
|
Purpose
I'm working on building a python app that needs to connect to an existing Oracle Database. The server it will be deployed on is Ubuntu 9.04 Server - 32 bit. No gui is installed. When I started down the road of installing Oracle Instant Client and cx_Oracle, I ran into several problems. I was able to find bits and pieces on the web that helped me along, but I did not find an all in one document. I'm sure there are some out there, but my Google-fu failed me.
|
|
Read full article: 'Install Oracle Instant Client 11.1 and cx_Oracle 4.4 on Ubuntu 9.04' (6652 bytes more)
|
|
Posted by: admin on Monday, July 06, 2009 - 08:33 PM
Linux
|
Oracle Applications (11.5.10.2) Installation on Oracle Enterprise Linux 4.5
This article is intended as a brief guide to installing Oracle
Applications (11.5.10.2) on Oracle Enterprise Linux 4.5. The article is based
on a server installation with a minimum of 2G swap, secure Linux
disabled and the following package groups installed:
- X Window System
- GNOME Desktop Environment
- Editors
- Graphical Internet
- Server Configuration Tools
- Development Tools
- Administration Tools
- System Tools
|
|
Read full article: 'Oracle Applications (11.5.10.2) Installation on Oracle Enterprise Linux 4.5' (14595 bytes more)
|
|
Posted by: admin on Thursday, June 11, 2009 - 03:36 AM
Linux
|
ORA-02068: following severe error from DBLINK
ORA-03113: end-of-file on communication channel
ORA-02068: following severe error from DBLINK
ORA-00603: ORACLE server session terminated by fatal error
ORA-00604: error occurred at recursive SQL level 52
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00604: error occurred at recursive SQL level 52
ORA-00036: maximum number of recursive SQL levels (50) exceeded
|
|
Read full article: 'DBLink Oracle 9i to 10g r2 Error' (88 bytes more)
|
|
Posted by: admin on Saturday, May 30, 2009 - 06:44 AM
Linux
|
ESC key button = CTRL + [
|
|
|
|
Posted by: admin on Monday, March 02, 2009 - 08:56 AM
Linux
|
|
In order to configure serial ports for Linux, you will need to make use of the setserial command.
Firstly, you will need to know the card's base address and and which IRQ it is using.
For an ISA card, this can be read off the jumpers on the card.
|
|
Read full article: 'Configuring Serial Ports for Linux' (8300 bytes more)
|
|
Posted by: admin on Saturday, February 28, 2009 - 06:07 PM
Linux
|
metastat | grep done
If the output is blank, that's mean the process synchronization is done.
|
|
|
|
|
|
Login
|
