Current Position:Home > DB_DOMAIN NAME IN ORACLE 10G

DB_DOMAIN NAME IN ORACLE 10G

Update:11-30Source: network consolidation
Advertisement
Hi,
I need to create my service_name instance.domain name. eg: hrdw.apx (dot betweek hrdw and apx). Where hrdw is my instane name and apx is my domain name.What are the steps to follow to create like this. I tried to create with net configuration , but its didn't allow me to create. my oracle version is 10.2.0.1.0
Here is example below
HRDW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HRDW.apx)
Thanks for your help.
Thanks,
Ratn.

The Best Answer

Advertisement
Hi,
I need to create my service_name instance.domain
name. eg: hrdw.apx (dot betweek hrdw and apx). Where
hrdw is my instane name and apx is my domain
name.What are the steps to follow to create like
this. I tried to create with net configuration , but
its didn't allow me to create. my oracle version is
10.2.0.1.0
Here is example below
HRDW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT
= 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
> (SERVICE_NAME = HRDW.apx)
Thanks for your help.
Thanks,
Ratn.You should put your instance name as Service_name, no domain name needed.
in your case,
(SERVICE_NAME = HRDW)
  • DB_DOMAIN NAME IN ORACLE 10G Update:11-30

    Hi, I need to create my service_name instance.domain name. eg: hrdw.apx (dot betweek hrdw and apx). Where hrdw is my instane name and apx is my domain name.What are the steps to follow to create like this. I tried to create with net configuration , b

  • Ora-00604 while installing Oracle 10g on Windows XP SP2 Update:10-11

    I was installing Oracle 10g on Windows XP but the dbca was failling. So I tried to create a database manually. But every time I launch this: "SQL> startup nomount pfile="C:\oracle\product\10.2.0\admin\XP10G\scripts\initXP10G.ora";"

  • Problem using template in database configuration assistant Oracle 10g Update:10-11

    Hi, I created a database using the database configuration assistant for Oracle 10g on a Windows Server 2003 box. The database I created worked perfectly, and I had saved it as a template so I could save some time when creating similar databases (whic

  • Cannot get Oracle 10g to start on a G5.  Floating point exception Update:11-30

    After a very painful 10g (EE) installation process i.e fixing all the following: 1) Created the missing /opt directory 2) Installation of XCode 1.2 3) Fixing the root.sh file 4) Downloaded the crstl file provided by Ron 5) Copied /etc/oratab/oratab t

  • Oracle 10g DB connecting for sys,system but not for other users Update:11-30

    Hi, I have oracle 10g in Windows XP. I am able to connect to database using sys/[email protected] as sysdba. All SYSDBA users able to connect DB. When I try to connect using user, Its not throwing any error but not connecting. Just the cursor is blinking... How

  • Error starting up Oracle 10g database. Update:11-30

    Hi, (I had shutdown my database by "shutdown abort") Now i'm getting the following error while trying to startup Oracle 10g database version :- 10.2.0.1.0. SQL> startup nomount ORA-07345: The datafile name must not contain the string '..'. I

  • Oracle 10g won't start Update:11-30

    Every time when I needed to reboot the server, Oracle 10g wouldn't start itself. 10g DB should start itself automatically, shouldn't it? If so, how can I fix this problem?You mean oracle alert.log? if so, here's some content from last startup --- Fri

  • Error while installing Oracle 10g on Fedora Core 1 Update:10-11

    Error while installing Oracle 10g on Fedora Core 1. After 40% of the Installation is thru, the progress bar is showing 40%, it gives error "Not connected to Oracle" and the installation has to be terminated. We have tried by using the on-line pr

  • Error while sending a mail using UTP_MAIL package in Oracle 10g Update:10-11

    Hi, We are using UTP_MAIL package to send a mail from Oracle 10g.We have follwed the following steps ... SQL> connect sys/password as sysdba Connected. SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql Package created. Synonym created. SQL> @$ORACLE_HOM

  • FRM-41211 Integration Error SSL - OracleAS 10g Update:10-11

    Hi. I have error Frm-41211 Integration Error SSL Failure Running Another Product error while calling a report from web form in oracleAS 10g. I have problem with RUN_REPORT_OBJECT in web forms. I have error: FRM-41211 SSL integration error ..... Oracl