One of my latest tasks was to install an application to a virtual machine, (running on a Vmware server). This application, built on client-server architecture, use an Oracle database so i had to install Oracle 10g and import the specific database for the application.
Installing Oracle and make it work seemed to be an easy task, theoretically, but it proved to be a real problem, practically. I had installed Oracle on VM (virtual machine) just as i would on my computer and at first everything worked just fine; the application was running to it’s normal parameters. The issues appear after restarting Oracle server, the database was not accessible anymore: “ORA-12505: TNS:listener could not resolve SID given in connect descriptor”.
This was a strange situation knowing that on any other computer,including mine, Oracle worked fine, as the whole application actually. While i have studied the problem and tried fixing it I found a few more errors which created a strange and confused situation but finally i discovered that running lsnrctl services from command prompt, the services needed for application to run correctly were missing. This is an unusual case but if you encounter this problem you will have to manually edit configurations files (listener.ora, tnsnames.ora, sqlnet.ora – all of them in
– in init.ora file complete with the appropriate values, attributes db_name and control_files, where db_name is the default database name and control_files contains the list of the .ctl files (from
e.g.
…
###########################################
# Database Identification
###########################################
db_name=XE
…
###########################################
# File Configuration
###########################################
control_files=(‘D:\oraclexe\oradata\XE\control01.ctl’,’D:\oraclexe\oradata\XE\control02.ctl’,
‘D:\oraclexe\oradata\XE\control03.ctl’)
…
– sqlnet.ora :
SQLNET.AUTHENTICATION_SERVICES = (NTS)
– listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME =
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME =
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST =
)
)
DEFAULT_SERVICE_LISTENER = (
– tnsnames.ora
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
There is one more file which existence you should verify and if it’s missing you should create it:
– init
SPFILE=’
In order to create file spfile
SQL> create spfile=’
SQL> shutdown immediate
…
SQL> startup
….
The real problem is that from certain reasons SPFILE
Now, if you completed configurations files with the appropriate values (see above) and you create SPFILE file, the Oracle database server should work normally and you should be able to connect to it from a database design/query tool.
Finally, there’s another very important peculiarity of what does Cialis that brings it so high above its alternatives. It is the only med that is available in two versions – one intended for use on as-needed basis and one intended for daily use. As you might know, Viagra and Levitra only come in the latter of these two forms and should be consumed shortly before expected sexual activity to ensure best effect. Daily Cialis, in its turn, contains low doses of Tadalafil, which allows to build its concentration up in your system gradually over time and maintain it on acceptable levels, which, consequently, makes it possible for you to enjoy sex at any moment without having to time it.