Monday, August 25, 2008

Oracle Installation troubleshooting

# Oracle installation
1. Unzip the file: gunzip
2. Extract the file: cpio -idcmv <
3. Installation guides and general Oracle Database 10g documentation can be found here.
4. Review the certification matrix for this product here.


# Oracle Environment
export $ORACLE_HOME=/fs2/oracle/product/10.2.0/db_1/
export PATH=/fs2/oracle/product/10.2.0/db_1/bin
tnsping mmxtest
sqlplus tstusr/tstusr@mmxtst


#tnsnames.ora
edit $ORACLE_HOME/network/admin/tnsnames.ora
with
------------------
EPNYDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 11.16.155.112)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = epnydev)
)
)
---------------------------


# Create a database thru a wizard
$ORACLE_HOME/bin/dbca


# Which instance are you connecting
env | grep SID

# Oracle process to determine if Oracle DB is started
ps -def | grep smon_

# Oracle env file
. oraenv

# Connecting to Oracle DB
sqlplus
sys as sydba
SQL> / as sysdba
SQL> show users;
SQL> connect sys as sysdba;
SQL> select name from v$database;
SQL> select username, password from dba_users order by 1;
SQL> select * from dba_data_files;


#ORACLESID already exits during installation
comment the sid in this file /var/opt/oracle/oratab

# Oracle Shutdown
shutdown or shutdown normal
shutdown immediate
shutdown abort
shutdown transactional

# Oracle Start
startup
startup restrict

# Run a script
SQL> @script_name

No comments: