ERPstuff - Oracle EBS Community

Hi

You are supposed to run vncserver as root. So just put it in /etc/init.d or can use any rc. directory. That's it. If you need to use it on specific time then use crontab.

Thanks
Amir

Hi

Try turn off firewall settings that you might have enabled at the time of installation. Make sure you have appropriately configured your Network card driver and it's enabled.

Hi So the basic guidelines for installation of AS Enterprise on 2 servers configuration for medium size deployment. 1- Install Oracle DB 10GR2 on DB Server. (Linux server is recommended) that wud be used as Metadata Repository (MR) name it MRDB. 2. Install Infra, name it INFRATIER and point it to yo...

Hi

Perhaps link below might help you to setup ODBC for unix/linux.

http://www.unixodbc.org/

Hi

How come you are selecting A.CLIENT_NO twice! in your query?


"SELECT A.CLIENT_NO,A.CLIENT_NO FROM SALES_CLIENT_MASTER A');

Hi

Because Oracle saves all its information in the form of tables. In other words info about tables are stored in tables as well. Part of that info is also called Data Dictionary.

If you wanna know about any specific package do let us know.

Thanks

Hi

Actually there are 2 different scanarios.

1- I have VIS installed and I wanna add PROD to it.

2- I have VIS & PROD installed, I need some space so I wanna remove only VIS from my machine.

Hope that might have cleared my question.

Thanks

W.A Dear Irfan We Import / Export with a pipe, you can change given below scripts accordingly. 1. Make a pipe using the mnod command 2. Start the export using an export parameter file. Export to the pipe rather than a normal dump file. 3. At the same time start the import using an import parameter f...

Hi there

After Installation either one. Do we need to run complete installer again to remove/add VIS or PROD?

Is there any easy workaround?

Thanks
Amir

Hi

Before running installer, you need to install VC98 and MKSTOOL with GNUMake.

Thanks

Hi

I've installed it on XP Professional and it's working fine.

Thanks
Amir

[:)]Thanks admin for correction. I didn't realize that in typin flow. anyway here is a new easygo. As of 10g instead of putting each tablespace in BACKUP mode we can put eintire database in BACKUP mode. SQL> ALTER DATABASE BEGIN BACKUP; As soon as you finish taking all backups. SQL> ALTER DATABASE E...

Hi Lukman! Congrats... finally u did it. [:X] the best tool to check your DB connectivity is "$tnsping <DB SID>" like $tnsping VIS. Briefly about BACKUP: actually there are 2 types of backup for DB tier. Physical/Cold or Offline Backup and Logical/Online Backup. For Cold backup your databa...

Hi Lukman If you can open your database. It's look like your password file is missing or corrupt to authenticate the APPS user. Find password file on your production database and copy it to TEST. The default location for the password file is: $ORACLE_HOME/dbs/orapw$ORACLE_SID on Unix and %ORACLE_HOM...

Hi Lukman

Are you able to bring DB up to MOUNT state? Unless your DB is not in MOUNT state you won't be able to restore your datafiles thru RMAN.

If you feel any problem with PFILE or INIT file just let me know.

Keep trying coz every problem teaches you a new lesson.

Thanks