Recent content by maryam421

Hi, I am an oracle dba and found a job in apps dba. Any one how can tell me the difference b/w the oracle dba or aps dba. Thanks

Thanks

Hi, I have installed oracle 10g on solaris. I can login to unix box as oracle and can connect to the oracle using sqlplus "/ as sysdba". But any other user(other than oracle) connects to server directly and try to do sqlplus on unix prompt gets the following error: Message file sp1<lang>.msb...

Hi, I am trying to configure owb on oracle 10g on liunx. I am unbale to start startOwbbInst.sh script. It just hangs. Do I need appache to open the webpages?

Thanks for your quick response. I have three databases running on this server. Should I shut down all of them or just the one that I am upgrading? Also do I need to the backup for all of them or only the one that I am upgrading? As per your instruction it seems to me that the oracle software...

I am trying to upgrade oracle 9.2.0.7 to 9.2.0.8 on sun solaris. I am not sure what to use. Either use a patch or dbua. Please help. Thanks

LISTNER FILE # listener.ora Network Configuration File: /home/oracle/oracle/product/10.2.0/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME =...

Hi, I am trying to install oracle 10.2 on redhat linux. I am getting the following error: ORA-12162 TNS:net service name incorrectly specified I used dbaca to install the database with character set US7AS11(none of the other worked). Although the database is up i was not able to connect to...

Mufasa, Startegy is good but there are many users to this application. I should say in 100. this is oracle app and in production. So not sure how long it will take for no activity in tmp table space. Worth giving a shot. Any more ideas!! Thanks

Hi, I am using oracle 10g on solaris unix. I am planning to move the temp table space datafile to a different location. What is the best way to do it. The database is online and user are working on it. I read few articles and I understand what it says like create the new temp tablespace drop the...

I already have mysql 3.0 installed. I am trying to replicate the environment and then will try to upgrade it to 4.0. I am using redhat linux es 4.0. Do you know where I can get mysql 3.0. Thanks

Well I am trying to upgrade 3.2 to 4.0. I think I got the right binary. Do you know any place where I can download correct version of 3.2. Thanks for all your help.

Hi, I am trying to install mysql 3.23 on redhat linux. When I ran mysql_install_db,it did create some tables but when it tried to give privilages it got the following error: ./scripts/mysql_install_db: ./bin/mysqld: /shlib/ld-bsdi.so: bad ELF interpreter : No such file or directory After that...

We are using redhat linux enterprise edition. Application requires 4.x not 5.x. Might be compatability issue. This is what I am planing to do: 1. Install 4.x on a separate directory structure. 2. Start 4.x. 3. Let the two instance running at the same time. As I have to schedule the down time...

Linux