Server Administration :: IP Address / Host Name Or Domain Of Oracle Database Servers

Mar 27, 2012

Due to some some Network issues . we have planing to move oracle database one domain to another domain changing domain name and IP address of oracle database . if want to change oracle database 10g(10.2.0.5.0) 32 bit windows version what are setting s to change in oracle database.

View 3 Replies


ADVERTISEMENT

Server Administration :: Error In Domain Name - Oracle Installation

Apr 22, 2011

When Oracle was installed, there was an error in the server's domain name (missing a "."). Is there an easy way to fix this domain name in the Oracle installation after the fact? I know about tnsnames.ora, pfile, system parameters, and I'm pretty sure I can do emagent -config. My concern is that the "Installed Products" would not like the fact that the domain name is now "abc.proj.org" when installation was done on "abcproj.org". The /etc/hosts file had "abcproj.org", and we want to fix it to "abc.proj.org".

I need to reinstall Oracle -- is there a better way?

View 3 Replies View Related

Server Administration :: Changing Oracle 11g From Workgroup To Domain

Jul 24, 2013

I am using oracle 11g in window server 2008 R2 enterprise under WORKGROUP. And it was working fine. But after changing it from WORKGROUP to DOMAIN not able to connect it.

Its comes as

ORA-12505:TNS:listener does not currently know of SID given in connect description.

View 23 Replies View Related

Server Administration :: Installation Of Oracle 11 G - Host OS Vista

Jan 4, 2011

Im trying to install oracle 11g release 2(11.2.0.1.0) on oracle solaris 10(x86-64) on vmware on my laptop and my host OS is vista home basic ...

i successfully installed solaris on vmware but while im trying install 11g on it,its show .oui:syntax error at line 1: '|' unexpected.

i follow oracle documentation as well as OFA...

View 3 Replies View Related

Server Administration :: Install Oracle 11g On Windows 7 - Just IP Address Available

Jan 17, 2013

With just the ip address available, how to install the oracle 11g software on windows 7? What are the access I will need in order to Install the oracle 11g software and create the oracle 11g database on windows 7?

View 7 Replies View Related

SQL & PL/SQL :: Extract Domain Name From Email Address Field?

Nov 29, 2011

I have a field for email address. I would like to create a field to capture just the domain (after the @ and before the .com) so I can process a count of records by domain.

View 17 Replies View Related

SQL & PL/SQL :: String Function - Extract Domain From Email Address

Oct 12, 2011

I'm trying to extract the domain from email addresses like from clay500@msn.com I want to pull msn

I figured I would use the POSITION function, but it fails, even when I cut and pasted the example from the syntax guide

SELECT POSITION ('CAT' IN 'CATCH') FROM DUAL;

the guide says you get the answer 1

but I get ORA-00907: missing right parenthesis

What gives?

View 8 Replies View Related

Server Administration :: Changing Web IP Address

Jun 22, 2011

trying to get oracle-xe-universal_10.2.0.1-1.0_i386.deb rolling on Debian/6.0.1a which coincidentally is on another server, not on my desktop, so I obviously can't reach the web frontend at 127.0.0.1:8080. And I couldn't trick it with a simple TCP proxy on the server:

nc -l -p 80 127.0.0.1 8080
and then on the client:
telnet 192.168.0.252 80
bailed out with an error
invalid connection to [192.168.0.252] from (UNKNOWN) [192.168.0.1] 35798

So, is there a way to change the listening IP address, or to allow IPs other than the local host to connect? I've tried some googling around,.

View 13 Replies View Related

Forms :: How To Get Domain Name Using Webutil From 10g And Oracle Application Server Name

Apr 29, 2010

How can i get my domain name using webutil. from forms 10g.

View 8 Replies View Related

Server Administration :: Configuring IP Address Instead Of HOSTNAME

Apr 7, 2009

I have purchased LIVE IP on my application server to access it anywhere on the internet.I am calling application on the internet as URL>...And its working perfectly.

I have configured Sigle Sign On and using this code on "When-Button-Pressed" to call report

WEB.show_document('/reports/rwservlet?server='||:PARAMETER.reps
||'&ssoconn=default/oracledb/userid'
||'&report='||repid
||'&desformat=PDF'
||'&destype=CACHE'
||'&pyear='||:PARAMETER.pyear
||'&branch='||:PARAMETER.branch_id
||'&bk='||:transactions.book
||'&sno='||:transactions.srno
||'¶mform=no'
,'_blank');

From Client side When i press button "sigle sign on authentication page" of Internet Directory is not coming. Because URL is accessing the application server using the HOSTNAME of application server instead of IP ADDRESS like this URL....

How can i configure it to use only IP address.

View 25 Replies View Related

Server Administration :: TNS-01150 / Address Of Specified Listener Name Incorrect

Sep 16, 2013

I am building a new Oracle Server. I have the following in the listener.ora file.

LISTENERProd =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=ORACLEPRODDB)(PORT=1555))
)
SID_LIST_LISTENERProd=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4odbc)
(ORACLE_HOME=c:Oracleproduct11.2.0dbhome_1)

