Some commands to help with port conflicts:
#Solaris
lsof -i |grep :1854
cd $ORACLE_HOME/sysman
find . -name "*.xml" -exec grep "<rmi-server port=" {} \;
emctl config iasconsole port [portNumber]
emctl config iasconsole rmiport [portNumber]
emctl config agent port [portNumber]
emctl status agent
emctl status iasconsole
$ORACLE_HOME/opmn/bin/opmnctl status -l
2009-08-28
2009-08-27
Oracle password file
Just syntax reminder.
RDBMS 11.1
Windows file name: PWDsid.ora
RDBMS 10.2 for UNIX-Based Operating Systems
orapwd file=orapwsid password=password entries=max_users force=y/n
if FILE is not full path, it is created in current directory.
the password file should be in the $ORACLE_HOME/dbs directory
RDBMS 10.2 for Microsoft Windows
orapwd FILE=PWDsid.ora PASSWORD=password ENTRIES=max_users FORCE=y/n
if FILE is not full path, it is created in current directory.
Oracle Database looks in the registry for the value of parameter ORA_SID_PWFILE. If no value is specified,
then it looks in the registry for the value of parameter ORA_PWFILE, which points to a file containing usernames,
passwords, and privileges. If that is not set, then it uses the default.
so the order is
ORA_SID_PWFILE
ORA_PWFILE
ORACLE_BASE\ORACLE_HOME\DATABASE\PWDsid.ORA
RDBMS 11.1
orapwd FILE=filename [ENTRIES=numusers] [FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]
Unix file name: orapwsidWindows file name: PWDsid.ora
RDBMS 10.2 for UNIX-Based Operating Systems
orapwd file=orapwsid password=password entries=max_users force=y/n
if FILE is not full path, it is created in current directory.
the password file should be in the $ORACLE_HOME/dbs directory
RDBMS 10.2 for Microsoft Windows
orapwd FILE=PWDsid.ora PASSWORD=password ENTRIES=max_users FORCE=y/n
if FILE is not full path, it is created in current directory.
Oracle Database looks in the registry for the value of parameter ORA_SID_PWFILE. If no value is specified,
then it looks in the registry for the value of parameter ORA_PWFILE, which points to a file containing usernames,
passwords, and privileges. If that is not set, then it uses the default.
so the order is
ORA_SID_PWFILE
ORA_PWFILE
ORACLE_BASE\ORACLE_HOME\DATABASE\PWDsid.ORA
Subscribe to:
Posts (Atom)