While Installing Repository Creation Utility (RCU) Installation the following error occurs: RCU:6107 DB Init Param Error This can be removed simply by the following: 1. Login on your database with system user. 2. Write > show parameters processes (which will show the current value of processes). 3. If its value is less than 500 then write […]
Make sure all the necessary environment variables are set, especially the following variables. ORACLE_SID ORACLE_HOME And follow the below steps to start, database, listener and enterprise manager(em) console For db startup: oracle@root.com$ sqlplus / as sysdba SQL*Plus: Release 11.1.0.6.0 – Production on Sun Nov 9 22:52:26 2008 Copyright (c) 1982, […]
CREATE USER CREATE USER ‘jeffrey’@’localhost’ IDENTIFIED BY ‘mypass’; Create user without password. CREATE USER ‘jeffrey’@’localhost’; DROP User DROP USER ‘jeffrey’@’localhost’; GRANT Steps: CREATE USER ‘jeffrey’@’localhost’ IDENTIFIED BY ‘mypass’; GRANT ALL ON db1.* TO ‘jeffrey’@’localhost’; GRANT SELECT ON db2.invoice TO ‘jeffrey’@’localhost’; GRANT USAGE ON *.* TO ‘jeffrey’@’localhost’ WITH MAX_QUERIES_PER_HOUR 90; RENAME USER RENAME USER ‘jeffrey’@’localhost’ TO […]