[code]....

View 6 Replies View Related

Server Administration :: Not Ping Linux Install On Vmware From Host Os Win 7?

Sep 12, 2012

my host os is win 7 ,,,,i install vm ware and install linux on vmware...now i want to ping linux from win 7...how i can do it... firwall is disable.

[root@lnxdb ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0
#
Advanced Micro Devices [AMD] 79c970 [PCnet32 LANCE]
DEVICE=eth0
BOOTPROTO=none
HWADDR=00:0C:29:22:FC:FF

[code]...

i want to ping the guest os linux install on vmware to os win7 host ...how?

View -1 Replies View Related

Server Administration :: Error In Log File - Address Of Specified Listener Name Incorrect

Feb 4, 2011

I am having issue with configuring listner name on Oracle Server.My default listener is working,But I have stopped the default listener and tried to create another listener is differnt port,but no success,It always says The address of the specifed listener name is incorrect.Below is the listener.ora file

My db name and sid name are etl

LIST1=(DESCRIPTION=(ADDRESS=
(HOST=127.0.0.1)
(PROTOCOL=TCP)
(PORT=1530)
)

and the list1.log file says The address of the specified listener is incorrect.

View 12 Replies View Related

Server Administration :: Trace IP Address And OS Username / Service IP Who Modified Objects?

Sep 4, 2011

I have a problem some user modified the objects and now objects became invalid .How to trace the ip address and operating system username and service ip who modified the objects?

View 3 Replies View Related

PL/SQL :: Find Database Server IP Address And Port Number

Aug 21, 2012

Is it possible to find the Ip address and Port number of a database server in Oracle 10g version?

actually i wanta to connect it through Putty.

View 7 Replies View Related

Security :: How To Find User And IP Address From Oracle Database

Jun 19, 2013

Last week we have realized that a user who connects through SQL Developer(as nothing wrong found in application server logs) has made a serious change in the database which created a real mess. The user has done some mischief in some calculations by making some inserts and updates in some important tables in our production database.

How can I find which user or from which IP the change is made.

View 6 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client

Feb 13, 2013

I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.

1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'

View 3 Replies View Related

Server Administration :: Oracle 10g - Database Server Startup / Shutdown

Jun 29, 2011

I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.

View 5 Replies View Related

Server Administration :: Oracle Database Server - Logon Denied

Jul 19, 2011

I am connected as System. It was the only user I set-up a password when installed the database on personal computer.

SQL> alter user sys identified by mypass007
2 /
User altered.
SQL> connect sys/mypass007
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

[code]...

SQL> conn sysoper/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied

View 1 Replies View Related

Server Administration :: From Where To Download Oracle 9i Database Server

Aug 17, 2010

I have some requirement wherein I need to install Oracle 9i database server (9.2.0.7). I am not getting it on Oracle website. where can I get the download.

View 1 Replies View Related

Server Administration :: Changing Of SID Oracle Database

Jan 3, 2011

i do know how change the database but can any one assist me how to chnage SID of database which in windows 2003 server?

View 1 Replies View Related

Server Administration :: How To Create A Database (Oracle 10g)

Jul 6, 2012

How to create own database in oracle 10g. I want to create new database in oracle.

View 10 Replies View Related

Server Administration :: Size Of The Oracle Database 11g?

Apr 21, 2010

how can we find the size of the oracle database 11g.

View 2 Replies View Related

Server Administration :: Creating New Database In Oracle?

Nov 10, 2010

how to create a new database in oracle??

View 2 Replies View Related

Server Administration :: Upgrading The Database To 11g From Oracle 8i?

Aug 27, 2013

I need to upgrade an oracle 8i database on HP-Unix server to Oracle 11g on Linux server, whether to upgrade it first to 10g linux and then to 11g ?

View 4 Replies View Related

Server Administration :: How To Get Tables In Oracle 10g Database

Dec 13, 2010

I have installed oracle 10g software and created Database on RHEL 4. when i run the run.sql its successively done but im not getting tables. whats the prob.

View 17 Replies View Related

Server Administration :: Oracle Database 12.1.0.1.0 No Emctl?

Aug 1, 2013

installed and configured oracle 12.1.0.1.0 on linux and i noticed there is no emctl? I went through the oracle docs and i see no references as what to use,

View 12 Replies View Related

Server Administration :: Upgrade 9.2.0.8 Database In Oracle 11.2.0.2

Sep 21, 2011

I am trying to upgrade the oracle 9.2.0.8 database in oracle 11.2.0.2. I have installed the new oracle home for 11g and after running the pre-upgrade script and setting the all environment variable like oracle base, oracle home, oracle sid and ora_nls

i am running the dbua but after click on finish button it's do the processing of 2% but after that i get
-------------------------------------------------
ORA-12709 error while loading create
database character set
--------------------------------------------------

View 11 Replies View Related

Server Administration :: Oracle 11gr2 Database And 11.1 ASM

Jun 26, 2012

I have oracle 10g running on oracle ASM 11.1, I want to know that if i install oracle 11gr2 database , can i use oracle 11.1 ASM which is already installed ?

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved