- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - Microsoft
- >
- Here's a hard one folks!
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 09:12 AM
тАО12-02-2003 09:12 AM
Here's a hard one folks!
I already had oracle 8.0.6 on the system with Oracle 6i designer. The problem is now none of the Oracle designer stuff or Sql-Nav or Sql-plus works. I get these errors now:
Ora-01034: oracle not available
Ora-27101 shared memory realm does not exist.
Please help me correct this, I├в ve worked on this all day without results.
Thanks so very much,
Mi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 09:23 AM
тАО12-02-2003 09:23 AM
Re: Here's a hard one folks!
I had come accross these errors sometime back.
It seems that the SID_instance name used to bring down oracle was not set properly.
Check for any processes that are oracle processes and kill everything.
Also with ipcs check if you have nay non-attached shared memory segments, if any(natth value 0) remove them with ipcrm and tray again.
Post the results.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 09:36 AM
тАО12-02-2003 09:36 AM
Re: Here's a hard one folks!
technet.oraclec.com or
metalink.oracle.com
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 11:34 AM
тАО12-02-2003 11:34 AM
Re: Here's a hard one folks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 12:15 PM
тАО12-02-2003 12:15 PM
Re: Here's a hard one folks!
The errors, 1034 and 27101 indicate the ORACLE_HOME or ORACLE_SID is not set properly or pointing to an oracle_home that exists, but is not the correct one. Also ensure that the installation was complete without any errors by looking up the InstallActions.log and OraInstall.err file.
Start up SVRMGRL.
Then CONNECT INTERNAL AS SYSDBA
Go ahead and run a SHUTDOWN IMMEDIATE (if it already is not shut down).
No go ahead and do a startup
SVRMGRL> STARTUP pfile=c:Oracle\Admin\sid_name\pfile\init.ora
See what kind of results you get then.
If you still have the same problem then recheck your memory settings. For some reason, you instance isn't able to allocate memory at startup.
This error message also indicates that the SGA did not initialize (i.e., the database is not started.) If you started the DB, then look in the alert log for clues as to why it did not initialize the SGA.
Did you use a tnsname when you were trying to connect?
sqlplus username/password@tnsname
If not, Oracle was looking for a database running against the ORACLE_HOME in which you were running SQL*Plus from. It didn't find a running database, hence the error.
Or if you are ├в ┬ж├в ┬ж├в ┬ж├в ┬ж├в ┬ж├в ┬ж├в ┬ж attempting to connect to an Oracle8i database from a client using sqlplus and receive the following errors:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
You have installed 8.1.7 on the same server in a seperate ORACLE_HOME.
Possible Solution would be :-
1) For local (BEQ/IPC) connections:
Verify that the ORACLE_SID environment variable is set and points to a valid
8.1.7 database that is up and running.
2) For remote (TCP/listener) connections:
Review the listener.ora currently used to startup the listener and verify the ORACLE_HOME value is correct for all listed Oracle8i databases.
If the ORACLE_HOME points to the 8.1.7 software, however the database was
created using a different version (e.g. 8.1.6 or 8.1.5), then this error can occur.
Reasons:-
Previously, when the ORACLE_HOME or ORACLE_SID were set incorrectly, in the
'oracle' or client user's environment, only ora-1034 was reported e.g.:
ORA-01034 "ORACLE not available"
With 8.1.7, error ORA-27101 reports that the shared memory key generated by the
client does not match any currently existing keys. This is to be expected if the ORACLE_HOME used by the client is not the same as that used to startup the
database or when the ORACLE_SID value is not correctly referencing the right
instance.
I
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2003 03:00 PM
тАО12-02-2003 03:00 PM
Re: Here's a hard one folks!
you can try to change your ORACLE_HOME by running the following program:
"..\Program Files\Oracle\oui\HomeSelector\ohsel.exe"
hope this helps too!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 12:58 AM
тАО12-03-2003 12:58 AM
Re: Here's a hard one folks!
One minor point. You may need to check your sysadmin services to make sure that the older copy is running.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 01:26 AM
тАО12-03-2003 01:26 AM
Re: Here's a hard one folks!
had? Does this mean, it is gone? Check the environment variables besides ORACLE_SID and ORACLE_HOME also TNS_ADMIN, which points to the network\admin. If you have uninstalled Oracle 8.0.6 there might be leftovers in the registry.
greetings,
Michael